Help please?AUTO ADD IN SUBFORM?

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

Guest

I have set up a db with client name & address details with a subform for
updating details about mail shots.
Is there a way to update the subform with new mailing details for multiple
clients? Please help I am really struggling and dont want to go back to
using excel as I have far too many records to do manually.
Many Thanks
Ani
 
I have set up a db with client name & address details with a subform for
updating details about mail shots.
Is there a way to update the subform with new mailing details for multiple
clients? Please help I am really struggling and dont want to go back to
using excel as I have far too many records to do manually.
Many Thanks
Ani
Click to expand...

Since we don't have any idea how your database is structured, all I
can say is: your mailshot data is NOT in your subform. The subform is
just a tool, a window which lets you update the data in a mailshot
Table.

If you want to edit existing records in the mailshot table, use an
Update query. If you want to add records for a new mailshot, use an
Append query. The nature of these queries will depend on your table
structure and on the source and nature of the information you want to
put into the table.

John W. Vinson[MVP]
 
Thanks John
I think you have helped me before. I will try and explain how Ive got it
set up, please excuse me because although I have managed to get access to
handle the info I need I dont understand the language or how alot of it
works. Been doing things as I go along on a wing and a prayer so its
probably not set up ideally.
I have two main tables, the client details/contact table and the mailing
information table. The information held in the subform is the information on
the mailing information table.
The problem I have is trying to transfer information held on excel sheets
that needs to go into the subform.
This specific problem is, excel table holding 765 client contact details and
two columns of mailing shot info.
I need to find those 765 clients (who are already entered in the db) and
create a new record in their subforms with new mail shot information. I can
import the excel worksheet as a different table and match the names but then
do not know how I can add the new mail shot records to their subforms. Is it
possible to do it from the query? Am I going about this all wrong?
Many thanks
Ani
 
Thanks John
I think you have helped me before. I will try and explain how Ive got it
set up, please excuse me because although I have managed to get access to
handle the info I need I dont understand the language or how alot of it
works. Been doing things as I go along on a wing and a prayer so its
probably not set up ideally.
I have two main tables, the client details/contact table and the mailing
information table. The information held in the subform is the information on
the mailing information table.
Click to expand...

Could you describe these tables? What are some of the relevant fields?
What is the Primary Key of each table (or is there one)? How are the
tables related - surely one to many, clients to mailings?
The problem I have is trying to transfer information held on excel sheets
that needs to go into the subform.
This specific problem is, excel table holding 765 client contact details and
two columns of mailing shot info.
I need to find those 765 clients (who are already entered in the db) and
create a new record in their subforms with new mail shot information. I can
import the excel worksheet as a different table and match the names but then
do not know how I can add the new mail shot records to their subforms. Is it
possible to do it from the query? Am I going about this all wrong?
Many thanks
Ani
Click to expand...

I would GUESS that you don't need to import the spreadsheet at all:
you can link it using File... Get External Data... Link.

You could then create a Query joining the linked spreadsheet to your
client table - by name and address, if that's all you've got (see
below). This will give you the unique ClientID (from the Clients
table) and the mailshot information (from the linked spreadsheet).
Change the query to an Append query and select the mailing information
table.

I can't be very specific here because, again, I cannot see your
database; I don't know what's in the spreadsheet, what's in the
clients table, and what's needed in the mailshot table - but in broad
outline that's what you need to do.

John W. Vinson[MVP]
 
Back
Top