Search results

A receive a compile error when an OpenForm macro action is executed. The error message is: The form you referenced may be closed or may not exist in the database. Microsoft Access may have encountered a compile error in a Visual Basic module for the form. How do I fix this compile error ?

I created a macro in MS Access 2010 with the ExportwithFormatting action. I want to export four tables into a single excel file with four worksheets. The macro exports each table but overwrites the previous table that was exported so I am left with a single table instead of four tables in the...

I am not familiar with how to split database. Can you advise ?

I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??

My earlier response was premature. Testing shows that allow edit = No and open form read only continue to be de-activated even if I use similar properties in the errant Form. Any thoughts on how to correct ?

After further testing, I think I discovered the problem, but still would like to hear your thoughts. The form with the problem was a copy of another form. Even though the allow edit property was "No", this property seemed to be de-activated, possibly when I created the form from another form...

I created a form which has locks so that I can't edit any textbox. The lock property is "No" and the allow edit property is "No". A second form has similar properties, yet I'm able to edit the textboxes. What property do I need to change to prevent any changes to the textboxes or the record ?

I have trouble understanding the logic of the if macro action in MS Access 2010, especially when you add layers of ifs and if elses. Can you provide a Microsoft link that explains the if macro action.

I created a simple macro using the ExportwithFormatting action to export a table from access to excel. The dates in the excel file are not in the original format of the dates in the access file. How can I save the date and other formats when I export an access table to excel ?

I recreated the forms with another copy paste and the problem dissappeared.

All the combo boxes were working for over six months. I had a multi-tab form that I recreated into single forms by copying each tab form into a new single form. That's when the problem started. I'm lost in this issue.

I get a "type mismatch" error every time I open a form. Since I thought there might be a problem with the data, I deleted all records in the datasource as a test and reoponed the form. I still get the same message even though there is no data in the data source. What is causing the "type...

I have a query that groups the data by customer. How can I create a "Transaction Number" field where I assign a sequential number to each invoice, starting at 1 with the oldest invoice and increasing the sequential number by 1 with each invoice. I need to create this field in a query without...

Form 1 has a textbox called Recno with datasource = [Current Record]. When I use the navigation bar to move from record 1 to record 2, Recno should automatically change from 1 to 2, but it does not. Why doesn't the Recno textbox update automatically ?

I believe I answered my own question. I created a text box called "Record Number" and made the control source = CurrentRecord. I can use this textbox to create a macro that fires whenever Record Number does not equal 1.

I have a Form with data entry property = No. If a user clicks the page down button accidently, this could move the form to the next record even when cycle property = current record. I want to create a macro that fires a message whenever the user clicks page down and moves to the next record...

I have an extremely complex database that requires 12 forms to remain open simultaneously. A command macro successfully opens all 12 forms, but 3 of the 12 are hidden from view because the window does not have enough room to display all 12. Even when I use the left / right arrows, these 3...

I'm trying to deactivate the page down key in my form with no luck. Can you help me deactivate the page down key. Here's the steps I have already completed. I opened the form in design view, set KeyPreview Property to Yes, selected Database Tools, Visual Basic and inserted code in lines 3...

The page down key has not been de-activated. I opened the form in design view, set KeyPreview Property to Yes, selected Database Tools, Visual Basic and added the code you provided, however I was not sure where to insert the code. The final code is below: Update_Total '...

If I disable the page down key with the code you provided, will this permanently disable the page down key even when a user is working on a completely different software application outside of MS Access such as MS Excel ?