Prev: Error Message after exporting MS Access Table
Next: how to view 2 tables in design view side by side (access 2007)
From: Lisa on 16 Feb 2010 10:01
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.
--
Lisa
From: Jeanette Cunningham on 16 Feb 2010 15:51
1)
Click on one of the linked controls to select it, go to the Arrange tab and
click Remove.

2)
I'd like to suggest something different for your table structure.
tblStreet
StreetID - autonumber primary key
StreetName

tblLandUse
LandUseID - automnumber primary key
LandUseType

tblStreetLandUse
StreetLandUseID - autonumber primary key
StreetID - foreign key from tblStreet
LandUseID - foreign key from tblLandUse
Description - text
LandUseDate - date

3)
Create a form based on a query using tblStreet.
Create another form based on a query using tblStreetLandUse

The main form is the one based on tblStreet.
The form based on tblStreetLandUse becomes a subform on the main form.
Put a combo on the subform - the combo's row source will use a query based
on tblLandUse.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Lisa" <Lisa(a)discussions.microsoft.com> wrote in message
news:BEC6D9B5-F7FF-4B00-B493-38743EDCDD7D(a)microsoft.com...
> 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.
> --
> Lisa


 | 
Pages: 1
Prev: Error Message after exporting MS Access Table
Next: how to view 2 tables in design view side by side (access 2007)