>> I'm workin on a Access form ?2010?, and I would like to do the following:
>> When a user clicks a specific fiel, the value =Now() will be entered; or when a user clicks a button besides a field (such as time now), the value =Now()will be entered.
>After some trail and fail, it actually works now. I have TWO other questionS:
>1. How do I calculate the time in seconds between the stating and ending time?
DateDiff("s", [StartTime], [EndingTime])
>2. I would like to interactive buttons on a form, such as on a list of choices, if a user clicks on choice, another box will appear beside the choice so the user can then enter the details?
I would not use that kind of interface. Command buttons require programming...
and when you add another choice or change the choice, you must change the
design of the form, revise your code, test your code, cuss and swear, fix your
code, test it again...
Instead I'd use a continuous Form with a combo box in one column to choose one
of the options, with a textbox next to it to enter the details. But since I
have no idea what kind of data you're entering or what sort of choices there
are, I really don't know. All I can suggest is that you look at the options in
my .sig and post your question in a working forum:
microsoft.public.access.formscoding has had FOUR MESSAGES in the past year,
all in this conversation. "It's DEAD, Jim!"
You can get lots more people (and lots more experience and expertise) in the