I have a form with the below code in the BeforeUpdate event.
I created a 'New Record' button:  DoCmd.GoToRecord , , acNewRec
and a 'Close' button:  DoCmd.Close, but they aren't working right.  When
they are clicked the message box "Do you want to save this new log?" appears

Access 2003
I have a switchboard form with 3 tab control pages. One of the pages is an
admin page that I want to password protect.
I used the ctrl_TabControl_Change() sub to trigger an admin login form

I have a series of three forms, editing two tables.  In the first form, there
is a combo box in which the user selects a place name (where the work was
performed).  The user then has two choices (staff effort or volunteer effort)
in button format; they go to different forms.  

I need to be able to setfocus to a sub forms text box AFTER the Main form and
the Sub form is loaded.  It doesn't matter what event I place the 'setfocus'
- it doesnt do it.  In fact when I press the tab key (only text boxes on sub
form showing) the cursor is invisible and is no ...

I am currently using the following code to change the AllowEdits property on
any form. The form calls the Sub procedure through a button's OnClick event.
Sub UnlockForm(strFormName As String)
On Error GoTo Err_unlockform

I am currently trying to get a form entry text box to remember the
last entry so as not to have to retype it each time.
I am using this code:
Private Sub tbxPartNumber_AfterUpdate()

I have an application which has neen running for a number of years, firstly
on Access2000 then XP and now on Access 2003.
It uses many currency fields for invoicing , credit notes etc. Each field
which is of currency type has the decimal property set to 2.

I have the following code looking up a record count, I am receiving
the 3601 error code on open.
Can anyone see what I might be doing wrong with this?  I have enclosed
all parameters in brackets.

I'm not sure if this is even possible.  
I will have Frm_Main (from Tbl_MAIN), Subfrm_D13_Main (Tbl_D13_MAIN;
one-to-many relationship with Tbl_MAIN) and Subfrm_D13_Inspection
(Tbl_D13_Inspect; one-to-many w/ Tbl_D13_MAIN).

I have developed an access application for the medical field (with much help
form this group, Thanks!) I have forms where nurses and doctors are able to
choose from a picklist of brief blurbs, i.e. Patient presents to clinic today
in acute distress. The blurge is then added to a ...

I've got a form with a bound control - REP_DATE.  When the form opens, I want
this control populated with the next day's date, unless the next day is
Saturday.  In that case, I want the next Monday's date entered into the
control.  Can somebody show me the syntax of how that ...

Is there a way to find out which column is selected/highlighted in datagrid?
I tried using "SelLeft" but it always gave me "1".
Thanks in advance.

I am making a simple sales database. I'm not too up with Access but
I'm finding it hard to figure this out.
Basically there is a customer form where you enter name, address etc.
This has the Customer ID from the table which is the primary key. I

Okay I have my data being automatically imported to a table
(TableNew). One of my fields is Called "File Name." For the new data
imported, the layout of the information in this field is example:
John.Pictures or Maryam.Videos. After the data is imported, I want the

Okay I hope someone can help. I have a form with an import button.
Clicking this button opens up another form which allows the user to
type in any date and then click the continue button which continues
the import process. The .CSV file that is being imported has four