Hello all,
I wouldn't call myself a beginner at Access but I am nowhere near a skilled programmer. I have a database I have to finish in the next several days and have some challenges that I have searched and searched the forums for answers to and can't seem to find the answer. Maybe I am not searching the correct terminology but I just can't find the answer(s).
#1 - I have a subform in which we enter quotes. Our quotes are for repairs to train cars and like automotives, they are done part by part (line by line). Each job per car can start out with say 5 lines and be modified several times (estimate and supplement) and wind up with as many is 80+ lines per job. To handle this, I have created main form with the job data and a subform containing the ob detail with a checkbox on each line so that we can select only the lines that need to be printed per quote and/or modification as they have to be submitted to the customer independently. This works great HOWEVER, since there are sooooo many lines and the check boxes have to be checked and unchecked for various reasons what I need is a check box or control that will check all or clear all of the checked boxes. Can anyone help accomplish this? I can't figure it out.
#2 - Based on that same form and checkboxes we another form/subform that has 2 columns, 1 for estimate approval and 1 for supplement approvals. These are set-up to feed into our customers required billing format. I have a pop-up form that pops up the lines as they are approved by the customer based on those same check boxes and what is being approved. This is working great as well, HOWEVER, again, these can be as many as 60 or so lines long and the approval number has to be entered into the appropriate box over and over and over. Is there a way to add a text box that has estimate approval and another that has supplement approval and auto populates the appropriate box (estimate or supplement) based on the value typed in the box? I have this working and it populates the fields but isn't saving them in the table.
#3 - I can't figure out how to set form size. For example....I have a form that opens to full size and I want the subforms to open to a smaller size. I have tried setting this but they seem to all still open to a full size form.
Thanks so much for any help you can give!
Dianne
I wouldn't call myself a beginner at Access but I am nowhere near a skilled programmer. I have a database I have to finish in the next several days and have some challenges that I have searched and searched the forums for answers to and can't seem to find the answer. Maybe I am not searching the correct terminology but I just can't find the answer(s).
#1 - I have a subform in which we enter quotes. Our quotes are for repairs to train cars and like automotives, they are done part by part (line by line). Each job per car can start out with say 5 lines and be modified several times (estimate and supplement) and wind up with as many is 80+ lines per job. To handle this, I have created main form with the job data and a subform containing the ob detail with a checkbox on each line so that we can select only the lines that need to be printed per quote and/or modification as they have to be submitted to the customer independently. This works great HOWEVER, since there are sooooo many lines and the check boxes have to be checked and unchecked for various reasons what I need is a check box or control that will check all or clear all of the checked boxes. Can anyone help accomplish this? I can't figure it out.
#2 - Based on that same form and checkboxes we another form/subform that has 2 columns, 1 for estimate approval and 1 for supplement approvals. These are set-up to feed into our customers required billing format. I have a pop-up form that pops up the lines as they are approved by the customer based on those same check boxes and what is being approved. This is working great as well, HOWEVER, again, these can be as many as 60 or so lines long and the approval number has to be entered into the appropriate box over and over and over. Is there a way to add a text box that has estimate approval and another that has supplement approval and auto populates the appropriate box (estimate or supplement) based on the value typed in the box? I have this working and it populates the fields but isn't saving them in the table.
#3 - I can't figure out how to set form size. For example....I have a form that opens to full size and I want the subforms to open to a smaller size. I have tried setting this but they seem to all still open to a full size form.
Thanks so much for any help you can give!
Dianne