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 was able to link my spreadsheet to Access but I can only get the data to display 1 record at a time. How can I get all of the records to display at the same time in an Excel spreadsheet. I have tried changing the control source to my linked spreadsheet but that didn't work. What is a record...

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...

With Me![OLEExcelSheet] .Enabled = True .Locked = False .OLETypeAllowed = acOLELinked .Class = "Excel.Sheet" .SourceDoc = "G:\TestOLEAuto.xls" .SourceItem = "R1C1:R7C4" .Action = acOLECreateLink .SizeMode = acOLESizeZoom End With

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...