Search results

I have a query which I need to email in an excel format to a changing list of recipients. The recipients are held in a query "email_lastturndata_qry" using the field "email_address" for the recipient email addresses. I have this code so far, Private Sub emailpostturndiameters_Click()...

I have two tables, which are joined by a union query. This is then appended to another an other table, called joined_data_tbl. Before appending the data from the union query, I run a delete query to delete all the records from joined_data_tbl, this is because some of the data in the original two...

I have a form that on open checks whether an Excel file on the server is open or not, be fore certain other functions occur. If the file is open I get a message, if the file is not open then the queries run. What I would like is to know who has the Excel file open. Can this be written into the...

Hi All, I have a linked table to an Excel file held on the company server. When I open a specific form, I have a delete query that deletes the contents of my table kmnow_tbl and then I use an Apppend query to update the table kmnow_tbl. The kmnow_tbl stores the current mileage for each train in...

Hi All, I have a text box in a report that uses DLOOKUP to select a record from a query but I have no idea how this should look, so would like a bit of help. I created below using the expression builder, but not surprisingly it doesn't work and returns #NAME...

Hi all, I'm not sure this post is in the right category, but here goes! I'm still getting to grips with Access, so please bear with me. I have form "front page 2" from which I can select 2 numbers from 2 combo boxes. The 2 combo boxes refer to the 2 halves of a train, known as north and south...

I have a database that is used to track wheels fitted to trains. each train has 32 wheels. At present I have 32 queries that give me the data for each wheel position in a particular train, I then have a further 32 queries that use the DMax function to return the last record for each wheel in...

I have a combo box where users can select from one of a number of even numbers, located in a table. The problem is users can also type a number into the box, they could by mistake enter an odd number, which would return incorrect data. My question is, is it possible to add a clause somewhere in...

Hi all, This is a follow up from a post I made some time ago. On a form I have a combo box that gives me the option of selecting from one of the next 5 Sundays; Private Sub Form_Open(Cancel As Integer) Dim I As Integer cboSundays.RowSource = "" For I = 1 To 5 cboSundays.RowSource =...

Evening all, I have a form training_edit_dates1 that allows me to add training types and dates for each operator, which is then saved in operator_training1. When a training type and date is added for a operator I would of thought the field trainingtypeid in operator_training1 would show the id...

Hi all, I have a database in which I require the users to be able to access risk assessments on the company's server. To do this I have a form risk_assessments, with a combo box. This combo box needs to list the refno and risktype, but not show the actual hyperlink. I have attached a db, with...

I have one form, operator_details, that has a close button, which when clicked on runs code; Private Sub close_Click() Forms!training_record_tableview1.Refresh On Error GoTo HandleError DoCmd.RunCommand acCmdSaveRecord DoCmd.close ObjectType:=acForm, ObjectName:="operator_details"...

Evening all, I have a form "training record tableview1" which at the moment has 2 subforms, which each give details of training for each employee. When a new training type is created, using form "training type" this type is added to the relevant crosstab queries, but I need this new training...

Afternoon all, this is a follow up from an earlier post, which I am still struggling with. I have 2 tables which have no common fields, which I need to combine into Query1, from which I can build forms etc. I can't find a way of making Query1 updateable, so I can add [passed on] dates and also...

I'm sure i'm doing something very dumb! I'm trying to create a delete query that deletes operators, [op name] and all their records from [train_tbl], when they are ticked as "left team" in the form [operator details]. I have spent all weekend on this, so any assistance would be very, very...

Morning all, I'm sure this has been asked before, but I don't seem to be able to find the thread. I have a form, [operator details] that has 3 checkboxes. I want to checkbox3 to untick checkbox1 and checkbox2. Also checkbox2 to untick checkbox3. Any help would be gratefully received Thanks

Hoping someone can help with this one! In an attempt to add security to a database I am building, I have added the file in the attachment to my database, without reading all the replies, now every time I open any Access database on my Pc I am asked for a password, because of this file. Let this...

I don't know if this is possible, I'm hoping someone can help! I have a query which lists train wheel diameters and I need to calculate the wheel wear per kilometer, to predict the life of a particular wheel. Attached is a portion of the query put into Excel, hopefully this explains what I'm...

I have a query, AccumaltiveKmnow, that is based on a linked table AccumaltiveKM. The query gives me the kilometres [km] on todays date for units numbered 02,04 06 up to 94. Accumaltive KMnowdaynow0204060804/05/2017760622714839.598851542891303 see attachment for the query. Is it possible to...

Morning all, I'm hoping someone out there can help. I am trying to print multiple copies of a report called "annual leave" from a button on a form called "annual leave form". I need to be able to print multiple copies of the report based on the value the user enters into a text box which is...