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 derfloh 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: *

  1. airwolf09

    2012 MS SQL SERVER MANAGEMENT STUDIO - Read from txt

    I use VBA to read from a txt file. Is the a way to read a txt file in 2012 MS SQL SERVER MANAGEMENT STUDIO query? Thank You
  2. airwolf09

    Creating a CSV file and removing the last comma from each row

    Andrzejek, Thank You for your help. You are right. It works perfect!
  3. airwolf09

    Creating a CSV file and removing the last comma from each row

    Andrzejek, Thank You for your input strCSV = Left(strCSV, Len(strCSV) - 1) Removes all commas, defeating the purpose. I only need the last comma to be removed. With CurrentDb.OpenRecordset("tbl_TEMP_ARCHIVE_ASSETS") 'Dim x As Integer For x = 0 To .Fields.Count - 1 If x <...
  4. airwolf09

    Creating a CSV file and removing the last comma from each row

    Good Afternoon The following code creates a .csv file. The output looks something like this Peter, Pan, 20, Male, Mary, Pan, 20, Female, John, Doe, 40, Male, The problem is the last comma on each row. It should no be there. Or I need to delete it. I can't figure out how to remove the last...
  5. airwolf09

    Delete Column from cvs file via VBA (Access 2010)

    Thanks
  6. airwolf09

    Delete Column from cvs file via VBA (Access 2010)

    Yes, I understand the Excel part but I am not using Excel. I am using Access 2010. I am not trying to open the csv. I am trying to make run the process in the background. I think I figured it out. Here it is what I was able to achieve. Sub Test() 'On Error Resume Next Dim objFSO, dataArray...
  7. airwolf09

    Delete Column from cvs file via VBA (Access 2010)

    Hello. I am trying to figure out why the code below does not produce a new row of data. For example the old.csv shows A B C D E 1 JOE DOE MALE UNF 2 MOE DOE MALE UF 3 FOE DOE FEMALE SPACE_HERE 4 JOE DOE SPACE_HERE CAL But the output to the new.csv looks like...
  8. airwolf09

    ACCESS 2010 SQL Columns to Rows

    Thank You for your reply. I see the relationship. Always a pleasure to have experts like you around.
  9. airwolf09

    ACCESS 2010 SQL Columns to Rows

    Records would be guaranteed. There could be any amount of assets but if a column for grouping is required, the same amount of fields would be available. GrpNum Field1 Field2 3 ITEM 1 3 ASSET 12345 3 MODEL 1234ABC 2 ITEM 2 2...
  10. airwolf09

    ACCESS 2010 SQL Columns to Rows

    Yeah. I had a hard time trying to figure this one. How about using Visual Basic? Is there any hope there?
  11. airwolf09

    ACCESS 2010 SQL Columns to Rows

    Good Afternoon I need some help transposing columns to rows based on ITEM number. I am using SQL but can't seem to figure it out. My qry_Table Field1 Field2 ITEM 1 ASSET 12345 MODEL 1234ABC ITEM 2 ASSET 12346 MODEL A1B2C3 ITEM 3 ASSET 12347 MODEL 1ABC456 My desired results ITEM...
  12. airwolf09

    csv file breaking after numeric characters and special characters

    Thank You. I didn't even realized the variables were not declared. I was scratching my head and it was a simple fix. Have a great day!!!
  13. airwolf09

    csv file breaking after numeric characters and special characters

    1 Joe Doe 1 Main St Downtown Building 2nd Floor Room 13 2 Bruce Wayne 9 Batcave Rd Bat Cave Building 1st Floor Room 1 3 Bruce Lee 1 Karate Way Chinatown Building 3rd Floor Room 5 4 Jet Li 26_Karate_Way Chinatown_Building 4th Floor Room 6 The results would be 1 Joe Doe...
  14. airwolf09

    csv file breaking after numeric characters and special characters

    I have no idea why is breaking up the data on the numeric and special characters. May be the way I am opening the file??? but I am not sure. Thanks for the help.
  15. airwolf09

    csv file breaking after numeric characters and special characters

    Sub FBI_RA_BOOKING() Dim hostSettleTimeout As Integer Dim hostSettleTime As Integer Dim osCurrentScreen As Screen Dim osCurrentTerminal As Terminal Dim returnValue As Integer Dim hiddenTextEntry As String hostSettleTimeout = 5000 hostSettleTime = 300 Set osCurrentTerminal =...
  16. airwolf09

    csv file breaking after numeric characters and special characters

    The plan 1 Access Database creates a csv file 2 Data is read by Reflections 2011 VBA code 3 Data is passed to the mainframe via Reflections 2011 VBA The problem 1 Access Database creates the csv file (NO PROBLEM) 2 Data is read by Reflections 2011 VBA code (PROBLEM) A) If leading numeric...
  17. airwolf09

    csv file breaking after numeric characters and special characters

    The plan 1 Access Database creates a csv file 2 Data is read by Reflections 2011 VBA code 3 Data is passed to the mainframe via Reflections 2011 VBA The problem 1 Access Database creates the csv file (NO PROBLEM) 2 Data is read by Reflections 2011 VBA code (PROBLEM) A) If leading numeric...
  18. airwolf09

    SendKeys &quot;Y&quot; code not working.

    Here is my Module Code. Thanks Sub BATCH_TRANS_OPT9_Loop() Dim hostSettleTimeout As Integer Dim hostSettleTime As Integer Dim osCurrentScreen As Screen Dim osCurrentTerminal As Terminal Dim returnValue As Integer Dim hiddenTextEntry As String hostSettleTimeout = 5000 hostSettleTime = 300 Set...
  19. airwolf09

    SendKeys &quot;Y&quot; code not working.

    I am using Reflections 11. The VBA code works but when it comes to pass the osCurrentScreen.SendKeys "Y", It does not pass the "Y" Key. Why is that? This only happens in my If Then Else statement. Any help would be appreciated. Thank You If (Line22) = "Do you wish to continue? N" Then...
  20. airwolf09

    DeleteFile VBA Attachmate Reflections

    I thank You for that code. But the main reason why I want to delete the line from the text file is to learn how to do this process.

Part and Inventory Search

Back
Top