Recent content by panchitocarioca

Dear Smeghead, Many thanks once again for the reply. I have tried the version you uploaded, and exactly the same thing occurs. At home it works fine, at the office, i get the error "9. Subscript out of range". Once again, i have tried on several PC's at work. We have several other access...

Dear Smeghead, Thanks again for the once again quick reply. Please find enclosed a copy of the test database. I have kept it extremely limited to just a few minimal test tables and forms so that it will hopefully be easiest to isolate the problem. 1 table with a few fields and a few records...

Dear Smeghaed, Many thanks for the quick feedback. I tried the code suggested by you, but the same error appears when trying it at the office: “Error 9 Subscript Out Of Range“. By the way, I have tried to run the code from several computers at the office but the same problem occurs from all...

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...

Dear Gemma, Many thanks for the feedback and apologies for my late reply. I had already switched of the warning by using docmd.setwarnings = false. That stops the program from asking the user for confirmation to run the action queries. However, it does not disable the possibility to interrupt...

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...

have tried it with and without quotes, but both do not work. Should it be possible to clear a numeric field that cotains a value, by using an update query?

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...