Changing table data via forms

[JasonKiebler]

Hello everyone, and thanks in advance for any help you can provide.

I am currently working on a large project to track, issue out, and re supply an operational stock of various tools and parts we use in our shop on a normal basis. This program is in it's beginning steps at the moment, and already I need some help.

If anyone has any tips on how I can change the raw numerical data in my table, via a textbox and a command button on a form, I would be greatful. I am trying to avoid allowing users to directly modify table data. Although this method is what I am aiming for, I will gladly accept any suggestions. Thanks

AIC Jason Kiebler
OSAN AB ROK

 

[Robert88]

Hi JasonKiebler,

I have recently taken data from a form to a table on unbound text boxes, check;

http://www.access-programmers.co.uk/forums/showthread.php?t=102707&highlight=robert88

But as suggested to me and I am starting to agree is to use bound text boxes so that the form text boxes look directly at the tables.

I supopse to overcome a way of your users not changing the data is to include a security group, two users (one with change rights, the other with read rights). Then assign the appropriate security to the form in order for users to use the form.

So dependant on how you log on (but this could be annoying, keep the username and password simple) to the database depends on what access you have to the tables, queries, forms, reports.............

If you do decide to go text boxes, it is long winded method as I am finding.

I hope this helps?

Robert88

 

[JasonKiebler]

Hmmm... Perhaps I was a bit unclear on my actual question.

My real goal is to be able to change the On Hand numerical value in my table, by allowing users to type a number in a text box, hit the command button next to it, and have the program automatically add or subtract (depending on if I am issuing an item out or restocking my supply) the number in the text box, and update the information in my table.