By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

vba reports and queries

P: n/a
Hi,

I've managed to create a form with various components on to create an sql
query within vba.

So I can create the query, and a recordset of the results, but how can I
then go about showing this to the user?
Ideally I would like the query (which is address details) to display as
mailing labels in a specified format, but I would appreciate help
surrounding the whole idea rather than just that specifically.

Web resources are also appreciated.

Thanks,
Chris
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I am not exactly clear about what you are trying to do. However, you can
do just about anything: take the SQL statement that you construct in VBA
and use it as data source for your report that is formatted as mailing
labels. Or you could use that SQL statement as data source for a form.
Either way you get what you need.
Good luck,
Pavel

C L Humphreys wrote:

Hi,

I've managed to create a form with various components on to create an sql
query within vba.

So I can create the query, and a recordset of the results, but how can I
then go about showing this to the user?
Ideally I would like the query (which is address details) to display as
mailing labels in a specified format, but I would appreciate help
surrounding the whole idea rather than just that specifically.

Web resources are also appreciated.

Thanks,
Chris

Nov 12 '05 #2

P: n/a
"C L Humphreys" <cl*********@toofgib.moc> wrote in message news:<bk**********@ucsnew1.ncl.ac.uk>...
Hi,

I've managed to create a form with various components on to create an sql
query within vba.

So I can create the query, and a recordset of the results, but how can I
then go about showing this to the user?
Ideally I would like the query (which is address details) to display as
mailing labels in a specified format, but I would appreciate help
surrounding the whole idea rather than just that specifically.

Web resources are also appreciated.

Thanks,
Chris


Um... one option is to use a "holder" query that you update with this
SQL statement. Then save the query. Then set the recordsource of the
report to the canned query.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.