Can someone please help me ? I made a button named "Open" for Visual Basic 6.0 , and i would like to execute/open Microsoft Access 2007, can someone please help me ...

Recommended Answers

All 4 Replies

its not hard.
first off , just locate where is EXE for MS Access and then put the address in shell statement.this is what i've in , i'm not sure about this in vb6.But i think that it should work.

Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe")

Learner010: yes.
johnchristian.pagnes: If you want to open report or anythings in access.exe, you need to make macro in access.exe before, and using (shell statement) command line to activate macro in access

Regarding to Learner010 post :
Its better to use the statement like this

Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe",vbNormalFocus)

Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe",vbNormalFocus)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.