L
Lisa
I've got 1 day under my belt with Access, so I don't know a lot more than I
do...
I'm "scrubbing" attributes from blueprints that we have scanned. At the
moment, the blueprint scan is identified by a bar code, not very helpful when
you have 1800 of them. My Access database will list the bar code number as
the primary key along with attributes (water, sewer, sidewalk, easement...)
listed on that blueprint. Our goal is to generate reports can be run
considering street address, and the attribute(s) in question, allowing us to
view only the scans of blueprints that would potentially have the answer to
our current question. I work for a Village & these prints are of our roads,
sewer lines, buildings, & plats, etc.
I've got my related tables set up. One with all of my street names, one
with land uses (R1, AG, C1). I have the "foundation or parent" table with
each attribute data type assigned with yes/no, text, date, & number.
1) I have my form designed with the fields in place but they are a mess. I
can't seem to get them to align vertically or horizontally or have a
reasonable space between the fields. They appear all to be locked together.
(Something I turned on without realizing it, I'm sure.) Acts like linked
fields in Publisher... Once I un-link them I want to "align to grid" like my
icons on my desk top but control that does not seem to affect my fields.
2)I want the street names or land uses to be a drop down selection & don't
know how to implement that. (Sorts require consistency...)
3)I still don't "get" how to use this form to add to my database once I get
the above figured out. Access is by far the most advanced program I've ever
attempted to self teach. I'm pretty adept at Word, Excel, & Publisher but
this is a whole different animal.
Thank you in advance for your assistance.
do...
I'm "scrubbing" attributes from blueprints that we have scanned. At the
moment, the blueprint scan is identified by a bar code, not very helpful when
you have 1800 of them. My Access database will list the bar code number as
the primary key along with attributes (water, sewer, sidewalk, easement...)
listed on that blueprint. Our goal is to generate reports can be run
considering street address, and the attribute(s) in question, allowing us to
view only the scans of blueprints that would potentially have the answer to
our current question. I work for a Village & these prints are of our roads,
sewer lines, buildings, & plats, etc.
I've got my related tables set up. One with all of my street names, one
with land uses (R1, AG, C1). I have the "foundation or parent" table with
each attribute data type assigned with yes/no, text, date, & number.
1) I have my form designed with the fields in place but they are a mess. I
can't seem to get them to align vertically or horizontally or have a
reasonable space between the fields. They appear all to be locked together.
(Something I turned on without realizing it, I'm sure.) Acts like linked
fields in Publisher... Once I un-link them I want to "align to grid" like my
icons on my desk top but control that does not seem to affect my fields.
2)I want the street names or land uses to be a drop down selection & don't
know how to implement that. (Sorts require consistency...)
3)I still don't "get" how to use this form to add to my database once I get
the above figured out. Access is by far the most advanced program I've ever
attempted to self teach. I'm pretty adept at Word, Excel, & Publisher but
this is a whole different animal.
Thank you in advance for your assistance.