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

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

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

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

I'm trying to use a value from a Recordset as part of a string statement. When the code executes, I get the error message, too few parameters. Dim db As Database Dim strSQL As String Dim rsinfo As Recordset Dim slic As String Set db = CurrentDb strSQL =...

I think my previous thread was misleading. I'm using a combo box to feed a criteria field in a query. How do I get the combo box to send a value that gives me all the records in the table? The current choices of &quot;North&quot;, &quot;South&quot;, &quot;East&quot; all return the records...

I'm using the value from a form to populate the selection criteria for a query. When the form returns values like &quot;Central&quot; or &quot;East&quot; there is no problem. But I also have an 'All' option which returns the value &quot;Is Not Null&quot;. This statement works when you...

I am using Microsoft Access 2002 as a front end to conenct to our Oracle Databse through ODBC drivers. When I run a query, I am prompted for the user id and password to access the Oracle Database. Is there any way I can script a response for this info, maybe through a module? I have an...

I am using Microsoft Access 2002 as a front end to conenct to our Oracle Databse through ODBC drivers. When I run a query, I am prompted for the user id and password to access the Oracle Database. Is there any way I can script a response for this info, maybe through a module? I have an...

I am trying to print a specific Excel file from an Access Form Button and am having problems with the VBA Code. Also, I am trying to open a specific Excel file from Acesss. I can do it with Word, but am somehow missing the conversion to excel. Private Sub Open_Word_File_to_Print_Click() On...