Why the warning?

[MdHaziq]

Hello, your video is really helpful. I was figuring out how to edit my quantity for my inventory database. The button edits the database but I keep getting a warning massage before I can perform the action.
And I would like to list down all the data in my main table in words but the user cannot edit in the table. It is just for the user to see how many quantities are in stock.
They can withdraw via the drop down

[ranman256]

turn off warnings with DoCmd.setwarnings false

show the table as READONLY, and user cannot edit:
docmd.OpenTable "table",,acReadOnly

[MdHaziq]

Thanks ranman

[pbaldy]

Don't forget to turn them back on. More here:

http://www.baldyweb.com/SQLWarnings.htm

[MdHaziq]

Don't forget to turn them back on. More here:

http://www.baldyweb.com/SQLWarnings.htm

kk. I will

[MdHaziq]

I can only choose one procedure. I am using macros as I did it via button wizard setup.
I do not know how to code.

[aytee111]

Start to learn VBA by creating macros and then using the Convert Macro to Visual Basic button. That way Access will show you how to do what you want using code. It is far easier to develop a database using VBA than using macros.

[MdHaziq]

Okay thanks mate

[MdHaziq]

Hello forum,

I tried to go to options>client settings>uncheck action query>save>close db but the change wasnt saved.

Why is that so ?

I have another question.

I am working on an inventory database.

I want to allow user to either withdraw or stock in.
I can do one but not both.
One way is the attachment ECDatabase.
Two way,not working, is Inventory Program.

I tried adding in another table for withdraw and stock in with numbers that will change the expression but it didn't work.

I have another question,
Right now users can enter blank and the Qty can go below 0.
How can I prevent that from happening?

I have another question.

I want to display the balance in a txtbox beside my item.
I do not know how to set the conditions because only after the user drops down till the item will we know the balance(Qty).

Another ques,

I would like to combine the button to run query and save in another table.
Can it be done?

[aytee111]

With an inventory system, you need to carry a transaction table to keep track of every in and out. This table will carry the information required to identify how much, where from, where to. You have a lot of tables and I don't know which fields are required for this, you can determine that. Then you will have a standard query that calculates the balance and you will use this whenever you need to display that figure.

I don't know the purpose of the items table, and the action table seems to be the one to carry the transactions. Create a form based on the actions table and get the user to enter a transaction which will be saved to that table. This is the way Access works, not to run an append query to add data to a table. Once you get the design of this figured out, you can start to add the extras, such as quantity validations and balances.

[MdHaziq]

I don't know the purpose of the items table.

The items table what the users are looking for.