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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.