PC Review


Reply
Thread Tools Rate Thread

REQ Assistance - Problem with updating Inventory Quantity

 
 
Dan
Guest
Posts: n/a
 
      24th Mar 2004
Good evening.
I am trying to correct some code that errors out while trying to update an
inventory. This code is hacked from another dbase. I understand most of
it except where it errors out (UPPERCASE). What is that line asking me? If
I knew that, I could probably figure it out.

Thanks for any and all assistance.



Private Sub cmdSignSuppliesIn_Click()

'On Error Resume Next
Dim intQuantity As Integer

'Find amount currently in inventory
intQuantity = DLookup("[Quantity]", "tblInventory", "[SUPPLYTYPEID]=" &
Me.CBOSUPPLYTYPE)

'Increase quanity by amount signed in
intQuantity = intQuantity + CInt(Me.txtQuantityIn)

'Update tblInventory to correct quantity
DoCmd.RunSQL "UPDATE tblInventory SET tblInventory.Quantity =" &
intQuantity & " WHERE tblInventory.InventoryID=" & Me.cboInventoryID


DoCmd.Close acForm, Me.Name

End Sub

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I wish to assign Quantity the value of [Quantity]-[OrderAmt] Tony Microsoft Access Forms 1 31st Mar 2010 05:13 AM
Need a formula to increase quantity of one cell until the quantity ofanother is exceeded rudyeb Microsoft Excel Misc 1 24th Oct 2008 03:34 PM
Updating inventory quantity kuansheng Microsoft Excel Worksheet Functions 3 2nd Feb 2006 02:48 AM
inventory quantity Frank Ruffolo Microsoft Access 3 4th Jan 2004 02:20 AM
FS: Lucent ClearTrac V352, SDM-9350 Routers, $100 each, quantity of 20 available, must get these cleared out of our bank inventory Pudda Work Windows Networking 0 24th Dec 2003 08:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:20 PM.