Search results for query: *

A Visual Basic procedure that I have used for quite awhile in my Office 2003, Excel, normally takes about 2 minutes to run. Yesterday, I installed Microsoft Office Home & Student 2007 on the computer. To my amazement, the same procedure now takes 6 and a half minutes to run! No errors occur...

I have a simple form that shows the fields from a query, in form view at the top and a subform that shows data from the same query in a subform at the bottom of the form. The top shows - one - record and the subform shows - all - records of the same query. I would like to ... a) Always have the...

In Excel 2002, I have code that creates an embedded Chart named "Results" on a sheet. It's there. When I record a macro and delete the chart, the macro has this line in it at the beginning: ActiveSheet.ChartObjects("Results").Activate When I run my own same code and put the chart back in the...

The code below creates a chart. I would like to put this code in a loop and then 1) have code before it that checks to see if this "Results" charts exists, and 2) if it does exist - to delete it. Please help. MyRange = Range("B4:B204") Range(MyRange).Select Charts.Add ActiveChart.ChartType =...

Is there any way in Excel, to see the mouse position in "points" so that you can then use that information in code like that below. In other words, how do you tell what the position is of any place on a worksheet, in points, so you can then place your Charts where you want them? With...

My access database has security groups setup that only allow certain abilities. However, I didn't see any security to prevent a user from writing macros. One of my users doesn't know any VB programming, but they like to play around and write their own macros when they use the access database. Is...

This probably doesn't belong on the VB 5.0 and 6.0 forum, but I'm desperate and hope someone may help. We have a 3rd party app created in Visual Basic 4.0 that we used to run in Windows 98 fine. We recently did a clean install of Windows XP Professional Upgrade from scratch. Then we installed...

We have Microsoft Office XP. We have a custom program in Access that we can use to query a table and produce another table of just the results of the query. After we have produced the results and have selected all its rows, we would like to copy and paste it into our Excel to use the results...

I'm an intermediate user of the Access in Office XP, but cannot figure out how to attach advanced filters to any Pivot Table design in Access. It appears you can attach very simple filters by dropping them into the "Filter Fields" section of a Pivot Table design, but how do you...