Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |