I have narrowed it down to [Field Trip Selection log].Driver) =" & Me![Employee]. My employees do have a comma in their names. Thank you for your help.
Error Code says:
Run-time error '3075'
Syntax error(comma) in query expression '(((Field Trip Selection log].Driver )= Thomas, Bob)And (([Field Trip Selection Log].[Yes]=False) And (([Field Trip Selection log]/[No] = False))'.
...
Vasago
Last Activity: Sep 3 '15, 08:17 PM
Joined: Mar 12 '14
Location:
-
Run Time Error '3075' Syntax error (comma) in Query
-
I do not have "pro" installed on my computer. If needed I will pick up a version of it.
I have Access 2013.
I'm going to say no to the digital certificate for file signing. I'm not sure what this is exactly. I don't need to ability to sign the documents but just a box where my clients can sign.
Thank you zmbd for the help. I couldn't find much at all on this subject. -
Exporting to PDF that contains a Digital Signature
Is there a way to export a form to PDF and have it contain a box for a digital signature? -
Run-time error '3075' with dlookup
I can't seem to get this dlookup to work correctly. I have double check all the spellings.
This is the error I'm Receiving.
Run-time error '3075':
Syntax error in query expression '[Trip Date] = #7/8/2014# and School = 'The A Group' and Amount =$409.78'.
Here is the code:
...Code:[Invoice #] = DLookup("[Invoice #]", "Invoices", "[Trip Date] = #" & Forms![charter -
Adding * to the left of a field to fill a certain number of characters
I am working out my payroll system and would like * to the left of the field that has the check amount in "words"
example:
(Currently Showing)
one thousand and five hundred dollar and 12 cents
(Would like it to show)
one thousand and five hundred dollar and 12 cents*********
Another example
(Currently Showing)
ten dollars
(Would like it to show)
ten dollars******** *************** *************** ********... -
Dsum with Syntax Error
I have a Dsum that worked until I added the " And [Trip Sign Off] <=8:45:00 AM" . I am now getting this error:
Syntax error (missing operator) in query expression '[Week] = 6 And [Trip Sign Off] <= 8:45:00 AM and DatePart('d',[Date]) <= 3 and [Employee]='Batson, Leroy''.
...Code:DSum("[time]","Profit Breakdown 1","[Week] = " & [week number] & " And [Trip Sign Off] -
I have found the issue. I need to run Dsum in a new Query.Leave a comment:
-
Update:
I was able to get it to calculate correct with this
But it only Calculating it for about 1/2 of the entries. I double checked the empty ones to...Code:Running Total: (DSum("[time]","Profit Breakdown 1","[Week] = " & [week number] & " And DatePart('d', [Date]) <= " & [ddate] & " And [Employee]='" & [Employee1] & "'")/60)Leave a comment:
-
Query Running Sum with no Values
I have a query that I am trying to get my employees weekly hours running sum. That way I can seperate the overtime hours and properly calculate profits. I am using a dsum() to add employee time if it is the same week number.
I am not getting any results for Running total.
...Code:Running Total: DSum("[time]","Profit Breakdown 1","[Week] = " & [week number] & " And DatePart('d', -
Compile error: End Select without Select Case
I am getting a this compile error on line 22 and I do have the Select case and End Select.
...Code:Select Case [Booking Status] Case 1 DoCmd.OpenReport "Charter Order Form", wherecondition:="Bookings.ID='" & Forms![Charter Order Form]![ID] & "'" Case 2 If [Invoice #] = 0 Then tempinvoiceid = (DMax("Invoice #", "Invoices") + 1)Last edited by zmbd; Apr 29 '14, 02:17 PM. Reason: [z{Stepped code without inserting any corrections. Placed continuations at logical points for easier reading}] -
ZMBD,
Thank you again for your help. Problem is solved and I feel extremely embarrassed. [Bookings ID] is suppose to be [Booking ID].
Thank you,
VasagoLeave a comment:
-
Zmbd,
I can't thank you enough for you time, lesson, and knowledge. My debug print for strSQL is Your criteria = [Bookings ID] = 2113. This is the correct Bookings ID.
I am getting the error below on line 9.
Error:
Run-time error '2471':
The expression you entered as a query parameter produced this error: '[Bookings ID]'
...Code:Private Sub Form_AfterInsert() Dim db As Recordset
Leave a comment:
-
ZMBD,
I can't thank you enough for you time, education and knowledge. I have included the code below. My debug print for strSQL is Your criteria = Bookings ID = 2110. This is the correct Booking ID number.
Error Code on line 9:
Run-time error '2471':
The expression you entered as a query parameter produced this error: '[Bookings ID]'
...Code:Private Sub Form_AfterInsert() Dim db As Recordset
Leave a comment:
-
Booking ID's type is a number along with IDLeave a comment:
-
Dcount getting runtime error '2471'
Bookings ID is number
ID is autonumber
Error says:
Run-Time error '2471':
The expression you entered as a query parameter produced this error: '[Bookings ID]'
Thank you for the help!Code:If DCount("[Click ID]", "Access Click log", "[Bookings ID] = " & Forms![Roll Out CRM]![Royal Rollout AM Routes]![ID]) = 0 Then
Vasago -
Dlookup using a expression builder getting a syntax error
I have a dlookup i am using in a query to pull in a field. My expression builder has this code.
Error:Code:Scheduled: DLookUp("[Hourestformatted]","Week and Estimated Hours","Driver='" & [Week and Actual Hours]![Employee] & " ID='" & [Week and Actual Hours]![ID] & "'")
Syntax error (missing operator) in query expression 'Driver=' ID='3'' <-----(these... -
Thank you for your help. I tried all of the above with no luck. Load a backed-up version and haven't had a problem sinceLeave a comment:
-
Running into the same issue if I use my created button or navigation pane to open.Leave a comment:
-
Access form not opening
I recently changed my code from Dlookup to opening a recordset. This is my first time using a record set and having issues opening the form now. When I click to open the form nothing happens. No errors and it doesn't load
Here is the opening code
...Code:Private Sub Form_Load() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strRst As String Dim strCriteria As String strCriteria
-
Seth,
I can't thank you enough for your help and for the "access VBA Class".
Sincerely,
VasagoLeave a comment:
No activity results to display
Leave a comment: