Search results

Hi llkhoutx That worked great. I can use all the help I can get VB and SQL are way past my knowledge unfortunately

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

Hey Rich, Thanks for the help It Seems to work but, i haven't thouroughly tested it yet got caught up in another DB project. :)

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

Thaks Travis Not only did I word it correctly but obviously I don't know how to spell Steal either. :D

Thanks Mile That worked great Although most of what you said went straight over my head I appreciate the help

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

Thanks Wayne, It doesn't do what I'm looking for. It seems to only look for specific text, which I tried throwing some wild cards in and nothing got retuned. It's the line itself I'm looking to pull no matter what the data is in it. Thanks for your help

Well I tried it first I get asked for a parameter for SearchString If just hit ok I just get error messeges in the field If i enter in something I get a VB error on this line of code ptrFront = InStr(ptr, SearchThis, FindThis) - 1 If ptrFront = 0 Then ptrFront = Len(SearchThis) End If...

Thanks Wayne, I'm a self taught user, so I apperciate all the help I can get :D

Hi Wayne, I pasted it into a module called utility functions. How do i use it though? :confused:

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

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

Thanks it worked great :D

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

Hi Rose412, Thanks for the reply, I'm going to try that to.

Hi raskew, I think I figured it out I pasted that inot a module and called it Utility Functions It works great. Thanks. Do you know how to pull info from a text field that has multiple lines. I need a specific line pulled but not all records have something in that specific line. :confused:

Thanks but I need some more info I don't know much about VB or SQL Ok what module do I paste that into or what do I name the module. The field is in a querry :confused:

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: