I have a Form1 with a tab control.  On one of the tabs there is a Form2a + a
subForm2b.  Form2a is based on a query with a permanent criteria filter.
The user performs a function on each of the records displayed by Form2a.
After the user function, the form is requeried using VBA ...

Using the Command Button Wizard to make a button to delete the current
record, Access inserts the code:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

I have written the public fucntion below to allow a set of records to be
written into an unbound textbox on a form.  (I realize that I could do all of
this more easily with a subform in datasheet view but the client wants
otherwise.)  The function is called in two places: (1) the ...

I have a sub that I would like ot run on the forms OnCurrent event that
takes values from the form's fields and does some math to display some
calculations.
My problem is that when I move to a new record, there are no values in those

I am using Access2003.  Using the After Update event for controls on the
form I color the background of the control if data has been put in.  The
problem is when I put data in via code without placing the cursor in the
control the After Update event does not fire.  I've tried the ...

I have a form where a user would enter usage information about an account.  
The account must first be listed in the Account tables before it can be
entered in the Usage table.  In the Usage table I currently have a drop down
box of all known account numbers.  What I want to do is ...

Is there a way to notify Access to ignore a row, i.e. not load it into the
listbox?

Access 2003 adp + SQL server project.
Would like to link to Exchange Server 2003 contacts. Would like to list
items in the contacts folders and eventually edit them.
Is it possible and if so how?

I have encountered a problem with the recordset property. The wording I have
used previously in Access 97 was as follows in a form:
Dim Rs as Recordset
Set Rs = Me.RecordsetClone

I am using DoCmd.OutputTo & it works find.  What I would like to know, is
when it brings up the standard Dialog box for the user to choose the Drive &
Directory the user is exporting to, is their any way to track (save) what
path the user chose ?

I have a 6 tab tabcontrol and I need to know in my VBA code when the user
has selected a new tab.  The tabcontrol Change() event seems to respond OK
to the user clicking a different tab.  However, I'm unable to determine
which tab is now visible to the user.  I thought the PageIndex ...

Can anyone help? I am really not sure exactly how to best approach this
problem.  So here goes ..
I have a TABLE called "TableA" of property numbers where the field name &
unique key is called  {"APN"} it is a text format.  I have another TABLE

I am sending an e-mail using the below function:
Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err
   DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality

Have Form & SubForm; want to change data in a Form Field
after lose focus in SubForm Field.
Cannot get Access to recognise Field name in Form.
Please advise.

I have a form with a listbox containing about 75 different items.
It would be handy if I enter a character the listbox would jump to the first
matching name.
Alas, entering a character doesn't make my listbox to move...