I have created a form in Excel that I want to use to fill in
information, and then have it save the information in a database.

The form is NOT simply in rows and columns, it has graphics and so on.


I want to simply fill in all the information, and then have it save it
to a database, where I can later run different queries to find specific
data that was entered into specific cells.

If anyone could help, I would be extremely grateful. I've been messing
around with it for hours and have had no luck.

I once saw a co-worker create a form in Excel that had the options at
the bottom to move to the next record, etc... just like you would see
in the form view in Access.

Thanks a million!!

-Trey


--
aragno
------------------------------------------------------------------------
aragno's Profile: http://www.excelforum.com/member.php...o&userid=32658
View this thread: http://www.excelforum.com/showthread...hreadid=524663

Your co-worker maybe used dataform? Regardless you can build a userform
using VBA or use something already existing like JohnWalkenbach's enhanced
data form

http://j-walk.com/ss/dataform/index.htm

a little bit about userforms

http://j-walk.com/ss/excel/tips/userformtips.htm





--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"aragno" wrote in
message ...

I have created a form in Excel that I want to use to fill in
information, and then have it save the information in a database.

The form is NOT simply in rows and columns, it has graphics and so on.


I want to simply fill in all the information, and then have it save it
to a database, where I can later run different queries to find specific
data that was entered into specific cells.

If anyone could help, I would be extremely grateful. I've been messing
around with it for hours and have had no luck.

I once saw a co-worker create a form in Excel that had the options at
the bottom to move to the next record, etc... just like you would see
in the form view in Access.

Thanks a million!!

-Trey


--
aragno
------------------------------------------------------------------------
aragno's Profile:
http://www.excelforum.com/member.php...o&userid=32658
View this thread: http://www.excelforum.com/showthread...hreadid=524663

i took a look at that form. That is pretty nice, but I have approx. 50
fields total to enter data into, and that form would get very long and
tedious. The form I have created in excel is very userfriendly, but
would like to input the data directly from that.


--
aragno
------------------------------------------------------------------------
aragno's Profile: http://www.excelforum.com/member.php...o&userid=32658
View this thread: http://www.excelforum.com/showthread...hreadid=524663