Help with Template

[Tillis]

I have downloaded an MS template for a Membership Data Base. I can't figure out how to import membership data from excell into the template. Please help this mewbe.

 

[MStCyr]

Hi

This is quite simple to do. Just link to your Excel table

 

[Tillis]

help with template

Thanks, I did that and I have the member information in a database view. Now, how do I insert this into the form that shows each members individual data without typing it in field by field? That's where I am having the problem.

 

[MStCyr]

then you just import the data into the appropriate table using an append query

 

[Tillis]

Thanks, just got back to this.

Now, I can import data from excell to a new table, but I can't load the fields in the table into the template's predesigned form. I can make a new form but I want to use the frorm that came with the template.

 

[Pat Hartman]

Link to the Excel Spreadsheet. There isn't any need to import the data. Create an Append query. To do this start with a query that selects all columns from the linked spreadsheet. Change the query type to append. This adds an additional row to the QBE grid, named Append To:. This new field is automatically populated whenever the column names match. For the column names that are different, you'll need to go to each empty AppendTo cell and choose the correct column name for the source data.

Running the query will place your data in the table and then the forms in the template will show the data.

 

[Tillis]

Thank you, I'll work on this and let you know how I come out.

 

[Tillis]

Well, some progress, but all I get in the members data form (template) is the first and last names. All the other fields have #name in them?? What am I doing wrong?

 

[jwhite]

That's telling you that your control source of the textbox does not match any field names in the table. Open the form template in Design Mode. To see the full list of field names available, view each textbox's properties that #Name is appearing in. In the Control Source property, click the down-arrow at right - a list of available fields as defined in your table (identified in the Record Source above) will appear. From this list you will be able to select fields which are valid for each control (in this case, it is a textbox).

If you are still having difficulty after this, post your MDB here. If confidential, make a copy. Delete all the data, and leave only the table, the form template, and the query in the database. Upload this modified MDB. I'm sure there are several here who will help you figure it out.

 

[Tillis]

Thanks so much. I'll work on your suggestions, and report results.

 

[Tillis]

Ok I can find the list of field names but, they are the names from the orginal template not from the table I made from the excell sheet. How do I open the from in design and show the proper field list?

 

[Tillis]

Hey I did it! With the help from all of you I have the template loaded with the correct info and even added some new fields. Thanks to you all. I am sure I'll be back with more questions later.