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 ...
johnchristian.pagnes 0 Newbie Poster
Learner010 99 Posting Whiz in Training
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 vb.net , i'm not sure about this in vb6.But i think that it should work.
Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe")
e.pol 0 Newbie Poster
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
Hamza Saleem 0 Newbie Poster
Regarding to Learner010 post :
Its better to use the statement like this
Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe",vbNormalFocus)
NewCoder_31 0 Newbie Poster
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, networking, learning, and sharing knowledge.