Multiple Challenges for A Novice

[denileigh]

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

 

[lightray]

Here's a couple to help with No#1 I hope!
http://www.access-programmers.co.uk/forums/showthread.php?t=106728
http://www.access-programmers.co.uk/forums/showthread.php?t=108951
sorry can't help with 2 or 3 at this time.
Can anyone else?

 

[edtab]

Item 2)
"I have this working and it populates the fields but isn't saving them in the table."
================================================================

If you are able to populate the two fields with values from your two textboxes, you should be able to save it in the table.

Try issuing a save command right after you populate the two fields, as in:

Docmd.RunCommand AccmdSaveRecord

Assuming your two target fields are bound to the table, it should work.

Item 3) Form size problem
=====================

Try searching this forum for controlling form size using the search button.
There are a number of threads archived in this forum relating to this issue.

Hope that helps.

 

[Florence1550]

Set form to Pop

go to the form properties selct other and select popup is yes

 

[gemma-the-husky]

i use a method taken from the access cook book (o'reilly) to save form sizes and positions.

basically it saves the position and form size in the registry on closeform and retrieves them on openform. Use standard getsettings, savesettitngs command in access to use the registry. never had a probelm with it, and it looks very nice.

 

[denileigh]

Item 2)
"I have this working and it populates the fields but isn't saving them in the table."
================================================================

If you are able to populate the two fields with values from your two textboxes, you should be able to save it in the table.

Try issuing a save command right after you populate the two fields, as in:

Docmd.RunCommand AccmdSaveRecord

Assuming your two target fields are bound to the table, it should work.

Item 3) Form size problem
=====================

Try searching this forum for controlling form size using the search button.
There are a number of threads archived in this forum relating to this issue.

Hope that helps.

Thanks for the response! Where do I add the Docmd? In the fields themselves or in the field I use to populate them? How do I know if they are bound to a table?

 

[denileigh]

Estimate/Supplement Approval Number.....

The form contains the fields estimateapproval and supplementapproval from the table.

On the form I have 2 unbound text boxes: 1) Estimate Approval Number 2) Supplement Approval Number

In the bound textboxes from the table I put =EstimateApprovalNumber to update from the unbound text box.....I put the code Docmd.RunCommand AccmdSaveRecord in the textbox from the table that says =EstimateApprovalNumber but although it populates from the unbound box it still isn't saving it. I put the save command in the after update field...am I doing this wrong?

Is there a better way to set this up?

 

[Rich]

Just bind the unbound textboxes to the table

 

[denileigh]

Just bind the unbound textboxes to the table

I have no idea how to do that....

 

[CraigDolphin]

Another way to accomplish goal 1 might be to use a control button on your subform to run an update query.

For example, if your subform checkbox field is called chkYourfield in tblSubformTable, and your mainform (linked to tblMAinformTable) is linked to your subform by a unique identifier called, say, AutoKeyfield_JobID, then your query would use Forms!MainFormName!AutoKeyField_JobID as a criterion, and update all records in tblSubformTable to make chkYourfield = False.

You may or may not need to refresh your subform after the query runs to see the changes.

 

[Dreamweaver]

Q1,
Haven't seen an answer to one like this so my pennys worth if i'm reading it right:

Add a tickbox (You Can use a command button and change it's caption afterupdate and test for the caption) but the tick box is easy

Then All you'll need do is clone the subforms recordset and loop through it setting each cheakbox to whats in the checkbox in the subforms header you need to put this in the afterupdate of the check box your ganna use to set all others

hope it helps

mick