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 gkittelson 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: lkuch
  • Order by date
  1. lkuch

    generating values from a number range

    Well, I would like to auto populate a text box on my form. The textbox would be used as part of a document number. Right now my document number format is one textbox bound to a Req table, giving me a Req number - 03RQ. The next textbox is a julian date field auto populated and converted from a...
  2. lkuch

    generating values from a number range

    How can I generate values from a number range like 780-799 and include alphabet letters and cycle thru all the alphabet letters as well. ex. 780, 780a, 780b, 780c...799a, 799b, 799c and so on and start over again...780aa, 780ab, 780ac...799aa, 799ab, 799ac and so on. All to auto populate a text...
  3. lkuch

    Run query from macro to populate a form field

    Thank You, Bob! Your expertise got me out of a jam. Thanks again! Lou Kuchenbrod
  4. lkuch

    Run query from macro to populate a form field

    I have a query I created to convert a date field to 4-digit julian date. Code use: SELECT Transactions.TransactionDate, Format(Format([TransactionDate],"y"),"3000") AS Julian FROM Transactions; My query shows two columns - TransactionDate and julian. The macro runs good...
  5. lkuch

    Calculating quantities

    I have a report that tells me what has not been returned and is grouped by transaction seral number in a SN field in my transaction table, Either issues or returns in another field I call source. My quantities are taken from another table called document history in a quantity field from which...

Part and Inventory Search

Back
Top