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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CTR

  1. CTR

    ColdFusion Administrator - Secure DNS

    Thank you! _____________ Cliff
  2. CTR

    ColdFusion Administrator - Secure DNS

    We have a webserver connected to an old database. The old database server is end of life. When we set that up we did not need a secure connection. Now we have a new database on a new database server. Our IT department is requiring this to be a secure connection (even though it's an...
    • CTR
    • Thread
    • Replies: 2
    • Forum: Adobe
  3. CTR

    Show / Hide Form Button

    I have a form that I want to act somewhat like a Switchboard. If a user has records they need to audit, I want a button to show that they can click on to display the records. If they don't have any records to audit, I want it to say that in text instead. The way i tried to solve it was with an...
  4. CTR

    Further define CFSEARCH

    Posted - 09/22/2005 : 16:25:54 -------------------------------------------------------------------------------- I am using this: <CFSEARCH name = "GetResults" collection = "blooper" criteria = "#Form.Criteria#" maxRows = "#Evaluate(Form.MaxRows + 1)#" startRow =...
    • CTR
    • Thread
    • Replies: 1
    • Forum: Adobe
  5. CTR

    Border around Report?

    This sounds like a terrific option. I tried it with Access 2000. Is it specific to a version of Access? _____________ Cliff
  6. CTR

    Conditional subreport

    I have a final report that has 5 subreports on it. I want to suppress one of the subreports based on it's value. The fianl report is "Donor Summary Report". If the value of the subreport "Donor loss 56 query" is less than 200 I want it to have some default text instead, say "Not required"...
  7. CTR

    Org Chart- Sharing Managers

    I am looking for the answer to this too, so if I post here the message will be brought back to the top. Hpefully someone has an answer?? :) _____________ Cliff
  8. CTR

    Soundex

    Hmm, no way to edit posts here? Anyway, I saved it as a module named Sndx2. I removed the word &quot;Public&quot;. Then I used it in a query like you listed above and got the error message of &quot;Undefined function in &quot;Sndx2&quot; expression&quot;. Any tips? _____________ Cliff
  9. CTR

    Soundex

    Michael, If you are willing to provide a bit more guidance I'd truly appreciate it. This is not for a mailing list. I am with a non-profit hospital that has a blood collection program. We have a very old and soon to be replaced computer system that is run on a cache database. The programs...
  10. CTR

    Soundex

    Hi Michael, Thanks for the response. Now let's pretend I don't really know what to do with this (OK, maye I'm not pretending). What I'd like it to do for me is convert all of the first names into one soundex key, then all of the last names into a separate soundex key. I will then run a...
  11. CTR

    Access Security??

    I plan to create an Access 2000 database to use over a network. The forms will be simple and the datapoints collected equally simple, but what I need to do is prevent the end user from having the ability to either access or edit the structure of the database, or edit the raw data in the tables...
  12. CTR

    SessionTimeout

    What is the server timeout set at? This will override any session timeouts you set. _____________ Cliff
  13. CTR

    Duplicate records

    I know I can search for duplicate records in Access, and I am aware of the so-so query that exists. Here is my dilema. I am trying to ensure that duplicate names do not exist in a seperate database (seperate from Access, it's an old database that does not have a lot of access to it). I have...
  14. CTR

    Soundex

    I know SQL has a Soundex function, but is it possible in Access 2000? Is anyone aware of a good add-on for Access? _____________ Cliff
  15. CTR

    Two variables output in Dlookup

    OK, how about an IIf with a Dlookup? There is a subreport on the report that has a calcualted value. If it is above a certain limit a statement prints: =IIf([Donor Plasma Loss Query].[Report]![plasma]>=12001,&quot;blah blah blah.&quot;,&quot;&quot;) Can I put a Dollokup in the true part of...
See more

Part and Inventory Search

Back
Top