I would also be interested to know if something like this can be done.

Create a Batch File and add the following:

@echo off
start "" "C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\Your\Database\Path\YourDatabase.accdb" /cmd 9

Saved As: OpenCustomer9.bat
Paste link into your email client. Example: file:///C:/Users/YOURUSERNAME/Documents/OpenCustomer9.bat

Make sure you add the full path to YOUR database.
cmd 9 means it will open at ID 9

Add the following to your Start Up Form:

Private Sub Form_Load()

    Dim cmd As String
    cmd = Command$
    
    If IsNumeric(cmd) Then
        DoCmd.OpenForm "CustomerF", , , "CustomerID = " & cmd
        Me.TimerInterval = 200
    End If

    SetCaptions

End Sub

Private Sub Form_Timer()

    On Error Resume Next
    Forms("CustomerF").SetFocus
    Me.TimerInterval = 0
    
End Sub

This will open the database, then open CustomerF at CustomerID 9 and give the Form the Focus.

You can pass arguments to Access using the /cmd switch with your parameter(s)
Compact Cmd Line
You would then have to handle the input however you need.

Does Access have a URI protocol?
Registering an Application to a URI Scheme
https://learn.microsoft.com/en-us/previous-versions/windows/internet-explorer/ie-developer/platform-apis/aa767914(v=vs.85)?redirectedfrom=MSDN
myapp://users/edit/5

Launch the default Windows app for a URI
https://learn.microsoft.com/en-us/windows/apps/develop/launch/launch-default-app

There are security concerns you need to think about.

Richard any ideas?

This is a solution but it would involve installation and maintenance of probably multiple machines and it does open a significant hole in security.

What I recommend is a simple message that if the numberof drawings needing approval >0 send an email.  Then have a form that opens on startup for the user if the same condition exists.   It would be a continuous form that shows all the drawings needing approval.  Also have an easy button just in case the database is already open.

The guys have done an excellent job of explaining how it possibly could be done, but this is one of those situations where do you really need it? I mean, if you have the database set up with multiple users, then all they have to do is open the database using whatever shortcut you gave them on their desktop, and then you could program in the database a big pop-up that says, "Yo, you've got to approve your drawings." The reminder email itself should be enough to jar their memory. I wouldn't bother sending them a link to open the database. Is it possible? Yes, but as other people have mentioned, it does open some security risks with batch files and stuff. This is one of those automation things that I wouldn't bother.

Or if you really wanna go high tech, you could move the data up to SQL Server and then create a web portal where they could approve their drawings so that you could click on the hyperlink in the email that would take them to the web portal. It all depends on how much work you wanna put into it for something that I think is unnecessary, but that's just me.

Thank you everyone.  I don't think the IT department where I work would appreciate me opening up security risks.  So I better stick with the link-less reminder email route.  One more question, is it possible to program access to automatically send out emails every Monday and Thursday, for example?

Thanks, Bob

Sure. I've got several videos on reminders. You just have to trigger it somehow. You can make it an event for when you log in, or when anyone logs in, or you can have a PC act as a server and it can do it.

Reminder Popup
Reminder Popup Date

Instead of a reminder, queue your emails.

Thanks Richard.  I love your videos!  What do you mean by queueing my emails.

My apologies. What you'll need to do is create a loop that will send your emails out, and I've got several videos that explain that.

Send Email
Send Email with CDO

At the point where the reminder would run, instead of popping up a reminder, you will instead have that code send out the emails. You'll probably need a recordset to loop through them to loop through the recipients and send an email to each one. This is a little more advanced. I cover stuff like this in my email seminar, but you'll definitely need some VBA under your belt first.

I'll talk about this more in today's Quick Queries video. Recording it now.

Oh yeah,  that's my plan.  I figured out how to concatenate the email addresses and put them into one email yesterday.  Your "How to Fix Run-Time Error 3061 Too Few Parameters" was a big help.  That error was driving me crazy until I watched your video.  Thanks!

That's what I'm here for. :)

Just what I have been look for :)