Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fergman

    VBA clock on msaccess

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

    VBA clock on msaccess

    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()...
  3. fergman

    IE, ff rendering issues

    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.
  4. fergman

    IE, ff rendering issues

    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...
  5. fergman

    Stumped on date conversions

    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!
  6. fergman

    Stumped on date conversions

    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...
  7. fergman

    Why doesn't this formula work?

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

    Why doesn't this formula work?

    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...
  9. fergman

    Why doesn't this formula work?

    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...
  10. fergman

    Why doesn't this formula work?

    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...
  11. fergman

    Running total or formula variation.

    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.
  12. fergman

    Running total or formula variation.

    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)...
  13. fergman

    Suppress or don't query some records that are similar

    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 <-...
  14. fergman

    Suppress or don't query some records that are similar

    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...
  15. fergman

    session.timeout isn't working

    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?
  16. fergman

    session.timeout isn't working

    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...
  17. fergman

    session.timeout isn't working

    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...
  18. fergman

    converting html text to float

    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)
  19. fergman

    Pages are expiring to often...

    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...
  20. fergman

    concatinating an SQL statement

    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.

Part and Inventory Search

Back
Top