Recent content by gator9

I have a MFC-8420 that works great on server 2003 however when I go to install the drivers it gives an error. The Windows WIA is enabled but there seems to be a problem with the drivers. Can anyone direct me to the correct drivers or offer a solution? Sincerely, Charles...

I found that the postnet font I am using seems to be the problem. When I changed the font out all workstations work. Go figure. Sincerely, Charles http://grahamenterprises.net

Redid the entire sysytem and the postnet font still does display correct? I have a micr font that I use and it is fine. Sincerely, Charles http://grahamenterprises.net

There are no differences. Sincerely, Charles http://grahamenterprises.net

Yes the font is available, and the drivers are the same. All other workstation work fine except one. Sincerely, Charles http://grahamenterprises.net

Here is a good one guys. I have a report that has a post net barcode font. Now when the report font type is listed as postnet on the report and the database is assessed on the server directly it works fine, but if you assess the database from a workstation the font on the report shows in the...

Yea thats why I say sratch it, I found that out when playing with it. Sincerely, Charles http://grahamenterprises.net

Sratch my last post it does not work! Sincerely, Charles http://grahamenterprises.net

Below is another way that seems to work pretty good and is easer not to make a mistake in having both the record source and the on open the same: Thanks for your help. Record Source = ---- SELECT DISTINCTROW MDraft.* FROM MDraft WHERE (((MDraft.DraftStartDate)<Date()+1) AND...

Ok Got it, but if you don't bound the record source as it is below it will open all the records once the criteria meets. Oh and I took out the where because I kept getting an error and it worked great. Record Source = ---- SELECT DISTINCTROW MDraft.* FROM MDraft WHERE...

Here is the exact error: Run-time error '3075': Missing ), ], or Item in query expression 'WHERE ([DraftStartDate]< Date()+1) AND ([MonthlyDraftYes] = Yes'. Sincerely, Charles http://grahamenterprises.net

Still getting an error but I do see what your shooting for. If IsNull(DLookup("[DraftStartDate]", "MDraft", Criteria)) <--- Error in above line Sincerely, Charles http://grahamenterprises.net

Good thought but this code is located in the record source. If there is another way please let me know. Sincerely, Charles http://grahamenterprises.net

Hey guy! The code below works great but when none of the criteria meets it shows the form, but shows it blank. What I would like is for it to prompt with a message and a button to close the message box without opening the form if the criteria doesn’t meet, any help? SELECT DISTINCTROW MDraft.*...

Thanks Lighting that is what the problem was, I guess it neeeded to know the exact order. What puzzles me is why it worked before. Here is the correct code for anyone that needs example: SELECT DISTINCTROW Projects.ProjectID, DebtorPaid, TotalPaidToClient, TotalPlus...