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

Thounsands of Queries

Status
Not open for further replies.
JUANCARLOS

JUANCARLOS

Programmer
Oct 30, 2000
61
0
0
PE
How to reduce database objets with code
I Have so much queries to any function like dsum, dlookup, etc, how to replace query object to code.
 
Sort by date Sort by votes
View the query in SQL view. Copy the sql code to where you want the query to run and use this format:

DoCmd.RunSQL "SQL view of query"

Uncle Jack
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
182
TheresAlwaysAWay
TheresAlwaysAWay
Jaime_78
  • Locked
  • Question
DoCmd.OpenReport Hangs when user wants to select location of report to save to
Replies
2
Views
73
Jaime_78
Jaime_78
lameid
  • Locked
  • Question
Office / Access 365 Trusted locations and GP
Replies
0
Views
102
lameid
lameid
qqp
  • Locked
  • Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
68
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Who has the largest Access Database in terms of objects (forms etc)???
Replies
2
Views
60
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top