Excel as Database?
 

I have created an Access database for project managers
from an Excel flat file, however, majority of the project
managers do not know how to work in Access.

These project managers will begin to train on using
Access, however, the immediate need is that there is a
way in which to track their projects.

So, I have created a form in which I can put all of the
data using dropdown boxes, comments, validations, etc.,
however, my question is, can I use this Excel form as a
database?

What I mean is, can the project manager, key in their
project number and and the rest of the information
populate on this form?

I know this is antiquated, however, until I can get them
up to speed, Excel is my option.

Excel as Database?
 

There is no automatic support for it. Your code would find the appropriate
row and assign the appropriate values in that row to the controls on the
form. (form meaning Userform - or putting controls on a worksheet to
simulate a paper form?)

--
Regards,
Tom Ogilvy




"ND" wrote in message
...
I have created an Access database for project managers
from an Excel flat file, however, majority of the project
managers do not know how to work in Access.

These project managers will begin to train on using
Access, however, the immediate need is that there is a
way in which to track their projects.

So, I have created a form in which I can put all of the
data using dropdown boxes, comments, validations, etc.,
however, my question is, can I use this Excel form as a
database?

What I mean is, can the project manager, key in their
project number and and the rest of the information
populate on this form?

I know this is antiquated, however, until I can get them
up to speed, Excel is my option.

Excel as Database?
 

I have created a form that simulates a paper form

Thanks for your help!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!