Search results for query: *

The pdf writer is also asking me for the path even though its in the code. Did anyone find a solution to this? Thanks

Sorted. I put a timer on a background form to close the databsae at a certain time so that users who don't exit before leaving will be kicked out. Increasing the timer setting stopped it interfering with the create new record process.

Hi, For some reason the code to select a new record (see below) has stopped working all of a sudden. Has it got something to do with references maybe? It has been working fine for months. command used: DoCmd.GoToRecord , , acNewRec Thanks

Anyone know how to call an Access routine from Excel. I can run queries and open recordsets etc. but not call routines.

amazingly enough a similar question was asked and answered in thread181-504232 almost simultaneously.

Any ideas on how I can go about importing a csv file into an access 97 database by calling the routine from excel (2000)? I can populate the access table from an xls file via an excel macro but having trouble with the csv file which has too many rows for excel.

Hi, I seem to be getting a number of Dr Watson errors when using combo boxes. The database I have is has a split front end / back end. The dr watson occurs as I go to select the from the combo box but before it shows any of the dates. It occurs every time you do this once it starts. If I...

Yes I think I'll look into changing the csv file. Thanks.

I am getting different results with different users when using opening csv files in excel from vba command. User 1. All date fields are open with dd/mm/yyyy format. The same when opening the file manually. User 2. All date fields are open with dd/mm/yyyy format when opened manually but when...

Thanks works a treat!

Hi, I have a query where I want to select based on the value of a combo box on a form if it is not null else select all records. See below SQL which is not working as no records are being selected when the combo box is null. Could you help please..? SELECT...