Need Menu

[mmaule]

I am looking for an external (from Access) menu and VB code that I can modify (and Learn from. I have three (3) Databases performing similar but unique functions and would like to make them look like one database, to a user. I would like to use the menu to call up the database forms and procedures.
I haven't used Visual Basic, but with a basic starting point I'll give it a shot.

[ItsMe]

Pretty sure you need to open the Access file in order to execute procedures contained within said file.

Why not just use one app that links to multiple back end files?

[June7]

Open the Access file as an object in VBA to run VBA procedure. Example:

Dim A As New Access.Application
Set A = CreateObject("Access.Application")
A.Visible = False
A.OpenCurrentDatabase "\\dotatufs02\Crm\PMS\airports\Report Production\GIS\Airports.mdb", False
A.Run "GetPaverData"
Set A = Nothing

[mmaule]

Thanks for the quick reply.
I'm not familiar with splitting databases and writing front-end VB code.
P.S.
I also work for GDC4S

[June7]

Splitting is fairly simple.

Backend has tables and resides on file server.

Frontend links to backend tables (advise to use UNC pathing) and has queries, forms, reports, code. Each user has a copy of frontend on their local workstation.

[mmaule]

Thanks, looks like what I need.
I'll see what I can do with it.

[mmaule]

Thanks, splitting may be in my future.

[ItsMe]

Let us know if you need further assistance.