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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql Direct and Access

Status
Not open for further replies.
Aietoe

Aietoe

Technical User
Nov 30, 2000
85
CA
Hello!

Is it possible to read a parameter comming from a form in a SQL Direct query like as follow?

SELECT XXXXXXXX
FROM AAAAAAAAA.AAAAA_BBBBB_CCC
WHERE YYYYY_ZZZZZ =([Forms]![A-B-C-D]![Date])

Thanks

Gilles
 
Sort by date Sort by votes


No. Try using <db>.CreateQueryDef. Amiel
amielzz@netscape.net

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
590
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
612
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
3K
lameid
lameid
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
3K
dhookom
dhookom
monkeysee
  • Locked
  • Question
Automatic Invoicing in Access 1
Replies
6
Views
287
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top