Search results for query: *

This request seems simple, but its killing me. A normal query returs the information as listed below. I would like the result set to be formatted like the bottom example. If I pick a singe column (DelVol for example) I can use a crosstab query to show in the bottom format, but I can't find a...

Why don't you use a DTS Package to copy the data into SQL Server, then you can schedule the package to run nightly. Look in the Data Transormation Services Folder in SQL to create the package, then look in the Management Folder for SQL Server Agent to create a job that will execute the package...

If I'm understanding your question correctly, the query can and is rerun after each update. IE the user pulls a date, the list box shows it, the user then pulls another date and the list box now shows both dates. The old design I had in place was to have the user click a button which ran the...

I am using a form where the user can hit a button to retrieve information for a date and a different button to delete all dates. I have list box on the form which lists the results of a query showing the dates that have been retrieved. After the user pulls a new date I do me.refresh which...

Thank you VERY MUCH. It's always the little things!! I read several tutorial trying to set it up correctly. Thanks again, Ron

I'm trying to use a session variable to capture the userid from my Login page. I've enabled sessionmanagement on the application.cfm page and created a varaible called <CfSet Session.userloginname = &quot;Default&quot;> On the login page I have: <cfif...

Thanks for the comment, I have made sure to save the files before and after any changes. In regards to the pivot table, don't think it will solve my problem, but thanks again for the suggestion.

Here's a Strange One . . . I'm exporting a data table out of Microsoft Access into an Excel file using the TransferSpreadsheet function. There is no problems with this export. Once the data comes into the Spreadsheet, I can perform &quot;Sum&quot; and other basic functions without a problem...

I am using a DLookup function to check for a date in a table. I have set up this simple if-then statement to execute based on the results (I'll build a more complex if-then later). The problem is that the DLookUp never seems to equal null so I always get the message &quot;Date Found&quot...

I have an excel sheet where users will enter numbers on one worksheet and the values are linked to another. Establishing the link from one cell to another is not a problem, I did a copy, paste special, paste link. My question is can you mimic the format of the original cell. So if it is...

I have a Procedure event which calls other sub events. One to FTP a file, one to unzip a file, one to append the unzipped files to external tables. These three sub procedures (FTP,Unzip,Append) are called inside of a loop which steps through a record set. Once the loop is finished 25 files...

I am appending data to an external linked table, in dBase IV format. My problem is that the size of the appended table is 10 to 12 times larger that the orginal dataset. The tables are quite large, ex. 172MB table when the original size was 15MB. The tables are empty before I append them, and...

I'm having the same problem, any new knowledge out there on how to fix this? All help would be appreciated. Ron

Solved the problem, I needed to put #'s around the date. sqlString = &quot;INSERT INTO mCBX (DEL_DATE, SLIC ) SELECT #&quot; & currentDate & &quot;# AS [DEL_DATE], &quot; & currentSlic & &quot; as [SLIC], CBX.* FROM CBX;&quot;

I am trying to append a date into a table, however, when I look at the table it only has 12:00AM for field values. I can look at the value of the variable I'm passing &quot;currentDate&quot; through a message box and it shows up fine &quot;11/14/02.&quot; The table field I'm appending is a...

I am trying to use the following SQL statement to create a table. All fields are fine, except for the BOOLEAN type. Everytime I try to add these fields I get an error. I must be defining the boolean field incorrectly, but I can't find any &quot;correct&quot; examples. Any help would be...

Thanks Snaggs your suggestion worked great. Private WithEvents m_cUnzip As cUnzip Set m_cUnzip = New cUnzip Dim sFIle as String ' Set the zip file: sFIle = &quot;D:\Data\021024.zip&quot; m_cUnzip.ZipFile = sFIle ' Set the base folder to unzip to: 'sFolder =...

If there any sample code or better explantions of the methods for InfoLib Unzip? I can't follow the sample project very well, in following the simple example on the website: ' Set the zip file: m_cUnzip.ZipFile = sFIle ' Set the base folder to unzip to: 'sFolder =...

Well, I was, kinda. You statement worked great, so thank you. Now my problem is that I have exceeded 2GB for my database, not exactly sure why, but it has corrupted my database. Also, when the database is completely built, it will probably hold 3GB of data, apparently too large for Access...

Thanks for all your help. Ron