Recent content by pedromac73

Thanks pbaldy that was exactly the problem working on a sunday morning in Scotland sure fuzzes the brain.... Cheers

My apologies on in advance for using an existing thread but I thought it would be best rather than start a new on. I have used Bob's code but I get the following error message; Runtime error Syntax error (missing operator) in query expression '[lngSalesOrderID]=". Here is the code I am...

Finally got this to work (with a little patience and no sleep :eek: ) so thanks for the guidance GaryPanic and johndoomed. Regards Peter

Hi Try this from microsoft, http://support.microsoft.com/kb/209974 remember to check the correct reference version i.e. OFFICE9 or OFFICE10 or OFFICE11. This can usually be found in the Microsft Folder within Program Files Regards Peter

Marion Check out the following link courtesy of user ghudson http://www.access-programmers.co.uk/forums/showthread.php?t=97578 This may be what your looking for Regards Peter

Thanks for the help in guiding me to the best approach I really appreciate it. I have managed to get the correct code for the tblInvoices from the form that I am using but I am having difficulty setting a set value of 1 into the lngServiceID field on the tblInvoiceLines sub form. This is what...

Hope you can help, I have searched the forums but cannot find anything that will serve my needs but if you know can you guide me to the relevant place it would be appreciated. I am trying to create an auto invoicing system that will create a new invoice after a date has been updated within the...