Search results

  1. A

    Totalling troubles- Help!

    Sum Ive done something similar in one of my University Projects a couple of years ago. Email me the database and I'll have a go!
  2. A

    Totalling troubles- Help!

    Sum Ive done something similar in one of my University Projects a couple of years ago. Email me the database and I'll have a go!
  3. A

    Opening Form error

    Query Im not too sure here but it sounds as if the forms source is from a query. If so go to the design of the query and check to see if the Criteria section has a prompt message. This may have been created by simply copying and pasting (Ive done it many times!). Hope this helps, if need be you...
  4. A

    IF statements

    Im using a RunSQL Macro and just wondering if this version of SQL supports the IF statement used in the likes of C programming I want to use the UPDATE statement with it, so if i can use it and someone suggest the layout Thanks in advance astarbyfar
  5. A

    Stock control

    Sorry but this does not work the code ive got from Access help is UPDATE Stock SET Quantity = Quantity - 1 WHERE Forms![EPOS].[Item#].Value; Where EPOS is the name of the form which will have the product details on and Item number is the unique identifier. What i want is for just that unique...
  6. A

    Stock control

    nice one genius!!!!
  7. A

    Stock control

    Ive done that but what goes where the bla bla bla goes. I need it to read in the product number that the user would enter in a query
  8. A

    Stock control

    Thanks, ive nearly done this ive inserted an SQL ststement UPDATE Stock SET Quantity = Quantity -1 but i need it to just update the levels for the produnt number that i am inserting from the query anyone got the SQL statement for this?
  9. A

    Stock control

    Can anyone give me the an idea. Ive already posted this in Query forum and now relize that it should be in VBA or modules. Im creating a stock control system and when i click on a Pay button i want Quantity that is in Stock Table to be deducted by 1. The form that the pay buttojn is on is based...
  10. A

    expressions

    Thanks
  11. A

    expressions

    Apoligies where it has query1 in the erro message that should be Stock
  12. A

    expressions

    Im not to sure what you mean, ive created a query which asks the user which has Item number Description These are all shown Price Then there is Quantity which is not shown I have then created a form with the data source being the above query which is called...
  13. A

    expressions

    Im creating a stock control system and I need an expression so that when i click on a button the quantity is deducted by 1. The table is Stock and the attribute is called Quantity i've created a query but i dont know whether this is right. Please help
View older results
Back
Top Bottom