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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.