Taperssection.com

Gear / Technical Help => Post-Processing, Computer / Streaming / Internet Devices & Related Activity => Topic started by: Phil on February 02, 2009, 03:28:54 PM

Title: MS Access Database Guru's??
Post by: Phil on February 02, 2009, 03:28:54 PM

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!

Title: Re: MS Access Database Guru's??
Post by: BJ on February 02, 2009, 04:35:08 PM

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?

Title: Re: MS Access Database Guru's??
Post by: Phil on February 02, 2009, 10:47:13 PM

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!!

Title: Re: MS Access Database Guru's??
Post by: BJ on February 04, 2009, 01:37:12 PM

Quote from: Phil on February 02, 2009, 10:47:13 PM

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?

Title: Re: MS Access Database Guru's??
Post by: Phil on February 04, 2009, 10:28:38 PM

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

Title: Re: MS Access Database Guru's??
Post by: phanophish on February 05, 2009, 12:28:52 AM

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

Title: Re: MS Access Database Guru's??
Post by: Phil on February 05, 2009, 10:43:40 AM

Quote from: phanophish on February 05, 2009, 12:28:52 AM

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.