Hi - im being a bit slow this monday morning so if someone could please help
then that would be great!
i have fullpaydateto and fullpaydatefrom where i enter the dates that the
person is to be off on full pay e.g. 01/09/2007 , 28/09/2007.

Hi to all,
does everyone to know how to fit the column width of a subform in data
sheetview?
I read about it but I'm still having problems to make it works.

I have 2 tables:  tblVendors and tblVendorContacts.
I want to add a new vendor via frmVendors, and at the same time, create a
new record in tblVendorContacts with both the VendorID from the new record I
am creating, and the new contact information I am typing in.

Hi, I have a form that has a few criteria to be passed to my query
"qry_EditMVCF". My goal is to allow the user to type in criteria to
the fields into the form header - click a button and have the query
result displayed in the detail of the form. The reason for displaying

I want a label control of a tickbox on a form to change colour if it is
checked, assuming the checked value is YES. I've tried this code but it
doesn't work
Private Sub txtwithdrawn_AfterUpdate()

Why cycle (all records) not work on my form
I set data entry = Yes
The form based on query == Query Criteria is
Forms!FormName!ControlName

On a Access 2003 form which is based on a table called Person there is
an autonumber field called PersonID on the form close I have code to
get the value from me.PersonID (or [Forms]![myForm].[PersonID]) into a
module variable. The form has record selectors.

I am trying to figure out how I can reset a value from a list box on
a form to its original value if the new selection a user chooses
violates a condition in my code (in this case a MsgBox would appear
asking the user to go back and select a different item).  My problem

Two things:
1-If no MVP can answer a question, someone should tell the questioner so
he/she can move on.  Frustration is high enough without being ignored.
2-It is grossly unfair that  I can't post questions because I have W2000 and

Being new to vba and Access, I think what I am trying to do is out of
my realm of understanding. I have two querries that query the same
table "QtyUsed". One query "QtyUsed6Mo" filters results by the date
field to records within the last 6 months. The other "QtyUsedYr"

I know I'm going to hear that this is a bad design, but please bear with me.
I have a field in a sub form called Qty (quantity) that is saved to a detail
table. In addition, I need that same value saved to another "temporary" table
that is used for posting, and then cleared. I ...

I have an image that is linked to my data base.  I would like to know what
the Do Command would be to open that image in Image Viewer.
i.e.  On the image click property.  I would like msg that say "Would you
like to view "me.[per picture]" in Image Viewer."

What is the best For design the Forms
800 * 600 Windows screen resolution
Or
1024*768 Windows screen resolution

I need some way to enforce an exclusive lock so I can perform an operation
with all other users locked out until I am done. How can I do this in VB with
Access?
Essentially what I need to do is:-

I posted a similar questions earlier today and got help, then tried to apply
the solution to this formula and got an error.
I use the following calculation in a sheet.  Where there is no value to
calculate, i want to have "NA" appear in the field.