FieldOne and FieldTwo are controls on my form that have a required data field
in my table.  A user types in a value in FieldOne, then selects a value in
FieldTwo from a combo box.  If the user deletes/changes what he's typed in
FieldOne, I need FieldTwo set to null so that the ...

I have an tabular form with check boxes that need to be changed but the form
is not updatable. I wrote some code that seems to work but the form needs to
be requeried to show that it has been updated. The only code I can get to
work with this requeries the entire list which ...

I have a query that returns a result. I want to use the result that it
returns and have it display in a text box on my form.  Here is my code:
Dim strSQL As String
strSQL = "Select ID FROM [Computer Inventory] " _

How does one programmatically assign something to the second column of a
listbox?
I was going to use a combo box, and set its after update property in order
to run a query that puts a pair of counts in a seperate listbox, filtering

I have a delivery slip form, I have a button that when clicked opens the
project form to edit or enter a new project. What I would like to have happen
is that when the form is closed the project combo box is updated with the new
information.

I'm using the =ColumnHistory([RecordSource],"Notes","[ID]=" & Nz([ID],0))
expression and want the results to be listed newest to oldest.  
I've searched all over and can't seem to find a way to do this.  Can someone
here either confirm that there is no way to reversing this order, ...

I have a form with a subform.  The 2 are not related based on the primary key
of the parent form. From the main form, I have a combobox who's event calls a
public subroutine in the subform... and that subroutine sets the subform
filter.

Hello All Again,
I hope I can explain this correctly;
I have a main form, on that main form I have a combo box to select criteria
from a table, [cboSelectStore], I then use a tabcontrol to show each

I have a subform based from a "Coding" table with a combo box (Charge
Description) in which lists Charge Descriptions and Charge Codes based from
"charge code" table. When the charge description is chosen I have the control
source on the Charge Code text box to automatically ...

I have a form that I am testing out a scenario to see if I am apply it to
other forms in my project.  The form is called frmTest.
The form is bound to the table TestTable and has columns:
Primary Key , autonumber,

Someone posted about compacting a backend file from within the front end. I
have had at least a 99% failure rate doing it this way. However, using
Tools - compact works but is a manual task.

I have a "Data Entry" form with a few fields. The fields are "List Boxes".
It is so easy to change your selection in the list box by accident. How can
I prevent accidental changes. I would like to configure it so that if someone
wanted to modify a list box they would have to hold ...

I can't seem to get my e-mail button to work. I have a book that says I can
do it with a DLookUp command.
This does open the E-Mail but always puts the 1st records e-mail address in
the To: Box.

I have a database being used as an information retrieval system. Users don't
add anything, just look up process, phone numbers etc.
On my primary form I have a field that if the information sheet (or record)
they are viewing has a link to another record then the name of this ...

Is it possible to have a button on a form that will delete certain files (if
there are any) in a specified folder?
I realise that such a thing would need to be used carefully, but provided
that I could ensure that it would, such a facility would be extremely