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!

  • Congratulations dencom 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: MrHeynow
  • Content: Threads
  • Order by date
  1. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Is there a way to create ranges for multiple dates associated with single record or AccountID from a query/table so that one could later evaluate a date of another table or query to to say that AccountID 100000001004 at 7/18/2017 10:11:00 AM was AssignedTo 3632. Three columns in the current...
  2. MrHeynow

    Create a new field based on values above select rows

    Is this even possible? I want to make a new table with three columns from the data sampled in Field1 and Field2. Two columns are to be the same, the third column is to be the record number found below the data and to the right each appearance of the word “Record” in Field1 in found in Field2...
  3. MrHeynow

    VBA, Make table query

    Have this bit of code I lifted from a older post (thanks Ed2020) in which I have modified to do my bidding however I cannot get it to complete. L The scenario is this , I have a table of 30 lines called, Ar_Code, with two fields of arrier_name and ar_code . I desire a VBA solution that moves...
  4. MrHeynow

    VBA Make table query

    Have this bit of code I lifted from a older post (thanks Ed2020) in which I have modified to do my bidding however I cannot get it to complete. L The scenario is this , I have a table of 30 lines called, Ar_Code, with two fields of arrier_name and ar_code . I desire a VBA solution that moves...
  5. MrHeynow

    Capture data on screens till exhausted,then export that data to Excel

    Sorry, over the past several days I’ve viewed over a hundred threads and I still cant piece together a good solution. I have these screens listing several transactions. There could be one page to over 100 pages. What I want to do is to copy/copy append or capture data in a select area from each...
  6. MrHeynow

    How to use a single query result in DoCmd.TransferText

    How do I use a single query result like “FS_20090122_121139.TXT” in lieu of "TRLR.TXT " for the file name when exporting another query? '------------------------------------------------------------ ' ExportTrlr1 ' '------------------------------------------------------------ Function...
  7. MrHeynow

    18 Recs from Excel, to Attachmate enter, back to Excel next 18 etc

    I have varying number of records all in one column, starting at A2. There maybe 1,000 or 20,000 records. What I am trying to do is grab 18 rows from a spreadsheet, switch over to Extra! /Attachmate paste the 18 rows then enter them, then go back to Excel grab the next 18 rows switch back over to...

Part and Inventory Search

Back
Top