Split DB, unable to have multiple users access form at same time

[katmomo5]

Good catch, ItsMe. The Save and Close macro is set for the Prompt ("Do you want to save changes to form?"). This should be set to No - for all of the Save and Close buttons.

Where can I set this to No?

[June7]

Do you know how to open embedded macro for editing?

[katmomo5]

Do you know how to open embedded macro for editing?

I'm not sure. Click the ellipsis or view code?

[June7]

Yes, click the ellipsis. This will open the relevant editor.

[katmomo5]

"macro is set for the Prompt ("Do you want to save changes to form?")"

okay, am I looking for those exact words? I don't see Prompt, or the above question.

thank you

[ItsMe]

The idea is not to have a macro asking for design changes. You can not make design changes in an executible file nor can you ask Access to "Save" a design, even if changes were not made. The macro is trying to "Save" a form.

All you can do is "Close the form. So have your macro Close and do nothing else or use VBA that looks like this

Private Sub Close_Click()
DoCmd.Close
End Sub

[June7]

Are you in the button's Embedded Macro designer? Do you see the line that says: Save Prompt

Change Prompt to No.

[katmomo5]

I clicked the ellipsis, chose macro builder, but the button's macro designer is blank. I did add DoCmd.Close to the close button's code, and also removed the undo button.

[katmomo5]

Just to clarify... I clicked the ellipsis, chose macro builder.
The tab that opens is labeled frm24hrNsg:Close:On Click
On the window, there is a green plus sign with a drop-down that says Add New Action.
======
I see...

Do I choose Close Window? When I choose CloseWindow, Object Type is blank, Object Name is blank, Save is set to Prompt. When I change that to No, I get a warning sign saying unsafe action.

[ItsMe]

If you use the wizard to create a new control button, the wizard will help you to create the macro. If you use the ellipses for an existing control and the field next to the ellipses is blank, the ellipses will prompt you to choose macro, code builder, or expression (I believe). This will create a NEW macro, VBA procedure, expression. If the field is not blank, the ellipses will take you to the appropriate area to edit existing macros, VBA, etc.

You need to make a choice to use an embedded macro or VBA.

[June7]

Odd, I thought it was just Close the last time I looked. I don't use macros. I just tested and don't get the warning. Macro works.

[katmomo5]

Sorry, I don't see what you see with the macro. Wish we could send screen shots to each other.

I tried changing Record locking to edited record thinking that would allow a new subsequent record to open, tested on two different computers, and still unable to open two forms at the same time.

I archived the data so I could send the BE. If you have time to test, I would very much appreciate it. NursingReports_be.zip

I, also, made sure that I was not in design mode when trying to open the form on other computers. Still unable to open the form if already open on another computer. Once the form is filled out and/or closed on the first computer, the second computer is then able to open the form.


I don't know if this helps, but the end-user is only to add records. Supervisors may update or delete records - which I created a separate form for updating, and a macro to delete. I was wondering if having the tracking number on the form is causing the problem, but the tracking number is needed to provide to supervisors for update/delete ability.

[katmomo5]

I found my first accde (which is opening on multiple computers) that does not have:
Now() Report date/time,
<Date() Event Date
<Date() Birthdate
required reporter name

It also has a save button and a close button, which I know Close will save the record.

Anyway, I was hoping that I could export the form to the db because it works. Unfortunately, we can't export from an accde

[June7]

Images can be attached to post, I just copy/pasted records from an Access table and that created an embedded image in the post.

No idea why I was able to edit the macro without the warning you see. Does it still allow the change?

Not seeing anything in the BE to cause issue.

[katmomo5]

Hi June, thanks for the continued help. While I was racking my brain, I created a quick new form off of the table without the command buttons. Tested it, and it opens on more than one computer, takes data and saves to the BE. I'm formatting the form and I just want a simple button for the user to click to let them know the data is saved and close the form. I'm scared of using the same button which was the close button, right? Will the Save Record button also close the form?