Search results for query: *

When this view is run, all of the discrepancies written the previous month are displayed. I've got the last day of the previous month, but I can't get the first day. Any help would be appreciated. A criteria example: Between 10/1/2006 and 10/31/2006 So far I have: Between 10/1/2006 and...

I have a select box that is populated using 2 queries, each from different tables. They both pass pkey for value. Based on which table's value is selected, determines another setting when an update takes place. I may have a pkey value of 8 for a department and a pkey value of 8 for an...

I am using Access 2003 SP1. Table1 has a description field. Table2 is a lookup table that has airport codes. I want to loop through Table1's description field looking for any reference to each airport code. Can I do this with an Access query?

Does anyone know where I can find a list of reserved words for ColdFusion MX?

I am using ColdFusion MX. I edit code and save. Refresh page everything is fine. The next time I go back in to the same code, the changeds I made have reverted back to the original version. If I make an edit unrelated to the first edit and save, I lose the first edit. I am using SourceSafe...

I am using DTS to export data from SQL to Excel. I have a large text field that is being truncated at 255 characters. When I look at the Destination field size for the package, I see that the Data Type for all the fields is VarChar and the size is 255. How can I change this so the text is not...

I understand that there is suppose to be a Sounds Library under Windows - Other Panels - Common Libraries. My installation of Flash does not have a Sounds Library. Do I need to reinstall?

I have upgraded to Office 2003 from Office 2000. I have an Outlook form, which is a vacation request used company wide. The user opens the form, fills in vacation info then clicks send. The e-mail then sits in the Outbox. Normally, this would have been sent to the user's supervisor. Is...

I am getting ready to look at Access 2003. We are currently using Access 2000. In previous upgrades I have had to do a considerable amount of work to convert my secured database to the latest version. Can someone point me in a direction for good information about Access 2003, specifically...

I have an application that sends mail to a manager everytime the status of an issue discrepancy changes to 'Ready for Recheck'. The manager is reporting that the mail is not always getting sent. I can not duplicate the problem. I checked the mail log in CFusion/Log/mail.log and found that no...

I have 10 DTS packages that I want to execute sequentially. Originally, there was one package, but it kept pulling errors during execution. Can I create a Stored Procedure that will execute all 10 packages sequentially?

I am trying to set up a DTS package that will import Access data into a SQL table. I create a SQL Provider. I create a Microsoft Access link. I add Transform data between the two. When I right click on Transform data and choose Properties I get the following error: mmc.exe Application Error...

I have 30 Excel spreadsheets that I am merging into a SQL table. I first truncate the table than copy each spreadsheet to the table. I keep getting the following error: "The connection is currently being used by a task. The connection can not be closed or reused" Each time I...

I have a shipping application using an Access front end and a SQL 7.0 back end. I would like to use CFHTTP to track the package sent by UPS, FedEx and Airborne. I have successfully connected to each carrier's tracking page. Now I would like to initiate the tracking from the Access Shpping...

I am using SQL Server 7 on a Windows 2000 server. The Transaction Log backup seems to hang. The Transaction log backup is scheduled every 15 minutes. It usually takes less than 3 minutes. Status reads: "Executing Job Step '1(Step 1)'". There are no errors in any of the logs. The...

I have a lookup table that contains file names. A # sign is included in some of the file names. In the following code #sow_file_name# should bring up a word document called 8532sow(Encore#2).doc. <cfoutput query=&quot;get_sow&quot;><a...

I have a department that is trying to create a spreadsheet that includes names that have been given to drawings that include the @ symbol. Everytime they type 8530@backpanel, it is seen as a link. They want it to be displayed as text only. The cell is formated as text. I have looked in Word...

We have installed VSS 6.0 on a Windows 2000 Server. When we go to run VSS Administrator and the log in window comes up, Admin is in the Username box, the password is blank, and Common is in the Database box. According to directions I have read, initially there is no password. If I click the...

I am not getting the results that I expect from the following code. There are several records where the sub_title field appears to be null but show up in the result set for a query that is testing for the sub_title field not null. Any idea why this is happening? <cfquery...

This is a problem in all of my ColdFusion apps. Example: I use CFMAIL to send users an e-mail when they are assigned DRs (Discrepancy Requests). There seems to be an 8 hour difference in when I send the message to the time displayed in the user's e-mail message. The time and the time zone...