Working on a DB

[dogbite via AccessMonster.com]

I hope This won't be to long or a string to many.
I'm using ACCESS 2000 on a lap top with windows 2003.
I go to about 20 different new subdivisions a day I track the building
progress of each new house (slab, walls, roof, shingled, Ect) on the data
base I'm working on frmMain has County, City, Subdiv. name, house address,
lot#, date, Ect. I have the DB it to the point of data for all this is in the
table.
I have to print a report after the electric meter can is on the house for
that house. Thats not much of a problem.
What I want to do is access the data by subdivision and street modify the
data put it back in the table.
I have tryed a macro and a qry. Qry the table and have the data come up on a
form then if I try to pull a 2nd subdivision I have to shut it all down go
threw all the (are you sure you want to do that's). I would like to do it off
the form with drop down box.
Mostly I need ideas of the easy and best way to do that.
Let me know what other information might help.
Thanks for any help

 

[Guest]

What is your table structure look like. Post an example of your data.
You can open a form that has a query as record source without a macro. You
can then step through the records - subdivision - house.

 

[dogbite via AccessMonster.com]

What is your table structure look like. Post an example of your data.
You can open a form that has a query as record source without a macro. You
can then step through the records - subdivision - house.

I hope This won't be to long or a string to many.
I'm using ACCESS 2000 on a lap top with windows 2003.

[quoted text clipped - 14 lines]

Let me know what other information might help.
Thanks for any help

Is there a way I could send you a copy of the DB
or post it or something or I'll give you my email address
Thanks

 

[Guest]

No. Just post the information I suggested.

What is your table structure look like. Post an example of your data.
You can open a form that has a query as record source without a macro. You
can then step through the records - subdivision - house.

I hope This won't be to long or a string to many.
I'm using ACCESS 2000 on a lap top with windows 2003.

[quoted text clipped - 14 lines]

Let me know what other information might help.
Thanks for any help

Is there a way I could send you a copy of the DB
or post it or something or I'll give you my email address
Thanks

 

[dogbite via AccessMonster.com]

No. Just post the information I suggested.
[quoted text clipped - 9 lines]

or post it or something or I'll give you my email address
Thanks

RecordId Builder Subdivison Address LotNum County City CrossStreet WireSize
WireCenter MinorSub BldgNum bldgpro1 bldgpro2 bldgpro3 bldgpro4 bldgpro5
bldgpro6 bldgpro7 bldgpro8 bldgpro9 bldgpro10 Date1 date2 date3 date4 date5
date6 date7 date8 date9 date10 CforDup chk1 chk2 chk3 chk4 chk5 chk6 chk7
chk8 chk9 Bvista PefExessive LocateTicket PefSameSide Comments chk10
1 Lennar Shire at Westhaven 125 Norfork 5 Polk Davenport Buckingham Dr Buena
Vista Engineering Slab 9/27/2006
2 Lennar Shire at Westhaven Norfork 70 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Shingle Canned 8/9/2006 8/23/2006
9/27/2006
3 Lennar Shire at Westhaven Norfork 69 Polk Davenport Buckingham Dr Buena
Vista Engineering Footer No Change Walls Paper No Change 8/23/2006
8/23/2006 9/13/2006 9/19/2006 9/23/2006 9/27/2006
4 Lennar Shire at Westhaven Norfork 68 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Sheet Shingle Canned 8/9/2006 8/23/2006
9/13/2006 9/27/2006
5 Lennar Shire at Westhaven Norfork 8 Polk Davenport Buckingham Dr Buena
Vista Engineering Footer Slab Walls Sheet Shingle 8/8/2006 8/23/2006
8/29/2006 9/13/2006 9/23/2006
6 Lennar Shire at Westhaven Norfork 13 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Sheet Paper 9/13/2006 9/19/2006 9/27/2006

7 Lennar Shire at Westhaven Sussex Dr 92 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Truss Sheet Canned 8/9/2006 9/12/2006
9/19/2006 9/27/2006
8 Lennar Shire at Westhaven Sussex Dr 63 Polk Davenport Buckingham Dr Buena
Vista Engineering Footer Walls Truss Paper Canned 8/9/2006 8/23/2006
8/29/2006 9/13/2006 9/27/2006
9 Bimminy Bay 503 Austrain Wy Polk Davenport Lady Palm Cir Buena Vista
Engineering Canned 9/27/2006
I hope this works

 

[Duane Hookom]

You have at least two issues:
1) you haven't told us what you mean by "access the data by subdivision and
street modify the data put it back in the table."
Normally you just open a form based on a query and edit the records. There
is not a need to "put it back in the table". I expect there is a very key
piece of relevant information that you are withholding.

2) You table seems un-normalized. I would expect the checks and dates to all
be stored as individual records in a related table.


--
Duane Hookom
MS Access MVP

No. Just post the information I suggested.

What is your table structure look like. Post an example of your data.
You can open a form that has a query as record source without a macro.
You

[quoted text clipped - 9 lines]

or post it or something or I'll give you my email address
Thanks

RecordId Builder Subdivison Address LotNum County City CrossStreet
WireSize
WireCenter MinorSub BldgNum bldgpro1 bldgpro2 bldgpro3 bldgpro4 bldgpro5
bldgpro6 bldgpro7 bldgpro8 bldgpro9 bldgpro10 Date1 date2 date3 date4
date5
date6 date7 date8 date9 date10 CforDup chk1 chk2 chk3 chk4 chk5 chk6 chk7
chk8 chk9 Bvista PefExessive LocateTicket PefSameSide Comments chk10
1 Lennar Shire at Westhaven 125 Norfork 5 Polk Davenport Buckingham Dr
Buena
Vista Engineering Slab 9/27/2006
2 Lennar Shire at Westhaven Norfork 70 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Shingle Canned 8/9/2006 8/23/2006
9/27/2006
3 Lennar Shire at Westhaven Norfork 69 Polk Davenport Buckingham Dr Buena
Vista Engineering Footer No Change Walls Paper No Change 8/23/2006
8/23/2006 9/13/2006 9/19/2006 9/23/2006 9/27/2006
4 Lennar Shire at Westhaven Norfork 68 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Sheet Shingle Canned 8/9/2006 8/23/2006
9/13/2006 9/27/2006
5 Lennar Shire at Westhaven Norfork 8 Polk Davenport Buckingham Dr Buena
Vista Engineering Footer Slab Walls Sheet Shingle 8/8/2006 8/23/2006
8/29/2006 9/13/2006 9/23/2006
6 Lennar Shire at Westhaven Norfork 13 Polk Davenport Buckingham Dr Buena
Vista Engineering Walls Sheet Paper 9/13/2006 9/19/2006 9/27/2006

7 Lennar Shire at Westhaven Sussex Dr 92 Polk Davenport Buckingham Dr
Buena
Vista Engineering Walls Truss Sheet Canned 8/9/2006 9/12/2006
9/19/2006 9/27/2006
8 Lennar Shire at Westhaven Sussex Dr 63 Polk Davenport Buckingham Dr
Buena
Vista Engineering Footer Walls Truss Paper Canned 8/9/2006 8/23/2006
8/29/2006 9/13/2006 9/27/2006
9 Bimminy Bay 503 Austrain Wy Polk Davenport Lady Palm Cir Buena Vista
Engineering Canned 9/27/2006
I hope this works

 

[dogbite via AccessMonster.com]

You have at least two issues:
1) you haven't told us what you mean by "access the data by subdivision and
street modify the data put it back in the table."
Normally you just open a form based on a query and edit the records. There
is not a need to "put it back in the table". I expect there is a very key
piece of relevant information that you are withholding.

2) You table seems un-normalized. I would expect the checks and dates to all
be stored as individual records in a related table.
[quoted text clipped - 41 lines]

Engineering Canned 9/27/2006
I hope this works

I go to a subdivision input the Subdivision, address, lot#, date, Ect. on
that house.
next week I go back to see if the house has gone from having the slab(floor)
poured to having the walls started next time to see if the roof is on, Each
trip is in a week cycle. I do that untill the meter can for the electeic is
on the wall then I print a report on that house. each time I visit a house it
gets that date and if the house has progressed as far as slab wall, truss,
roof, sheeting, shingles. So i have to get tha recordset for a house and
update it then save it back to the table. I do 2 areas and each area has
between 150 and 300 houses At this time i have a Qry to transfer the houses
that have the Ele. meters cans up, to a seperate table and then delete them
from the orignal table so I din't have to go threw them on each visit.

I'm not sure what you meen by un-normalized table
Do I need to splite the table? Are there advantage to that? All this is in 1
table.
Many thanks

 

[dogbite via AccessMonster.com]

You have at least two issues:
1) you haven't told us what you mean by "access the data by subdivision and

[quoted text clipped - 11 lines]
I go to a subdivision input the Subdivision, address, lot#, date, Ect. on
that house.
next week I go back to see if the house has gone from having the slab(floor)
poured to having the walls started next time to see if the roof is on, Each
trip is in a week cycle. I do that untill the meter can for the electeic is
on the wall then I print a report on that house. each time I visit a house it
gets that date and if the house has progressed as far as slab wall, truss,
roof, sheeting, shingles. So i have to get tha recordset for a house and
update it then save it back to the table. I do 2 areas and each area has
between 150 and 300 houses At this time i have a Qry to transfer the houses
that have the Ele. meters cans up, to a seperate table and then delete them
from the orignal table so I din't have to go threw them on each visit.

I'm not sure what you meen by un-normalized table
Do I need to splite the table? Are there advantage to that? All this is in 1
table.
Many thanks

10 dates 10 bldgpro are drop boxes that print on the report so my boss knows
that I go there every week or his boss.

 

[dogbite via AccessMonster.com]

[quoted text clipped - 19 lines]

table.
Many thanks

10 dates 10 bldgpro are drop boxes that print on the report so my boss knows
that I go there every week or his boss.

Accessing the data Bringing up the recordsets using (find) for subdivision.
I would like to do that on a separate form and have it update the table when
I finish

 

[Duane Hookom]

When you edit data in a form, it changes the data in the table. There is no
reason to "put it back in the table".

You don't seem to understand normalization. Did you understand what I meant
by putting the 10 date values in 10 different records? What are you storing
in these fields?

--
Duane Hookom
MS Access MVP

You have at least two issues:
1) you haven't told us what you mean by "access the data by subdivision
and

[quoted text clipped - 19 lines]

table.
Many thanks

10 dates 10 bldgpro are drop boxes that print on the report so my boss
knows
that I go there every week or his boss.

Accessing the data Bringing up the recordsets using (find) for
subdivision.
I would like to do that on a separate form and have it update the table
when
I finish