Z
zer0hmz
Guest
Hi Everyone,
I have a couple of questions, and I'm hoping you can help out an Access rookie. I tried searching for this, but frankly, I'm not even sure what keywords I'm looking for.
The DB I'm working on is a very simple DB to track where and what shipments we send.
On the form I currently have checkboxes with equipment titles next to it, then a Quantity associated with that piece of equipment ( Computer Yes/No field, ComputerQTY Number field)
The first question I have is:
How can I make it so when I click on the checkbox the associated QTY field automatically populates to 1 and gets focus? So if it's 1 I'm done, if it's more than one, I can go ahead and type in the number I want.
Question 2 works hand in hand with the above, there is another table that will have each piece of equipment sent and a description. So if three computers were sent (3 in the Computer QTY box) then I would go over and put in three records in this table. On the form, this table is a subform and is setup in Continous Form mode. The question I have here is, how can I make it so when I type in a number in the quantity box (mentioned above) for an item, it will automatically create the corresponding record.
Example:
I check off the Computer checkbox, in the QTY field I enter 4. What I (or my boss rather) would like to happen is for the subform Description table to automatically populate 4 records with Computer as the device, so then we could just type in the description. Then do the same with the other checkboxes.
Is this possible in Access? I am unfortunately not a coder, so I don't know what I don't know about Access and it's potential .
The form is currently working, the backend is working correctly, relationships, etc. I just don't have this process automated like my boss wants it.
Many, many thanks in advance for your time and help. By the way, I read a few posts, and people here don't like it when people request code be written for them. I can respect and appreciate that, I'd just like to request perhaps where I can find out how to do these things.
I have a couple of questions, and I'm hoping you can help out an Access rookie. I tried searching for this, but frankly, I'm not even sure what keywords I'm looking for.
The DB I'm working on is a very simple DB to track where and what shipments we send.
On the form I currently have checkboxes with equipment titles next to it, then a Quantity associated with that piece of equipment ( Computer Yes/No field, ComputerQTY Number field)
The first question I have is:
How can I make it so when I click on the checkbox the associated QTY field automatically populates to 1 and gets focus? So if it's 1 I'm done, if it's more than one, I can go ahead and type in the number I want.
Question 2 works hand in hand with the above, there is another table that will have each piece of equipment sent and a description. So if three computers were sent (3 in the Computer QTY box) then I would go over and put in three records in this table. On the form, this table is a subform and is setup in Continous Form mode. The question I have here is, how can I make it so when I type in a number in the quantity box (mentioned above) for an item, it will automatically create the corresponding record.
Example:
I check off the Computer checkbox, in the QTY field I enter 4. What I (or my boss rather) would like to happen is for the subform Description table to automatically populate 4 records with Computer as the device, so then we could just type in the description. Then do the same with the other checkboxes.
Is this possible in Access? I am unfortunately not a coder, so I don't know what I don't know about Access and it's potential .
The form is currently working, the backend is working correctly, relationships, etc. I just don't have this process automated like my boss wants it.
Many, many thanks in advance for your time and help. By the way, I read a few posts, and people here don't like it when people request code be written for them. I can respect and appreciate that, I'd just like to request perhaps where I can find out how to do these things.
