I have designed a form that is used to help me in my Human Resouce duties.  
As a person is hired, the person has several forms that need to be signed and
kept on file.  I have about 12 forms that are used and decided a yes/no field
for each turned in form would help me track the ...

I have some monitoring results which should be carried out monthly.  However
on occasions a measurement is made at the beginning of the month and right at
the end of the month (ie measurement is early for preceeding month).  The
problem is when I produce a chart access sums the ...

I have created a table and used the number data type for a field named
Invoice Number. I did not use the AutoNumber data type as I needed to input
over a 1000 records that were in no particular order that had already been
given invoice numbers and mailed out to clients etc. Now, ...

This message popped up when i tried accessing data in tables. This was an
attempt made using the datasheet view. First time this happened!
- Tried compacting it, but to no avail.
- Tried creating a new DB, so that the table objects could be imported into

I'm using Access 2002 and want to set the commitonclose property on some of
my forms to '0'.  According to the help file
"Returns or sets a Byte indicating whether the specified form saves changed
records when the form closes. Read/write.

Daily work order for buliding maintence crew.  I need it to give space for
work being done, apartment work is being done in.  Type of work and the tools
needed.  The space should also have space for approval, as well as sign off
of the tenantsaying they approve the work done.

I have a subform in datasheet view which I want to filter based on the
choices entered un  several unbound combo boxes on the main form.  Once I
have built a strFilter from the ichoices selected in the combos; how do I
apply the filter to the subform?  Whenever I try something ...

I have a combo box on a form called QuotationNumberQuery where the user
selects a reference number from the list and a button is pressed which then
displays the quoation they selected in a nice report.
I want a msg box to appear if the button is clicked when no quotation is

I've got a send object macro assigned to a command button on a form.  After
clicking the command button, it prompts you for an ID#.  After you enter the
applicable ID#, then an e-mail is generated with the person's information
filled in.  However, after I send or close the e-mail ...

Hi, I need a help please
I just made simple print button in wizzard with DoCmd.PrintOut command
When I try to print current form I get Microsoft Office Access warning -
"The selection with is greater then selection with and there are no items

Is there a way to limit the amount of characters in a memo field.

This code doesn't seem to work; I'm expecting my list to look empty after
runnign it but it doesn't.
  Dim iCount As Long
  ' clear it out first

Is there anyway of stopping a form from maximising? I have a number of small
forms which fit in the centre of the screen. However if the user
inadvertently maximises any screen then all the forms seem to maximise. I
want them to stay the same size all the time. I've looked through ...

I have code in the AfterUpdate event of a control with an error handler.  
when I update the control, I get a "compile error: label not defined".  The
Private Sub MileageDescription_AfterUpdate() line is highlighted in yellow
and the

I have created  a form to update a table for wireless bills. My form worked
fine the first bill (Feb bill) I entered but now I am trying to enter the
second month bills and I believe I have messed up on designing the keys or
the form.