VBA and Access

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

Dear all,

I want to write a program in VB to access MS Access form.Command function.
What the code should be if I want to access c:\sample.mdb ---> Form1--->
command1.click()? I think it may be set oaccess=createobject( ....)
somethings like that.

Why I need to use Vb to access MS ACCESS?

It is because I want to have the scheduler function in windows to run VB.exe
to run sample.mdb!forms1!command1.Click() event.
That is

Any help is requested and thanks for your help.
 
not sure this is a right approach, i would probaly write to some table from
VB
but what you can do:
- create access instance: set oAccess=createobject("access.application")
- open your mdb there
- run some public function using oAccess.Run method
- in public function - you open your form and run code on it
 
Back
Top