Form field sizing & alignment troubles, using related tables

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.
 
J

Jeanette Cunningham

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top