473,549 Members | 2,655 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to display The values of a query

86 New Member
hello friends,
i am using ms access 2003.

i have a form.
and i want to show the results of a query output in the form.
the query is dynamic. it changes often.

for this purpose data grid suits well.
but we dont have data grid in ms access(by default).

so what should be my approach to display the results of the query?


Thanq
Sep 7 '07 #1
5 1894
hariharanmca
1,977 Top Contributor
hello friends,
i am using ms access 2003.

i have a form.
and i want to show the results of a query output in the form.
the query is dynamic. it changes often.

for this purpose data grid suits well.
but we dont have data grid in ms access(by default).

so what should be my approach to display the results of the query?


Thanq
I think this has to move in MS Access forum.
Sep 7 '07 #2
QVeen72
1,445 Recognized Expert Top Contributor
Hi,

Create a Query Object and
Create a Form Based on the Query Object and in runtime change the Query Parameters, And the show the form, Results will be automatically refreshed..


REgards
Veena
Sep 7 '07 #3
ravindarjobs
86 New Member
Hi,

Create a Query Object and
Create a Form Based on the Query Object and in runtime change the Query Parameters, And the show the form, Results will be automatically refreshed..


REgards
Veena


Thanq for your responses.

Veena if you dont mind, i dont know what a query object is.
do u mean creating a query manually through wizard?
can you please tell me?
else can you give a sample code.
if u cannot, can you please explain in detail.
.

please dont mind


Thanq
Sep 7 '07 #4
QVeen72
1,445 Recognized Expert Top Contributor
Hi Ravindra,

Yes, Create a New Query Thru Query Wizard Save the Query. And then Create a Form Based on this query. So if u change the query Parameters, and Run the Query, then the Results are displayed automatically..

Check This
or this

Regards
Veena
Sep 7 '07 #5
ravindarjobs
86 New Member
Hi Ravindra,

Yes, Create a New Query Thru Query Wizard Save the Query. And then Create a Form Based on this query. So if u change the query Parameters, and Run the Query, then the Results are displayed automatically..

Check This
or this

Regards
Veena


Thanq.

But isnt that query created by through wizard a standard one?

Means can we edit it at runtime?
how can we do that?
suppose i have created a query named "query1" through wizard, how can we edit this query at runtime?
veena, in my query the number of parameters too changes.
still are we able to display?
i am really glad to know this thing.
can you plase tell me how to do.

Thanq
Sep 7 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
1957
by: erica | last post by:
Hi, I am currently writing PHP code for some polling software. When someone votes, it stores their IP address in the database. From then on, they cannot vote in that particular poll, they only view the results. There are several polls in the database, and there is a field called "status". When it is 0, the poll is "active" and can be voted...
0
4072
by: dotyet | last post by:
Hey All, I have a small problem. consider the following >db2 "create table ttt (mynum float, yournum double )" DB20000I The SQL command completed successfully. >db2 "describe table ttt" Column Type Type
3
4018
by: google | last post by:
This is something I've done plenty of times in '97, but I can't seem to get it to work correctly in Access 2003. Say, for example, I have a form with an unbound combobox, the data source is a table of customers, first column is the key field, which is hidden with a 0" width, and the second column is the customer name. The SQL is a union...
3
1221
by: Miguel Dias Moura | last post by:
Hello, I am working in ASP.NET/VB and I need to see a string value. Howe can I display the string values and also only one of the values? Thanks, Miguel
3
3114
by: Bob Sanderson | last post by:
I am trying to create a form for a MySQL database similar to a spreadsheet. The idea is to display a list of records, with the last line of the list being an input form. When the user enters data in the form and hits the submit button, the data is entered and the form is reloaded with the new data displayed and another input form becomes the...
1
3876
by: Regnab | last post by:
I've got a form where the user can edit the lookups available in the database. It consists of a list box of the various categories on the main form, a checkbox on the main form and a sub form which displays the lookup values in a datasheet format. When a lookup values is no longer current, the user can untick the "Active" box in the datasheet...
5
2750
by: PHPBABY3 | last post by:
Hi, 1. I have two SQL tables. I will call them employees and departments: EMP: LAST_NAME, FIRST_NAME, DEPTNM DEPT: NUM, NAME Input: text string FIND Output: the LAST_NAME, FIRST_NAME and department name NAME (link DEPTNM
2
1556
by: DavidOwens | last post by:
<form action="do.php" method="post"> <?php /* create table users (id int, staffid int, region varchar(20), firstname varchar(20), surname varchar(20)); insert into users values(1,1,'region1','John', 'Doe'),(2,2,'region1','Pete', 'Mackay'); create table stores (name varchar(10)); insert into stores...
4
13687
by: Yitzak | last post by:
Have a query that is arregated into crosstab query, it is working correctly. select Yes as selected from tblname or select true as selected from tblname Produces -1 ( vba value of True) in the results pane I would like to see it produce a checkbox with tick in just like I would see if I displayed a boolean/yes/no field from a table.
8
2719
ddtpmyra
by: ddtpmyra | last post by:
Hi, Im looking for sample code that will retrieve the values from mysql query. Most of my code has the "while($row = mysql_fetch_assoc($result))" and that will display the values by rows. How about the display are in indent format? Belowi s the input text box that I wanted to show the values from mysql query. Anybody can show me how...
0
7541
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...
0
7464
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...
0
7734
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. ...
1
7497
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...
0
6065
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...
1
5385
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...
0
5107
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...
0
3512
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...
0
3493
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.