I have a list box and I want it to update the exact time when I click a
button and fill the list box with the long time (including time and date).  
The list box is name "Clock-In".  How can this be done?

I have a query that has 2 columns.  The first column has a dollar value, the
second is a number,  I want the dollar value column to not show on a report
if the number column has a value. This query will be used on an accounts
payable report that will report only open payables.  ...

I Have a continuous form that has a due date field, I want to set this so it
changes to Red, background if >today()
I have tried to enter this but it fails...anyone any ideas?
TIA

How can I set up a new form to open to select a customer from the customer
table?  I want sort of a pop up table that the user can double click on a
record and get that customer name into the orders table.  Currently I am
using combo boxes but I'd prefer popup forms.  I think it's ...

Hi All I have two questions.
1) How would you auto populate a field to current date ( =date()  ) based on
a check box selection.. The check box selections are Yes='1', No='2'. So if i
click Yes='1'( for processed) , i would like the date processed field to auto

How can I close all the toolbars with VBA?
I've tried the following :
-----------------------------------------------------
   Dim cb

I'd like some advice! I am thinking about possibly using an unbound form for
data entry, and I don't know if it would be a good idea or not.
This is for a library database. Currently I have a bound data entry form
with 3 subforms. I use a tab control, with book information on the ...

 My company has 30 different items and I want to create a form on which
has 30 controls that represents 30 items. When an user adds a new record,
he or she just drag the item on the form and drop it to the field.How Can I
do it.Thanks.

I don't understand what happened.  I created a switchboard using the
switchboard manager and there is only one switchboard, the main switchboard.  
When I click on one of the buttons to open a form, the form open in the back
of the switchboard, not in front of the switchboard.  I ...

I have a form that lists different records
the form is made up as:-
dateonletter   reply         refno   name          prod   issue       resolved
3/5/2005       6/5/2005    1785   johnsmith   car      broken    yes

Looking for some advice in advance.."An ounce of prevention is worth more
than a pound of hamburger".  (Or something like that).  
I'm a temp contractor modifying a 16-user, 2002 Access database.  They rely
heavily on a CO_CommentText field (Memo) which currently receives input ...

I create the following update query and show it in SQL view. I want to copy
this to use in a sub routine and like to change some of the static Text to
variable. Thanks
UPDATE Tbl_Search_Result SET Tbl_Search_Result.ProjectTitleKeywords =

I had some unbound forms and would like to make sure there is information in
every field.  And if there is not information available or just N/A then auto
fill the unbund field with N/A.

Is there anyway to format the datasheet view of a form?  I want to be able
to turn off things like the header and such.
Thanks
Lee

I would like to put Personal Folder contents in my preferred order not
alphabetically