Search results

I have an unbound search text box Heres is the code Me.RecordsetClone.FindFirst "SerialNumber = " & SearchStock If Me.RecordsetClone.nomatch Then MsgBox "Stop You Made a Mistake" Me!Technician.SetFocus Me!SearchStock.SetFocus SearchStock = Null Exit Sub End If Me.Bookmark =...

I have this code Private Sub SearchStock_AfterUpdate() Me.RecordsetClone.FindFirst "SerialNumber = " & SearchStock Me.Bookmark = Me.RecordsetClone.Bookmark SearchStock = Null End Sub But I need a message box to appear when the user imputs data that is not in the database

Im using access to generate a confirmation letter for my company. I need to address the letters which wouldn't be a big deal but I have to flip flop between fields depending on certain cercumstances. For every place there is the physical address For some there is a mailing address For others...

I need to search a number field in a form. I'm using a unbound text box and the code i'm using is this Private Sub SearchStock_AfterUpdate() Me.RecordsetClone.FindFirst "PollIdField = '" & SearchStock & "'" Me.Bookmark = Me.RecordsetClone.Bookmark SearchStock = Null End Sub This code...

Ok here is the text field I'm working with EXAMPLE 1 : COMMENTS: RICHARD PESCI 909-823-1224 OR 909-823-2600 10AM-??? 1.5" DOORSILL HALL EXAMPLE 2: COMMENTS: FOYER I'm going to need to pull the info from the specific lines is there any way to do this In case you're wondering why...

I'm Using this function to round up Function roundup(pNum As Double) As Integer roundup = IIf(pNum > Int(pNum), Int(pNum) + 1, pNum) End Function -------------------------------------------------------------------------------- test it from the debug window with ? roundup(15.01) 16...

I have a field I want to round up if there is anything past the decimal point. How do I do this? the decimal point is set to auto. :confused:

I HAVE A FIELD I WANT TO BE ABLE TO ENTER A PARAMETER FOR WHEN I RUN THE QUERRY. BUT IT NEEDS TO INCLUDE A WILD CARD AT THE END OF DATA ENTERED. HOW TO DO THIS?