Ask Experts Questions for FREE Help !
Ask
    Firestorm's Avatar
    Firestorm Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 17, 2009, 03:36 AM
    Is this Weird Or Am I Missing Sumthing?
    Here is my code...

    'Works Fine Adding Items
    Private Sub Command1_Click()
    If Text2.Text = "" Then
    MsgBox "Please Enter Item Name"
    Else
    Data1.Recordset.AddNew
    End If
    End Sub

    'Works Fine Updating Items
    Private Sub Command2_Click()
    Data1.Recordset.Update
    End Sub

    'This Is The Problem
    Private Sub Command3_Click()
    Data1.Recordset.Find ("Barcode = 'Text5.text'")
    End Sub

    If i Type 123456789 in the textbox, it returns blank textboxs (There should beItem Code and Stock)

    However, if i change the code to this

    Private Sub Command3_Click()
    Data1.Recordset.Find ("Barcode = '123456789'")
    End Sub

    Then it returns all information regarding that Item?

    Please help me, I need it to locate the item from the Txtbox at runtime, But it will only do it ifthe number required is built in the code??

Check out some similar questions!

Weird '''''''s. [ 2 Answers ]

Hi there, I'm having a strange problem, that only happens with the internet. Sometimes when I'm typing in a window the computer will start typing ''''' for me... And won't stop. It's really annoying. What's going on and how do I fix it?

Am I weird? [ 12 Answers ]

I'm 14 I'm in the 8th grade and I HATE make up and I don't like wearing skirts or dresses... I barely ever wear shorts all I like to wear is blue jeans a t-shirt and my hoodie... is that weird??

Is it weird? [ 23 Answers ]

Would you guys think it would be weird if your (male) boss put his hands on either side of your thighs like... in line with that crease of the top of your leg and butt, but from like behind you.. Like you were standing in front of him and to the left, and he was sort of squatted down diagonally...

I love her to death but should I stay n sumthing that don't exist [ 1 Answers ]

I have mess up a lot throughout my relationship wit my girl and even wit the same thing more then once. What really upsets me is when I'm telling her I love her or I miss her she would say yea right or something negative. I take that to da heart sometimes and get upset. I told her that, and she...

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.