Recent content by miken5678

When I have two tabs everything works fine when hiding and unhiding. However when I add a third tab which visible property varies it was causing and issue losing focus so to get around that i stuck the third tab data inside each of the original two tabs. Since I am new to this any advice is...

I have three tabs which the visible setting is driven off of three other fields one field drives each tab. I was running into an issue while going through each record where it could not hide a field that had current focus. I noticed this happens when i try to click through records rather...

slowly getting it. Makes me wonder if there is a reference to be used that is a variable where Forms!WindOptOut!Text261 could be referenced as Forms!ActiveForm!Text261 thank you for all of your help and input thus far..

I think I caught your drift. Let me know if right or wrong. I chose this method as only one form will be utlized however there will be a lot of silly validations as to choices made by the input in terms of what is visible and what is not visible/available. I changed the modules to a similiar...

I thought I might have had issues do to multiple functions in one module so I split them out. I have attached a zip file of the db.. the vba works fine when done manually on the form and in the before/after events however once in a module and referenced on the form there is no worky? Since I...

I am trying to learn modules and while some of them tend to work others dont. I assumed you could per say nest different functions within a module without issue but advice and input is suggested as to any help to be provided. Option Compare Database Private Sub Form_Current() Call...

the only reason I went with the forms reference is do to an issue when someone was selecting a record in the split form none of the vba visible items would work. When i did a direct reference to these, after finding the fix on here, things started to work. I have always read about...

here you go, as the revision doesnt work. Can I ask your opinion on .visible items. I have several items setup to change the view however I originally tried on the before events but issues popped up while scrolling through records. My final decision was to do before after and on the form...

maybe this doesnt accept and statements or maybe I am doing this wrong If Forms!WindOptOutV12.IndStatmentHandwrittenComment = -1 And Nz(Forms!WindOptOutV12.IndStatmentHandwrittenComment, "") = 0 Then blnError = True strError = "Other Deviations Comment" & vbCrLf End If...

I did the below and apologize for me not catching your wording as i figured it would work as a defined function.. this has no issues but does not catch the empty text box.. also when you use len it is to cont characters so why is there a & "" added? this will work by itself If...

nevermind trying something rather quickly.. i thought the function would work

Private Sub Other_BeforeUpdate(Cancel As Integer) OtherFunction Dim blnError As Boolean Dim strError As String If Forms!WindOptOutV12.Other = -1 And Len(Forms!WindOptOutV12.IndStatmentHandwrittenComment & "") = 0 Then blnError = True strError = "Other Deviations...

I attached the file and I know its far from perfect. If blnError Then Cancel = True If MsgBox("You need to fill out these fields before we can save the record: " & vbCrLf & _ strError & vbCrLf & _ "Do you wish to cancel this record?"...

i set this up as a test but it does not catch the field on going to the next record.. the only thing i can think of is should it be altered to be nz(fieldname)? it is called in the Private Sub Form_BeforeUpdate(Cancel As Integer) Validation End Sub Public Function Validation() Dim...

deleted this as I am not making sense.