473,804 Members | 3,185 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 6418
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.goo gle.com...
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******@sympa tico.ca> wrote in message news:<Wo******* *************@n ews20.bellgloba l.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.goo gle.com...
"Mike Storr" <st******@sympa tico.ca> wrote in message

news:<Wo******* *************@n ews20.bellgloba l.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
2966
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 "frames"). Do you think this is true> 2. Some people think they take up too much KB. 3. Some people are worried that people who have javascript turned off wont be able to see them. What percent of web users have javascrips turned off? I thought it was...
10
3491
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 there is no drop down menu functionality at all. I wanted to implement an alternative stylesheet for IE, but my link to it is apparently broken. What is wrong with my link? I'd
0
16172
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
2586
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 disappears). Is there a way, I can keep the menu always on top. ( A good example of what I'm looking for is similar to the menu bar in http://www.milonic.com/ ).
4
2671
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 problem only in IE, in firefox it works ok. Is there a solution to this problem? I tried to hide the drop down when the menu opens but sometimes the menu covers only a small part of the drop down, but enough to obscure the menu choice. I would...
1
2860
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 a bit of information on what i did if you want t read it. When I choose select an option in the drop down menu and hit submit, I increase a counter, and a 2nd loop generates a second drop down menu with the same options. This is exactly what...
3
4469
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 having one problem. The menu, as designed, is a 1-tier menu (or is it 2-tier). It has the horizontal menu bar, along with the drop downs... but the drop downs aren't designed to propogate another menu (3rd teir). I was wondering if, but looking at...
4
9301
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 if it works, and if it does not, tell me why it does not work. Thanks.
1
2411
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 name="menu" style="font-family:'Calligrapher';color:#993333;background-color:#FFFFFF;font-size:10pt;"><option value="http://www.localwebsolutions.com/local-business-marketing-online.html">Marketing Online</option><option...
22
3471
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);
0
9704
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10562
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10319
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10070
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9132
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7608
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5639
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4282
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2978
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.