I have a form where during usage I will change certain control property
values to something other than the original design-time default values.
Under certain circumstances during run-time I want to change them back to the
original values - specifically the Enabled property.  How do ...

I have designed a multi user application, where I have 1 MDB as the Client &
another which holds the data & is placed on a networked Drive.
The client has the Linked Tables to the Network one.
At random times when some users try to do something in the program this

Setup
Form1 --> unbound (just acts as a container for the other two forms)
   Subform1a  -> Bound to Query1
   SubForm1b - Bound to Query2

Is it possible to take a textbox and have it expand to a new length depending
on the length of the info in it?  I could have company names show in a
textbox as short as 3 letters to one that would have 24 letters (or any new
ones that might be longer).  The info in the txtbox ...

I'm using this logic to import Excel data into Access.
Public Sub ImportProtected(strFile As String, strPassword As String)
Dim oExcel As Object, oWb As Object
Set oExcel = CreateObject("Excel.Application")

I have a main form that is unbound with an unbound combo box.  The users
would like to be able to add  a New CTAName to the list in the combo box.  I
have tried to use the NotInList event, but something is not working.
Here is what is happening when testing:

Anyone know how I can detect if a form has been opened with acDialog set?  I
have a situation where the form needs to behave differently if opened in
acDialog than in acWindowNormal.  Basically, I need to create forms that can
be optionally used as custom dialog boxes, but not ...

I have a query and a report based on it, which as standalones work
perfectley. Once I add a command button [using the wizard] to a form they
both then return no data. The parameter being passed from the form is a date.
I have checked every form and button property, they are ...

I have an email sendobject routine that sends an email to the user.  However,
if the user decides NOT to send the email, they get a runtime error 2501..
"The Sendobject action was canceled"  with the END  DEBUG buttons.
Is there a way to Override this system error with my own more ...

I have a rather general question regarding the maxxing of the forms and seek
the thoughts of those of you who have maxxed in the past.  Where is the best
place to put the DoCmd.Maximize?  In the Load?  Open?  Activate?  And so on.  
Or in several different places?

How can I change the toggle button that is pressed in through code? I have
a form with toggle buttons to select a company division which is stored in a
table. Other selections on the form run macros to print specific reports for
the selected division. A small number of the macros ...

I am using Access 2002 and I am using a text box to get the time.  In the
Data tab in properites I put Now() in the Default Value and in format I am
using Long Time.  My problem is that I do not see the seconds change.  The
time changing only when I close and open the form. Can ...

I currently Have this form setup in 2 sections. The first sectio
includes 2 text boxes for Eligibility Number (field name
EligibilityNum) and the second for School (SchoolName). The secon
section is a subform called sfrmSchools that includes all th

I have a table that has 5 options that populate a drop down menu in one of
my forms. The users have asked if there would be a way to have a selection
that has ALL. So if they were to have picked ALL they would have all entries
returned not just one.

I have a form with a button to insert a new record, but i want that the
button put in the field of that new record, the next number as the last
record, similar to autonumber(but i don't want the field to be autonumber)
If someone could tell me the code to put in the button to do ...