Search results for query: *

This is running with a Sybase back end. Would this corruption be likely since it's not an Access db? Also, for clarification, this happens on all different types of tables, not just one. I had heard that there is an access bug that causes this, but I could not find any helpful information on...

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

Try Total_Used.Requery in the field's AFTERUPDATE method.

Thanks for the suggestion. I will either try the "fake continuous form" approach as a popup panel, or I can try the array with a list box. I could figure out how to use the convoluted routine that allows you to populate a list box from a function (a new challenge), with the function...

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

Ogart, you can go to View/Tab Order in form design, tell it to AutoOrder to get it in the basic order indicated by the field placement on the screen, then modify the auto-ordered fields manually using drag/drop. I had the same problem. My recommendation is to do all of your development and not...

My form has tabs, and it updates indiscriminately every time it changes tabs, without using any of my specialized code in my Save method (also, a Save is not always desirable). So I set a flag to tell BeforeUpdate if the update is OK to do or not. It just says "Cancel = cancelUpdate&quot...

As it was "leaving" the main form, it was calling the main form's BeforeUpdate method, so it lost focus. Commenting it out solved that problem. But now I have a new problem. I NEED that BeforeUpdate method. I'm trying to figure out some hack-around, if you have any further ideas...

I'm getting closer... When trying to set focus on the subform, I get runtime error 2110 saying it couldn't move focus to my subform. When I ignored the error twice (telling debugger to end), it goes to the field. So I added code to trap error 2110. Then I get a message that the field I want to...

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

Thanks for the tip. I checked the old app and it also has a subform on the 2nd tab, like the new app. But there is a difference in that the new app sets the subform record source only upon clicking the tab, whereas the old one's record source is hard-coded and loads when the parent form...

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