I have co-workers who would like to only enter the month and day and
not have to type in the year, as the current InputMask requires.
Can this be done?? I searched this group but only found posts about
incrementing.

I use the following code to copy data from the previous
record except for two fields:
Private Sub cmdnew_Click()
On Error GoTo Err_cmdnew_Click

Hello.. I would like to add a text field to my form which, for the current
record, displays an order date, due date,  and send date for job orders.  I
would like to add an additional text field (call it txtStatus) which would
indicate the following:

If the user clicks No in this message I want the form to close, but I get a
message that says This action can't be carried out while processing a form
or report.
Here is my code

Is it possible to insert my own sub procedure at the application exit event?
If so, how?

I have a Form where all the controls are Bound to fields in a Table which is
opened by using
DoCmd.OpenForm "frmProposal", , , , acFormAdd, , "Add"
Basically I want this form to be opened to only allow Data entry for 1 record.

    Thank you in advance for any suggestions!!    
I have a form which takes its values from several tables
and queries. the data in the tables are prices that are
changed very frequently.

Using Access 2003, a bound form, running query from VBA code using
       DBEngine(0)(0).Execute strSQL, dbFailOnError
In the sub to run the query, which of the following are needed when the
database when will be running under runtime on other computers?

Re Template File part of the SendObject function.
Further to other postings I can not find any info can anyone help even if
"No cant be done"?
Can any one advise on this part of the function.  I would assume it to

Hi, I have users in Access 2k who suddenly can't run a date comparison in an
.mde file. This worked for at least a year previous to this. I hoped that
upgrading them to Access 2003 would help, but no luck. Of course, the code
works on my pc. I suspect a patch would fix it for ...

How do I modify an existing MDA file?

We have an application developed in Access 2000 that uses forms, VBA and
Activex controls including Listviews.
We had a backwards compatibility problem with mscomctl.ocx when our
application was ussed in Access 2002.  Listview controls were not displaying

I have a new person joining my company in a week or so who I'd like to train
up to be capable of debugging our existing Access dbs.  Does anyone have any
ideas/links/resources that they're tried that they could recommend?  I
really don't want to spend too much of my own time coming ...

when i run this on my form i get the following: "An unanticipated error has
occurred. The error number is 20 and the description is 'Resume without
error'. Please contact your System
Administrator"

I have a form based on a query.  It has unbound Start Date and End Date
textboxes at the top to set the criteria for the recrodsource query.  When a
particular textbox is clicked, it opens another form based on a different
query. This new form has the Start Date and End Date ...