Use VB to call / open forms in access

[Bulldog13]

This is a relatively simple question, but all my searching hasn't yielded the simple information.

Assuming I am using a simple VB program, how do I progmatically display forms from Access?

All I want to do is start VB (as a real simple front end) and use it to display forms already in an access database (2002).

I would want the program to start up with a splash screen, a little login box. I do some password checking. (I can do this part easily.) Next I just want to open up a selected form in access and manipulate the data via access, using the previously opened form. All I would be using VB for is the splash screen, and a simple login box.

I know this is a simple question and I am sorry if it has been answered before.

Thanks

 

[Bulldog13]

Before bed bump. ^

 

[GilletteCat]

I wouldn't recommend developing splash screen and just a login form in VB and the rest of the data-maintenance forms and beck-end in Access. Do it all in Access and use its VBA. Then, you don't have to worry about porting access forms as modules into a VB project. Access VBA is more than capable of doing everything you've described you need done. So, after validating the credentials of the user you would simply do MyDataMaintenaceForm.Show() It's as simple as that 🙂

 

[calpha]

actually....you can add security on the access side of things and take out VB altogether. For what your'e describing, there's no need to have VB, if in fact, all of your data entry is w/i access/vba itself.