how to find out difference between 2 dates without calculating weekends i.e.
2 days
thanks

I need help with code  I have a current date field named Date and a futer
date field named ExpireDate.  I can't seem to get one month from current date
to enter into expire date.  this is what I have:
Private Sub Date_AfterUpdate()

I want to populate a txtPackaging with one value if true and another value
if false what I am getting is only the value as if the statement is always
true and I know for a fact that it is not.
Look at tblCustomerPricing if cpFlatRate =-1 and the second  If statement is

I'm still learning Access and coding.  Here's my dilemma:
On my form I would like the "Last Name" field to flag if the same last name
has already been entered.  I want to allow duplicate last names, but I'd like
to have the field turn red (for example) if the name has already been ...

Hi All ....I am trying to create a Reporting Form where an end-user selects
the report and chooses an email option. Once the Email button is clicked, the
Access Application will send out the report as attachment to the recipient.
The sendObject method or action only works with ...

I know there's a way to input a short date format (i.e. 11/30/05) in a query
on a field that is formatted as general date (has time included).
The query is simple - it reads: >=[Enter Beginning Date] and <=[Enter Ending
Date].  The field name is: ActionDate.

Hi All...I have three fields that I would like end users to enter before
closing the form. I have following code
If IsNull(Me.tblClient_ClientName) Then
   MsgBox "Missing Client Name", vbCritical, msgTitle

How do I determine if a control is displaying "#name?"  ?
My front end needs to "turn off" any control that has an invalid control
source, but I can't seem to test an invalid control source until I try to use
the control.

Is there a known problem w/ speech recognition not working with an Access
2003 field defined as the following:
Format: 0000000
Decimal:0

I am using Access 2K and need to generate multiline strings within a memo
field via VB code.  Where you would click a button and it would first move to
a new line within the field, then add the following format of text:
Line 1

I have a form with 2 combo boxes, the selection made from the first combo
will be the criteria for the second one.
How do I implement this ?
Thanks for any help or leads.

From a Form I would like to enter a date range to pull from one single column
within my table labeled "Date".  When clicking a button I would like to have
that date range opened to a report to preview/print.  I have been unable to
figure this out after numerous hours of trying.

I am having problems with a few lines of the code.
I am having problems with the line of code that states:
If Me.txtPassword.Value = DLookup("Password", "Login", "[lngUserID]=" &
Me.cboLogin.Value) Then

I would like to store the user's logon ID in a record when inserting or
changing a record.
Putting a couple of invisible text boxes on the form would work, but how do
I get the user's ID in Access?

I'm chosing records from a listbox,  If I choose one record. It works
fine.  But If I do a Multi-Select then only the last Record I select
gets inserted.  How do I make this code accept Multiple Selections?
Thanks