Search results for query: *

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

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

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

I have a table with user defined data, i.e. company name, address... Can I use Dlookup to output more than one varialbe? I want to output: City, State ZIP. I am considering this option so that it will format correctly on the report without unecessary space or overlaps and the user can edit the...

I've never used VB, but I am familiar with ColdFusion and comforatble with Access and query building. Will I be able to learn VB? What I want is to create a program that I can distribute to others. It will manage a lot of data through data entry fields and perform calcualtions. Reports will...

I recently installed Win 2000 prof. Most seems OK. Every noew and then it will just freeze for about 10 seconds. This happens evry 10 minutes or so and it doesn't appear related to anything in particluar. This didn't happen with Win 98. Has anyone else experienced this? _____________ Cliff

I am currently using Windows 2000 Professional. Is there a benefit to upgrading to XP? It looks like both 2000 and XP are built on NT technology (not that that it means anything to me P-) ) If so, do I need professional or can I use the home version, I am not running a business on it. I heard...

Hi, This is my first try at displaying crosstab results. I'm almost done. I have the columns and rows properly labeled and displayed. Now I just need to fill the cells with the data. The last part with the ## near the end is where I will display the value. It sould be a count of SpecPK, but...

We recently upgraded to Outlook 2000 from 97. This is a much nicer tool. When viewing the calender in 97 you could right-click on an appointment and uncheck the reminder notice. I don't see that in 2000. Can it be turned back on? Thanks! _____________ Cliff

My Page x of y seems &quot;broken&quot; in Word. All I can get is Page 1 of 1 Page 2 of 2 Page 3 of 3, and not Page 1 of 3 Page 2 of 3 Page 3 of 3. Any tips? _____________ Cliff

I have a table in Access 2000 that I imported from a text file. The original text file was delimited with the &quot;|&quot; symbol for several reasons. One of them is that the comma was used as a character in some of the fields. Now my challenge is to seperate some of the comma sepertated...

I have a text box in a form that is loaded with the value stored in a database. The default value is &quot;Not Read&quot;. Is there a way for this text to clear from the text box when the user simply clicks in the box? _____________ Cliff

I have two tables. The first table has many records - about 17,000 and is called bbdd. The second table (DupCheck) is related to the first and contains records that have been compared to records in the first table and found not to be the same. What I want to do is look for duplicate records...

Hi All, This is my first post. I have a database that stores &quot;events&quot;. These events have related pdf files stored in a seperate folder on the same drive. I'm lokking to do two things. 1. How do I dsiplay the file name on a form, if there is one? I don't want to manually enter...

Anyone know of a Javascript development program that has source line debugging? Preferably, shareware or freeware? ------------Christian