Recent content by ParanoidAndroid

That is fantastic! That's some of the maddest code I've seen yet. Thank you. Now perhaps I wont break the "live" database by accident :)

Hi comrades, I have two copies of the same database... one that is "live" the other I use to test changes. To make it obvious to me which of the two databases I am in I'd like to colour the workspace area. After many fruitless google searches I am begining to wonder if this is possible...

Hi there people, I would like to be able to remove any captions from a pivot using VBA. I know how to change a caption in VBA: ... ActiveSheet.PivotTables("PivotTable1").PivotFields("Name").PivotItems("SmithF").Caption = "Fred Smith" ... And I have found out how to remove the captions by...

I found my problem... :) My form was set to "Allow Additions" only... which stops you from changing the option group (even though it is not bound to the table!) I need to "Allow Edits" and then the form works as planned... so I now need to work around the problem of someone being able to...

Hello comrades. I'm using Access 2002. I have created a form that is bound to a table. On this form I would like to create a group of radio buttons that affect the way the form is displayed, but do not update the bound table in any way. My problem is: When I create the option group I am...

You would think that... I know I did. The problem appears to be that excel refuses to let you modify (or delete) in any way a range name that is not currently a "valid" name! I have heard a rumour that this is improved, or maybe even fixed in 2007... but I don't see my firm moving to 2007 in...

I've spent a lot of today trying to find a way to fix invalid range names in a Xp/2002 excel workbook. The problem has been compounded over time by people copying sheets from one workbook to another which includes all the range names (including the invalid ones) to the new workbook. The file...

You are right! I should have checked that before posting! (you really do learn something new every day! :))

Re: Text Formatting To change the style of the text within the same cell you need to use the .Characters(start,length) method... I think the following should work for you if the cell is still selected. With ActiveCell.Characters(Start:=1, Length:=9).Font .FontStyle = "Regular"...

I do not have enough knowledge of how the US government works to answer that conclusively. Part of me desperately wants it to to work in a way that GWB had little to no influence over such a big decision of declaring war. Perhaps I am guilty of wishful thinking! As for taking the entire...

Are you asking if I believe the story actually happened.. or are you asking if I believe in the sentiment or moral behind it? I try to be helpful all the time ;)

The correct answer is 7.41104581673307... which even with rounding is only 7 Running your numbers through a database I get the same answer for both methods you describe.

You need to split criteria into two parts like so: ([datetime]-Int([datetime])>=TimeSerial(6,0,0) And [datetime]-Int([datetime])<=TimeSerial(15,15,0)) And ([datetime]>=[Forms]![Form1]![StartDate] And [datetime]<=[Forms]![Form1]![EndDate]) You will need to replace [datetime] with your...

Now you've opened a can of worms! :D For either (or both) of them to be blamed for the B*lls up that is the war on terror, the Iraq war, and the enconomies of the US and UK they would have to be solely responsible. I am not saying they are completely blameless (far from it!)... but they...

"All characters in this book are fictitious, and any resemblance to real persons, living or dead, is coincidental." :rolleyes: