Search results for query: *

I am trying to display data from an external spreadsheet in a spreadshet on an ms access form. I need to be able to edit and save the data in the spreadsheet on the form. This is probably very simple but I just can't seem to get it to work. I have tried: 1. Linking a spreadsheet to an...

I have a spreadsheet with several sheets but I only need data off of one of the sheets. How do I select a specific sheet to link to a bound/unbound OLE frame.

I am trying to link a spreadsheet external to Access to a spreadsheet on an MS Access form. I need the spreadsheet in Access to look just like the external spreadsheet and be able to transfer data between the two spreadsheets. I have already tried several methods with no success. Any source...

I get the following error when I try to set the SourceDoc property on an OLE object in one of my MS Access forms: Run-time Error 2101: "The setting you entered isn't valid for this property." My path an file and filename are: OLE.SourceDoc = "H:\TestOLEAuto.xls!R1C1:R30C15" I checked the...

I am trying to embed an excel spreadsheet in an access form and link an external spreadsheet to it. I have found several examples on how to export data to a spreadsheet and import from a spreadsheet but no luck. I have also tried the following : With Me![OLEExcelSheet] .Enabled = True...