Form and Database

  • Thread starter Thread starter zangel
  • Start date Start date
Z

zangel

I have a simple form in Excel. In this form, I have a the member'
number, name, address and phone number. Presently, I save each for
under the member's number. So I have a bunch of files.

I would like to use only 2 files (one for the form and one for th
database). I would like Excel to automatically save the data in th
database.xls file. If the member exist, I want Excel to update th
data, if the member doesn't exist, I want Excel to create a new lin
and add the data.

I would also like to call back the datas of a member by calling
macro. This way, I will see the member's data and I would be able t
update them.

Can this be done?

Thanks a lot
 
Take a look at advanced filters. These are fairly easy to setup to copy
information from a database and paste it into another area of the sheet.
When the database is queried the result can then be modified and this
information pasted back into the original record in the database. If no
result is returned from the database then this would be a new member and the
information could be copied then pasted to the end of the database. One
problem with Advanced filters, they are restricted to work within the same
sheet as the database. One advantage is that querying with wildcards and for
multiple records is very easy, once you get a handle on the criteria syntax.
 
Back
Top