Search results for query: *

I am working in Access using VBA to processes spreadsheet lines. I copy failed lines to a second spreadsheet to re turn to the user. It is working using a range of cells and pastespecial to the second excel file. However, I can't get the column width to go from the original to the second...

I got a new version of Toad version 9.1, and since then I cannot connect to my Oracle databases and get the message -TNS could not resolve service name. I am using the same TNSNAMES.ORA which worked before, and it is in the right location i believe ( becos i can select the database read from...

Hello, I am familiar with SQL and VB, but am new to Access. I need to update a column in a table based on a heirarchy of other field values in that same table. I can't find a syntax that works using a SQL query in Access. I have tried IIF, but it only gives me one true, false--and I need...

I am new to Access although I have used Oracle and Sybase. I need to use it to import a text file containing a list of IDs with some other descriptive information. The text file will have about 800,000 rows. The import will be to a shared network drive tuned for database performance. Can anyone...

Good Afternoon, I need some help understanding buld collections and their use in a forall statement. I want to update multiple rows in a table based on the results set of a query (cursor). A simplified example of my current statement is shown below. It's been thought several interations as I try...

Hello, I hope someone can help with this --its driving me crazy!! My trusty old machine crashed and I have a new XP professional which is so far a lot less than trusty. I have installed VB6 and a local Oracle database. When I run my VB app, it fails on the opening connectionstring with the...

I would like to export Oracle data from a VB6 program recordset to an Excel file - similary to the way TOAD allows you to save a grid as an .XLS file. Does anyone know an easy way to do this? I'd appreciate any help you can offer. Thanks, Jax

I have a VB6 app connected to an Oracle 9i database. I have several queries which return large recordsets which I would like to save as an .XLS file. Does anyone know of a utility or module I can use to do this? I load the recordset into a flexgrid; can it be saved fromthere. I have experimented...

Hello, I have a table with two indexes one on load_nbr (indexed as shipment_pk which is the primary key) and one on status code (Status_code_indx - non-unique). My query looks for all loads above a certain value where the status code is within a range. I would like the set returned in order of...