Hello,
I’m kind of new to Access 97 so please bear with me.
I have a form with four combo boxes linked to a union query. It’s a start date, end date, User, and system
What I am trying to do is, by there selections in the combo boxes I want to use the query to populate a report with the matching information.
All the combo boxes are populating with the correct information I just need to know the proper VB coding for the submit button.
Thank you.
3 1305 jimatqsi 1,276
Recognized Expert Top Contributor
Before we try to spell it out for you, guessing your field names and such, try using the button wizard to see how close you can get. When you add a button to your form, one of the wizard options is to launch a report.
The wizard leads you through the process to do exactly what you want.
Actually I don't remember well what is in Access 97, so I could be wrong for that version. If necessary, you might try loading Access 2000 or 2003 and do the same thing, then if you must work in 97, just apply the same code; you can probably even copy and paste the code from 2000/2003 to 97.
Jim
NeoPa 32,572
Recognized Expert Moderator MVP
That's good advice from Jim. If you want an understanding of how it works though, have a look at Example Filtering on a Form.
Welcome to Bytes!
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jim |
last post by:
Hi, there,
I am a beginner on Access.
I have been taking so long time to try to figure out his, but so far,
no clues.
I want to select 2 combo boxes and Access will automatically fill in
other 5 bound text fields for me. I searched all groups and microsoft
support sites, no result.
|
by: Steve Chatham |
last post by:
I have a page where I have some combo boxes on it. A click on each one
spawns another box, and another until each area has been selected, or until
they choose to pull all items into a datagrid from that category.
For instance:
say the first combo has in it:
meat
dairy
|
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the second combo to
change depending on what values the user selects in the first box, it's
just that every time the user changes the first combobox, the second
combobox FOR EVERY RECORD goes blank.
|
by: jim |
last post by:
I have created a Table that has 13 fields and 2 Primary Keys, e.g. 60 1, 60
2, ... 60 28,
61 1, 61 2, ... 61 28, etc...
I want to create a Form where I can input the Primary Key values to query
the Form to
show the 13 fields assigned to the Primary key pair. If I create 2 Combo
boxes I can only
get the see the assignments for the first Primary Key, or only for the
second Primary Key.
I can't see how to get the lookup to use both...
|
by: Miguel |
last post by:
I have synchronized combo boxes linking Account Type with Customer
Names based on the template that Microsoft has in one of its samples
databases. There are the appropriate relationships between the Account
Type Table and the Customer Name Table based on the ID field, so it is
the ID field which is stored in the main table. However, in the form,
the Account Type and Customer Name are displayed because the column
width property has been...
| |
by: consonanza |
last post by:
I am working on a report filter form. It has 2 combo boxes
(cmboSelectSubject and cmboSelectCategory) to select criteria.
Selecting an entry in combo 1
restricts the options available in combo 2.
The row source for combo2 is:
SELECT DISTINCT tblComplaintCategory.fldComplaintCategory,
tblComplaintCategory.fldComplaintCategoryID,
tblComplaintSubjects.fldComplaintSubjectID
|
by: Dave |
last post by:
I want to put the information that the user selects in my combo boxes
into a subform that lies on the same form as the combo boxes.
Thanks for your help already,
Dave
|
by: Dave |
last post by:
Hello all,
First I'd like to apologize...This post was meant to be put in my
previous post, but I tried many times without success to reply within
my previous post. Now here goes...
I have a main form (RD Form) with 4 combo boxes (i.e. cbo1, cbo2, etc)
and a subdatasheet (the subform...let's call it subInfo) below the
combo
boxes on the RD Form. I hope this eliminates any confusion of the
|
by: jaymaelescent |
last post by:
I have been asked by worklace to try and make a database for them, i have some experience but have encountered a problem making user specific reports. I need to make a report based on a person stored within the data base showing a series of data where i single field is null,
So the things i need to know is:
*How to make a query to pull out only data related to a specific field
*How to make that field be that the report will...
|
by: troy_lee |
last post by:
I want to look at the values of six combo boxes. If any of the boxes
are not null, I want to change the value of a separate text box. How
can I look at all of them at once?
Thanks in advance.
Troy Lee
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |