Dynamic Report

[Samuel]

Hi

I would like to make a report dynamic i.e.. before I open the report I want
to set the SQL statement or the report's recordsource

Thank you,
Samuel

 

[Guest]

Hi Samuel,

See "Report Selection Example" here, created by Access MVP Armen Stein:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

If you'd like to know how it works, consider purchasing one of these books,
depending on which version of Access you are using:

http://www.amazon.com/s/ref=nb_ss_g...ks&field-keywords=Armen+Stein&Go.x=12&Go.y=10

Armen covers this technique in this book.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Armen Stein]

Hi Samuel,

See "Report Selection Example" here, created by Access MVP Armen Stein:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

If you'd like to know how it works, consider purchasing one of these books,
depending on which version of Access you are using:

http://www.amazon.com/s/ref=nb_ss_g...ks&field-keywords=Armen+Stein&Go.x=12&Go.y=10

Armen covers this technique in this book.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Thanks Tom!

Samuel, note that when using this technique, the report is actually
opened first, then its recordsource is altered during the Open event
before the recordsource has been evaluated.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[goode2fox]

hahahahahahahahahahahahahahahahahahahahahahahaha

 

[Michel Tim Becker]

hi

you know what i can not send the paper next week i can tell you something
about the paper call me later

 

[David Cressey]

I'm asking anyone who can help me. I'm a newbee. I installed a lexmark x1270
on my acer aspire 3680, vista, 2 days ago, but it keeps saying install your
software everytime i get on the computer. it's already done.but I put the CD
in a 2nd time to see the warranty info and now it keeps asking me to run the
software. help!!

Don't know whether this is the problem or not. Check it out.

There are two items of software that come on most CDs that are packaged with
printers.

One is an application that helps you generate material to be printed, or
helps you manage the printer itself, by doing things like printing a test
page.

The other is a driver that is specific to your printer. A driver is,
functionally, part of the operating system, but is generally provided by
the device vendor rather than by the OS maker (e.g. Microsoft).

I'm guessing that you installed the application, but not the driver. If
that's true, then every time you turn the printer on, the operating system
(e.g. Windows) will detect a device for which there is no driver, and alert
you to install the driver.

If my guess is correct, you need to answer the dialog. Have the CD ready.
When you see the button labelled "Have CD", press it. It should lead you
through the rest.

 

[Barbara Diehl]

I'm asking anyone who can help me. I'm a newbee. I installed a lexmark x1270
on my acer aspire 3680, vista, 2 days ago, but it keeps saying install your
software everytime i get on the computer. it's already done.but I put the CD
in a 2nd time to see the warranty info and now it keeps asking me to run the
software. help!!