Search results for query: *

Configuring an OLE DB Command, need to update each record with a value returned from a stored proc. The stored proc requires an output variable to store the result from the stored proc. I then want to update the record with the returned value and write the record to a new destination. I have...

Thanks. I may also pursue writing the column labels and data to a table and sort them somehow. I will also need to create a dynamic. The dates are always monthly. I am displaying the data in a form. The number of months to display is dynamic, but in most cases, the number will be the same. It...

In the help for the crosstab column headings properties, it is looking for the name of the column. In my case, the names are actual dates that can change for each customer id. How do I reference and sort the column names in the ColumnHeadings property?

Works Great!!! I am now trying to get the invoice date columns to display in descending order left to right. Tried an order by clause in both the union and cross tab qeuries with no success. Any ideas?

Thanks! I will give it a try.

worked with the crosstab query, no luck so far. Here is some additional info; Data colums in the table are as follows; CustId InvoicePeriod Balance CAP BilledAmt 111 10/1/2009 1.00 1.00 1.00 111 9/1/2009 2.00 2.00 2.00 111 8/1/2009 3.00 3.00 3.00 111 7/1/2009 4.00 400.00 400.00 I...

how can I use a select query to display a row vertically?

TRIED A PIVOT TABLE, BUT ADDS TOTALS AND DISPLAYS THE COLUMNS HORIZONTALLY. IN ESSENCE, i WANT THE ROWS TO BE VERTICAL INSTEAD OF HORIZONTAL.

My company uses ZixSelect to encrypt e-mails. In my VBA code, I am creating and sending e-mails that I want to encrypt. From within the code, I want to press the "ZixSelect" button that appears in an add in menu bar of the Outlook application.

Thanks. That is what I thought, but had to ask.

Has anyone converted class modules they may have written in an ACCESS .mda library to vb .net?

Just an idea: try increasing the ODBC buffer size to 32768. I ran into a crashing situation in the past with large databases during a data conversion project. We had not upgraded from 97 to 2003.

Thanks FancyPrairie!! By following the steps outlined, I was able to instantiate the object. Now I can use "pseudo-OO" development! It is interesting that the createable and exposed attributes can only be seen/changed when you export the class.

I have created several modules in an MDA library that work great. I am in the process of replacing the modules with class modules. In the calling app, the newly created class does not show up in the objects browser, only the original modules. I tried readding the reference to the library...

Thanks Wayne, I will give it a try !!!!

Is there a way to prevent Access from automatically saving a record when the form is closed? When the form is initially opened, I am placing the user at a new record; DoCmd.GoToRecord , , acNewRec. When exiting the form, I am prompting the user via a msgbox asking if they...

I figured out the problem by playing with the form properties, but I will provide details also; Running Access 97 sr-2. The two forms are for two different tables in the same DB. Each table contains multiple records. No sort order is specified on either form. On the form where the buttons...

I created two forms that use the find, previous, and next command buttons via the wizard. In one form, the buttons work as expected, finding a record and allowing navigation through all the records using the previous and next. In the other form, the find, previous and next only work on the...