Search results for query: *

Skip, Thanks for your help, but I already used many of the speed techniques in my VB code. Why doesn't the VP in the Excel 2007 run the same code at least the same amount of time as the Office 2003 did? I wonder if anyone else experienced a slow down in their Visual Basic code execution when...

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

The code works well 90% of the time and I can move thru records in the main form and also the subform and they do synchronize fine. When I am in the main form (not its subform) and go to Add a new record this error pops up: "Runtime error 3077 ... Syntax error: missing operator in expression"...

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

I have other Charts in the sheet that I do want to keep. Will the ... ActiveWorkbook.Charts.Delete ... delete all of them?

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

Well it really surprised me in my first question ever on this forum, that no one knew any answer to my posted question about filters in Pivot Tables. After further work I guess the best answer without using code, is to design the Pivot Table and then go into Form View in it. Then the Filter by...

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