I need to be able to calculate the time to midnight on any given day. E.g. it
is 4:00 pm. How many hours, minutes and seconds until midnight? I've tried
several different approaches with inconsistent results. Any help?

I have a numeric field placed on an entry form. I want to be able to enter
fractions into the numeric field - eg. 2.33, 2.60, etc.
What is best way to do this.
Thanks tons for help.

I have a simple form with a single record recordset, using Access 2003. For
some reason if data is changed the afterupdate event doesn't fire. The
beforeupdate works fine.
I would assume if the beforeupdate fires, the afterupdate should also fire

I have the following function which is part of a module (modPerformance_PC)
which I would like to call using the on Click event of a button on a form.  
However, when I use the button I get a message :Ambiguous name detected:
Del_performance_PC".

I have a form with a cmd button that pops up a sub form. On the subform are 3
buttons, yes, no & cancel. The cancel button was easy, but having issue on
the yes button and maybe the no button.
Here is the code on the "no" button

Hi everyone!  Using A02 on XP.  Got the answer I needed earlier from Van and
Marsh but now I've been asked to default to 12/31 of the PRIOR year.  I have
put a minus one in every spot but it's not working.
DateSerial(Year(Date()),12,31)  gives me 12/31/2006.

I have a Public Function TotalTime(), which I call from a Text Box:
=[TotalTime]
I currently sort two bound fields.  How do I include the Function
TotalTime() in my sort order, and how do I specify Ascending/Descending

I just tried to display the current Access users loginname with the
following script found on this forum:
http://www.mvps.org/access/api/api0008.htm
But I can't figure out how to get this to work. I just want to display the

I have a main form containing a subform.
The subform is a continuous form that lists related items.
What I want to be able to do is to click on the label of the subform (on the
main form) and then jump to the new record line of the subform list.

I've found your post how to prevent form from closing by setting the
Cancel variable to True, but I don't really know how can I extend it?
The form that opens is linked to a table with let's say 35 records.
Now based on a SELECT query as a rowsource, it finds 4 records that

I have a combo box on a form. The combo box looks up data in a memo field
(RowSource) to place it in the (contro source) which is also a memo field.
what happen is that when the user makes the selection, the text gets
truncated exactly at 255 char. even though, the user can copy ...

I have the following code
Public GroupName As String
------------------------------------------------------------------
Function fGetGroupName() As String

What event do I need to add my macro to when the date in my date field
changes by way of a popup calendar?
I have tried the events of the date field to no avail.
I have the following in the Click event of the button to show the calendar

Access 2002
I have a form whose detail section repeats. Within that detail section, I
haev a text-box control that I'd like to make visible (or not) based on the
data in that specific record.

Hello everyone!!! Using A02 on XP.  I have a little form I use to input date
criteria for queries, forms and reports and I would LOVE to have the begin
date default to 01/01 of the current year.  90% of the time the begin date is
Jan 01.  Tried to play with it in the Default ...