Search results

Well with the version that I posted, there are no errors so I dont think any of the lines are giving it an issue, I think there might be some sort of logical inconsistency. But when I un-comment those bits of code in the clickconditions function it dosent like this line: SFLSApproveDate =...

Hi everyone, I am having trouble getting my code to work. I have a form that has 5 checkboxes and under each of these 5 checkboxes there is a field where I want today's date to be placed when the checkbox is clicked and nulled when the checkbox is unclicked, but for some reason nothing...

Ok, I think I should clarify that I am a novice to Microsoft Access and I am kind of learning this as I go, so please forgive me if I did not completely understand your post. Are you referring to the relationships that are set up within the tables, like the one to many, many to many or many to...

Hello, I have a main form that can be updated using a subform. The subform has check boxes and when they are checked/unchecked the main form will change its status. My subform is called frmStatusDetails and the main form is called SchedView. In SchedView, SchedStatus is a box on the form...

So here is a chunk of my code: If chkCSDAB.Visible = False Then If chkSMMB.Value = 0 And chkTCB.Value = -1 Then Forms!SchedView!SchedStatus = "Unapproved-SMMB" End If If chkSMMB.Value = -1 And chkTCB.Value = 0 Then...

Thank you for your help. The only control whose visibility changes are those checkboxes. But that is a more efficient way of coding it. So this is what I am understanding from the simpler version of the code that you provided: .value is no longer needed because I do not need to compare the...

Thanks for the quick response. So if my if statement is currently: If chkSMMB.Value = 0 And chkCSDAB.Value = 1 And chkTCB.Value = 1 Then Would I change it to: If chkSMMB.Value = 0 AND chkSMMB.visible = True And chkCSDAB.Value = 1 And chkCSDAB.Visible = True AND chkTCB.Value = 1 AND...

Hi everyone, I am working on a database as a student intern and I am gradually learning access and VBA as I go along, so put simply, I am no expert. Currently, I have a form which displays 5 check boxes. Depending on information from a previous form, some of these check boxes may dissapear...

Ok thank you so much, it works now :D

Hello everyone, I am a student intern and a bit of a novice to Microsoft Access. I have been asked to fix a database that originally had worked fine, however after my workplace switched to Microsoft XP, they changed the security settings so that certain Macro's in that database do not work...