Search results

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

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

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

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

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