Adding FlexGrids - Freeze Calculated Fields

[johnherrerajuan]

Hello

I have to build an estimate worksheet from scratch on Access I am almost finished with the project but I have a few questions.

(SEE ATTACHMENT FOR CLARIFICATION)

1. There is a labor section on the form where the user selects the combo box adds the quantity of workers, and number of hours. The output would be what the total amount needed for that trade. On a different table i have the wages of each trade per month that is associated to the form. My problem is if there is a new wage amount for a trade it will affect all my previous records and i do not want that. Is there a way i can set it to only change my new records. In file maker there is something called defined record that is a solution for that program but i was wondering if i could do the same for access or Visual basic application for access. Another solution that I had in mind was like having a button where user could click and all field’s data will not be changed in the future.

2. There is a material section on this form where user input cost of materials. Once user is finished with data entry they click on a button that generates another form for presenting/printing purposes. The thing is that not all fields are always used i wanted to know if there is a way on to adding a flex grid so there would take less space up?


If you could help me out I would much appreciated.

Please let me know if you can help me.

 

[JHB]

..
(SEE ATTACHMENT FOR CLARIFICATION)
..
My problem is if there is a new wage amount for a trade it will affect all my previous records and i do not want that. Is there a way i can set it to only change my new records.
...

No it didn't really give any clarification!
A date field could maybe help to keep track on from when the new wage amount should be used.

 

[spikepl]

To preserve values of data that can change with time you have essentially two options: one as outlined by JHB or the other, often used for eg invoicing, that the price field in an invoice record is part of the record and gets filled with the actual value valid at the time of creation.

In the context of Access we have no clue what "flexgrids" are

form for presenting/printing purposes

in Access forms are definitely not for printing purposes, for that use a Report. There you have much more freedom to reformat the data prior to printing.

 

[johnherrerajuan]

The reason I used a form is because I am not sure if I could use VBA codes on a report, so what I do now is adjust the size to fit in a page

Also, how can I preserve values? I know I have to use VBA but can you help me out with that

And flex grid is a flexible grid that expands based on users input.

To preserve values of data that can change with time you have essentially two options: one as outlined by JHB or the other, often used for eg invoicing, that the price field in an invoice record is part of the record and gets filled with the actual value valid at the time of creation.

In the context of Access we have no clue what "flexgrids" are



in Access forms are definitely not for printing purposes, for that use a Report. There you have much more freedom to reformat the data prior to printing.