If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form field sizing & alignment troubles, using related tables
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 |
#2
|
|||
|
|||
Form field sizing & alignment troubles, using related tables
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|