I have a date field in a report (data type is medium date i.e. 20-
Feb-08) and a date control on a form (also in medium date format).  I
am trying to filter the report by date according to the date the user
enters on the form.  My problem is that when a user enters a date in

I have Office 2007 (moving up from Office 97) and am developing a database
using Access 2007.  In form view, at the bottom with the record selector is a
search/find dialog box.  It searches every field in the database however I
want to limit it to searching only selected fields.  ...

I found this article about validating Postcodes and would really like to use
it.
http://www.mvps.org/access/modules/mdl0063.htm
I have copied the code to a new module and on my Data Input Form  and have

i have a form in data entry mode and a subform showing the related
records to the form. i want to double click on the a specfic record in
the subform the shows me the details in the main form. what is the
best way in doing it.

 I want to zip some text files in my access application by clicking button.
How can I do ?
Thanks.
Jason

I have a situation where I need to display 10 to 20 questions with three
response
fields (approx 6 different forms). I'd like to create a single form and
populate it with

I'm having difficulty passing the OpenArgs parameter to a 2nd form.  Here's
what I have:
Form 1 has this line of code in one of its subroutine:
 If (kitting) Then

Below is my current code for October's reporting.  It is a project form
showing planned progress (OctPlan), actual progress (OctAct) and via the
attached code, an indicator and color for October (OctInd).  This code works
great (thanks to the help on here)  However, my form shows ...

I have a field that I want to ensure is not forgotten on a form's
close after new record is created.
I have used the following code on a forms Close Buttons OnClick event,
and I did something wrong! Help me figure it out if you have a minute.

Public Function getTradeMarks(varProdName As Variant) As String
 Dim rs As DAO.Recordset
 Dim intRecords As Integer
 Dim strTradeMarks As String

Can anyone explain why using Option Explicit would case the following line to
error out saying "Variable Not Defined":
If CountDen > 0 Then DoCmd.SendObject , , , "nscarpinato@letstalk.com", , ,
"Items were rejected on initial RA submission form.", "Items were rejected by

Hey all...
Is it possible to open a specific form based on the log-in that the User
implimented?  For instance, I have 3 groups (not user groups, no security
setup currently).  They are Sales Support. Order Entry and Ad Production.

I have created a command button on a form and I want it to open Outlook for
the user to choose who to email, then email the current record in the body of
the email.  I have looked in this forum and on other sites and tried varies
codes, and tried to piece them together to get ...

Access 2007
FormA uses TableA.  TableA has FieldA which is a very non-descript code.  
TableB is related to TableA on that field (FieldA) and has all the
descriptive info behind the non-descript code.

I have a continuous form listing available parts.  I need to be able to
select a part from the list using a check box (or something that will give a
true if selected).  I tried an unbound check box, but when clicked, it
selects all of the records in the form instead of only the ...