Recent content by mozgheib

Here is the code I wrote. Now to turn my select into a (select into) instead obviously I will need to create a connection to my sequel server and reference a sequel server table name next to into. To do so I was wondering what should the code look like below? Private Sub Button1_Click(ByVal...

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

Thanks to all very much.

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

Thanks for your reply. I went to their website but it looks like a complete solution. Is it possible that I can find a little tool which will emulate a scsi driver and can be installed on windows 2000 advanced server. thx.

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.

Correct me if I am wrong the Oracle client should always be the same version as the server or more recent meaning oracle client 7 cannot talk to oracle server 8 but Oracle client 8 can talk to server 7 and 8? Thanls.

Thanks for your reply. If I were doing this programatically. For instance I have created a VBA module in access and I am using ODBC to connect to both Oracle servers. The module in the mdb file is sitting on a seperate server. Now to use the odbc drivers I will need to use the ones provided by...

to create a dblink you need an oracle host string created. To create a host string you need oracle client installed. So to connect to Oracle 7 I will need oracle 7 client and to 8 I will need oracle 8 client. I do not think oracle 7 and 8 clients can co-exist.

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

Hi, As a matter of fact I copied the code wrong. The lastposition assignment is happening inside the loop. Now I can't trace the code in design mode I get error 2499 can't use goto method on an object in design mode. I get the error when it hits the goto first record. my code looks now like...

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

The records need to be selected as a first step and as a second step if the user decides to accept the values, these selected fields will update the database and turn a false value to true.

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