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 Chriss Miller 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: jock95
  • Content: Threads
  • Order by date
  1. jock95

    Auto numbering in Excel based on cell criteria.

    I am looking to have a cell that contains a Number, like a Purchase Order Number. When the excel worksheet is opened and a particular cell is changed, then the number will advance 1 spot. Creating a new PO. Any suggestions?
  2. jock95

    Advance Cell Number Every Time Excel is Opened.

    I have built a Purchase Order in Excel and was wondering if I could have the # representing the PO # advance 1 everytime a To: cell is changed? Thanks,
  3. jock95

    When a drop down changes parsing first piece into another field

    I have a field on a form that when I change the selection I want the first part of that field to be parsed and changed in another field. Example. I have a list box with the following. Books - Doc 7 6180 In the other field, I need this to happen in the on change() cmd...
  4. jock95

    LEFT() in Query.....

    I have a query that is looking up the first part of a string in a field. The first part is separated by a "-" i.e. Books - Number 7 DOC 6180 Due to the fact that the first part can be any length, I just need the first part of that field. I wrote this below, and it works for the BOOKS...
  5. jock95

    Check Box in Table for Query....

    I am needing to run a query based on whether a check box is checked or not. What is the code to do that? "Is Not Null" does not work. Thank you,

Part and Inventory Search

Back
Top