Referencing a table from VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure this is the right place for this question again ... however I am
very Stuck!

I have a Form that makes calls to several SQL statements through VBA, The
Module is getting somewhat untidy and I was seeking a way to reference a
SQLQuery Table (that I have created) that I could call in the SQL statements
From ??

Thus instead of having lengthy cumbersome SQL statements ... SELECT * FROM etc
I could reference the table identifier and lift the SQL text ???

The table has currently three colums QryNo (Integer), QryName(String) and
QryText(Memo[due to length of some of the queries])

Can anyone point me in the right direction for the VBA code to lookup this
table Using either QryNo or QryName and return the QryText

Any pointers gratefully appreciated
 
Please Cancel ... I will read my books more thoroughly

I have used DLookup("[QryText]", "tblQry", "[QryName] = 'xyz'"

Many Thanks in anycase

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-Selection Code review 2
HELP --- Please 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Searching for partial match on a referenced table? 2
Open a word mail-merge document from Excel VBA 1
VBA Macro Copy Table and Increment by One Letter 1
SQL table updating 1
Problem with complex sql statement underlying a form 1

Back
Top