How do I format a date field for inputting? I want the user to put the date
in as day-month- year. Example, 06-Jan-05.
thanks!

I dont want the standard message of "Save changes to form?" after I change
it's OrderBy property programatically, when I close the form. How do I do
this?
TIA

The user needs to pull up records by specific quarters or product types from
a form.  
  qtr             ProdType
2004-01

On a form, I got  some fields with different colour text. When it's insert
into it's TABLE, the text is still black. How do I mantain the different
colour text in the TABLE like it is display in the forms. Thanks.

CODING used
-------------------
Response = msgbox("You are about to delete this Contact's details. Is this
Correct?", vbYesNo + vbDefaultButton2, "WARNING")

Im using this piece of coding to password protect a form, however when the
password is input it is not masked so everyone around can see it, is there
anyway of adding an Input mask to an Input box?
private Sub Form_Open(Cancel As Integer)

I need to be able to execute DIR type search commands and get the results
into an Access table.
I downloaded some code from the web that does this via API calls but after
working on it for 2 days can't get it to work in all cases. It works if I

I don't understand why one of two computers does not show a list of report
in a box on the form using row source.
SELECT DISTINCTROW msysobjects.Name, msysobjects.Type, * FROM msysobjects
WHERE (((msysobjects.Type)=-32764) AND ((Left([name],3))="rpt"))

Hi everyone and Happy New Year
I have a combo box whos data source is a table with about 4000 records. When
the box first opens, the scroll sliders dont work properly (ie the list
doesn't scroll as the slider moves) until you have got right to the bottom of

I implemented the use of Allen Browne's Audit Trail Code in a database that I
created for the purpose of tracking errors.  The Audit Trail code works great
for all but 4 users.  Unfortunately, for those 4 users the following error
occurs:

Novice using VBA ... Strong  in Access
The user needs to filter specific records by either quarters, Prod Type or
both quarter and prod type from a form.  First, what type of object (command
button, drop down box, etc) should the user select to run the filter?  

I am setting up a database that provides an interviewer scripting based on
the respondents feedback. I am using the ".visible" feature for many of the
fields. It is working, however, when the interviewer moves to the next record
(next customer to call), the code does not ...

Novice level, please....
I want a custom message to notify the user that his input is a duplicate of
an existing field (CompositeID).  The user then needs the ability to either
abort  or retype his input.  This is what I have so far... which gives the

I'm using Accesss 2000 and trying to make use of some VB code to do file
searches. I understood that the VBA in Access 2000 was the full VB but I'm
getting syntax errors on these statements:
Event SearchStatus(ByVal CurrentFolder As String, Cancel As Boolean)  

My production database calculates labor and progress values for our various
jobs by JobID.
I have a query thats liste JOBID, SatusDate, Hours, Progress for all active
jobs