setting up a database

[sharon137]

I have the data for my database in excel.

How do I drop the information into a form as I think it would be easier to view and edit in that format.

When I import it from excel, it puts it into a table

Please help me!

Thank you

 

[pr2-eugin]

Hello Sharon,
Yes the data that you import from EXCEL will be put inside a table.. Forms are based on tables, to create such a Form you have to click on the Form Wizard under Create Tab.. This way you can tell the wizard to pull only the infromaton that you need to see on the Form.. Try this post back if you still find it hard to follow..

 

[sharon137]

Can other people add to the information on the form once it is set up?

 

[pr2-eugin]

Ofcourse they can.. That is the main use of the form, to view, edit, and add new details to the form.

Forms, On top of just add/view/editing the information there are several functionalities that you can add on it.. like validation of field, making sure some value is entered in a field, automatically add some data.. You will learn everything one step at a time..

 

[sharon137]

I have created my form but get an error message against the field named account: #Name?

How do I copy/link the data from the table in the form?

Thank you

 

[pr2-eugin]

How did you create the Form? Was it using the Form Wizard? Do you get the error in all records of the form? or a particular record?

 

[sharon137]

I created the form using the wizard, and added some of my own fields. the account was the only one with an error

 

[pr2-eugin]

First, Check the table and see if the Field has valid value in it..

BTW, Do you mean that, you added the Account Field after the form was created? If so where does the value come from?

 

[sharon137]

I have taken out the Account field for now. I might add it at a later stage once I get the hang of this program!

How do I copy/link the data from the table to the form?

Thank you

 

[G37Sam]

Can you share the DB with us to troubleshoot it?

 

[sharon137]

my database in excel has the following headings:

a/cCo nameCo addressaddress 2address 3 address 4address 5contact nametel noemailemployeesT/Osic codeH&SL&DFinance

I want to be able to view this information in a table.

How do I do this please?

Thank you

 

[G37Sam]

I have taken out the Account field for now. I might add it at a later stage once I get the hang of this program!

How do I copy/link the data from the table to the form?

Thank you

First you have to link form to a table => Use record source property of the form

Then you link your fields using the fields control source

 

[G37Sam]

Do you just want to do a one time import?

Or do you want to have the excel sheet linked to your table so that changes in your excel sheet are reflected in your access table?

I recommend against the latter, unless you have no control over it.

Both can be done from the External Data tab => Import => Follow the wizard

 

[sharon137]

Wow! I've done it! Thank you so much for your help.