I am using the following code to try to use the MS Excel funciton trunc,
but I get the error:  (I did make sure I have a reference to the MS Excel
Library)
Object doesn't support this property or method (Error 438)

I have a problem trying to display a subform.  I would like to be able to
have a combo box list a few selections possible and based on that selection,
display a subform (there would be a different subform per selection from the
list in the combo box) as part of this form that I'm ...

I am trying to do two types of calculations of a Continuous Form. I have a
vehicle log form and I am trying to have a running calucation for mileage
used and one for total fuel put in vehicle.  Mileage is input as odometer
reading at log entry. How do I program the difference ...

I'd like to give users rudimentary formatting cability in a memo field by
allowing them the build pseudo bullets using tabs.  How can I capture say
CTRL TAB to allow them to insert a tab into the memo text?  Thanks in advance
for any assistance.

I have been on multiple forums and found help on this issue, yet I still am
having difficulties.
My form named frmAssignStudentsToClass has a subform named
sfrmAssignStudentToClass.  Inside my subform I have two combo boxes, one of

I have a form called "frmMain" and on that form I have four list boxes.  The
table for these list boxes are tblSurveyor.
If one of my users are entering data and the surveyor is not in the list.  
The data entry person can click a button and a form called frmSurveyor opens

I have created a small database using Access 2003 from which I would like to
print a blank form. This form would be used by clients to complete by hand to
subsequently allow me to update information in the database. I know i can
print the form as a report but it always contains ...

I have two combo boxes side by side.  The second box looks up from a query
based on the first box.  This works exactly how I want it to when you first
get into the form.  But if you decide to change the first combo box, the
query doesn't run again with the parameters.  Any ideas? ...

I am trying to create a form that will prompt the user a question - just like
a parameter query. However, I cannot build the form from a parameter query
because I need the form to update the initial tables involved. Is there a way
to do this? Or is my thought process wrong, and ...

A question that appears to have been asked lots, but not answered (that I can
see).  I have Access 2003 and Crystal Reports 8.5 and want to generate a
Crystal report from Access based on a parameter that comes from a field on a
form in Access.  At the moment i am struggling to ...

I just had a user click the print button on the tool bar instead of clicking
the print button on the form that would switch the user to a report view
before printing (and we wasted 2 reams of paper).  Is there a way to prevent
a form from printing or to disable the print button ...

I have a form and subform used for orders. The main Orders form tracks
customer information, and displays the parts order subtotal, taxes, delivery,
etc.
The subform is used to pick part numbers from a Products table, and add them

I would like a field in my Access database that shows a persons age.  I have
two fields now that are; Date of Birth and current date.  I cannot figure out
how to create this field that takes these two fields to show the persons
current age.

I would like to have my database to open just the form by itself without the
access window in the background. I use tools-startup- and uncheck the box for
display window. but that is not what i want. I would like the database look
more interactive by only allowing the user to use ...

Is it possible to assign keyboard shortcuts (e.g., CTRL-ALT-Q or
whatever) to buttons on a form?
Thanks,
Darrell