|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
vba access automation bypassing autoexec
Hello,
I'm trying to automate some work processes. Basically, from Excel, I have to open up access and run some things in there. Unfortunately for me, the person who set up the access database has it so that you've got to enter your initials on setup. I can't get passed this. I remember reading somewhere that you can have access open up normally if someone goes to it normally, but have it skip initial macros if it comes in through an automation process. Can anyone tell me what I'd be looking for. What property is it? Thanks. Jeff |
|
#2
|
|||
|
|||
|
I can't know your meaning fairly..What's your problem??When u open a access file from excel,u get some trouble in here??
|
|
#3
|
|||
|
|||
|
access automation
I'll try to describe things a bit better.
We have a database that we all use at work. When I open it a form pops up asking me to type my initials in. Only once I do that will it then let me go do other database things like printing reports and such. Now, when I want to automate the printing of reports, I can open up Access from Excel, but I get the same form asking me for my initials. I would like to be able bypass that form when I'm running a vba script from excel. I don't mind having to do it when I'm doing things manually, but I'd like to skip it when I'm opening it as part of an automation program. Thanks. Jeff |
|
#4
|
|||
|
|||
|
When u open a database,the DB will ask your password??And u will skip this step with automaticlly to do it??This is your meaning??
|
|
#5
|
|||
|
|||
|
vba access automation
Well, close.
It's not really a password. It's more just like an identification. there's a table in the database with my initials. It looks at that table and puts those initials in the form that it shows. The thing is, I've worked a bit more on this and I think it's doing it before the autoexec file is even run. So it's not really a password because I could type anything in there. It's really more just a way to know who is logged on to keep a record of what you do. I don't know if the fact that it's not a password matters so much. But it does seem to be doing this before the autoexec. |
|
#6
|
|||
|
|||
|
If u will press some key to access when the db is opened,U can try to use vba with sendkey function to send key press to the access.
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > vba access automation bypassing autoexec |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|