| | |
|
|
|
Wizard help? |
|---|
| message from =?Utf-8?B?bWFieW4=?= on 27 May 2004 |
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.
|
| tina replied to =?Utf-8?B?bWFieW4=?= on 28 May 2004 |
are you saying that you want to import the contents of an Excel spreadsheet
to a table in your database?
"mabyn" <anonymous@discussions.microsoft.com> wrote in message
news:E0E6CEC5-0756-4D06-A2FA-5F2B60BAE9A2@microsoft.com...
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.
|
| =?Utf-8?B?bWFieW4=?= replied to tina on 28 May 2004 |
no, not really... not sure that would help at this point. I've already copy and pasted the data into the Access file however when I open the database, the contacts form is a blank form. The table with all of the kids names isn't accessed and I want it to be. Does that explain it better? When I "x" out of everything and look at the contacts table, the information is there.
|
| =?Utf-8?B?VGFzaGE=?= replied to =?Utf-8?B?bWFieW4=?= on 28 May 2004 |
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.
|
| =?Utf-8?B?bWFieW4=?= replied to =?Utf-8?B?VGFzaGE=?= on 29 May 2004 |
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.
|
| =?Utf-8?B?VGFzaGE=?= replied to =?Utf-8?B?bWFieW4=?= on 1 Jun 2004 |
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.
|
|
Archived message: Wizard help? (MS Access)
