Wizard help?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a Contacts Database with one of the wizards. Then, I went to the Contacts form and switched it to "database". Line by line, I have been cut and pasting info from an Excel file that is "way wacko out of order from this wizard database" and placing it individually in each cell. I didn't do all of the info because I wanted, of course to make sure it worked. Well, the information winds up in a nice table once saved however, when I exit the program and re-enter the info is not showing up under the database form Contacts. Is there a way to link it back? If so, can you direct me? I was trying to short cut the entry because there is so much to enter. Thanks for the assistance.
 
are you saying that you want to import the contents of an Excel spreadsheet
to a table in your database?


mabyn said:
I created a Contacts Database with one of the wizards. Then, I went to the
Click to expand...
Contacts form and switched it to "database". Line by line, I have been cut
and pasting info from an Excel file that is "way wacko out of order from
this wizard database" and placing it individually in each cell. I didn't do
all of the info because I wanted, of course to make sure it worked. Well,
the information winds up in a nice table once saved however, when I exit the
program and re-enter the info is not showing up under the database form
Contacts. Is there a way to link it back? If so, can you direct me? I was
trying to short cut the entry because there is so much to enter. Thanks for
the assistance.
 
You might try checking the record source of the form (this should say the table name) and the control source of each control(This should be the field name in the table). If you're not sure how to do that reply back.
 
I'm not really sure if there is a specific way to do this. When I click on it at the bottom of the screen I see "contacts" so I presume it is accessing the only table it can, contacts. That is the table where everything is entered.
 
Go to the design view of your form. In the upper lefthand corner of the form where the vertical and horizontal rulers meet there is a small box. Right click on this box. Click on properties. Click on the all tab. Make sure you scroll all the way to the top. You should see the record source property. The table you want the form to be linked to should be here. If it is not click in the property and choose the table from your dropdown menu. After this, click each textbox and check the control source in the properties. It is located on the all tab 2nd from the top. This should say the field in your table that the textbox should be linked to.

Let me know if this doesn't fix your problem.
 
Back
Top