Search results
-
W
On Change occuring when it's not supposed to
I do. Its a form with information on in that if one cell is changed the other cells must me changed or left blank. The before update seems to do that well, unless there is something I'm missing... :? -
W
On Change occuring when it's not supposed to
Nevermind I added a Me.Refresh and it works! Thanks! -
W
On Change occuring when it's not supposed to
That meant to say it works well when applied to the afterupdate. -
W
On Change occuring when it's not supposed to
Thanks for the reply. It created an error when i applied it to beforeupdate. This now created another problem however... If the user changes the field to a new value it clears all the values in the other combo boxes like it's supposed to, but if the user then changes it back to the original... -
W
On Change occuring when it's not supposed to
I have 4 drop down combo boxes in my form. The other three update when the first one is changed erasing the value in the field. The problem am having is... when the user click on the dropdown list, if instead of clicking the arrow again to close the dropdown list they click the same value that... -
W
Use Control Source to calculate age
Found this one too: =DateDiff("yyyy",[DOB],Now()) Any way to add days and months to that? -
W
Use Control Source to calculate age
Tried this and it doesn't seem to work either... =DateDif([DOB],TODAY(),"y") & " years " & DateDif([DOB],TODAY(),"ym") & " months " & DateDif([DOB],TODAY(),"md") & " days" -
W
Use Control Source to calculate age
I already have a date of birth field named DOB. I am trying to calculate age with full years, months, and days using the control source in a text box, but all I can get in return is the calculated years old and nothing else. Here is my code... -
W
Row Source SELECT statement with Expr
Thanks for the reply! Is there a way to pull that information from another form or table so I don't need to have a check box on the F_Log form to make it work? I am hoping to make this form as simple as possible; all the user is entering is an animal training session with notes and some other... -
W
Row Source SELECT statement with Expr
I am fairly new the using Access and seem to be stuck on something. Here is the code I am working with: SELECT T_Keepers.KeeperID AS Expr1, T_Keepers.FirstName & " " & [LastName], T_Keepers.DepartmentID AS Expr2 FROM T_Keepers WHERE (((T_Keepers.DepartmentID)=Forms!F_Log!Departments)) ORDER BY...