Search results

I'm a complete and utter twat. I just realised that there was nothing wrong with it other than I was trying to update "Dispatched" with "Dispatched" when it should have been "Dispatched" with "Completed". Thanks to everyone who has helped me. Cheers Chris

Thanks for your help, I seem to be getting a syntax error on this line. Set rs2 = db.OpenRecordset("Select * From Job_Data When Dispatch_Number=" & Me.Dispatch_Number, dbOpenDynaset) Run time error 3131 Syntax error in FROM clause Cheers Chris

The reason I am using the "format(now(), dd/mmm/yyyy) etc is because it prevents the date from defaulting to the American style of MM/DD/YYYY. I guess I also split it up to make it easier in the future if I need to extract different elements of the timestamp. Cheers Chris

Good morning Guys Thank you both for your comments. There isn't any errors being displayed when I run it. The completed information is writing to the table as expected. Its the updating of the status that isn't working. The database is only being used on a nightly basis to record...

Just wondering if someone could please point out the error in my code. I'm looking to add details onto one table and edit a field on a second table after looking it up. Many Thanks Dim db As Database Dim rs1 As DAO.Recordset Dim rs2 As DAO.Recordset Dim Str As String Str =...

Hi Guys, I was just looking for some assistance. I'm looking to send an access report in RTF format attachment direct from a command button through my Gmail account. I have found some code that allows me to send an email but not with the attachment. The name of the report is...

You will find that once you have installed office on your new PC that it will be fine. I'm running access 2003 on windows 8 with no problems. I'm about to upgrade to office 2010 in order to continue working on my carpet shop database. If you have any issues give me a shout. Chris