Search results for query: *

I tried using oncurrent but it did not do what I needed. I tried the issue but its only when the whole code runs, It will not let me move to a new or the next record after this code runs and makes the box change color.

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

For sure if you have an idea. I have been taking my time with this one. It's not a priority right now, but any help would be appreciated.

Thanks for the help skip!

I'm trying to make that work. haha. slowly. I attached a progressive example of what I'm trying to do. Maybe this will help you better understand. Sorry you have to bare with me, I'm not so good with excell. I'm better with...

Thanks This should help you guys understand what I'm doing. http://cid-89754df45f8ee6d2.skydrive.live.com/self.aspx/.Documents/example.xlshttp://cid-89754df45f8ee6d2.skydrive.live.com/self.aspx/.Documents/example.xls

Would love to pasted the book I created but I'm having trouble with that cause I don't have an online place to store it. If someone wants to give me an address to send it to I would send it off. As to Skip's question. I was hoping to make the conditional formatting(you know how you get to...

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 could do that yes. I figure I should put this up. It's excell code, but its how I changed the Matrix into a List. Sub MatrixList() Dim aData Dim cList As New Collection Dim i As Integer Dim j As Long Dim c As Range aData = Range("a3"). CurrentRegion...

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

Thankyou. Works now!

Finally had time to test this function. but It's not working. [Cable No] is the feild in query [UnionTagLists] [txtTagLine] is the feild person types into [TagCheck] is a checkbox to show true or false [Txttagline] mustequal [Cable No] Private Sub txtTagLine_AfterUpdate() If Not...

Thanks, I just added the second column onto the query for the combo box. And used that to grab the info! Works great! Thankyou so much!

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()...

Thankyou!

[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...