I have a form that the recordsource is called from query.  On this form I
also have a multiple select listbox.  this has the following sql statement as
the row source
SELECT qryproductfamilydescription.[Product Family Description] FROM

Hi, I Have to calculate the difference in hours between dates and times
ignoring weekends, holidays and the hours between 6 Pm till 9 Am.
Do any one know how could I do that

I have a combo box on an sub form cboPDOPID.  The row source is SELECT
tbl_Policy_Procedure.PDOPID, tbl_Policy_Procedure.PDOPName FROM
tbl_Policy_Procedure;
It is bound to column 1 which is an AutoNumber field in the table.  Columns

  First, sorry for posting a question like this again. I know its been
answered before, but even after trying a few methods on this site, I'm still
unable to get mine to work. I have a main form called Employee Information.
On This form is a tab control with 2 tabs: "contact ...

I have a large number of photos linked to display in a report and a form.
This is set up so that the image frame will look for the appropriate file
without incorporating it as an OLE object:
'define the photo file name'

Is it possible to UPDATE or DELETE any record which is located on
another database table, by using update and delete query?
I can manipulate a table on another database by using APPEND and MAKE
TABLE query.

I’m building a Travel Expense database for my co-workers who travel to
various companies to do audits. This will not be a shared database, each
employee will have their own copy of the application that stores only their
travel expenses.

I have the following code to check for duplicate number. the code work when
there is an existing number. I got error when IDStg is null.
Dim db As DAO.Database
Dim rst As DAO.Recordset

Hi All,
I thank you in advance for your time.
I have a text box with an event code on click that calculates a number based
on data entry in my main form (the user clicks the button to calculate).

I developed a linked front-end/back-end application (Access 2000) for one of
my customers.  Is there anyway I can add a field to one of the existing
back-end tables using VBA from the front-end?  I'd like to simply be able to
send them a new front-end with a command button that ...

2003
Currently 1st time design/use of form.
I am not sure how to code a form.  Is there a wizard?  Does creating a form
and/or buttons generate any code?

Using Access 2003, I am using two combo boxes to filter a form with
the following code at the top of the form's event procedures:
Option Compare Database
Option Explicit

DB is A2000 running on Access 2003
I have a main form ( frmOpenReport) with a subform (subReportList)  listing
the reports I want to open.
The main form has three fields to input date ranges as report parameters :

This is probably because I have trouble getting my head around
Nulls...
I have a text box and if there is a value (not null) I want to call a
module to email a report to a user.  If there is no value (null) I

There must be a way to determine the field names of a ListBox whose record
source is Table/Query.  For example I would like to know that  
ME.LISTBOXNAME.COLUMN(0) corresponds to the field recordID in the table. How?