Search results

Pretty much all processes are divisible. You just have to work out how many divisions (progress bar movements) you want and tell the P bar to progress at different stages through the code. If it is very time consuming due to processing a massive table then just use a counter or similar to...

Try this JohnPapa, I think you'll find it rather tastey...

it does work. Add photo simply adds or changes the filepath to the photo through a dialog box to "memProperyPhotoLink" Here is a sample that adds the photo to the form...

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.