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

  • Users: agp4
  • Order by date
  1. agp4

    Left Join Query

    Hi, I have the following 2 tables; Table1: Products (ID, Customer, ProductName, Price) Table2: Orders (ID, Customers, ProductName, Price, Quantity) I want to create a query that selects all the records from the Products table and also any matching records from the Orders table for a given...
  2. agp4

    Reading and Displaying a CSV file using ASP

    Worked a treat! Thank you very much I had spent hours tring to work that one out on my own!
  3. agp4

    Reading and Displaying a CSV file using ASP

    Hi, my appologies for not replying but called away on work. Thank you for both the answers given. I am having a small problem with the getrows method in that it does not seem to pick up the first line in the txt file! The seconds method using the split function does recognise the first line but...
  4. agp4

    Reading and Displaying a CSV file using ASP

    Hi, can somebody point me in the right direction - I have a csv files of the following format; "HDR","1","1","STORE NAME" "LNE","1","M6-T" "LNE","2","L6-T" "HDR","2","1","STORE NAME" "LNE","1","M6-T" "EOF" The HDR field represent a header, whilst the LNE fields represents lines/records. EOF...
  5. agp4

    How to access asp application over a small network

    Thanks - I will give it a go!
  6. agp4

    How to access asp application over a small network

    I have a small network consisting of three computers - one running Win XP Pro and two XP Home editions. I need to be able to access an asp/html application that I created from all three computers, which I currently do by accessing it through the Internet. Rather than accessing it over the...
  7. agp4

    Excel reference every nth row

    Thank you - the solution by anotherhiggins worked a treat!!!
  8. agp4

    Excel reference every nth row

    I have two worksheets in the same workbook. In worksheet one I have a number of records that populate about 9 rows each with each record representing one week. I have copied and pasted the original record (9 rows) to display a whole year. In worksheet two I want to be able to reference the last...
  9. agp4

    Help with an simple excel lookup by date program!

    Sorry for the delay in my getting back to you, but thank you for your response. I think you are right suggesting that I use a MS Query. The application will only need to hold around 600 non relational records - would I be best storing these in access or an excel worksheet? My next problem is...
  10. agp4

    Help with an simple excel lookup by date program!

    Could somebody help point me in the right direction for the following; I am creating an excel application (using vba if necessary) whereby I have a table of data with a date field, customer_name and quantity field on worksheet1. On a seperate worksheet (worksheet2) I have created a userform...

Part and Inventory Search

Back
Top