Hello all,
Im having a bit of trouble getting my stock level update to work when an item is deleted from an hire.
I got an hire table - with stockselected = the quantity the company wants
I got a item table = with overall stocklevels for each item
When a item is selected in the hire table this will deduct the quantity from the hire table.this works but if the item is to be deleted during the hire...
compwizard
Last Activity: Mar 1 '08, 03:15 PM
Joined: Feb 18 '08
Location:
-
Delete issue
hello all,
Just a quick query
I currently have an hires form where clients place orders,
When an item is selected this would drop the item within a listbox and save within a itemhireline table. If clear is selected half way through an order i want the items within the listbox to be deleted from the tblitemhireline so when the next order is placed the listbox should be empty. It sounds pretty simple but i cannot... -
syntax error !
I am getting a syntax error (missing operator) in query expression 'itemhireno = 'Code:Dim rstremoveAs Recordset Set rstremove = Database.OpenRecordset("SELECT * FROM tblitemhire WHERE itemhireno = " & ListBox & ";")
Would anyone know what this problem could be, ive been through it over and over again but the same problem remains
Thanks -
stock update
Hello,
Would anyone know how to update stock levels? for example for an hire system
If hireitem1 ixs selected with amount of 10 and the current stock level is 20
This would leave 10 remaining
if then hireitem1 is updated from 10 to 12, this should leave a total of 8
And for example if the 10 was to be changed to 1 this should change to 19.
Any help would be much appreciated -
thats right.......... ............... .. -
The problem was,
The field IsSelected in my table was stored as selected only and therefore this error is occuring, also the piece of code "'" is used for alphanumeric fields.
So i finally worked out....Hope this helpsLeave a comment:
-
Not to worry, i have resolved this issue....Leave a comment:
-
syntax problem
Hi,
I am getting a syntax error saying: too few parameters expected one.
This is the code that i have been trying:
CurrentDb.Execu te "UPDATE tblitem SET IsSelected = True WHERE itemID = '" & cboItemID & "'"
Would anyone know what the problem could be, the field is alphanumeric -
I was hoping for the all the items to remain, but if the same item is selected again a message will appear advising ' that this item has already been selected, something along those lines'. any ideas?
Secondly, just reading through the code you provided, how would you hide a bound column.?
thanksLeave a comment:
-
selecting one item for each hire
Hello All,
I have a quick query regarding limiting only one of each item to be selected in every single order.
For example from the drop down list of item, only one of each items could be selected so
if item1 is selected this would drop into a listbox, when the next item is to be selected, item 1 should not be allowed to be selected.
For the next order this item should reappear.
I am really stuck... -
I have also tried this, but then it shows too few parameters expected1Code:Set rstreset = dbase.OpenRecordset("SELECT * FROM tblline WHERE itemID = " & Me.Listbox)Leave a comment:
-
quick query with regards to populate problem
Hello All,
I have a quick question, well im hoping it is quick
i am trying to edit an item from a listbox, what i am trying to do is double click on an item from the listbox during placing a order, and i would like this item to appear within the orderline above to start to edit, Currently i could get this to happen. then i want to edit the quantity column and select edit, when this is pressed i would like to repopulate...
No activity results to display
Leave a comment: