Results 1 to 3 of 3
  1. #1
    byczsek is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    2

    Form and macros

    Hello all,


    i get a problem with form. I create a data base and form, which add records to this base. I added some button with simple macros, that change visible settings of some subforms in my main form. But when i added that buttons, no more than one person can use that form at the same time. When i delete that buttons, everything is working and a few people can add records at the same time.
    So, is there any options to fix that? Those buttons only change visible from true to false, nothing else.
    Furthermore, when i add any other button with macro the same action happen, only one person can add records. Any idea?

    Here is the error:

    Thanks for help

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    you need to split the database. (theres a button on Database Tools) It creates the frontend (FE) of forms, and a backend (BE) of tables.
    the tables are saved on the network.
    the FE is copied to every person. Each gets their own copy. THEN everone can work without conflict.

  3. #3
    byczsek is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    2
    Thanks for answer, i will try this!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adjusting Form Labels when macros are selected
    By chamberlaing in forum Access
    Replies: 9
    Last Post: 08-21-2016, 06:58 PM
  2. Form using Macros
    By Srin in forum Access
    Replies: 6
    Last Post: 08-31-2015, 02:59 PM
  3. Macros for a web database data entry form
    By Twinnie in forum Access
    Replies: 13
    Last Post: 05-29-2014, 01:33 PM
  4. Replies: 3
    Last Post: 02-24-2014, 02:24 PM
  5. Using macros in a Form
    By Mill21 in forum Forms
    Replies: 2
    Last Post: 03-24-2011, 04:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums