Search results

Hello all, hope that you are having a Great Day! I hopeing that someone could help me with a Loop problem. I am trying to create a directory on each name change. My code works for the first name, however, when I am trying to Loop through the table, it isn't working. Here is my code 'MkDir...

Thanks Dennisk, I was able to use the append method that you suggested and kill sheet 2. Thanks alot for your help!

I have the following code that is working fine, in the immediate window. How can I get this infomation (copy) into my other text document. Here is the code I have thus far. Dim TextLine Dim PRI As String Dim PRD As String PRI = "\\wil-tdv01\trp\ma\Privacy.txt" PRD =...

I have tried using the Open method but I am not able to export anything. Am I supposed to use the transfertext method in addition to the Open method? I am stumped at this point because I want to combine the 2 Specification names for my fixed width text files so that they will be one file...

Great idea! Thanks.

Hello All, I have 2 reports that are exporting to 2 different .txt files. Currenlty, I am using the transfertext function in access. What is the best way to combine these 2 reports into one .txt file? I have 2 different specification criteria being used, but I need all the data in 1 report...

I know that I can do this by exporting through Access delimiter encapulation, but how can this be accomplished through code?

I am trying to line up the columns in my table for output to another external system. I will be exporting this file as a .txt file, but the information needs to be in a specific format so that the other external system can read it from the .txt file. The format would be like this: First Name...

I am actually trying to line up the data to show the following: First Name Last Name Address Everything would need to line up under the appropriate column not matter how many characters are used. I hope that I am saying this right. Thanks for your help.

I have a query that I am trying to export to a text document. My question is how can I get the data to show up in tab delimited?

Paul, that's what I have done with the combo box. Will it still work with a list box with multiple items selected. Thanks again for all your help.

Is there a way to relink multiple tables instead of one at a time? I created a list box (works well with a combo box)that is querying Mysys objects; I would like to be able to select more than one table at a time to relink and refresh. The code above works like a charm doing 1 at a time. I was...

That worked Paul...........thanks alot.

Ahh, looks like it is working now.........I am getting an ODBC error, but that is probably due to my connection string.........I will research further.......thanks for your help. Thanks to everyone.

Ahh, looks like it is working now.....I am getting an ODBC--connection to test failed........this is probably due to my ODBC connection string....I will research further... Thanks alot to everyone to has helped.

pbaldy, thanks for your reply, I didn't see yours when I replied...........Could you provide an example. Thanks again.

Thanks Wyan and Bob for all your help; I am now receiving the following error on the following tdf.Connect = ChangeODBC tdf.RefreshLink I am getting a Run-Time error '3420'; Object invalid or no longer set. Any ideas? Thanks again.

Thanks for your reply Wayne. I tried your code, but I am getting an error message stating that the Object variable or With Block variable not set; this is referring to the tdf.refresh link code.

I have tried the following without any success. I am trying to connect to a cache database using an ODBC connection. The following code is being used: Dim ChangeODBC As String ChangeODBC = "ODBC;DSN=Cache Database;server=Test;port=1792;database=test" CurrentDb.TableDefs("tblimport") =...

I tried looking for this without any success. Any other suggestions? Thanks again for your help.