Recent content by kmrkmj

Yep your question mark made it click for me. I was using enabled instead of lock. Thanks!

Hello, I'm using this bit of code to lock my controls on a form Private Sub Lock_Controls() 'Locks the controls to prevent editing Dim ctrl As Control For Each ctrl In Me.Controls If TypeOf ctrl Is TextBox Then ctrl.Locked = True End If If...

I've attached a mock-up of the database i'm working on. Thanks!

Thanks isladogs, I like setting records! I’ll cut out the unnecessary fields at the moment. My tblClass consists of 3 fields. class_classID, auto number/pk class_keyword, short text – Contains the keyword value that is being searched for. Can be multiple words class_value, short text –...

Hello all. Just looking for some guidance with a query. I have one query that finds a keyword in a string based on keywords in a table. SELECT excelRaw.rawIncdNum, excelRaw.rawFileName, excelRaw.rawSynopsis, tblClass.class_keyword, tblClass.class_value...