We help IT Professionals succeed at work.

Access and VB/DAO - Update table off of submitted unbound textbox using VB?

chosaru
chosaru asked
on
268 Views
Last Modified: 2008-02-01
Well, pretty much what the title says. Here is the flow:

Unbound Textbox submits string of numbers/letters to VB based on an event (BeforeUpdate)
A SQL string will update the DB date field where the submited string matches
The user will now be ready to repeat the same process.

Here is the SQL statement that I am trying to use:

strSQL = "UPDATE inventory INNER JOIN invHistory ON inventory.ID = invHistory.invID SET inventory.inOut = True, invHistory.dateIn = Date() WHERE inventory.serialNumber = " & StringFromUnboundTextBox

How do I get the submitted value to do use that SQL string with Access?

Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Sigh... I knew I was close.  THanks for the help :)
CERTIFIED EXPERT
Top Expert 2006

Commented:
No worries
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.