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

Set a MS Access Report Recordsource from a script

Status
Not open for further replies.
Malc8179

Malc8179

MIS
Oct 8, 2007
28
GB

Hi Guys

im trying to change a reports recordsource from a bit of code

im using
Reports!GND37R01.RecordSource = "qrygnd37r01"

and i get a runtime error 2451

any thoughts
 
Sort by date Sort by votes
have you tried

me.RecordSource = "qrygnd37r01"

just a thought

Hope this is of use, Rob.[yoda]
 
Upvote 0 Downvote
i was close it should be like

me.RecordSource = "SELECT * FROM [qrygnd37r01]"

should work.

Hope this is of use, Rob.[yoda]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
582
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
988
strongm
strongm
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
866
hermanlaksko
hermanlaksko
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
484
sal21
sal21
Moss100
  • Locked
  • Question
Updating Outlook Contacts from Access
Replies
0
Views
332
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top