asked on Use Excel to interface with MS Access query or table
I want to apply Excel as interface for an MS Access database. The user will only have to enter and updata one field in a query (or a table), but needs to see the other fields also. How can I accomplish this?
The reason to do this is that the only database interaction for this user is only this one field in one query. The user is used to simple Excel use and we do not want to expose him to a "new" computer application.
The reason to do this is that the only database interaction for this user is only this one field in one query. The user is used to simple Excel use and we do not want to expose him to a "new" computer application.
Microsoft AccessMicrosoft ExcelVBA
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks to you both. Crystal opened my eyes to the possibility to link to Access from Excel side. I always exported from Access to Excel.
Thanks for Jeffrey as you confirmed that what I want to do is not possible.
I do still believe that there must be a VBA way. For instance use the linking from Excel and then have an update button to go and save entered data into the access table. I will ask a question.
Thanks for Jeffrey as you confirmed that what I want to do is not possible.
I do still believe that there must be a VBA way. For instance use the linking from Excel and then have an update button to go and save entered data into the access table. I will ask a question.
you're welcome, Fritz ~ happy to help
I think a VBA linking process will work best. Do you perhaps have linking VBA code?