mojomusic72
Last Activity: Aug 15 '07, 01:18 PM
Joined: Jul 9 '07
Location:
-
Definitely see the wisdom of that now. -
Think I may have figured out a solution using an Update Query. Hopefully that does the trick....Leave a comment:
-
Thanks for your help in this.
Is there a way to, each time the form loads or closes, to recalculate? Perhaps to better phrase, I want the user to be able to print a report showing how much time has elapsed between DateA and the current date, so of course Field1 must be recalculated when loading the report to reflect today's date instead of, say, yesterday's or whichever date the record was last updated . I am only using one form for...Leave a comment:
-
Would I (more specifically COULD I) still use the fAge function in the AfterUpdate portion (btw, duh, I should have known about the control source problem ... still pretty new to databases)?
It was hard enough finding some code that would display correctly. I hope I don't have to start over on calculating the date....Leave a comment:
-
Table field not being populated by function
I have a module with the following function (modified from raskew's "age" function):
...Code:Function fAge(dteStart As Variant, dteEnd As Variant) As Variant If IsNull(dteStart) = True Then Exit Function Dim intHold As Integer Dim dayHold As Integer 'correctly return number of whole months difference 'the (Day(dteEnd) < Day(dteStart)) is a Boolean statement
-
Woo hoo! Thanks ... I know just enough code to be dangerous. I had something similar to your 1st method, but my syntax was pretty messy.
Thanks!...Leave a comment:
-
Choosing a date from two possibilities
I'm trying to populate a form field depending on dates entered.
Specifically, the user will enter DateA, and DateB, with DateC resulting from those two entries. What I want is for DateC to = DateB + 9 months, UNLES DateA + 12 months is greater, in which case DateC would = DateA + 12 months.
The DateA+12 is a new criteria. I was formerly using After_Update with DateB:
Me![DateC] = DateAdd("m",... -
I have also encountered a problem with the Leban's fix.
During the process of developing a DB, I installed the fix and it worked fine for quite some time. I have continued to work on the DB, adding a form here, a function (like keyword search), but nothing that drastically altered the design of the DB. Then one day, it just stopped working. I've re-installed the moduel but no use.
I am running the DB from a network...Leave a comment:
No activity results to display
Leave a comment: