Search results for query: *

Guys, you are awesome thanks, my mistake it was on one of the controls, I moved it to the form and it works perfectly.

I am attempting to add a clock to an access form, mainly following this thread: http://www.tek-tips.com/viewthread.cfm?qid=1282461 When I compile the module I get this error: Compile Error: Invalid use of Me keyword Here is the code that I am using: Private Sub Form_Timer()...

Thanks, I figured out what I was doing wrong. So feel free to ignore this post. In short I didn't know what I was doing with the background container.

Let me start by saying I am new to CSS and not good at it yet. So feel free to tell me if there is a better way to do this. I have two CSS problems. 1. I'm trying to put a background in the center of the browser window at the top, and stay there when the user resizes their browser. Problem, IE7...

Thanks to both of you, I had suspected the date was being an issue, but hadn't yet stripped it off. The varchar convert with the 120 style also made sure it stayed in the right format. I could have sworn I tried ,120 style last night but maybe I didn't. I appreciate the help!

I thought this was simple, but my query yields a datetime value in 12 hour format and I can not get it to convert to 24hour (and I do need it in 24 hour). The query below has three commented sections, and I denoted the steps, originally it is 24 hr, I convert it to float, average it convert it...

lbass, you know, I think it was so simple I just didn't think about it, but that worked! lol thanks!

Here is a sample entry, county is a group, and primary lev of care is a group, sorry about the alignment, but I can't seem to get the preview to display it properly. County: CountyName Primary Level of Care: HOSP AGE # % T% $ 0-17: 1 1.64 0.12 1,762.00 18-29: 2 76.04 5.39 81,445.06 30-44: 1...

My bad, sorry was getting frustrated... crystal 10, this is a filedb connection to access. I have a catalog of codes such as the 99000 to 99999 that I origionally had in a nice case statement, but now it is necessary to know if it is HOSP or OP or RES then add the billed amount to the end...

So when I run this I get the "the remaining text doesn't appear to be part of this formula" error. What I want to do is output text for a bunch of procedure codes, that's the HOSP part, but if it is HOSP I want to dump the billed amount into a global variable to report on it at the end...

I actually just came up with a way to solve this. Using a running total and the formula field built into it instead of a manual running total. it seems to be doing most everything I need. Thanks for the response.

This is one of those things I've spent to much time on and still can't solve, so here goes: I have an age field, calculated using this formula: WhileReadingRecords; DateTimeVar Birth := {Abha7105_93005.MceHdr_BirthDate}; DateVar CurDate := CurrentDate; If (Month(CurDate)*100) + Day(CurDate)...

I'm sorry, my bad.... I want to see the 12/31/9999 only when the other row exists. For example, I want to see: subscname subscid effdate termdate Jane Doe 1112222 1/1/2006 1/1/2006 Jane Doe 1112222 2/1/2006 12/31/9999 <- Want to see Janet Doe 1112233 2/2/2006 12/31/9999 <-...

Hey all, I have a report that I'm trying to suppress some data, but here's the problem. I will have a subscriberName, a SubscriberID an EFFDate and a TermDate. The subsc will have 2 records sometimes, one that says effdate is 01/01/2006 and term date is 01/01/2006 and the following row shows...

heehehhe that would be great, but I'm on a shared hosting and I dont' have access to the server, any chance someone can just give me a decent idea of what the global.asa ought to look like?

I have actually tried to set my session timeout, and my gloabal.asa file does have a couple lines that say: Application("tempdb_ConnectionTimeout") = 60 Application("tempdb_CommandTimeout") = 65 and they are under Sub Application_OnStart I guess I didn't explain properly. I have tried to...

I have a strange problem with session.timeout, no matter what I set it to, no matter which page I set it on, it doesn't seem to work. it also isn't defaulted to 20 minutes, it's more like 12 minutes. I have in order to try to get it working, have set it at the point of login, the commonly used...

it is also possible to use cint (type coeresion) it isn't really an int variable but it should work for your purposes. if memory serves it is just cint(variable)

I am having page expiration problems. I am unsure of several things. One, the session.timeout value, do I need to set that on every page accessed if I want it to be something other than the default? and If I do not, then why do all my pages expire so quickly. and Is it at all possible to...

hmmm, Is that the only option, I'm not familar with that type of function. And I don't have access to the server, it's a shared host.