Yes - Actually I have it set to a variable first
xlFile = "S:\Proposal\"& me.document & ".xls"
me.OLEUnboundName.SourceDoc = xlFile
Ive checked the filename and its correct..
Yes - Actually by Default Enabled was NO and Locked was Yes.
Changed them to Yes and No respectively and Still get an error:
Cant Link the OLE Object or the bound or Unbound Object Frame
Thanks for the help -
I do get this error though:
- Can't perform the operation specified in the Action Property of the visual basic procedure you're trying to run.
Any Ideas why?
I'd like the ability to view an Excel Spreadsheet in an Access Form - Using a field on the form to indicate the filename of the xl Document.. Is this possible? If so, How?
Is it possible to view a PDF File in a form? If so can someone give em some guidance.. I tried inserting the acrobat reader activex component on a form but I cant figure out how to load a file into it.
thanks in advance
Steve
I'd like to have some code that can see an existing and open excel document, go to pre-named cells and retrieve the data to then be put into an access table.
I want to do this from Access.. I know how to send the data to the tables. I just need to know how to get access to see the open excel...
Can anyone direct me in how I can store a matrix of 12 Insertion points. Currently Im doing the Following
Dim IP (12, 0 to 2) as Double
IP(1, 0) = 21.25: IP(1, 1) = 23.5: IP(1, 2) = 0
IP(2, 0) = 23.625: IP(2, 1) = 23.5: IP(2, 2) = 0
IP(3, 0) = 26: IP(3, 1) = 23.5: IP(3, 2) = 0
IP(4, 0) = 21.25...
Could anyone provide some basic code from access vba on inserting a block? Im having trouble understanding how to gain access to the Autocad enviornment from ACCESS.
Im assuming that Autocad will be running in the background, and I just want to call the current drawing, and simply place a...
I have a series of events happing in some code and as each one completes Id like a Progress bar to grow.. Ive made a new form with the bar and I call it up in the fist line of code (userform.show), at each place in the code I want the bar to grow I simply call it (userform.progressbar.width =...
The Code is long - Here's the upper section.
Private Sub fetch_Click()
Dim FSO As FileSystemObject
Dim DocPath As String
Set FSO = CreateObject("Scripting.FileSystemObject")
DocPath = ThisWorkbook.Worksheets("Sheet1").Range("A101").Value
vJobNo =...
Im trying to copy files in Excel and I keep getting Access Denied to the Files.. I dont have them open else where so Im confused why I'd be getting this.. Is there a work around?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.