473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Interactive query

Hi all,

I'm trying to create a form that will display the results of a query
that the user will decide on the fields searched. I need a form that
shows several fields, possibly in a list box or series of combo boxes
that the user can select the fields to search in. Then I need to use
the contents of one or more text fields that will contain the search
terms. Not all of the fields will be searched each time so how would I
go about setting this up?

Any help is greatly appreciated.

Many thanks, Dean...

Jun 5 '06 #1
2 1679

DeanL wrote:
Hi all,

I'm trying to create a form that will display the results of a query
that the user will decide on the fields searched. I need a form that
shows several fields, possibly in a list box or series of combo boxes
that the user can select the fields to search in. Then I need to use
the contents of one or more text fields that will contain the search
terms. Not all of the fields will be searched each time so how would I
go about setting this up?

Any help is greatly appreciated.

Many thanks, Dean...


there's an example of a form with a textbox at the top and the results
of the sql query in a flexgrid (I think) in the lower portion of the
form. The only difference is that you'd have a field list (combobox
wizard will do this no problem) to get the fields to search. Then
you'd just OR the stuff together, generate your SQL statement, then set
the rowsource for the flexgrid.

Jun 6 '06 #2

pi********@hotmail.com wrote:
DeanL wrote:
Hi all,

I'm trying to create a form that will display the results of a query
that the user will decide on the fields searched. I need a form that
shows several fields, possibly in a list box or series of combo boxes
that the user can select the fields to search in. Then I need to use
the contents of one or more text fields that will contain the search
terms. Not all of the fields will be searched each time so how would I
go about setting this up?


Did you look at the SQL text/results table form in ADH?

I would start there and then maybe use a multi-select listbox to
collect fields to be listed and maybe a subform to collect fields and
values combinations to search. Something like...

<cboFieldList> <cboSymbol> <txtValue>
e.g. <tblLineItems.ItemID><"="><15>

and then you'd end up with...
SELECT...
FROM...
WHERE tblLineItems.ItemID=15;

then you'd assign the flexgrid control's rowsource to the query. (See
ADH).

Essentially, you'd just replace the textbox control with controls to
choose {FieldName, Operator, ComparisonValue}, and then generate the
SQL on the fly, and then assign it to the rowsource of the grid.

Confused? (So am I!!)

Pieter

Jun 6 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
by: Joe | last post by:
When you run "python -i scriptname.py" after the script completes you left at the interactive command prompt. Is there a way to have this occur from a running program? In other words can I...
2
by: Charles Krug | last post by:
List: I'm trying to us pylab to see what I'm doing with some DSP algorithms, in case my posts about convolution and ffts weren't giving it away. I've been using pylab's plot function, but I'm...
3
by: GB | last post by:
After having established a connection to my local db using tcp/ip I run a simple select request. I allways get following error when using the interactive tab in the command center: "DBA2192...
1
by: Nick Palmer | last post by:
As the title suggests, I've got a question about running an ASP.NET app on a server that has no interactive desktop login. In all our testing of our app here,the server always had an interactive...
2
by: WJ | last post by:
I have three ASPX pages: 1. "WebForm1.aspx" is interactive, responsible for calling a web site (https://www.payMe.com) with $$$. It is working fine. 2. "WebForm2.aspx" is non-interactive, a...
3
by: Lubomir | last post by:
Hi, I read that interactive windows services will not be allowed to run under Wista. I would like to ask what exactly is the interactive service. It is supposed to be a service that communicates...
0
by: Xah Lee | last post by:
Interactive Find and Replace String Patterns on Multiple Files Xah Lee, 2006-06 Suppose you need to do find and replace of a string pattern, for all files in a directory. However, you do not...
5
by: Julian | last post by:
I have a saved query from which I build my weekly customer reports. It queries a "Region" column which has predefined values: North, South etc. With this same query I would like to quier one more...
1
by: KPOJonesECC | last post by:
I am currently working on creating a visual calculator in an access form. The visual bit being a graph and the interactive bit (or what I would like) being that by moving sliders on a series of sub...
3
DAF LAD
by: DAF LAD | last post by:
Hi All, I have a dtatbase that stores alot of data. I have a query that brings back all the data that i need for the reports I need to produce. These reports that I produce are organised by date....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.