If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
confused and lost
Okay, I've read and tried dozens of articles and suggestions about how to use
parameters, how it's done, and every time I try something, is comes up as not working. It's a report driven by a parameter driven query. The way the parameters are produced is to assign VBA date values to text boxes on a form, from which the query reads the parameters using something like... forms!frmReports!txtFirstBegin.value I've been trying to use the Between And operator since I have two dates. It seems to never work. I even tried entering parameters into the parameter screen on the query, didn't work. I've tried a where variable on a DoCmd.OpenReport statement. Didn't work. Does this even work anymore with Access or has Microsoft made it impossible to do this now? |
Thread Tools | |
Display Modes | |
|
|