By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,347 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,347 IT Pros & Developers. It's quick & easy.

Drop down menu

P: n/a
Need help with creating a drop down menu. I am trying to replicate the
GUI of a large db application that runs on large Sun servers using
Oracle/Solaris, etc. My purpose is to create a stand-alone training
package using Access that people can run on a laptop to simulate as
near as possible the GUI of the real system.

My problem is that the actual application has a number of forms in
datasheet format which have a the word "File" in the form header. On
clicking "file" you then get a drop down menu with New (open New data
entry form), Open (open Edit form for selected row in datasheet),
Delete (delete selected row in datasheet), Cancel, plus other options
specific to the relevant form.

I have created the various forms and then added sub-forms in datasheet
format. My problem now is to create the drop down menu. I don't want
to use a Menu bar as this would not replicate the actual application.
I can't see how I can get a Command button to do the job.

My VBA knowledge is nil.

Looking at past group messages I haven't seen a solution, so any help
appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Without using a MenuBar (or at least a toolbar), I'm not sure how you could
possibly make a menu or toolbar.
Or maybe I don't understand what you are asking.

Mike Storr
www.veraccess.com
"Andy Munnis" <an***********@sciatl.com> wrote in message
news:f6**************************@posting.google.c om...
Need help with creating a drop down menu. I am trying to replicate the
GUI of a large db application that runs on large Sun servers using
Oracle/Solaris, etc. My purpose is to create a stand-alone training
package using Access that people can run on a laptop to simulate as
near as possible the GUI of the real system.

My problem is that the actual application has a number of forms in
datasheet format which have a the word "File" in the form header. On
clicking "file" you then get a drop down menu with New (open New data
entry form), Open (open Edit form for selected row in datasheet),
Delete (delete selected row in datasheet), Cancel, plus other options
specific to the relevant form.

I have created the various forms and then added sub-forms in datasheet
format. My problem now is to create the drop down menu. I don't want
to use a Menu bar as this would not replicate the actual application.
I can't see how I can get a Command button to do the job.

My VBA knowledge is nil.

Looking at past group messages I haven't seen a solution, so any help
appreciated.

Nov 12 '05 #2

P: n/a
"Mike Storr" <st******@sympatico.ca> wrote in message news:<Wo********************@news20.bellglobal.com >...
Without using a MenuBar (or at least a toolbar), I'm not sure how you could
possibly make a menu or toolbar.
Or maybe I don't understand what you are asking.

Mike Storr
www.veraccess.com

My understanding is that Access will not allow a customized Menubar to
be "locked" to top of a specific form, but is free floating. I want to
be able to have a customized drop-down menus which are locked to the
top of each form. I have been given some VBA code (thanks Darryl)which
gets multiple drop down menus on a form but so far I'm unable to get
the selected item to call the relavant action (as I say I have nil VBA
skills).

Andy
Nov 12 '05 #3

P: n/a
Without seeing what you've been given, I'm not sure anyone but Darryl could
help.
It is possible to attach custom commandbars to a form, however these will
appear at the top
of the access window. They can however show and hide themselves while the
form does not have focus.
"Andy Munnis" <an***********@sciatl.com> wrote in message
news:f6**************************@posting.google.c om...
"Mike Storr" <st******@sympatico.ca> wrote in message

news:<Wo********************@news20.bellglobal.com >...
Without using a MenuBar (or at least a toolbar), I'm not sure how you could possibly make a menu or toolbar.
Or maybe I don't understand what you are asking.

Mike Storr
www.veraccess.com

My understanding is that Access will not allow a customized Menubar to
be "locked" to top of a specific form, but is free floating. I want to
be able to have a customized drop-down menus which are locked to the
top of each form. I have been given some VBA code (thanks Darryl)which
gets multiple drop down menus on a form but so far I'm unable to get
the selected item to call the relavant action (as I say I have nil VBA
skills).

Andy

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.