Recent content by Danny_H

Thanks both for the help arnelgp The code worked spot on and did exactly what I needed

Hi plog Table 1 has all records Table 2 has some records I want to find the records from table 2 that do not appear in table 1 Hopefully that explains a bit better

Hi Guys I have a query that looks at 2 tables and returns the values that are in both and this is fine However I need to replicate this but with the results returned being the values that are not in both tables Whats the easiest way of doing this? SQL for working Query is below: SELECT...

Thanks Paul That worked spot on

Hi All I am trying to show in a query the completion percentage of each project but am struggling to show this. There is 2 sets of criteria that determine if a record within a project is complete, Yes or No. What I would like to show is against each project how many records are yes and where...

Thanks Kiwiman, this is what I have ended up doing and it works spot on, thankyou.

Hi I need to use a table field as a file path rather than typing the exact text in the vba I need this as the file path needs to be able to be easily updated with an update query rather than having to keep going into the vba and altering it manually Currently my sheet path is...

lol, sorry Tried both ways and both ways worked for me. Chose Pr2's way as it is just more in line with what I needed Thanks again

Thanks That worked a treat

Hi I am trying to get a txt box to state Yes after a date has been entered into another box for some reason the IF statement is not working? Code below: Private Sub Final_approval_date_AfterUpdate() If Me.Final_approval_date.Value = True Then Me.Status.Value = "Closed" Me.Refresh End...

Yes, All code was copied exactly from my Book? Ive copied your text and still gives the same error? Query1 just contains 1 column, with 54 records that are single numbers ie, line = 1, line = 3 etc. I just want to copy these numbers into a range on the Excel worksheet. Is there another...

Ive added the space in front of FROM and WHERE and now have a different error message (See Below) Run-time error '-2147217900 (80040e14)': No value given for one or more required parameters.

Hi pwbrown I have tried that but unfortunately still get the same error message (see below) Run-time error '-2147217900 (80040e14)': Syntax error (missing operator) in query expression 'Query1.TrackerFROM Query1WHERE (((Query1.Tracker) Is Not Null))'.

Hi Im trying to use the following code to copy the values in a Query to a cell range in Excel when a button is clilcked. Private Sub Command120_Click() 'We'll start by creating a recordset named MyRecordset. Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection Dim MyRecordset...

Hi All Just joined up to this site today to build my Access knowledge & also get some help with issues I have encountered with my DataBases. I am a Manufacturing Engineer working at Rolls-Royce in Derby, currently building a couple of DataBases to streamline our processes and try to move...