Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tpolony

    DESPERATE! #Deleted in all fields when saving new row

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

    DESPERATE! #Deleted in all fields when saving new row

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

    Fields set to #Deleted, session gets corrupted

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

    #Deleted message upon save, causes execution errors

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

    Field requery doesn't work after save

    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()...
  6. tpolony

    Subform doesn't always load, causes errors

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

    Subform not loading

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

    How to have a total field updated

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

    Adding subform-like data without updating DB

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

    Adding subform-like data without updating DB

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

    Can't get cursor to tab into a subform

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

    Can't get cursor to tab into a subform

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

    Can't get cursor to tab into a subform

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

    Can't get cursor to tab into a subform

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

    Can't get cursor to tab into a subform

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

    How to stop Access automatically saving BEFORE tab's OnChange event?

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

    How to stop Access automatically saving BEFORE tab's OnChange event?

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

Part and Inventory Search

Back
Top