Search results for query: *

Not done in VBA, but at point of initially attaching table to your database, File, Get External Data, Link Table, then selct table from source and list. In the dialogue box containing list of tables, check the small box in the bottom right hand corner to save the password for the link.

Assume "X" = table field name containing number try this code in the query column for the number...

Only way I've found is to opt for the password to be saved when you link the table to your database.

I'm presuming that you have security set up on the database to get this message. I had the same problem and the cause was due to the user not having read/write access to the drive on which the database was stored. This prevented the security lock file from being opened thus the database...

I have a combo box that obtains its record set via SQL which has a criteria applied to allow filtering of records to take place. The criteria is obtained from a form object and VBA assigns a value to the form object accordingly. The criteria can range from a value of between 1 and 7, but it is...

I have a report in Access that contains several graphs. The print preview on screen looks fine and all graphs appear. When I try to print the report, one of the graphs refuses to print. I've tried copying one of the graphs from the report that does print and simply changing the SQL for it's...

Is there any visual basic that will perform the same function as pressing the escape key on the keyboard? Thanks