Search results for query: *

if that last post seemed a little barbed PHV i didn't intend it to be. I've been fighting with this database for a week and I'm just trying to keep it basic. Once it's functioning properly we'll problalby be looking to SQL and leave access as a front end.

it just needs to subtract one when i click on it. Thank you, but I am familiar with the fundamentals of relational database design. I am trying to avoid redesigning the entire database because I would be hand keying old information for a week. I just want it to subtract "1" from a field that I...

okay here is the breakdown. This is a very SIMPLE database. I am thinking about just redoing the entire thing, but I would have a lot of data i would have to manually put back in.. tblBFT is the main table of this database. It contains the Yes/No checkbox fields that are on the form frmCables...

is there any kind of IF statement I could write to make this happen? (so far i haven't been successfull)

the two tables are not joined. The yes/no field does not belong to that quantity field. I just need it to deduct from that field when checked.

the field on the form with a checkbox is a Yes/No field in a different table. When it is checked I am trying to get it to subtract 1 from a different table. (forgive me, i'm attempting to repair a database that I didn't create)

didn't take it...VB got stuck at SET

i was debating whether i needed it or not. This table is a very simple inventory table. It just tells how many of each part we have. (300 11/32 screws, 100 power supplies, etc.) There isn't a good identifier for each record. Right now I have a checklist for each system these parts go into, and I...

i am attempting to update an inventory table from a checkbox on a form. The table does not have a primary key. All the checkbox needs to do is subtract 1 from the field when checked, and if accidentally checked, then unchecked needs to add the 1 back. Any help is appreciated!

ya, it sounds like the CPU is overheating. Does the client have the PC inclosed in very tight quarters? (disrupting air flow) Possible in a very warm environment?