Search results for query: *

Here's what I mean the code should look, withou the two unneccessary "else" :) Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim i As Integer With ActiveSheet.PivotTables("PivotTable1") For i = 1 To .PivotFields.Count If .PivotFields(i).Name = "REFRNUMB" Then...

Thanks again ETID, and I might try your solution, even though it looks like you have two "else" not needed in your code, actually one that is unneccessary and one that is orphaned. I am still searching for a simpler solution, non-programmatic, which can be presented and used easy by...

Thanks for the reply ETID, but I have data where I do not know yet what the data is, and cannot not just slap zeroes all over the table(s) causing the chart to treat the cells as such. Keep in mind that I only have this problem when I pivot my data from one set to another, AND where the...

I have blank cells in my Excel 2003 pivot chart data table. When I switch from displaying one variable to another on the chart, Excel automatically defaults to COUNT the cells instead showing the SUM of the cells. How can one correct for this, other than putting a zero in each blank cell in...

I just double checked the range "Alert" is defined in "Insert/Name/Define". My sheet is protected, so I had to unprotect the sheet to view this information that way.

Actually now I am not 100% sure it can be called a range, but I do have a cell named "Alert". It is a cell where I display messages to users, dependent on their input. And like I said it worked swell in Excel 2000.

Yes I tried that, plus tweaking the margins manually and it works. BUT now I have a rather large right white space margin in my document. Maybe it helps if I say that my right most column contains several combo drop-down boxes, and I suspect that it is here that Micro$oft is screwing up, but...

The company I work for was FORCED to upgrade to Office 2003, because Office 2000 will not work with the new Microsoft Exchange Server. I am 100% sure Micro$oft could have programmed this new Exchange Server so it would work with Office 2000, or put out a patch for Office 2000. I really, really...

The following VBA line worked swell in Excel 2000. ActiveSheet.Range("Alert").Cells.Font.Color = RGB(255, 0, 0) The company I work for was FORCED to upgrade to Office 2003, because the new Microsoft Exchange Server required that version. I am 100% sure Micro$oft could have programmed this new...

Furthermore, sometimes it works for a while and then if I click my above posted command button with code twice on the same record I get this error: "Run-time error '2719': A problem occured while accessing the OLE object"

Hmm, that is depressing. A minute after I posted last, I got the same error I got earlier, when using "PageUp" on first record, to test and go one record further back. This is the error I'm getting: "Microsoft Visual Basic Run-time error '2753' A problem occured while...

Specificly I once in a while got some "DAO" error when using the OnCurrent event to update my unbound pictures fields, when jumping back and forth through records. However after reading in almost all the answers, that the OnCurrent should work. I suddenly thought that an Microsoft...

Hmm, now I really offended someone. To: JeremyNYC (Programmer) I'm very sorry, but I only see one post from you that says, and I quote: "Danish Diver, I don't think he was assuming you are stupid, just that you hadn't looked in the help files. It's often best to mention that you've done...

Thanks for all your replies. To: JeremyNYC (Programmer) The Current event fires BEFORE the record data is displayed, like I wrote in my first post. I'm interested in an event that fires AFTER the record data is displayed. Thanks...

I already looked there and I do NOT see any event that triggers when I move to a new record on an existing form AFTER the data is displayed. I might be new to this VBA, but you assume that stupid and have not looked in the help file. However I did, which is why I went ahead and searched for an...

Hello there, Ok I'm fairly new to VBA so please forgive me if I'm axing a stupid question. I'm trying to find an event that fires when I move to a new record in MS Access AFTER the first or next record is displayed, not like the event OnCurrent that fires before the first or next record is...

Hello there, Ok I'm fairly new to VBA so please forgive me if I'm axing a stupid question. I'm trying to find an event that fires when I move to a new record AFTER the first or next record is displayed, not like the event OnCurrent that fires before the first or next record is displayed. You...

Ok where NS before did absolutely NOTHING when I hit the submit button, at least now when I add the "refresh" variable and store the form and selection value and then use that variable when I write (see 3 posts ago) , something does output in NS: Here is the color you selected: and...

Oh crap my typo in the last post. Sorry forget it folks

However it DOES not work in IE, if I use: document.SaveFormValue=ColorForm.ColorChoice.value instead of: SaveFormValue=ColorForm.ColorChoice.value Strange!?!