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

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

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 code below was working just as it should until I streamlined the database and updated with more stability. All of the fields that are need to run this report is available. The code is the control source for a financial report sent to the clients. Union query is need so that we can get all...

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