I have a form that is set to 'Continuous Forms'. I need to have the entire
"Record" highlighted.  The reason is that I also have an subform attach which
contains centain information that I transfer to related fields in the Parent
form through a button. How do I have the entire ...

There are two reports in a value list text field and also  a text field with
a list of quarters on a form,like,  "FY 01/07, FY12/06, FY11/06 etc.  This
code opens the report based on a query but it doesn't filter it.  In the
query of the report I have this same fiscal year period ...

Good Morning - first of all THANK YOU very much for your answer to my
"Stopping an automatic save" question on 1/30/07. (I am making changes to a
Db that I did not create).  Your instructions were very clear and easy to
follow and it works beautifully.

I have a form called frmVisitsNewEdit with a listbox control called lstVisit.
In the form Load event and the form's Current event have the following;
Me.lstVisit.SetFocus. This works when the form loads, but when the record set
changes lstVisit sometimes gets the focus and ...

On a form I have three memo fields which append via a query to a SQL table -
these fields in SQL are also memo fields. When one enters data in any of the
3 fields on the form and tabs off of it the data is truncated down to I
imagine 255. Can anyone explain to me how I can stop ...

I have (3) NotInList in my database.  One for TYPINV, one for SSN and one for
Organization.  They are exactly the same.  My problem is only Organization
works.  The other two keep saying an error occured, please try again.  What
can I do to get this from occurring and have the ...

Need help with subject issue for a MS Access (2003) module.
Specifically the following code will not execute.
Public Function UDBlankXYZ()
   DoCmd.RunSQL "Update tblSales, Set tblSales.Cust =

I want to run a ms dos batch file from a button in an access form.  The file
is located in a folder (P:\AAReports).  Is this possible?

In code, how do I find out if a table exists??
Thanks

behind a command button on a form I have the code:
the fields: LampCnt1 and LampCnt2 are both numeric fields and may or may not
have had values entered
BuildText = ""

Greetings all.  I am using Access 2003 and I can not figure out how to get
the following to work in the click event of a command button.
If Me.cboEWO.Value = null Then
 MsgBox "Enter an EWO"

The following code comes from FMS as a Tip.
In order to make this code work, does this code get placed in the subform or
main form?
On what event of what form (Main or subform) should this procedure be

Hello. I'm using Stephen Lebans navigation buttons form (from his site
www.lebans.com)- both of which are fabulous!
Our data entry person is wondering why she can't enter two new members in a
row- after entering a new record, the "add a new record" button is grayed out

I have a form in which a user will select a specifc course from a combo box.  
What I am trying to accomplish is that when the user selects a specific item
from the combo box (MISC-Project), a text box will appear asking for the name
of that specifc project (Misc_Project_Name) and ...

Can someone help me find an add-in that I loved at my last job? It was
a free-add in for the VBA editor. It added buttons to the toolbar that
inserted error handling code, basic code comments, or both.
I haven't been able to find it again now that I've started my new job.