Search results

Hello, all hope somebody can help with this. I have a report, and in its header I want to display field values from a table. This is a different table to the reports records ource. However, the record read from the table depends on a field value from the reports record source. I presume there is...

Hello all, I am setting up an access 2003 database in a Client/Server configuration. All dat entry is done through queries, forms are not used. I am wondering if it's possible to prevent users in the client database (Or a copy of it) from creating new queries that hang of the linked tables. I...

Hello All, Help! Does anybody know if it's possibe to run an update query based on a trigger. For example every time somebody opens a certain table the update query will run? I'm sure it must be easy.

Hello all, Hope somebody can help with this. I am currently trying to tidy up a large messy database. I am standardising the naming convention for tables and queries etc, as they are a mess. I want to create a form with some code perhaps, that will allow me to change the name of a query etc...

Sorry I cant help, but I have a related question. Can you create a macro that auto saves the database as a backup every hour or something like that?

Hi All, I'm Looking for a bit of advise. I'm about to try and build a new database that will have about 40 tables. One of these will be the main table. This table will have a primary key TAGNUM and several other fields containing data associated with each tagnum. Most of the other tables will...