Search results

Sorry, I forgot to mention that I also tried the "dbFailOnError", but with the same results. I checked the table after execution of the SQL statements, but nothing has been updated or inserted in the table. When I run the procedure for the second time where "FirstGRV" evaluates to "N", the...

Hi all, Thanks for the responses. Let me try and explain what I want to achieve: I have a table (Tbl_SellingPrices) with the following fields: SellingPriceStockCode [Text] SellingPrice [Number] SellingPriceDateFrom [Date/Time] SellingPriceDateTo [Date/Time] When a GRV (Goods Receive Voucher)...

Hi all, I am trying to update and insert records with SQL statements. Below my code: Select Case FirstGRV Case "Y" sql = "UPDATE Tbl_SellingPrices " & _ "SET SellingPrice = " & Me!Text2 & ", SellingPriceDateFrom = date(), SellingPriceDateTo = #" &...

Hi Rx, Thanks a Mil!! This is what I have been looking for for a very long time. Regards Deon

I do apologise - I used the acCmdPrint and it brought up the list of printers. Much appreciated.

Thanks vbaInet, I am using the "docmd.printout" method to print, but I need a routine to bring up the list of printers so that the user may choose to which printer he/she wants to print to. Regards

Is it possible to call the printing dialog box without the MS Common Dialogue ActiveX control? I tried to use this ActiveX control, but get an error message that I do not have the required licence to use the control. Can someone help? Thanks

Thanks. I will test on one user. Regards

I have just upgraded to Access 2010, but all users are still using Access 2003. Will the existing Access 2003 databases work correctly (if at all) if I remove the Access 2003 package from the user's computers and load only the Runtime version of Access 2010? As always, much appreciated. Deon

Thanks, much appreciated

Hi, I have written a database in Access 2010 in 2003 format. When I run the DB with MS Acess 2003, I get messages of missing or broken references to the files "ACEDAO.DLL" and "APSVIEWPANES.DLL". I cannot detect (through the search of files) these two files on the 2010 machine. Does anybody know...