Can Excel work as Access

davis1189

Registered User.
Local time
Today, 09:42
Joined
Sep 10, 2003
Messages
10
I have created a form in Excel. I would like to know if it is possible for the information from the spreadsheet to be utilized on the form as though this Excel form was an Access form? In Access, the information I show in datasheet view is able to be used as a record and can be accessed on the form.

In my search over the last days, I have found how I can use the form as an easier way to key information into the spreadsheet format, however, I cannot figure out how to take that same spreadsheet information and put it in a form.

What I need to happen is for project managers to be able to go in to the form I have created and use the drop down box to select their projects and the rest of the information show up as it shows on the spreadsheet.

Is this possible? I am looking at each row in the spreadsheet being a record (like a datasheet in Access).

Help! I know we should be using Access, but this option has been shot down. So, if I am not explaining this in a manner that makes sense and able to generate help, please let me know and I will take another stab at it.

Thank you!
 
I don't know of a way but I'm not an Excel guru (you should probably have posted this in the Excel forum by the way). You can create custom forms in Outlook that may be able to do what you want and would have more integrity than Excel.
 
I know I should have posted this on the Excel forum, however, there are many Access gurus who are also Excel gurus, however, not as many Excel gurus also know Access gurus so they may not be aware of the functions in Access.

By the way, if you weren't able to assist me, you probably shouldn't have posted a reply.
 
davis1189 said:
By the way, if you weren't able to assist me, you probably shouldn't have posted a reply.

But I did assist you. I told you that I didn't think it was possible and wouldn't have said so if I thought there might be a way. You will probably get a reply that "for sure" it is not possible. I offered an alternative as well. Can't ask much more when requesting free advice.
 
You are absolutely correct.

Thank you very much for the free advice.
 

Users who are viewing this thread

Back
Top Bottom