How Do I Set RecordSource in VBA to a Predefined Query
For example...
Me.RecordSource = qryAllUsers
Does not work.
Thanks,
Dave
How Do I Set RecordSource in VBA to a Predefined Query?
Hot Topic
- Runtime Error '2001'
- List available printers?
- ms access
- opc
- How to declare activeX object in source code instead on the form?
- Excel: Copying cells under a specific cell containing a title
- SQL within a VBA Module
- Substitute/Replace
- automatically saving word doc versions every 5mins
- Scorecard & Sharepoint
Microsoft ISV
- Happy Holidays
- MS Office document and image writer print driver
- Date and time picker control
- Possible to add multiple (300+) hyperlinks that run the same VBA code?
- Contact in Canada
- Setting Password Char in InputBox?
- How do connect an Excel file from Remote Server
- vlookup for a range of cells
- Projects, objects & modules
- Run-time error '2448' Using MultiSelect in MS Access 2003
How Do I Set RecordSource in VBA to a Predefined Query?
michael aird
That was it, I knew I was missing something really easy.
Thanks!
Dave
Jay S
Hey Dave,
Do this instead...
Me.RecordSource = "SELECT * FROM [qryAllUsers]"
Oren Novotny
Is qryAllUsers a String containing the SQL select query text, or is it a QueryDef object
RecordSource expects to be passed a String, not a QueryDef. If you're trying to pass the latter, it ought to be snagged as a compile-time error. Can you give any more information about how it "doesn't work"