I have a form that I use to input criteria that I have then being passed into a query. Currently the query saves the results as an excell file. I would also like to have the results show up in the form, I guess as a subform. If this is possible I would love some assitance on this. Thanks to all of you who have helped me so far.
32  18607  MMcCarthy 14,534
Recognized Expert Moderator MVP
I have a form that I use to input criteria that I have then being passed into a query. Currently the query saves the results as an excell file. I would also like to have the results show up in the form, I guess as a subform. If this is possible I would love some assitance on this. Thanks to all of you who have helped me so far.
Create an unbound subform based on this query and don't bind it to the main form with any master child relationship.
You will need to requery the subform in code somewhere maybe behind a command button. - Me.subformObjectName.Requery
Mary
Create an unbound subform based on this query and don't bind it to the main form with any master child relationship.
You will need to requery the subform in code somewhere maybe behind a command button.
- Me.subformObjectName.Requery
Mary
Sorry, but how would I do that exactly? <--Newb
Create an unbound subform based on this query and don't bind it to the main form with any master child relationship.
You will need to requery the subform in code somewhere maybe behind a command button.
- Me.subformObjectName.Requery
Mary
What do I put in for the Me part of your code, and where does it go?
What do I put in for the Me part of your code, and where does it go?
i also set up the sub form to be independent of the main form. I need the subform however only to populate when I run the query from the main form, to save on load time.
I am using this:
DoCmd.OutputTo acOutputQuery, "TestQuery" , acFormatXLS, "", False
to output to an excell file
MMcCarthy 14,534
Recognized Expert Moderator MVP
i also set up the sub form to be independent of the main form. I need the subform however only to populate when I run the query from the main form, to save on load time.
thats what the Me.subformObjec tname.Requery is for.
Put a command button on the form to run the query (use the wizzard) and then add this line of code substituting the subformObjectna me.
Mary
thats what the Me.subformObjec tname.Requery is for.
Put a command button on the form to run the query (use the wizzard) and then add this line of code substituting the subformObjectna me.
Mary
You are a life saver thank you so much!!!
is there a way to keep that subform from running until I click that query button?
MMcCarthy 14,534
Recognized Expert Moderator MVP
You are a life saver thank you so much!!!
is there a way to keep that subform from running until I click that query button?
It will run when the form opens and shouldn't run again until the button is clicked.
It will run when the form opens and shouldn't run again until the button is clicked.
Yes that is what it does now. But the query, unrestricted, could take A LONG time to run. is there a way to prevent this?
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: heyitsme_ryan |
last post by:
Ei guys I’m Ryan from Philippines, I need your advice and
recommendations about Windows 2003 Server and SQL Server 2000
installation. Well, here’s the scenario.
First is for windows 2003 server:
We have a windows 2003 server that is a Logon Server and we have at
least 90 workstation here in our office to manage. The problem is when
we...
|
by: Jeremiah J. Burton |
last post by:
I am trying to create a database (in Acces 2000) to track my fossil
collection. I have a main table that has records for every specemen. I
have a secondary table with information on localities that the specimens
were collected at. The tables are linked. Each record in the specimen
table will link to only 1 record in the locality table,...
|
by: Susan Bricker |
last post by:
Greetings.
I am having trouble populating text data that represents data in my
table. Here's the setup:
There is a People Table (name, address, phone, ...)
peopleID = autonumber key
There is a Judge Table (information about judges)
judgeID = autonumber key
|
by: Susan Bricker |
last post by:
Greetings. Before I begin, I have been stuck on this problem for about a
5 days, now. I have tried and just seem to be not getting anywhere. I
know that the explanation is lengthy, but I am a relative newcomer to
Access and need to be methodical until it become more familiar. Thanks
in advance for your help.
I have a form with a subform...
|
by: Uninvisible |
last post by:
I have put together a db for a law firm to keep track of counterfeit
activities. There are four parent tables:
tblContact
tblTransaction
tblAction
tblFile
I have created a form, frmNewMatter, for adding new records to the db.
The form is based on tblFile and has a subform based on tblContact,
| | |
by: Anja |
last post by:
Hi everyone,
Well, kind of new to Access and VBA development in general.
What I have a query that returns me all records based on a criteria.
Now, I have a form where the user can choose this criterial via a combo
box and I want a sub form to show up with the relevant records.
I have 2 questions actually...
|
by: sesling |
last post by:
I have an unbound form (A). The form contains lists boxes that get information from different tables. When the form is opened the lists are populated with various bits of data. The operator will select certain items from the list boxes.
I have a query (Z) that uses the information the operator selects on form (A). This information is...
|
by: jerk |
last post by:
Hello,
Houston, i´ve got a problem... ;)
I am trying to make a subform Details which contains the following information (i am only mentioning the relevant ones)
- Country
- Currency
- Date
- Excange Rate
|
by: canabatz |
last post by:
im using paging on this query:
i got this code that returning wrong results:
(SELECT bid_price, count(*) as n from bidding_details where bid_id=$bid_id GROUP BY bid_price DESC HAVING n = 1 )
UNION ALL
(SELECT bid_price, count(*) as d from bidding_details where bid_id=$bid_id GROUP BY bid_price DESC HAVING d > 1) limit $eu, $limit ";
...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |
