Recent content by hhag

  1. H

    Adding new listposts

    Thanks for feedback. I'll test a little. I use a navigation form for walking around among the forms and task I want to do. Can I then get back to the form that I use for registration of new records and get back to this specific record I started with? When I switch from one form to another, the...
  2. H

    Adding new listposts

    When I add data to a new record in a form (tblOffer) I use a combox (tblContact) to choice contact to each record. It happens when I choice contact that the name doesn’t exist. In order to add a new contact I need today to leave the form and go to another form in order to add this new contact...
  3. H

    Solved Editing conflicts after splitting the database

    Yes, I know it's bad design. Any suggestion on how to think @Galaxiom ?
  4. H

    Solved Editing conflicts after splitting the database

    Seems to be solved. Shame on giving up! :) I removed my event based macro from the combobox and replaced it under the Form_AfterUpdate() event. And then suddenly my editing conflicts seems to be erased. And all records in all three tables seems to be according to expected and the conflict...
  5. H

    Solved Editing conflicts after splitting the database

    Does anyone know if there's a way to run a macro after an open record is closed and the form is about to be closed? Some kind of an eventbased propertrty in order to prevent overlapping edits?
  6. H

    Solved Editing conflicts after splitting the database

    Is it all three forms (the main and the two subforms) I should try to refresh?
  7. H

    Solved Editing conflicts after splitting the database

    I've tried to change and add records in the child tables presented as subforms in the tab-control. And this works fine. No message about editing conflicts. It's when I chane status in the main table (parent table) one table shows an editing conflict.
  8. H

    Solved Editing conflicts after splitting the database

    It's an Access file. The form is based on a multi table view and I've googled that this might create problems. Well, you'll learn as long as you live. I've a main form with a tab-control of three different tabs. One tab contains the 'main data' from one specific table and the other two tabs...
  9. H

    Solved Editing conflicts after splitting the database

    I need to leave my PC for a couple of hours now. I'll be back this eventing.
  10. H

    Solved Editing conflicts after splitting the database

    I've read bout using locks to stop overlapping edits. This might be an idea?
  11. H

    Solved Editing conflicts after splitting the database

    Yes, I didn't see this message before.... I do changes in three different tables with the macro code, and only one 'kicks backwards'.
  12. H

    Solved Editing conflicts after splitting the database

    Access gives you constantly new challanges.... :rolleyes: :confused: After I splitted the database in order to open up for additional users I get a message 'Write conflict', or 'Record has been changed by another user'. The thing is that I know for sure that no other 'user' has been doing...
  13. H

    Solved Unwanted records are created in a table when user changes forms

    Well, soon it wasn't.... too much work. I've done above changes and I've also set the data property "Allow extensions" (translated from Swedish since I've a Swedish version of Access) till 'No', and when I want to add a new record I've inlcuded a Commandbutton (from the scope of different...
  14. H

    Solved Unwanted records are created in a table when user changes forms

    Thank you @The_Doc_Man! You would just now how much I appreciate you time and feedback. 🙏 :) I'll try your advice with removing all default entries and then test each fields in the form and if necessary set some to default values. And I will return within soon.
  15. H

    Solved Unwanted records are created in a table when user changes forms

    I try once more to explain my issue. I use a navigation form (standard one included in Access, both with horisontal and vertical tabs). Here I've placed my form which I intend to use adding new records. The issue is a new record is created as soon as I select this 'Record-adding form'. Maybe...
Top Bottom