Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: turil
  • Order by date
  1. turil

    connect VBA to mainframe datasets

    Hi GhostWolf, This is just awsome! I will try to understand and implement the code you gave me. Might be back with some more questions if i can't figure it out on my own. I really apreciate this, i can't thank you enough!!! Regards
  2. turil

    connect VBA to mainframe datasets

    Thank you very much, lameid, I will try to post this question to a mainframe related forum as well. Regards Teresa
  3. turil

    connect VBA to mainframe datasets

    Thank you for your reply Lameid, I am able to download the datasets from the mainframe in txt or binary format on the server, and I wrote some code in a vba module to read them in MS Access. I am looking however for a way to directly connect to the files on the mainframe, better yet ftp them in...
  4. turil

    connect VBA to mainframe datasets

    Hi, Thank you in advance for all the information you can give me on this. I would like to know if there is a way to download datasets from the mainframe to tables in MS access-(by writing some VBA code possibly). I know my PC has ODBC and I'm not sure if I have OLE DB. The files that I want to...
  5. turil

    Query to find unique account

    Hi Duane, Yes it should be ignored, I listed it under Access Queries and JET SQL as well, could not decide which forum is more apropriate. Is there a way to close it? Thanks, Theresa
  6. turil

    Query to find unique account

    Thank you very much PH, I did other 2 left joins on the unmatched query and got the result. Thanks again! Theresa
  7. turil

    Query to find unique account

    Great!!! Thank you very much. I have one more question related to this one. Between 2 tables with different number of accounts for example Table1 has 100 accounts, Table2 has 50, how do i write a SQL statemnt to get the 50 accounts that belong to table 1 and not to table 2 (having in mind that...
  8. turil

    Query to find unique account

    Hello, I have a data base and i need to identify how manny different accounts it contains. A account is formed by a distinct combination of Group, Div, Policy - found on differnt colums and of a text format. for instance i could have: Account Group Div Policy acct1= 79213 001...
  9. turil

    Query to find unique account

    Hello, I have a data base and i need to identify how manny different accounts it contains. A account is formed by a distinct combination of Group, Div, Policy - found on differnt colums and of a text format. for instance i could have: Account Group Div Policy acct1= 79213 001...

Part and Inventory Search

Back
Top