using Access 2007
thanks for your help

I've recently converted a database from Acc97 to Acc2003.  In the previous
version there was a form that had 2 subforms.  A popup form was used to edit
information displayed on the subform.  When you closed the popup form, a
requery is called on the main form and the subforms so ...

I have a button by which a row is added in a subform with a datasheet. But
this datasheet has a bounded parent datasheet where the focus currently is on
a certain row. After the adding of a row in the child datasheet, the focus of
the parent datasheet jumps back to the first row.

thank you
===================================
Private Sub Form_BeforeInsert(Cancel As Integer)
===================================

Using a tabbed subform - the code below works perfect to validate one field
and force a required value for a second field IF the users tabs through the
fields.  However, I'm not sure how to compile the code that gives the user
the option of tabbing or manually selecting each field.

Im currently doing a database for a Salon Booking System and was
wondering if you could help with some explanation on something.
I want to have the staff available certain times on certain days
depending on what they can work so they all have different shifts. How

Is there a way to capture the user's screen resolution, and then set it to a
different value in VBA?
I have tried unsuccessfully to get all of my users to set their monitor
resolution no lower than 1024 x 768, but there are some holdouts that insist

I am using VB code in the "after update" event for a field on a form.
The code checks for errors and if there is an error, it is displayed using
Msgbox.
The next step attempts to set focus to the same field so the error can be

There is a backup database under file menu which is very nice.
I just wonder that can I schedule to do backup in the background just in
case I forgot to do so.
Is it schedule a batch file to copy mdb file to destination directory best

Is there anyway that it can be set that when a form opens up it will
automatically start a new entry and not go through ones that have
already been done?

I have a form called "Form1" who has a subform called "subform1".  Depending
on what the user picks as the source object, subform 1 can be either 1.)
frmCalendar, 2.) frmContacts or 3.) frmProjects.
On each one of these forms (frmCalendar, frmContacts, and frmProjects) I have

I have an Access 2000 Database with info on the videos on my computer. On an
Access form I have a button with a hyperlink to the video file. On my old XP
computer it worked just fine. I'd "push" the button and the video would play
(on Windows Media Player). Now I have a new ...

Need some assistance on getting this coding to work right on this form.
Basically, if the location and date are already in the SQL table, the 'Date1'
and 'Location' fields need to be cleared on the form and the focus be in the
'Location' field. Here's my latest (but obviously not ...

I am using an option Group for the first time and have a question as to
translating the Assigned Option Group "Number" to an acutual word on the
report.
Example: