Linking to Database

M

MoosieDog

I need have made a "form" page that I would like to be linked to a database for this information. Nothing seems to be working to move the info I enter on the form into a saved database. Is there anyone willing to work with me on this? I am totally out of my league here with excel. Could I send someone the form to look at and see what I'm missing??

HELP
 
R

Ron de Bruin

If don't know how much data you are talking about?
If you want to use Excel see this page

http://www.rondebruin.nl/copy1.htm

See the last example
"Example If the Database sheet is in another workbook"


--
Regards Ron de Bruin
http://www.rondebruin.nl


I need have made a "form" page that I would like to be linked to a database for this information. Nothing seems to be working to move the info I enter on the form into a saved database. Is there anyone willing to work with me on this? I am totally out of my league here with excel. Could I send someone the form to look at and see what I'm missing??

HELP
 
M

MoosieDog

Thanks for the quick reply, but you're way over my head with that info. Maybe I need to be more specific. Bare with me.

I contact prospective clients for my business and need to track contact info (name, phones, time called, etc.)

When they call in, I need to quickly access their information. So, I made up a single page form on excel for all the information for just one contact that I normally need to view. What I want excel to do is when a new person calls in, I would like to pull up this "Contact" single person page, enter the appropriate info for that person and then have that info transferred to a permanent database for later retrieval and review, back onto that one page form. Seems like this all should be an easy task but excel just has more options than I have brain cells. Is there a service that would be willing to set something like this up?
 
R

Ron de Bruin

Look at this Add-in first
http://www.j-walk.com/ss/dataform/usage.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


Thanks for the quick reply, but you're way over my head with that info. Maybe I need to be more specific. Bare with me.

I contact prospective clients for my business and need to track contact info (name, phones, time called, etc.)

When they call in, I need to quickly access their information. So, I made up a single page form on excel for all the information for just one contact that I normally need to view. What I want excel to do is when a new person calls in, I would like to pull up this "Contact" single person page, enter the appropriate info for that person and then have that info transferred to a permanent database for later retrieval and review, back onto that one page form. Seems like this all should be an easy task but excel just has more options than I have brain cells. Is there a service that would be willing to set something like this up?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top