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 bkrike 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: input1000
  • Content: Threads
  • Order by date
  1. input1000

    My code won't end -- have to hit escape to move to next record

    Currently I have a textbox setup that after a user updates the box, it checks to see if what they typed exists in a tag list. If True, Tagcheck=true, If false Tagcheck=false. There is then conditional formatting on the box, when true background is green, if false background is red. Problem #1...
  2. input1000

    Conditional Formatting based upon the color of a cell

    I have a matrix which is automatically create. 100x100 cells large. The matrix is filled with values 1-a to 1-z depending upon earlier calculations. 1-a through 1-z are sub-parts to a larger groups (there gates 1 - 8) Example... Gate 1 includes (1-a, 1-b, 1-c .... 1-f) I have another sheet...
  3. input1000

    Creating a table from a matrix

    I have 2 tables. TblTag - This consists of tags i.e. LIT-11000 This table has many columns, the ones that matter is the - TAG and FUNCTION FUNTION - is the LIT portion of the TAG TblMatrix - This consists of a matrix style table. Down the First column are all the possible FUNCTIONS(ie. LIT)...
  4. input1000

    Excell Sheet updates Access Tables

    I will have numerous Excell sheets that will I will have to update my database with. This will be a weekly task. What I require is some code that can do the following 4 things: 1 - Take an excell sheet from a specified location with a specific name and update the Access Table with New items 2 -...
  5. input1000

    Updating Feilds using AfterUpdate

    Trying to write the code for this: This a punchlist form(fills data in tblpunchlist) I have a feild that you manually enter the craft. After updating the craft (this is based tblcraft) I want a feild to autofill the responsible superintendant. Private Sub ComboRespCraft_AfterUpdate()...
  6. input1000

    Checking a feild of a text box in a form against multiple tables

    [frmPunchlist] has a text box [tagitem] [tagitem] must = one of the tags over a multiple of tables eitherwise when I run reports later they will not show valid results. to use a drop down list of all tags, over the 9 tables would be to large. what I was would like to do make a function...

Part and Inventory Search

Back
Top