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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MrRocky

  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...
See more

Part and Inventory Search

Back
Top