Search results for query: *

When users try to save a new row, all of the fields change to "#Deleted", and the application becomes corrupted, ie, global variables are lost, error messages occur when they try to do anything else, and the user has to quit the app and get back in. The row actually saves, but the user...

When trying to insert a new row to the database (using acCmdSaveRecord), the form's fields are replaced by "#Deleted" and then the rest of the session is a disaster -- the application loses track of global variables after that, as it would after a crash, and nothing works right until...

Users are telling me that when they try to save to the database, the form's fields are replaced by "#Deleted" and then the rest of the session is a disaster -- the application loses track of global variables after that, as it would after a crash, and nothing works right until they get...

I have a field called TotalAmount, which must recalculate anytime SomeAmount is updated. Let's say I just changed SomeAmount from 3 to 4, and so TotalAmount also changes from 3 to 4. The following code, using Requery, doesn't refresh the value. What am I doing wrong? SomeAmount_AfterUpdate()...

I have a two-part problem with subforms not loading, no pattern that I can figure out. When I open a form containing a table-based subform, sometimes instead of showing rows of data, or in the case of no data, a blank row, it's just a blank, white blob where the subform should be. OR, when my...

I have a two-part problem with subforms not loading, no pattern that I can figure out. When I open a form containing a subform, sometimes instead of showing rows of data, it's just a blank, white blob where the subform should be -- OR, when my code tries to set the recordsource for the subform...

I'm trying to come up with a solution where users can add/edit rows of data in memory only (the "many" part of a 1-to-many relationship, for example adding/editing several orders for a single customer), so that if they want to cancel, changes will not go to the database. I thought a...

When I try to tab from the main form into the first field of a subform, the cursor gets stuck in the last field before the subform. It won't enter the subform, even when I try to click on the field manually. The fields are all enabled, all set with tabstop = yes, and the and the tabstops are...

I wrote an app (with bound data fields) where if a user changed to a different tab on the form, the tab's OnChange event checks for Me.Dirty to prompt user to save first if needed. Worked great. I'm trying to do the same thing with a new app, but NOW Access is executing an automatic save BEFORE...