Search results

VehTypeID is the PK for a table and the FK for this one, so it's an autonumber/number, I apologize I should have mentioned that, easy fix though! Thanks for the assistance, it makes sense now! Made some minor corrections and it worked as intended, again, thanks so much!!!

Hi, Briefly what I'm trying to do is determine if the user entered correctly the Vin number for a vehicle and warn them if they have or have not. I can go about it two ways. #1: There's a field in my table that references vehicle type, I only need to match if the VIN is 17 characters...

I found this page, which lead me to this code: Format([StartTime] -1 -[EndTime], "Short Time") which works fine for part of my issue. My other issue is that I need to subtract 8 hours from that time for OT hours, and I've failed on many levels trying to achieve that. Also my OT hours would...

Thanks for the tip, but the problem is I have no idea what i'm looking for...

Hi, I have the following code I'm using to merge 2 current fields in a new table, along with other data. It works as it should when there are multiple records, however, when there is only one record, it skips it. I cannot figure out what's wrong, any assistance would be great. I did not write...

I did change it and tyvm again for the coaching!

I was almost there at my last edit!! I see what I was doing wrong. Thank you again so very much

I'm definitely doing something wrong and my head hurts :( Private Sub searchrecs_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Search Evidence Sub" stLinkCriteria = "[Serial Number]='" & Me![Search] & "' " stLinkCriteria = stLinkCriteria &...

One more question if you're still there. I just can't figure it out. This is the entire code for the above Private Sub searchrecs_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Search Evidence Sub" stLinkCriteria = "[Serial Number]='" &...

I know I am using non standard naming methods, and unfortunately this project is at it's end stages for me to start the entire thing over again. Trust me when I say i will be following more normalized naming methods in the future. The thing is I have a form, it's just an unbound field with a...

Thanks for the reply Brian. I tried that out, it's giving me an Error 13 :(

Basically what I'm trying to do is make a search form that will open another form from the search form that will match the records if the data was from any of the three fields. Dim stDocName As String Dim stLinkCriteria As String stDocName = "Main Case Details"...

That's not working either :( The form is pointed to the correct form I need to open, and it's opening it fine, it's just not displaying the correct records, it's not even filtering them, it's showing all of them.

I've tried and got countless errors, so I'm obviously not doing something correctly. I can do one or the other ="[SN]=" & "'" & [SN] & "'" ="[CN]=" & "'" & [CN] & "'" but I guess I'm just lost with combining the two in the OpenForm argument of the embedded macro.

Hi, I have a form where all of my data is showing for a particular record, from that form I have a button that will open a new form where a form letter with that data is placed. The problem is that I need to only show the matching form to that form which is matched by 2 conditions the CN and...

After some trial and error I finally got this to work properly SELECT qry_MainSum.[Case Number], qry_MainSum.Examiner, qry_MainSum.[Date of Assignment], qry_LooseDriveSums.CountOfSize, qry_LooseDriveSums.SumOfSize, qry_HDSums.CountOfSize, qry_HDSums.SumOfSize FROM (qry_MainSum LEFT JOIN...

Thanks for the reply, but I'm still getting the same error :( This is the code SELECT qry_cfu_MainSelect.[Case Number], qry_cfu_MainSelect.Examiner, Count(DISTINCT [qry_cfu_HD]![Size]) AS CountOfSize1, Count(DISTINCT [qry_cfu_LooseDrives]![Size]) AS CountOfSize2, Sum(DISTINCT...

That is what I am looking for I need what the values should be, and not doubled. With that I'm getting an error. (img attached) I should have mentioned I'm horrible at sql and advanced queries, which is why I'm asking for help. I'm aware it's giving me what I'm requesting of it, I don't know...

I know what the problem is, but I'm not sure how to fix it. Here is the query in question: SELECT qry_cfu_MainSelect.[Case Number], qry_cfu_MainSelect.Examiner, Count(qry_cfu_HD.Size) AS CountOfSize1, Count(qry_cfu_LooseDrives.Size) AS CountOfSize2, Sum(qry_cfu_HD.Size) AS SumOfSize1...