Connecting Tech Pros Worldwide Help | Site Map

Noob:VB help calling a control to open the database window

kennyrogersjr
Guest
 
Posts: n/a
#1: May 3 '07
Hello,

My main question is... What and where do I write to allow a button in
a form to open my main database window?

We all know the keyboard command F11 opens the database window. Well,
when I edit the Startup... menu and disable everything, I still want
to be able to edit the database.

I'm using the Switchboard Manager to organize all my forms and
reports. I'm trying to make it so simple, that anybody in my
workcenter can open it and fill in/print out the information that they
want. However, I need to make a hole in the form so I, or the next
person after me, can come in and edit the forms and reports to meet
the needs of our jobs.

Is this possible?

Thanks,



Ken

Jason Lepack
Guest
 
Posts: n/a
#2: May 3 '07

re: Noob:VB help calling a control to open the database window


To edit the database, just hold SHIFT on startup, it will bypass the
startup routine.

Cheers,
Jason Lepack


On May 3, 10:38 am, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
Quote:
Hello,
>
My main question is... What and where do I write to allow a button in
a form to open my main database window?
>
We all know the keyboard command F11 opens the database window. Well,
when I edit the Startup... menu and disable everything, I still want
to be able to edit the database.
>
I'm using the Switchboard Manager to organize all my forms and
reports. I'm trying to make it so simple, that anybody in my
workcenter can open it and fill in/print out the information that they
want. However, I need to make a hole in the form so I, or the next
person after me, can come in and edit the forms and reports to meet
the needs of our jobs.
>
Is this possible?
>
Thanks,
>
Ken

kennyrogersjr
Guest
 
Posts: n/a
#3: May 4 '07

re: Noob:VB help calling a control to open the database window


That doesn't work when you uncheck all options in Startup....

Is there anyway I can right some VB code to allow access to open the
main database window?

Thanks,



Ken

On May 3, 11:38 am, Jason Lepack <jlep...@gmail.comwrote:
Quote:
To edit the database, just hold SHIFT on startup, it will bypass the
startup routine.
>
Cheers,
Jason Lepack
>
On May 3, 10:38 am, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
>
>
>
Quote:
Hello,
>
Quote:
My main question is... What and where do I write to allow a button in
a form to open my main database window?
>
Quote:
We all know the keyboard command F11 opens the database window. Well,
when I edit the Startup... menu and disable everything, I still want
to be able to edit the database.
>
Quote:
I'm using the Switchboard Manager to organize all my forms and
reports. I'm trying to make it so simple, that anybody in my
workcenter can open it and fill in/print out the information that they
want. However, I need to make a hole in the form so I, or the next
person after me, can come in and edit the forms and reports to meet
the needs of our jobs.
>
Quote:
Is this possible?
>
Quote:
Thanks,
>
Quote:
Ken- Hide quoted text -
>
- Show quoted text -

Jason Lepack
Guest
 
Posts: n/a
#4: May 4 '07

re: Noob:VB help calling a control to open the database window


I'm using Access 2003 and it definitely does work. Open the database
while holding the SHFT key. If you get the little Security Warning
window, hold SHIFT while clicking Open.

Cheers,
Jason Lepack


On May 3, 8:43 pm, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
Quote:
That doesn't work when you uncheck all options in Startup....
>
Is there anyway I can right some VB code to allow access to open the
main database window?
>
Thanks,
>
Ken
>
On May 3, 11:38 am, Jason Lepack <jlep...@gmail.comwrote:
>
Quote:
To edit the database, just hold SHIFT on startup, it will bypass the
startup routine.
>
Quote:
Cheers,
Jason Lepack
>
Quote:
On May 3, 10:38 am, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
>
Quote:
Quote:
Hello,
>
Quote:
Quote:
My main question is... What and where do I write to allow a button in
a form to open my main database window?
>
Quote:
Quote:
We all know the keyboard command F11 opens the database window. Well,
when I edit the Startup... menu and disable everything, I still want
to be able to edit the database.
>
Quote:
Quote:
I'm using the Switchboard Manager to organize all my forms and
reports. I'm trying to make it so simple, that anybody in my
workcenter can open it and fill in/print out the information that they
want. However, I need to make a hole in the form so I, or the next
person after me, can come in and edit the forms and reports to meet
the needs of our jobs.
>
Quote:
Quote:
Is this possible?
>
Quote:
Quote:
Thanks,
>
Quote:
Quote:
Ken- Hide quoted text -
>
Quote:
- Show quoted text -

kennyrogersjr
Guest
 
Posts: n/a
#5: May 4 '07

re: Noob:VB help calling a control to open the database window


I'm going to have to try it again at work, but I'm pretty sure I held
SHIFT down the whole time until my form opened.

Thanks,



Ken

On May 3, 8:57 pm, Jason Lepack <jlep...@gmail.comwrote:
Quote:
I'm using Access 2003 and it definitely does work. Open the database
while holding the SHFT key. If you get the little Security Warning
window, hold SHIFT while clicking Open.
>
Cheers,
Jason Lepack
>
On May 3, 8:43 pm, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
>
>
>
Quote:
That doesn't work when you uncheck all options in Startup....
>
Quote:
Is there anyway I can right some VB code to allow access to open the
main database window?
>
Quote:
Thanks,
>
Quote:
Ken
>
Quote:
On May 3, 11:38 am, Jason Lepack <jlep...@gmail.comwrote:
>
Quote:
Quote:
To edit the database, just hold SHIFT on startup, it will bypass the
startup routine.
>
Quote:
Quote:
Cheers,
Jason Lepack
>
Quote:
Quote:
On May 3, 10:38 am, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
>
Quote:
Quote:
Hello,
>
Quote:
Quote:
My main question is... What and where do I write to allow a button in
a form to open my main database window?
>
Quote:
Quote:
We all know the keyboard command F11 opens the database window. Well,
when I edit the Startup... menu and disable everything, I still want
to be able to edit the database.
>
Quote:
Quote:
I'm using the Switchboard Manager to organize all my forms and
reports. I'm trying to make it so simple, that anybody in my
workcenter can open it and fill in/print out the information that they
want. However, I need to make a hole in the form so I, or the next
person after me, can come in and edit the forms and reports to meet
the needs of our jobs.
>
Quote:
Quote:
Is this possible?
>
Quote:
Quote:
Thanks,
>
Quote:
Quote:
Ken- Hide quoted text -
>
Quote:
Quote:
- Show quoted text -- Hide quoted text -
>
- Show quoted text -

ManningFan
Guest
 
Posts: n/a
#6: May 4 '07

re: Noob:VB help calling a control to open the database window


On May 3, 10:08 pm, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
Quote:
I'm going to have to try it again at work, but I'm pretty sure I held
SHIFT down the whole time until my form opened.
>
Thanks,
>
Ken
>
On May 3, 8:57 pm, Jason Lepack <jlep...@gmail.comwrote:
>
>
>
Quote:
I'm using Access 2003 and it definitely does work. Open the database
while holding the SHFT key. If you get the little Security Warning
window, hold SHIFT while clicking Open.
>
Quote:
Cheers,
Jason Lepack
>
Quote:
On May 3, 8:43 pm, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
>
Quote:
Quote:
That doesn't work when you uncheck all options in Startup....
>
Quote:
Quote:
Is there anyway I can right some VB code to allow access to open the
main database window?
>
Quote:
Quote:
Thanks,
>
Quote:
Quote:
Ken
>
Quote:
Quote:
On May 3, 11:38 am, Jason Lepack <jlep...@gmail.comwrote:
>
Quote:
Quote:
To edit the database, just hold SHIFT on startup, it will bypass the
startup routine.
>
Quote:
Quote:
Cheers,
Jason Lepack
>
Quote:
Quote:
On May 3, 10:38 am, kennyrogersjr <kennyroger...@kennyrogersjr.com>
wrote:
>
Quote:
Quote:
Hello,
>
Quote:
Quote:
My main question is... What and where do I write to allow a button in
a form to open my main database window?
>
Quote:
Quote:
We all know the keyboard command F11 opens the database window. Well,
when I edit the Startup... menu and disable everything, I still want
to be able to edit the database.
>
Quote:
Quote:
I'm using the Switchboard Manager to organize all my forms and
reports. I'm trying to make it so simple, that anybody in my
workcenter can open it and fill in/print out the information that they
want. However, I need to make a hole in the form so I, or the next
person after me, can come in and edit the forms and reports to meet
the needs of our jobs.
>
Quote:
Quote:
Is this possible?
>
Quote:
Quote:
Thanks,
>
Quote:
Quote:
Ken- Hide quoted text -
>
Quote:
Quote:
- Show quoted text -- Hide quoted text -
>
Quote:
- Show quoted text -- Hide quoted text -
>
- Show quoted text -
Ken -
Skip the n00bs who think they know more than u.

Where I work we use the following code. Some of it will need to be
modified to fit your database, but the concepts should point you in
the right direction:

'ADD SHOW DATABASE WINDOW
Set CmndB = .CommandBar.Controls.Add(msoControlButton, , , ,
False)
With CmndB
.Caption = "Unhide Database"
.FaceId = 69
.OnAction = "=DatabaseVisible('True')"
.Parameter = "Value"
.TooltipText = "Open the Database Config Form"
.Style = msoButtonIconAndCaption
.Width = 50

Closed Thread


Similar Microsoft Access / VBA bytes