Search results

I got it; too many quotes stLinkCriteria1 = "[RecordLock]=No And [Analysts]=" & StaffUserID()

StaffUserID() is a function

I am once again having syntax issues with the following statement. I have tried all variations of single ticks and quotes, HELP !!!!! I can get the two statements to work separately, but when I add the "AND" it fails. The "RecordLock" field is a yes/no field. stLinkCriteria =...

THANK YOU Ajetrumpet, your code worked perfectly. I always seem to have difficulty with ticks and quotes. Appreciated, Gina

I have a form with 10 unbound text boxes. A user will populate between 1 and 10 of these text boxes with report criteria, and click a button to open a report. The data in the criteria field is not consistant (which is a issue I will eventually fix), so if the user is looking for P2522, it could...

Hi, I was wondering if you ever came up with a better solution to this printing issue. I have a similiar issue and the CPU speed is the issue. Thanks,

Thanks Axis I will give it a try.

I have used Wasp Fontware. It seemed to be the easiest to install and use. Within minutes I had barcodes on my reports. You must add and * before and after * your data to make it scannable.

I am trying to figure out set up a command button in a form that runs a select query using the parameter "Between..and.." then runs a report using the same criteria and if o.k., then runs an update query using the same criteria without asking the user the parameters 3 times. I'm not familiar...

I have just purchase Wasp Bar Code Fontware for $95.00 and it works great.