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

  1. MrRocky

    Getting the next available number for users

    Thanks for the help to those answered my question the first time, but I can't seem to get either one to work. Here what I now have tried. And I tried to debug to see if a nummber is coming in. I do get 1 for the SeqVal. 'SQLstmt = "SELECT max(SequenceNum) FROM tblSequencer WHERE Dept =...
  2. MrRocky

    Need help to find next available interger

    Thanks for the help I can't seem to get either one to work. Here what I now have tried. And I tried to debug to see if a nummber is coming in. I do get 1 for the SeqVal. 'SQLstmt = "SELECT max(SequenceNum) FROM tblSequencer WHERE Dept = " & DeptNum & " AND YearValue = " &...
  3. MrRocky

    Need help to find next available interger

    Can anyone give me an idea on why this is not working? I have a "Record ID" textbox in a add form that I want it to find the next available number that is not used for the user. I can't seem to get this to work because it keeps showing "001" as the next number when there is...
  4. MrRocky

    excel document with asp

    I have 95% of my my problem complete but I am still using the default cell names(A, B, C etc for columns) when I have excel open; I need some variables for some SUM formulas to work in excel. So I used (chr$)character references in the formulas but when I get to the double letter column (AA, AB...
  5. MrRocky

    force all names of list into report

    I would like to auto email injury records to people in a email table. This people only take care certain teams of plant floor. So they only need to see the injury records related to their teams based on a start date and end date. Problem is that I have 20 teams and as in example above John Doe...

Part and Inventory Search

Back
Top