VBA to move move around in form

[oravec]

Hello,

I got the following code yesterday to open an Access file from Excel VBA. It works great. My next step is to close what I believe is a form that opens when file activates. Form has an "OK" button to close. Need to activate that button or "tab" three times then use "enter" key to close the form.


Thanks,
Cliff


Dim db As Access.Application
Sub test_opendb()

Set db = New Access.Application
db.OpenCurrentDatabase "c:\Program Files\opsnet\Opsnet20.mde"
db.Application.Visible = True

End Sub

 

[davers5]

Have you tried using a close statement? I'm not sure if it would work from excel but I'd give it a shot. From the help menu:

The following example uses the Close method to close the form Order Review, saving any changes to the form without prompting:

DoCmd.Close acForm, "Order Review", acSaveYes

Dave

 

[oravec]

Thanks,

That command works fine, but form must have a macro associated with the "OK" button that is not being activated with this method. Any way to automatically click "OK" button prior to closing form?

Cliff

 

[davers5]

I'm not quite sure what the problem is, however, you should look in help under the sendkeys method. You can "send" specific keystrokes to program (like the tab control three times). It's very inefficient but it works.

Dave

 

[oravec]

Thanks,

Will give that a try.

cliff