A
Alex
Hello All
I am building a database for someone to be able to do reports as a
construction supervisor.
I will first put what I want to do, then how far along I am, and where I'm
stuck, to see if I can get any hellp.
I built 4 tables:
Cat_Obras has the sites, it has all information, like contractor, address,
amount, and it has an index field called IDObras.
Cat_Conceptos has all the different concepts that can be used in all
construction sites. I use it as the source for a combo box in another table
called Cat_Avances_Informes.
Cat_Informes is where I keep the weekly reports. It only has 4 fields, one
to link it to IDOBras, its own index field IdInforme, then it has a date
field for when that report is made, and a comments field.
Cat_Avances_Informes is where I keep my updated reports. This table has
five fields it has IDObras and IdInforme, it has a concept field and two
percetange field, one for the percentage of that concept in the construction
site and one for how much percentage of that percentage is made on that
report.
Now I have a form in which I capture the construction site information. It
has an independent list box that fills in depending on the records that are
found in Cat_Informes that match IDObra.
I have another form for capturing the reports. This form's record source is
Cat_Informes. I have a subform in this in datasheet view, whose record
source is Cat_Avances_Informes.
Now the idea is that from the site form, i can jump to the reports form. So
I have a doubleclick event on the listbox and an "add report" button. The
doubleclick is working fine, I double click and it goes to the appropiate
spot. The problem is with the add report.
My code for the button is basically just an openform command with acFormAdd,
where I pass as an openargs IDObra. The new form opens and automatically puts
the IDObra into the report and the date. The problem is, that for every
construction site, there will be the same concepts, but I have to retype them
every report. I have been trying to think of a way to do this but as of now
haven't been able to. Any help would be great, thanks!
p.d. Im using access 2003
I am building a database for someone to be able to do reports as a
construction supervisor.
I will first put what I want to do, then how far along I am, and where I'm
stuck, to see if I can get any hellp.
I built 4 tables:
Cat_Obras has the sites, it has all information, like contractor, address,
amount, and it has an index field called IDObras.
Cat_Conceptos has all the different concepts that can be used in all
construction sites. I use it as the source for a combo box in another table
called Cat_Avances_Informes.
Cat_Informes is where I keep the weekly reports. It only has 4 fields, one
to link it to IDOBras, its own index field IdInforme, then it has a date
field for when that report is made, and a comments field.
Cat_Avances_Informes is where I keep my updated reports. This table has
five fields it has IDObras and IdInforme, it has a concept field and two
percetange field, one for the percentage of that concept in the construction
site and one for how much percentage of that percentage is made on that
report.
Now I have a form in which I capture the construction site information. It
has an independent list box that fills in depending on the records that are
found in Cat_Informes that match IDObra.
I have another form for capturing the reports. This form's record source is
Cat_Informes. I have a subform in this in datasheet view, whose record
source is Cat_Avances_Informes.
Now the idea is that from the site form, i can jump to the reports form. So
I have a doubleclick event on the listbox and an "add report" button. The
doubleclick is working fine, I double click and it goes to the appropiate
spot. The problem is with the add report.
My code for the button is basically just an openform command with acFormAdd,
where I pass as an openargs IDObra. The new form opens and automatically puts
the IDObra into the report and the date. The problem is, that for every
construction site, there will be the same concepts, but I have to retype them
every report. I have been trying to think of a way to do this but as of now
haven't been able to. Any help would be great, thanks!
p.d. Im using access 2003