Topic: MS Access Database Guru's??

[Phil]

Hey All,

I'm needing some help with creating a MS Access 2003 database that will pull in some fields from an excel spreadsheet then spit out a report.  I can't seem to figure out how to import / link the excel spreadsheet to my form.  Any help is much appreciated!

[BJ]

you need to import the data into a table, not the form.  the form will run off the table. 

have you tried to import?  did you get errors?

[Phil]

I have it imported into a table, but how do I link the table to the form fields with a dropdown box?

Essentially I'm trying to create an access database for tracking calls to clients.  I want to pick my client from the a dropdown box in access then it will prefill the phone and address info by pulling from the linked excel file in the table. Thanks!!

[BJ]

I have it imported into a table, but how do I link the table to the form fields with a dropdown box?

Essentially I'm trying to create an access database for tracking calls to clients.  I want to pick my client from the a dropdown box in access then it will prefill the phone and address info by pulling from the linked excel file in the table. Thanks!!

did you ever get this working?

also, what version of access are you using? 2007?

[Phil]

Thanks! I just sent you a pm.  I'm using 2003 btw.

[phanophish]

Phil

Outlook also has pretty extensive journaling and history for tracking communications to a given contact.  Might save you the trouble of building a DB from scratch. 

http://office.microsoft.com/en-us/contactmanager/HA101759211033.aspx

[Phil]

Phil

Outlook also has pretty extensive journaling and history for tracking communications to a given contact.  Might save you the trouble of building a DB from scratch. 

http://office.microsoft.com/en-us/contactmanager/HA101759211033.aspx

Thanks Brian, but it's not really contacts I'm pulling over, it's just the easiest way to explain it.  My agents that I have use certain codes that interally we use to identify them.  It's the codes I'm trying to pull over, but the easiest way to explain it to people is to reference my agents as a contact and their code as a phone number.