 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Update UnitsInStock Field in Northwind.mdb
I have written and run an update query in Northwind. It updates the unitsinstock field of the products table. What I want to do is update this field based on the qty ordered in a specific order not every order. Eg. I have 10 products in stock, someone orders 3 - this gives me 7 in stock after I run the update query. Another order wants 3 of the same product and after running the query again, it subtracts these 3 products AND the previous 3 again leaving me with 1 product when I should actually have 4. :mad: How can I attach this query to the orders form so it only runs according that particular order and not all previous orders? Thanks
|
||||
Check out some similar questions!
access 97 has option to convert .MDB TO .exe now i am using Access 2000 and using access run time please help to find way to convert .MDB to .exe or any other ways
Hi, I'm working on a database and would like to lock the access to the tables and queries. I was told that the best way to go about it is to convert the mdb file into an exe file. The question is: (1) how do I go about it and (2) is there a better way to lock user acces to the tables/queries/vba...
Hello ! I'm new to this site. Here's my problem I created a password for a mdb access, and now it won't let me back in. the user name box keeps telling me it's the wrong password. I've search the web for a password recovery fix but it seems everyone wants the money. No shareware. And I wouldn't...
Dear How can I change an Access MDB file to an executable EXE file? SOS Thanks
I made a small vb project and copied the coding from a friend word for word (which works for them btw). I made up the database on access and when I try to run the project I get an error saying that vb doesn't recognise the .mdb file?? So what have I done wrong?
View more questions Search
| Question Tools | Search this Question |
Add your answer here.
|
