I believe I am missing portions of code in the BeforeUpdate event and am
wondering if someone can help.  Here is my scenario:
I have 3 related tables:
tblProject contains the field ProjectID, which is on the one side of a one-to-

Hi, I have created a main form/sub form.  The main form is based on the
Employee table and the sub form on the Holiday table.
I want to be able to look up employee details in the main form and allocate
holidays on the sub form.  I can do this BUT I can’t figure out, how to stop

When inserting a tab Contral.  Is there any way to get the tabs/pages to stop
moving when you click on differant tabs?

I need a workaround for a problem in the "Collect & Update Via Email" feature.
Users need the ability to remove data from certain fields. Normally, this
can be done by typing a space or "" into a table.
The HTML form generated by this feature accepts a space or "". But, the

I have a database created in Access 2003. When a user running Access 2007
opens it up some of the forms open about the size of a postage stamp. Even
though the boarder style is resizable the resize handle isn't available
making it un-usable. Any suggestions would be appreciated. ...

I am using Access 2003 and I need to create a form with 2 columns. I got
this to work on Reports but I can't get it to work on Forms.
So far I have gone to Page Setup on the form, changed the orientation to
Landscape, Under columns changed it to 2, Column Size 5", and Down, then

Our Customer Service team wants to track incoming field response
calls/requests.   So, I have a simple form/subform but I am at an impasse as
to how to get the subforms cascading combos to work in the main form. They
worked great in the subform prior to placing it in the main ...

I have not been able to get a filter to work and now I quit and ask you guys.
I have a form with 7 text boxes. I want to filter by selection on ONE text
box. I want to have a command button, textbox, combo box or whatever where
the user selects a school district (one of 255) and ...

I have always struggled with creating static data points in a form. I need to
create a form where by managers have to add hours for different tasks their
employees peform, almost like a weekly time sheet. Where I struggle is if
there are 5 different types of data tasks under a field ...

I've asked this before, but never got an answer. Is there any way to get this
button back in this version of Access?
Thanks

My apologies in advance as I'm an Access newbie. I've been doing light
database work for a couple of decades -- mostly in Paradox for DOS -- and I'm
now moving to Access. But I'm running across something I would like to do and
I can't figure out how to get it done.

How can you convert access table contest to text fixed block file
Thanks

I have a project where I would like the text box controls of a form to
be disabled according to the choice made from a combo box.  I've seen
questions similar to this many times in this forum, but none of the
answers seem to work for me.  Here's what I have:

Could you, please, help me with this task –
I have to add a button (or another control), which would let users save a
record as a separate file in a certain directory  - the name of subfolders
will be different for each record, the name of saved file will be always the

Access 2003
So I am on one tab and when I click a button on that TAB I have a "msgbox"
as part of the "On Click" even.
Depending on their answers