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.
Jan 4 '07
32  18629 
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?
Right now the table is only about 7,000 records. This from will be used to query tables much, much, larger.
MMcCarthy 14,534
Recognized Expert Moderator MVP
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?
You could try leaving the Record Source of the Subform blank and add it as a line of code in the command button before the requery. - Forms![MainFormName]![SubformName].Form.RecordSource = "qryName"
You could try leaving the Record Source of the Subform blank and add it as a line of code in the command button before the requery.
- Forms![MainFormName]![SubformName].Form.RecordSource = "qryName"
WOW! you are awesome!!! How do you know so much about this? I am amazed at your knowledge of this Program!
MMcCarthy 14,534
Recognized Expert Moderator MVP
WOW! you are awesome!!! How do you know so much about this? I am amazed at your knowledge of this Program!
Years of experience. We all have to learn. You'll get there.
Mary
I was also wanting to know about having the ability to point this form at a database inside the form. Is this possible. It will only be used by myself and a coworker, so the danger may be reduced. Any thoughts?
MMcCarthy 14,534
Recognized Expert Moderator MVP
I was also wanting to know about having the ability to point this form at a database inside the form. Is this possible. It will only be used by myself and a coworker, so the danger may be reduced. Any thoughts?
Sorry Chase
I don't understand the question?
Mary
NeoPa 32,569
Recognized Expert Moderator MVP
I was also wanting to know about having the ability to point this form at a database inside the form. Is this possible. It will only be used by myself and a coworker, so the danger may be reduced. Any thoughts?
Are you asking about using a table from a different database within the form?
It's not clear I'm afraid from your post.
Are you asking about using a table from a different database within the form?
It's not clear I'm afraid from your post.
My form/query needs to look at several tables, but only one at a time. Each table contains information on a seperate product line, however each table has the same information, all labeled the same. Is it possible to select which DB you look at?
NeoPa 32,569
Recognized Expert Moderator MVP
I'll take that as a 'No' then.
What you need to do then (I would suggest) is to set the RecordSource of the form when you've determined which table you need to bind to. After setting it you may well need to do a ReQuery on the form (Call Me.reQuery).
NB. There is a difference between a Table and a Database.
A database contains tables, as well as many other object types.
I'll take that as a 'No' then.
What you need to do then (I would suggest) is to set the RecordSource of the form when you've determined which table you need to bind to. After setting it you may well need to do a ReQuery on the form (Call Me.reQuery).
Where do I go to change the record source. I was trying to go through the SQL code of the query the form is populating and change every instance of the DB name and replacing it with the value I place into a combo box. Is there an easier way?
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 connect to this logon server. It takes 15 to 20 minutes to connect
the workstation to the server. My...
|
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, however each
locality can be linked to multiple specimens.
I am trying to create a form (based on...
|
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 that has a subform.
form: frmEvents
subform: sfrmTrialInfo (controlname = )
|
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 listed in the criteria section of the query.
I have a form (B) that is bound to query (Z).
On...
|
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 ";
the limit is working only on the first query ,the second query is running after the first limit ,so...
|
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: 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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
