Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I build a query from a form in access 1

Status
Not open for further replies.
JaneBeech

JaneBeech

Instructor
Nov 23, 2001
3
GB
Can anyone tell me how to makea userform to select which fields to display as the result of a query? This would be the equivalent of ticking the 'show' boxes in a QBE design grid. :)I
 
Sort by date Sort by votes
I'm not sure if I completely understand the question, but If I was going to do something like that with ASP, I would make a two step form that first presented the user with a list of choices of fields to query, and then based on the selections, pass the variables to the second part of the form using a querystring and have that part of the form build the SQL statement.

 
Upvote 0 Downvote
HI,

I have just completed what u r looking for! If you wish the code and example please let me know !

regards

Lee
 
Upvote 0 Downvote
Attn Lee24

Yes please I would like the code, but I don't know how to contact you directly! I'm in the UK

Jane Beech:)I
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
13
Views
429
strongm
strongm
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
241
mikrom
mikrom
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
3K
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
3K
lameid
lameid
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top