Recent content by testkitt2

Thanks PHV , Melagan , AceMan1 Since I'd like to give the person who will be using this DB at my job besides myself options to cancel are necessary. The many If's, Then's, Else and ElseIf's just got a bit too much for my bit of experience. All of your suggestions did work. I appreciate all of...

Thanks PHV , Melagan , tigersbh ,for your assist on this.. I tried PHV suggest "F1" (help) but was unclear upon reading inst and examples. *********** I tried to change part of the code abit...as shown below. If IsNumeric(Me![Location].OldValue) Then answer1 = MsgBox(" Remove Old Position...

Hello to all can anyone help on this post. "How do I use VBOKCancel correctly?" Thank you JZ Testkitt2

lameid Access has a query that finds dupes...but since my DB does not have all tables relating or allowing to create a dupe. the access query will find a dupe only if its in the same column or row. What I have if you can picture this a picture of a Truck and in place of the trucks wheels a...

leaving work...will log on from home. Thank you JZ Testkitt2

Thank PHV For you input. Normally if I use a Msgbox..such as example below Dim answer As Integer answer = MsgBox("Click ' YES ' If You Want To Quit This Program," & vbNewLine & " or ' NO '...To Cancell.", vbQuestion + vbYesNo, "Shop Dept") If answer = vbYes Then Application.Quit Else...

Hello Group The code below works but if you hit cancel at any time it does not exit the sub, the form just fires up. Any suggestions on how to correct this.. It's probably simple for coders ..but I'm not one. Private Sub Location_AfterUpdate() Dim stDocName As String, cancel As Boolean Dim...

Hello, I haven't been on for a while...computer was donated...have a new one now... the last post has not been tried..but I will give it a shot. The other codes did not work for me...I need something that can compare 10 individual positions at one time and find if there is a duplicate. Thanks...

Hello and good eve to all. As Remou quoted. He is completely correct in saying this...but guess what I'm too deep in the Mud to back out now, and I should have not strayed away from my original question. Ok maybe this can't be done. My question was this... I created with Access built in "find...

Lameid Stated this In a perfect world you could fix the table structure so that you have a table with the Fleet number, tire postion and tire as the three fields. Then finding duplicates would be much easier. Hey I agree but you have a truck that has 2 front tires 2 tag axels, 4 rear inner and...

hello to all and good eve Thanks to all who posted... suggestions Thanks Remou (TechnicalUser)

Remou, I know I'm doing something wrong here, I took your example and added all the positions to the union SQL and came up with this SELECT tblTirePosition.[Fleet Number] From tblTirePosition UNION ALL SELECT tblTirePosition.[Right Front] From tblTirePosition UNION ALL SELECT...

Good eve to all and thanks Remou I'm totally...????? Ok there is only one table that holds all tire positions, Remou when you say make a "union", do you mean convert my existing query... Your suggestion sounds like it would work..but I'm stuck..please explain or give me an example.. Thanks JZ...

Hello folks, missinglinq,TheAceMan1 To answer your question I first put the code in the "After Update event"....got that msg....then I made it a function...still got that msg... but quess what... missinglinq I tried your suggested code below and you hit the nail on the head...

Hey good late night to all. I tried the code suggested by missinglinq and It look like it was working but then I go the error messager below. The macro of function set to the beforeupdate or validationrule property for his field is preventing JZ POlog from saving the data in this field. Thanks...