Noob:VB help calling a control to open the database window | | |
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 | | | | 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
| | | | 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:
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:
Ken- Hide quoted text -
>
- Show quoted text -
| | | | 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:
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:
Ken- Hide quoted text -
> Quote:
- Show quoted text -
| | | | 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:
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:
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:
Ken- Hide quoted text -
> Quote: Quote:
- Show quoted text -- Hide quoted text -
>
- Show quoted text -
| | | | 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:
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:
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:
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 |  | Similar Microsoft Access / VBA bytes | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,272 network members.
|