Typing/editing an OLE object in an Access Form

S

Sandra Gomez

I created a form in Access that requires a simple spreadsheet that allows
data entry to the Excel object I have inserted into the form. It's simply 4
rows of name, date, hours and a total at the end of the 3rd column. The
object looks perfect but I can't type in the Excel portion of the form. How
do I maintain the link, allow users to enter data and retain the data when I
review the form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel in an Access Form for entering data 3
Append data to linked SQL Server 2008 table 0
OLE Object Data Type Question 8
OLE Object Field Question 0
How to display OLE Object (e.g. Word Doc) on form 1
Linked OLE Object 3
Excel sheet (OLE object) sometimes open on the form sometimes in E 1
Can Excel show OLE object created in DLL of VB6 ? 13

Top