Recent content by CTR

Thank you! _____________ Cliff

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

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

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

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

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

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

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

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

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

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

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

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

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

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