Search results for query: *

Hello, I have a windows folder with many csv files. Now I would like to import all these csv files into sql in vba apply some logic and spit out one consolidated file. WHat I would like to know how can I write code to go into the folder and loop around all the files in order to make the file...

Hello, I have multiple csv files. These files need to be updated based on data contained in another csv file which is used as a reference. All records containing a key in the csv files that is not in the reference file should be removed. All records containing a key that is in the reference...

Hello, I am trying to setup a two windows 2000 adavanced server machines. For the purpose of clustering. IS there a workaround so that I can instead of using shared SCSI disks use non-scsi disks. I am trying to simulate a clustering environment. Thanks.

Hello, I have an Oracle 7.3.4 instance and an Oracle 8.1.7.4 one. Each sit on its own server. I was wondering how to make data flow from one place to another? The problem that I can see is that I cannot have odbc for Oracle 7 client and 8 client installed on the same machine so if I write a...

Hello, I have a sub that loops around a number of records displayed by a form. In side that code anything I put after the loop does not get executed. Any hints? In my example below I want after the loop is finished to go back to the original position the form was at when the user called the...

Hello, I have a bound form to a linked table. The table has got several rows. As part of each row structure there is a checkbox. I would like to know how to select specific records from the form based on certain criteria? It seems like I need to loop around something. Can u please tell me...

Hello, I have a radio button in a contiuous form. It is used to accept or refuse a record which is represented in a form. Now I want to provide the user with a button that when clicked it will seleteced mutliple records. Obviously I need to loop around my radio button control and based on a...

Hello, I am recreating my external links by dropping them and then recreating them and finally refreshing. Now when asked to log on I am presented with the "Select data source" dialog box despite the fact I have specfied my dsn already in my connect statement see below : tdfLinked.Connect =...

Hello, I have an external odbc link from vba to oracle 7. The problem I am having when running my aplication the link is not refreshing properly. So I decided to drop and recreate the external link every time I load the application. I know how to drop create a tabledef but not an external...

Hello I have written a query for Oracle 7. It should get max date and group by two fields. Now Based on the max I would like also the query to return the remaining fields for each row returned meeting that criteria. The query is below but it is too long. You will notice the select max part of it...

Hello, I have a bound form to a linked oracle table in Access. Now when I open it I am asked to connect via odbc using my oracle account. I would like to know how to capture this userid in VBA. Thanks.

Good morning, I have a linked table inside my mdb, using an odbc driver that links to my Oracle 8 server. Now when I try to programatically connect to my linked table I get the error "ODBC - Connection to test Failed" despite the fact my odbc driver is properly configured and when I manually...

Hello, I was wondering how can I make my forms that are bound to linked tables not ask about a user logon to the database via odbc. I want to give control to a switchboard that has a logon main screen that loads the forms and ask for one logon instead. Thanks.

Hello, I was wondering how can I make my forms that are bound to linked tables not ask about a user logon to the database via odbc. I want to give control to a switchboard that has a logon main screen that loads the forms and ask for one logon instead. Thanks.

Hello, I have built an application in VBA which uses ADO to connect to Oracle. This application has a main logon screen to the Oracle database, which validates against oracle users. Now I have a form that is bound to a table which is linked to the oracle database. My problem is it asks again...

Hello, I have a continuous form in VBA whose source is a linked table in Oracle. Now the form reads multiple records. In each record there is radio button control. Based on the user input he clicks on the radio button for some of the records. My problem is when he clicks on a radio button, the...

Hello, I have a select statement which reads from a table. In the table there is flag. Based on the flag I decide what action to take. Basically I need to test if the flag is X then bring all its records else if the flag is Y then test for another additional flag which should be equal to 100...

Hello, I am using the following statement and running into problems. The message I am getting is "sequence number not allowed here". Kindly advise as how to write it. See below. select a.orion_tank, b.OrionCrude, a.prop_modified_value, a.DayInserted, SEQ5_CRDINV.nextval, sysdate, user from...

Hello, I have a function by the name isnum. I need to reference it from another schema here is the syntax select * from y where isnum(x) = 0 I am getting an invalid column name when running it. I prefixed the schema name to the function name no same problem. If I run my query under the same...

Hello, I have a varchar2 field that has values that are sometimes not numeric. However, I am only interested in numeric values since there are records that have numeric values in that field. SO I would like to test that field values and only return the numeric values. I was wondering what...