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...
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...
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)...
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 -...
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()...
[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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.