Search results

OK I will give it a try to see if it gives what I want. Thank you!

I need to write a query to show me all records that are older than the current year and the last current year that never has to be updated. I currently have one for month, but need one for year as well. Year(Date())*12+DatePart("m",Date())-1 Right now I want my query to show anything older...

Found the article I needed and book-marked your page. I am sure I will use it many, many, many times! Thank you so much!

Look at you with your own site there Bob. Thank you I will look it up.

once again the COC number IS NOT OURS. We get paper work with the number already on it. We just do the data entry. WE CANNOT CONTROL THE 10 DIGIT NUMBER. I just need to build a form that makes my user enter the number twice for accuracy.

My field other than social is a field called COC. Each 'COC' number is 10 digits long and all numbers. We have issues every month of multiple employees transposing numbers. By making them enter the number twice to make sure they match it should catch any transposing issues.

Is there any way to disable right clicks for just the one form?

Time for bed. I will revisit at 8:15 am. THANK YOU ALL for the help thus far.

Yes I did name my text boxes SSN1 & SSN2

OK that code works great to stop the control buttons. Is there any way to stop right click and copy, then right click and paste?

Here is all of my code. Private Sub SSN2_AfterUpdate() If Me.SSN1 <> Me.SSN2 Then MsgBox "Social Security Numbers Entered Do Not Match! Please Re-enter!" Me.SSN1 = "" Me.SSN2 = "" Me.SSN1.SetFocus End If End Sub

this is the highlighted line Me.SSN1 = ""

MISSINGLINQ, I just set up a new form and it works almost perfect already. Right now if I type a different number into SSN2 field it does give the pop up error. As soon as I hit "OK" to go make the change it brings up the Microsoft Visual Basic Debug Popup. I then have to hit "End" to continue...

You are correct. The information comes to us with the number already supplied. We then enter it into the system. I will try to play with the codes you have provided to see if I can make it work. Thank you so far. Anyone else want to add any examples please feel free to jump in. Thanks.

do you know of any examples out there similar to this so I can see an example of a access db that utilizes similar code?

now we are getting some where. THANK YOU SO FAR. 1.) I like the idea of two text boxes one that double checks the other with clipboard disabled. can the copy/paste be disabled just for the one form? 2.) the randomly generated number comes from an outside source. when we get the paperwork it...

I am not really sure what you are asking. I do know that I cannot have a value list because the number changes with each record. One field is a Social Security field and the other field is a 10 digit code randomly signed to the record we are typing in at that moment and will never repeat.

I want to make an entry form with about 20 fields. 2 of the fields are number based and are often entered incorrectly. I need to make my users enter those two fields twice to confirm accuracy. Is it best to have some sort of pop up window for confirmation or just have the field twice on the...

Also I hope you had a great trip.

Paul, Thank you I did figure something out. Took me a while, but I do have it resolved. thank you for the follow up thou.