Search results for query: *

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

...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 ((MDraft.MonthlyDraftYes)=Yes)); On Open (On The Form) = ---- If...

...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 (((MDraft.DraftStartDate)<Date()+1) AND ((MDraft.MonthlyDraftYes)=Yes)); On Open (On The Form) = ---- Dim Criteria As...

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

...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.* FROM MDraft WHERE (((MDraft.DraftStartDate)<Date()+1) AND ((MDraft.MonthlyDraftYes)=Yes)); Sincerely, Charles...

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...

Thanks PHV! Got it! I took out the single quotes and this is the code for others that may need it. Private Sub ProjectName_BeforeUpdate(Cancel As Integer) If (Not IsNull(DLookup("ProjectName", "Projects", _ "ProjectName='" & Me!ProjectName & "' AND ClientID=" & Me!ClientID & ""))) Then...

Your right the semicolon is not nessary but the problem is still there. Sincerely, Charles http://grahamenterprises.net

Yes the table structure is the same on both the projects, and aprojects. I will try removing the semicolon Sincerely, Charles http://grahamenterprises.net

...the data is in the correct field, it is. Now if you get rid of the union query it shows the data correctly. Any idea? SELECT DISTINCTROW Projects.*, Mid([ProjectName],InStr([ProjectName]," ")+1) & ", " & Left([ProjectName],InStr([ProjectName]," ")-1) as LstFrst FROM Projects WHERE...

Here is my code and it works great but it queries for duplicate records threw out my whole projects table, and in would like for it to filter its search via the client ID. Any Suggestions? Private Sub ProjectName_BeforeUpdate(Cancel As Integer) Dim stLinkCriteria As String...