Search results

I like that. It is more efficient code. Unfortunately, it does not solve the problem. :( The same line still gives me the same error. If I add a . in front of these lines (e.g. change Range to .Range) then it runs and the next time aborts at the next non-dotted line, etc. until it reaches...

That worked!!! Thank you so very very much. :) That solved the first problem I was having, but the second one still remains. Every other time I run the Event Procedure I receive the error: Run-time error '1004': Method 'Range' of object '_Global' failed on the line: Range("A1").Select as...

I should have put that into my code on principle. However, it unfortunately has not changed anything. I am still have the same problem. :( ~Landar

The line: ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R2C1:R" & i & "C1" is definitely where the error is showing up. If I remove the ActiveChart.SeriesCollection(1).Delete before it, the program runs, however, it only runs every other time I click the button the above Event...

I have code I wrote that automates an Excel application and MS Graph via an Event Procedure in Access (this is all done with Office 2000). Whenever I run the code, I watch the Excel application open, the first sheet is populated with the data, and then I watch it automatically generate the...

Unfortunately, I had already looked at the previous postings on the error and they were not helpful. Thank you for pointing out that I was using Date, I had overlooked that. The name has now been changed to ReportDate (alas, this was not the source of my problems, but would have likely been a...

Hi. I am trying to export a query I stored as a String in VBA (SQLstr) into Excel. However, it gives me the following error: Could not create spreadsheet. Error: 3061 Desc: Too few parameters. Expected 2. The code I am using is as follows (with unimportant stuff left out): Dim db As...

That worked great! :) Thank you. :) Since I am manipulating Excel with a Set xl = CreateObject("Excel.Application") With xl I added the line: .DisplayAlerts = False and that worked perfectly. Thank you for the help. :) ~Seth Neustein

When manipulating an Excel application from Access (that is, open a .CSV file, make some changes, save changes, close excel application), how does one stop the save confirmation box from popping up? Otherwise, is it possible to have the VBA code automatically select yes to the confirmation box...

I am trying to open an excel file as a delimited file using VBA code (so I can perform some automated manipulations on the file from Access before importing the data into a table). The issue I am having is with using the file open parameters (with the exception of Origin, which Access VBA...

Unfortunately, yes. However, thankfully it is not a large database and does not appear to actually be taking up any virtual memory, so perhaps it will one day delete itself. Thanks again for the help. :) ~Seth

I cannot delete it. Even after rebooting my PC (since the database resides on my hard drive) the .ldb file still remains and when I click "Yes" to delete it, I receive a sharing violation error message stating the file is still in use. ~Seth

I do not know why such an obvious thing did not occur to me. Thank you so much for your suggestion, as that worked. :) Although what is weird is that the original database is in an Admin locked format that I cannot unlock, and even though shut down (and after a reboot) the .ldb file still...

I have an Access 2000 database I created with Event Procedures attached to the On Click Event line in Command buttons' Properties menu. This, so far, is not unusual. However, the Event Procedures on my buttons suddenly started associating themselves strangely. Without making any changes to...