I'm a new Access user and I believe I'm facing a problem that can be
solved easily, but I don't know how.
My goal is to calculate monthly failure rates A failure rate is the
result of dividing used parts by the number of systems. For example.

    A customer has a table with greater than 30 columns (scientific
readings). The form used to input the data is very difficult to use
and I'd like to ask the group:-
   (1) Can a main form call a sub-form that allows input of data

I have constructed a database application in MS 2003 (Access 2000 file
format) that uses a series of standard switchboards as the GUI to access
various functionality of the database.  I've been asked if it is possible
to establish keyboard shortcuts or hotkeys or keyboard ...

I have a command button “AddIncident”. I would like to make it so that it
will not add the record to the database if textbox “Type” is empty. I also
would like to add a message that will prompt the user with the message “You
must enter incident Type” when textbox “Type” is empty and ...

I have 51 Security Employees who take various courses throughout the year
and participate in various security drills as well.  I want to keep track of
these individuals and the courses (training) they have taken and in the
drills they participated.

I have a list of favorite websites in a table.
I use the following command to view it:
   strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!web_address

Got a bit of a major task coming up - I need to migrate data from one
version of my mdb to another.  Normally I manually track what's changed but
there have been so many alterations it's been impossible to keep up.
What I would like is some sort of tool to analyse two mdbs and give ...

I have a form (Change Card List by Status) with a check box
(cboNOT) and a list box (lstStatus). There is an Open Report button
that opens a report (Report - Change Card List) which uses a query
(SQL -Change Card List).

I am still having trouble trying to use a popup form to allow user to
set filters for the main form.
The main form is based on a single table.
The popup contains 5 listboxes, so the user can filter on 5 fields in

I need to input a date into one field and have access show me a
another date (plus 20 days) in another field (which I can do) but here
is where I need help. I need to exclude Saturdays & Sundays and Bank
Holidays. Can anyone one help please

Dear reader,
If "Compact on close" is set to yes (tickbox) the mdb or mde will be compact
by closing.
During this process a temporary db1.mdb will be generated and deleted after

Dear reader,
Is there a tool available to check the necessity of a Query.
Queries are used in Forms and Reports. It can be that a Form or Report is
not longer required and will be deleted. In case you are not aware to delete

Hi, im trying to create a prototype application in MS Access that I
will later port to VB.Net.
Essentially it is a Tendering System that will allow Tender Managers
to Create Request For Tenders(RFT), Request for Quotes(RFQ),

I have recently installed Office 2007 (SP1) retaining the previous
installation of Office 2003.
I have converted an Access 2003 database to Access 2007.  The database
contains the VBA code 'DoCmd.RunCommand acCmdLinkTables'  to initiate

Hi All ~ First time posting.
I have a module that works  ... it contains:
Set objCDOMessage = CreateObject("CDO.Message")
   With objCDOMessage