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!

  • Congratulations Chris Miller 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. CFrockchelle

    Case Statement Syntax

    I think I figured it out. . . I used the following in my control source: =IIf([DaysOverDue]<=0,"On Schedule",IIf([DaysOverDue]>0,[DaysOverDue],"In Progress")) Thanks for all your help.
  2. CFrockchelle

    Case Statement Syntax

    The report displays the actual value of Days Over Due if the value is greater than 0 which is what I want. But if the value is less than zero it displays On Schedule,On Schedule,In Progress. I just copied and pasted what you had into the format property. I have some values that are null...
  3. CFrockchelle

    Case Statement Syntax

    I couldn't get what you suggested to work. Not sure what I did wrong. I have the days over due already calculated in a query. I used that as my control source and for the Format property I put in what you suggested and when the report is ran I get - On Schedule,On Schedule,In Progress. In...
  4. CFrockchelle

    Case Statement Syntax

    I'm not actually sure how to write case statement in Access. I have a report that has a scheduled completion date, completed date, and days over due. The days over due is the difference between the scheduled completion date and the actual complete date. On my report I want to display the...
  5. CFrockchelle

    Query Help with Max function

    Ok Heres the situtation. I need to show a list of customers who have a invoice date that is 2 years or older or they have a last ship date that is 2 years or older. I'm using the max function on the last date ship since there are several shipping dates and I need to get the lastest ship date...
  6. CFrockchelle

    Login for multiple applications

    Both of the application.cfm are now named the same and everything works fine within the same addressing such as secure.name.com/app1 then automatically logging into secure.name.com/app2 however,when I test the program like how the customers access sites with 2 different domains such as...
  7. CFrockchelle

    Login for multiple applications

    By the way both applications have their own application.cfm file with sessionmanagement = &quot;yes&quot;. I'm not sure if this helps with whatever information you may have. I really new to CF and going through lots of books but I can't seem to find anything for this type of situation.
  8. CFrockchelle

    Login for multiple applications

    Is it possible to have a user to login only once for one application and then pass their user name and password to another different application? I have an application where a few users use the same login and password for a totally different applciation (both apps reside on the same server) and...
  9. CFrockchelle

    Passing Query Data to Forms

    Never mind I figured it out. Thanks anyway... I'm new at CF so please bear with me :)
  10. CFrockchelle

    Passing Query Data to Forms

    Is it possible to pass data from a query result in one template to a form in another template so if a user clicks on link to another page, the form is already populated with information. If this is possible how? Would you use <CfHTTP> and <CFHTTPPARAM> to do this? Thanks for any help that you...
  11. CFrockchelle

    Repeat headings in table for printout

    I have a query that is displayed in a table. The table is very long. Is there anyway that the table headings can be repeated on everypage that is printed?

Part and Inventory Search

Back
Top