Search results

Hi, I have a small question. In Access I have created a function that copies all (filtered) records of a form (in datasheet view) to a newly created Excel file. At home this function / datanase works fine. When I tried to run it at work today, it did not work. I get the...

Hi, I have a small question. I have a database in which in the background action queries (through vba docmd.runsql "insert etc....") are run in some situations (the user does not see it happening). However, by pressing escape, the action queries can be cancelled. I would like to prevent this...

Hi, I have a question :confused: and i am hoping you guys could help me with it. During an event procedure, I would like to pause that event untill a certain condition has been met. More specifically, after the beforeupdate event has been started, it opens another form. In that form, the user...

hi, i have question and i was hoping you could help me with it. By using an update query i update several fields of several records of a table. The values which the update query uses to fill into the fields of the records are in a form. In some caes the value of the field of records in the...

dear all, i have a databse with a relatively large number of tables, queries, forms and reports as well as a significant amount of vba code and expressions. Now, the name of a number of the tables, queries, forms and reports has to be changed. However, the references to those in the queries...

Hola, I have a small question. I have a form which is based on a query that is built up through VBA code as an SQL text and the query is then saved. In case the query already exists, then the existing version of the query is first deleted (db.QueryDefs.Delete "QueryForReport") after which...