Using Excel to enter data using Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a form in Access that I would like to transfer to Excel so
input can be done through Excel. There is limited access to MS Access and
users are more comfortable with Excel. Is this possible?
 
Hi

With the standardized VBA and its close integration with Office objects (ie.
Access, Excel, Word), I suppose you can force your way to make it work. I
wouldn't even try it. It's almost like forcing a triangle shape object into
a square hole.

You brought up two issues:

- There is limited access to MS Access
What limitation? Access is fully programmable and very flexible. It does
have its limitations but I'm trying to understand whether this limitation is
your "perceived" limitation or a true Access limitation.

- .. users are more comfortable with Excel
Maybe true, but again Access can be programmed and customized to where user
comfort level would not be an issue. The big selling point of development
tools such as Access is control over and customization of user interface.

Immanuel Sibero
 
You can design a UserForm in Excel, which will look much like an Access
form, but is better tailored to the specifics of Excel.

AFAIK, there is no way to transfer an Access form to Excel "whole cloth".
 
I beleive he meant that only some users have access to Access.

Hi

With the standardized VBA and its close integration with Office objects (ie.
Access, Excel, Word), I suppose you can force your way to make it work. I
wouldn't even try it. It's almost like forcing a triangle shape object into
a square hole.

You brought up two issues:

- There is limited access to MS Access
What limitation? Access is fully programmable and very flexible. It does
have its limitations but I'm trying to understand whether this limitation is
your "perceived" limitation or a true Access limitation.

- .. users are more comfortable with Excel
Maybe true, but again Access can be programmed and customized to where user
comfort level would not be an issue. The big selling point of development
tools such as Access is control over and customization of user interface.

Immanuel Sibero
Click to expand...

Please remove obvious from email address if emailing.
 
Yes that is exactly what I meant. Some users have Access 97, 2000, 2002.
The database is currently being designed in Access 2000. I understand how to
make the database accessible to the various versions but some of my users
don't even have Access. Thank you for all your postings!!
 
Back
Top