Form Design Tool-Indent

[amerifax]

Something known to me. I'm in the "form design tools". I have a column of 20 fields or tables that are similar like Name, city, address. I want to indent the address rows. I thought I would be able to just drag the left side in a little bit. I must be missingf some thing.

Bob

 

[boblarson]

Are you using Access 2007 or 2010? If so you probably need to do this:
http://www.btabdevelopment.com/ts/default.aspx?PageId=27

 

[amerifax]

Thanks once again for your help. I am figuring out my way around in the form design.

I do have another question I am hoping you can help with...When I create a Form, where exactly is it getting saved? Can I take the form I create and attach it or use it with different tables that all have the same structure? The first form I created, I almost lost. Once I saved it, it disappeared and I didn't know where to go to find it. I searched the help and ended up changing a setting that loads the form I want everytime the database is opened. But then I created a second form. When I saved this form, it added the form right under the table name in the navigation pane. I am not sure what I did on the first form I created because it didn't do this.

Your expertise is always appreciated!

Bob

 

[boblarson]

Sounds like you need a quick lesson on how to filter the navigation pane. When you select the drop down for the navigation pane, there are two things you may want to have selected. The first is the OBJECT TYPE option and then ALL ACCESS OBJECTS. That will show you a list of everything (all tables, queries, forms, reports, macros and modules) unless they have been specifically set to be hidden.

See these screenshots -

Also, you can use the same form with a different recordsource. If the same fields exist then you don't have to do anything except assign the recordsource to the form. What would be the purpose though? There may be a better way to do it by simply filtering. I hope you don't have multiple tables with the same exact fields as that is not normalized and not a good way to design the database.

 

[amerifax]

Good question what is my purpose. Over the past 15 years, as far back as DOS dBase, I have been developing a program to process building permits. I have now decided to switch to access. You Bob have helped with one of my first items.

I would like to know the best way to approach what I'm doing. What I have done in the past worked very well. Every permits in my database since 1989 is live. I have one file called Permit, Builder, Municiplaity, State, LC, Custom, Subdivision and Instector. All linked and controlled by tabs. Permit being the master file. Atached is a view of the program I developed over the years.

a> 6a selects window to add permits.
b> Add permit in the top form (Add Permits)
c opens a fly out that gives an actual name to select.
d shows only subdivisions connected to nine. Nine is a municipality.
e. Five shows all the enterys that are highlighted item in box 4
f. 2 copies external data in a program called multi-edit.
g. Three searches the upper data based on database LC or Certified.
h. 1 search both ways between the lower and upper data.
i. 7 will bring down field of information from upper to the lower data box.

I hope I'm not getting too wordy. I I have asked some questions in the past and all my questions will be trying to get to the end result. I would like a suggestion on what should be my best approach. What I'm actually doing is crosschecking data between many different databases and updating when needed.

Bob