473,385 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Drop down menu

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
3 6396
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
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: KK | last post by:
Drop-down menus are the hottest thing since Wonder Bread but . . . 1. Alot of people put them in the they-look-nice-but-you-cant-code-them-right-so-they-always-look-messed-up category (a la...
10
by: Haines Brown | last post by:
I've implemented the horizontal drop down menu discussed recently in this newsgroup, and it works nicely under Galeon and Mozilla, but not IE 5.0. Here are the problems: Under IE 5.0, the...
0
by: vikram.cvk | last post by:
Hello Experts, Im trying to design a CSS vertical drop down menu which should have the following functionality. Home About Us | -->Overview
2
by: hemanth.singamsetty | last post by:
Hello there, I've a drop down menu (created using CSS & Javascript -- see code below). My problem is, whenever I click a link on the menu the new page replaces the current page (and the menu...
4
by: simon.cigoj | last post by:
I have an javascript made menu and some forms with the dropdown element. When the menu opens and scrolls down the drop down is displeyed over the menu and obscures the menu choices. I have this...
1
by: phpnewb | last post by:
Hi, I know i'm doing it wrong, but I'm using a while loop right now to create several instances of a drop down menu. It gives me undesirable results. Can you tell me the right way to do it. Below are...
3
by: rsteph | last post by:
I have a javascript drop down menu that I borrowed from a website. It utilizes a little .css to help with formatting. The menu works great, and on all 3 of the browsers I'm concerned about; but I am...
4
by: TycoonUK | last post by:
Hi, As I do not have IE7 on my computer, I was wondering if there is a fault in my CSS Menu when using IE7. Please can someone look at my site - http://www.worldofmonopoly.co.uk and tell me...
1
by: Kaland | last post by:
Do the search engines follow links that are within forms (like the drop-down menu) so that those pages are indexed? Here is the code for a sample drop-down menu that I created. <form><select...
22
by: Archanak | last post by:
Hi, I am using 2-level CSS Drop Down Menu in my perl/CGI program. here is the code. #!c:/perl/bin/perl.exe use CGI qw(:standard);
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.