This has me tearing my hair out!  Objects previously deleted from a form
persist in the VBA object list evn though they don't actually exist.  I had
an object called Feasibilty which has been deleted.  When I try to acces a
column called feasibility (in another table), the IDE ...

I would like to change the caption on a toggle button to reflect its current
state.
I suspect I will put something like:
Me!myButton.caption = "inny"

In 'Private Sub Command2_Click()' I have a check if any of the available
checkboxes has been activated (via an if loop). If not, a Message is
displayed.
How can I exit the Private Sub after this message has been displayed, there

We are experiencing an intermittent problem that is affecting some forms in
an Access XP database. At some sites the problem occurs almost everytime and
at others it is rare. The database is split into a frontend and backend.
What happens is that when viewing a form, if a new ...

I have MainForm, SubForm1 and SubForm2.  If the CheckBox on SubForm1 = True,
than I would like the AllowAdditions = False on SubForm2.  I have the
following code in the On Current Event of SubForm1
If chkboxName = True Then

I have a 'control' table, tblMetricsControl, with one record with some fields
that I need to reference.
I tried ADO and got connected ok, but then I get an error that the 'database
has been placed in a state by admin that prevents it from being opened'.

I have a form containing 3 subforms. Each of these subforms is a continuous
form based on a query, in this example, it is for invoices and tells you
which are due today, which are overdue, and which are still outstanding.
Running the query externally reveals one invoice which is ...

thanks to Allen Browne's help, I managed to get a recordset from an
option group, for a report.
I am trying to further filter the report down to a department number
(FacilityID).  There are two departments I am trying to isolate, nos 18

Is there a function that will take an Object as input and return a string
that corresponds to an absolute reference to the object.  In other words I am
imagining a function like:
Function GetObjectRef(TargetObject As Object) As String

I am trying to change the color of a text box if the value falls below a
certain number. How do I do that or what is the expreesion that I can use in
a form field to do that.

I have a subform that allows the user to set budget amounts for each service
that will be used for a specific job.  The user wants to enter either a
dollar amount and have the % of total budget be calculated OR enter the
percentage amount and have it calculate the dollar amount.

I have a text file which needs to be imported into a db.   The file
structure unfortunately contains extra characters in the various fields
that are generated by the ancient program that exports the text file.
is there a way to strip out hex codes, underscores, or ascii characters

Following a book I read I add new columns (fields) to an existing table in
via code in Access2003 I should set the SQL Server Compatible Syntex to
ANSI92 in the Options/ TablesQueries tab.  When I do this I notice the
AutoExpand  for combo boxes no longer works. Is there a way ...

OK, I am having problems with refreshing when I go to the next record. This
is what I have:
2 unbound Combo boxes cascading.
When I click on the next record, I want the combo boxes to reset to blank

I have tried to get combo box to update it's list after adding a record to no
avail.  It works fine when I close and save the database which sense as the
following query is run when the form loads:
Row Source: SELECT Login.[Primary Key], Login.StudentID FROM Login;