Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Past Connect to __ Database prompt

Status
Not open for further replies.
davisto01

davisto01

MIS
Jul 11, 2003
21
US
I'm using a module to automate a process in Access.
Any Ideas on how to use a get past the “Connect to X database” prompt? I tried to use the sendkeys command:
Sendkey (tab)
Sendkey(my username)
Sendkey (tab)
Sendkey (tab)
Sendkey(my password)
Sendkey (tab)
Sendkey(enter)
Etc.
To get past it.
The issue with this is that the macro sends the keys way before the screen pops up.
Any suggestions? I was thinking I might be able to do this if there’s a way to:
send the keys ...
when screen pops up.
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
227
Moss100
Moss100
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
103
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
392
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
240
dhookom
dhookom
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
174
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top