Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FORMS and DYNASET quieries (Access 2000 sp1)

    I have built a large Access database (tracks over 5,000 records) and now that it has been finished for a year we are finding some bugs. The main form is bound to a dynaset query. One button, which is not used frequently, is designed to save info (via standard recordset code) to a table which is already open by the dynaset query. Since I am modifying data already open by the query, Access complains, burps, and does not save the correct info.

    I really do not want to unbind all the controls (30+) on the form since all the end users are use to the info being "magically" saved once typed. Any suggestions?

    Thank you.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: FORMS and DYNASET quieries (Access 2000 sp1)

    What do you mean by Access complains, burps, and does not save the correct info?
    Can you be more explicit.
    Pat

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FORMS and DYNASET quieries (Access 2000 sp1)

    Are you getting a write conflict error? The simple workaround for that is to make sure first thing the button code does is to test for the dirty condition in the form and then do a DoCmd.RunCommand acCmdSaveRecord. That will save any edits made to the record and enable you to do any other updates or field value changes your "save" code performs. Of course, it would be easier if you didn't do it both ways, and I'm assuming there are other steps that need to be taken when the Save button is clicked. If I'm mistaken, then why bother with the save button?
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •