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

Viewing an SQL statement

Status
Not open for further replies.
Rohdem

Rohdem

Programmer
Sep 20, 2000
553
US
I have a sql string that I built in code. What I want to do is, using code, open the sql in datasheet view like it does when you click on the ! in the Access QBE. Is this possible?

Mike Rohde
rohdem@marshallengines.com
 
Sort by date Sort by votes
I'm thinking that a simple DoCmd.RunSQL("SQLstatement") might be of help.
 
Upvote 0 Downvote
I figured out what I needed. I used a querydef and then a docmd.openquery.

This saves my sql as a query and opens it.

Mike Rohde
rohdem@marshallengines.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
5K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
7K
Andrzejek
Andrzejek
ameedoo3000
  • Locked
  • Question
animation waiting
Replies
0
Views
470
ameedoo3000
ameedoo3000
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top