Search results

I can assist. What is your scenario?

Sorry dude, I only have Access 2003. Can you convert (or can someone with 2007 solve this small problem?)..

OP, you are going to have to post your DB....it is hard to follow you now. Make a copy and empty out all the tables. Then post it.

I am discombobulated

Can you list the fields that are in the report source table or query please?

The field that you are filtering has to be in the report source table or query. Is it?

In the filter it has to be whatever the field is that is bound to the Visit ID textbox: Replace this part: theFIlter = "VisitID = " & theRecord with this (replacing <fielname> with your field name: theFIlter = "<fieldname> = " & theRecord

Hey, use a dialog box to get the folder. See attached example which calls a function for the get folder dialog

You can filter your receipt report by the current visit ID. See the attached DB for filtering a report demo.

This one has both exact matches and partial matches, still to message box (not report sorry..)

if you are recording their username in the record, and they access the records through a form you could have this on form open: strUser = VBA.Environ("username") me.filter = "usernameField = " & strUser me.filteron = true

Try this it has no rental option

Here is a sample:

Did you try importing your tables from the old database into my one and see if it works? I used the exact same table structure, so it should work. Let me know how that goes.

I also recall having to convert to US format and put # on either side of the date in an SQL statement....

Greetings, Have you checked that tblDocket.D_Date and [Forms]![frmCash]![TxtD_date] are in the same format? One of them might be date/time or US format. Put this into the event to check them: msgbox tblDocket.D_Date msgbox [Forms]![frmCash]![TxtD_date]

This puts em into a message box. Alter the code to put in a report.

That's Fantastic

Yep, put it in the macro

Me thinks... If the font is smallest and the names are not fitting, then you have to either make the chart bigger or split the staff into smaller groups (by department?) and make several charts.