Search results

Wow that is so frustrating that it was as simple as that. Big thanks to Bob and Linq...you guys are amazing. Have a great weekend!!

SOS need help with this.

Still getting an error in the same spot even with the change. I attached DB.

Linq, Can't figure this out, still getting an error in that spot. Please helpppp lol Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.Tag = "Required" Then If ctrl.ControlType = acTextBox Or ctrl.ControlType =...

I think this is in the right order but all my Ifs and Fors and what not are probably wrong. I'm getting an error on the Next "Compile error: Next without For". Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.Tag = "Required"...

Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control If Me.OtherUnivEmployeesInvolved = -1 Then If Nz(Me.OtherUnivEmployeeFullName1, "") = "" Then MsgBox "The OtherUnivEmployeeFullName1 Field Cannot Be Left Empty!" Cancel = True OtherUnivEmployeeFullName1.SetFocus...

Well here's an idea...I just tried your code and it handles everything from the first drop down and below. If I use a Ctrl Tag group ("Required") for the rest of my felds (above portion of the form) and have that group validated with the otheir groups validation then that should work right?

Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.Tag <> "skip" Then If ctrl.ControlType = acTextBox Then If IsNull(ctrl) Then MsgBox ctrl.Name & " Cannot Be Left Empty!"...

Hi All, It was recommended to put this in a fresh thread since it is a new problem. I inquired on this original thread (http://www.access-programmers.co.uk/forums/showthread.php?t=219821&page=2) to hide/show fields based on two Yes/No dropdowns. This was accomplished thanks to BL. Summary...

http://www.access-programmers.co.uk/forums/showthread.php?p=1256668#post1256668 Fresh thread addressing the new issue.

Bob, that is great! exactly what i wanted. Now I just have to work on what is required because even with No selected my Save feature is still prompting me to fill in those fields. For the first Yes/No section, if Yes is selected, only "OtherUnivEmployeeFullName1" is required. For the second...

Hi Bob thanks for the response: All I'm focusing on right now is the frmSunlightInput form. 1. My Yes/No boxes default to No when I open this form (is that normal)? 2. For the question "Were other university employees involved?", if the user selects "Yes" - the (3) text boxes will open for...

When looking at the Data Type in my table, there is no "CheckBox" option, only Yes/No field so i selected that. And yes, they are bound to fields. Could you help me with that Yes/No validation? About the new record thing, is there a way to keep those Yes/No boxes blank until the user gets...

I have: Private Function ShowFields() If Me.OtherUnivEmployeesInvolved Then Me.OtherUnivEmployeeFullName1.Visible = True Else Me.OtherUnivEmployeeFullName1.Visible = False Me.OtherUnivEmployeeFullName1 = Null End If End Function "OtherUnivEmployeesInvolved" is...

Thanks Gemma, I'd like to hide them if No is selected since they are not needed or even need to be looked at. I can't figure this out tho so if Bob could weigh in that'd be great.

How would this code change if instead of the checkbox, i used a Yes/No field with the Yes/No options...And If Yes, I'd want these 3 additional fields to show?

I made a mistake for posting this. In the embedded macro, under the SelectObject there's an option for In Database Window that was set to "Yes". I didn't realize what this was until now. Sorry if I wasted anyones time.

Hi All, Using Access 2010. I purposely disabled the Access Objects when opening my database for added security. This works. The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the...

Its to make sure they typed the right number on the search because a record not exisiting and typing the number of an exisiting record wrong would bring up the same result when searched... Like I said though the number has no reference to the record...what if I put something in the Delete...

I dont know how the =[Text10] would work when there is no Text10 on this form. Like I feel it would need more to know to reference Text29 from the previous form...