Search results for query: *

Hi there, I've been searching all over and can't find exactly what I'm looking for. I have the following data: Team Rank Points CAN 5 11 SLO 2 20 GBR 6 10 KOR 1 25 CAN 3 15 CAN 3 15 CAN 7 9 CAN 8 8 USA 9 7 CAN 10 6 USA 11 5 JPN 12 4 KOR 13 3 USA 14 2 USA 15 1 USA 16 11 AUS 17 11 USA 18...

Fiddling: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub End If On Error GoTo ErrHandler: If Not Application.Intersect(Me.Range("C1:C200"), Target) Is Nothing Then If IsNumeric(Target.Value) = False Then...

Oh, and actually, it need to be all caps.... __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

The latter. I've got untrained, unskilled folks entering the data and two columns would really mess with their heads... __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Hi there, I've been digging about and just can't seem to find what I'm looking for. I am trying to format Column C contents (after they have been entered) to Ucase(). I'm not familiar with the Private Sub Worksheet_Change(ByVal Target As Range) End Sub method and am not sure how to pass the...

Thank you genomon. My built in help was annihilated when this version of Access was loaded. I'd just done a Google search when I checked your post. The 'n' was the missing factor. Thank you again! __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

It seems that DateAdd() needs whole numbers to calculate. I just tried: =DateAdd("h",.5,Now()) and it showed up with the same time.... bummer __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Ah, and the boss changes his mind yet again...he really wants it to expire in 30 minutes. (Frustration level is about a 9.8 right now.) Thanks for any help!! __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

REPEATING:Yeah, the first thing I tried was Now() + 10 and got it to work... THE GOAL: Show the expiration time one hour from the report publication time. __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Remou, Yeah, the first thing I tried was Now() + 10 and got it to work... I'm trying to put this in a textbox and have it calculate based on when the report is printed. As I mentioned, I'd ultimately like it to expire in one hour. DateAdd() appears to need too many pieces of info to work...

I think I've been looking at this too long and feel like I'm beating my head against the wall. I am trying to add an expiration date to my report based on NOW() and adding 10 days to it. Ultimately, I'd like the report to expire in an hour, but I'm trying to break the peeps in slowly... Any...

Fahhhhbulous! Even works when it's grouped (once everything has been populated on each sheet). Thanks! __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Oh Bummer. Not working. Only works for one sheet. And they aren't grouped. When I change the cell on say the worksheet titled "January" it changes all 12 sheets A10 cell value to January instead of each sheet with it's own name. BTW, ur right about the hitting the wall thing. I hit the dirt...

Oops! Don't try this if the sheets are grouped though... __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Schweeeeet! Thanks guys! I was going the VB route and hitting a wall. __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Hi there, I have several worksheets in my Excel file and would like to know how I can do something like the &[TAB] function that is available in the Custom header/footer area and put that value in one of the cells in the worksheet. Thanks! __~o `\<, (_)/(_) MTBChick...

Dang! That was too easy (and Fast) Thanks so much! C __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

I have a form that has a list box that displays items based on it's id in the database. It has been working for several years, but today, decided to give me this error. I am over 45000 id's. (Just added a ton of new products.) Could this be the problem? Here's where it's balking With rs...

If you need to calculate on your table, have you thought about an append query? __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.

Are these columns static or do you need to calculate for several rows? __~o `\<, (_)/(_) MTBChick The day you stop riding is the day you die.