Search results for query: *

It worked! Thank you for you help on this. Have a great weekend.:)

Thank you for patience and your help! Now i am receiving the following error.

I placed the code on the event procedure for a command button and I received an error "Object Required" for "MyDB". If I create a lookup table as you suggested how do incorporate that lookup table i.e table2 into this code?

1. Imported data from excel into a table. 2. Yes on Primary key. 3. I did not use an orderby. This is the query: SELECT Import_PT1_Table.PID, Import_PT1_Table.Code, Import_PT1_Table.Serial FROM Import_PT1_Table;

I need some assistance with this query and I am not sure how to go about it. I need to create a query that will fill the same "Code" where it is Null just like the lower screenshot.

Skip, Thanks! that worked for me.

I need some help in figuring this out. is there a way to input a number for example "51424303" and it would return a Job_ID of 1939706. Can this be done with a query and if so how? Job_ID Range1 Range2

...When i try to run the query below. Any suggestions on what I am missing here? DELETE PT_102_Employee_Attendance_Table.[DateofOccurrence], * FROM PT_102_Employee_Attendance_Table, AT_271_Isolate_Last_Years_Date_From_Today_Table WHERE...

Thanks you both. I must of copied and pasted the code incorrectly I did have DELETE * in there but fixing the null did the trick.

Need some help here. Why is this not working? DELETE FROM HR_021_Isolates_Records_For_Anniversary_Reset_Table WHERE HR_021_Isolates_Records_For_Anniversary_Reset_Table.Code="Unpaid" AND HR_021_Isolates_Records_For_Anniversary_Reset_Table.UTimeTaken=Null AND...

That was it! Thank you so much.

I have this query and it worked fine except until I add one more criteria "J.Code1" to the statement below and now I am receiving a syntax error message. I am not sure how to fix this. SELECT R.PID, R.Total AS RTotal, L.Total AS LTotal, F.Total AS FTotal, J.Total AS JTotal FROM...

Got it! I understand now how it will work. Thank you both so much for the help and happy holidays!

Skip, What is the Andy Table?

Thanks Skip! I going to go at this with a different approach. I have striped of the letter there by just creating a numerical value. If I have table1 that contains "startnumber" and "Endnumber" and lets say the startnumber is 1401 and the endnumber is 1501. How do I create a query that will...

That's an idea! I will try this to see if this will work for what I need. Thank You and Happy Holidays!

Hello Everyone! I am not sure if this is possible but I have to two fields which have a datatype of ShortText. The Fields are called StartNumber and EndNumber. The startnumber will always start with the letter "A" as in this example "A1971400" and the end number "A1971500". Is it possible to...

Is there a way to disable the Client Settings "Confirm" for the queries? I have multiple users and I have to do this manually for each time a new user logs into a windows machine. It would be nice I I could do this once per machine and all three check boxes are disabled for all users. Thanks...

...Const conJetDate = "\#mm\/dd\/yyyy\#" If Not IsNull(Me.txtFilteraccountrep) Then strWhere = strWhere & "([AccountRep] Like ""*" & Me.txtFilteraccountrep & "*"") AND " End If If Not IsNull(Me.txtFilterStatus) Then strWhere = strWhere & "([Status] Like ""*"...

...string below... If Not IsNull(Me.[txtFilteraccountrep]) Then strWhere = strWhere & "(Forms.F_012_Won_Loss_Form.Form.[AccountRep] Like ""*" & Me.txtFilteraccountrep & "*"") AND " End If lngLen = Len(strWhere) - 5 If lngLen <= 0 Then MsgBox "No criteria"...