brucemc777
Member
- Local time
- Today, 15:30
- Joined
- Nov 1, 2012
- Messages
- 88
Good Afternoon Everyone!
Can anyone tell me what i am doing wrong with the following?
As i am getting the following error:
Since i am learning about recordsets right now due to necessity, i am using without fully understanding, and unfortunately the same goes with SQL - some knowledge, more than i have about nuclear reactors, but less than i have about a stapler. I went to the length of copying the spelling from the source items into the SQL text to eliminate "fat finger issues" in spellink.
Many thanks for your kind consideration!!!
-Bruce
Can anyone tell me what i am doing wrong with the following?
Code:
sSQL = "SELECT ContactBilling, EmailBilling, BankAccount, FROM qryCustomerEmail"
Set db = CurrentDb
Set rs = db.OpenRecordset(sSQL, dbOpenSnapshot)
As i am getting the following error:
Since i am learning about recordsets right now due to necessity, i am using without fully understanding, and unfortunately the same goes with SQL - some knowledge, more than i have about nuclear reactors, but less than i have about a stapler. I went to the length of copying the spelling from the source items into the SQL text to eliminate "fat finger issues" in spellink.

Many thanks for your kind consideration!!!
-Bruce