Recent content by crowegreg

Hello, I'm trying to extract data out of Microsoft Project using the MS Project object within MS Access. Can anyone offer some suggestions as to how to do this? Basically I'm trying to take the data and insert into a SQL DB. Thanks in advance for your assistance!!

Within our corporate environment, I've been asked to automate the process of updating the distribution lists that are apart of our Global Address List within MS Exchange. I've written code to display the members of a distribution list within our Global Address List. I can't figure out how to...

Hello, You are correct. The posting of mine a few years ago is exactly what you are trying to do. If you haven't found a solution yet, I can zip my DB, and post it for you. I developed this for a customer a few years ago, and haven't done any work with it since then.

Here's my working, finished code.

You are able to put a formula within the textbox.

I've written code to export data from Access into an Excel spreadsheet. I have everything working except one part. Within 1 of the worksheets, I've created a chart. Using VBA, I've added a text box to the chart. I can't figure out how to place a formula within the text box. Here's the code I...

This is amazing. With looking at a lot of different things, I've come up with something. I've attached the DB. Please follow my exact instructions to duplicate what I've encountered. Please read all the instructions before testing. 1. Open this DB. Three objects are contained. 2. Open your Task...

Thanks for the suggestion. I'll give that a try on Thursday.

That makes two of us confused!! The code that I have used to create the Excel object, I've used throughout my DB, and I have not experienced this problem. After cleaning up the code, which primarily meant getting rid of the code that used "ActiveChart," all the remaining code only uses "wb1."...

In my troubleshooting, here's what I discovered, after the sub completes, an instance of Excel is displayed within the Task Manager. After closing the form, Excel is still within the Task Manager. When I close the database, Excel is no longer within the Task Manager. I've verified that opening...

The only differences I have are Access 14.0 Object Library. I'm sure that's the difference between Access 2010 & Access 2013. Here is my revised code. I removed the ActiveChart statement. Although my spreadsheet is being created correctly, I still have an instance of Excel running. Any...

Amazing. Your code is nearly identical to mine. I'm using Access 2010 and Excel 2010. What references do you have selected within your DB?

Thank you for the two replies. For Extra Mile Data, the statement "wb1.Sheets(1).Shapes.AddChart.Select", does that create another instance of Excel? For Rx, I'll try some of your code and see what happens.

I've written this code in Access to create a pivot chart in Excel. All the code listed is good except for the last line. The last line creates another instance of Excel. I can't figure out what the correct syntax is. I've tried, charts, worksheets, everything I can think of, and I can't figure...

I figured it out. Within the cmdViewReport, after CreateData, I needed these two lines of code. Me.frm_PM_Changes_subform_ID.Form.RecordSource = strQry Me.frm_PM_Changes_subform_ID.Form.Requery