I have a Form 'Delete' displaying records (Debits and Credits).
All the transactions (approx 10 at a time) have a 'Yes/No' field named
'Active', with the current records set to 'Yes".
I want to delete all the displayed records by changing 'Yes' to 'No' in the

Hello, all,
Access help states that 'You can set conditional formatting based on (among
other things) an arbitrary expression referencing another control'.  I
cannot find any info on how to do this. I would like a field to be formatted

I need to take certain action when the user pushes a navigation button.
Using "OnCurrnet" event will tell me that I already moved to another
record. I need to act before moving but after clicking a navigation
button. I actually also need to know if it was a new record navigation

I want to use a query to load a control.  I have minimal SQL and VBA know
how.  This is what I am trying to do:
I am starting off in Form![Chart].  Using AfterUpdate in Form![Chart].[24D1
CPT] I need to do a query: I want to select from Table![Insurance Company]

Please, check this: Open a New Form in a Design View. Lay down a Textbox, a
Combo Box and a Checkbox. Save the form and open it again.
Are the Backgrounds of the Objects sunken or flat? In my Access 2003
(11.6355.6360 with SP1) the sunken effect is set as a default and the

Is there a way to have balloon help popup when you a user scrolls over a
label? I found some code in VB help that uses the office assistant to popup
balloon help, but when I tried using it I realized there's no way to program
a label in it's  properties section.

This problem has plagued me so long I've reduced it to one combo box on one
form and one table to eliminate extraneous input. The table has two fields,
WordID and Word. The combo box allows the user to enter a word. If it is
not in the table, a message box asks if he/she wants to ...

I have a project I'm working on that requires me to calculate the speed of a
vehicle. Currently I have a table that stores records with a vehicle
identifier, their beginning and ending time and odometer reading. At the end
of the vehicle's movement, I've calculated the distance ...

I am trying to validate an odometer entry >= the last entry for this truck.  
From what I gather, I can't use DMax because the truck number for the
criteria is in a different table.  I've created a query to return the last
odometer and tried to use DLookup to get the result.  The ...

I have a fairly complex form that is opened in Data Entry mode.  The user
can subsequently change the mode to 'normal view' via a command button so
that the form can either be used to view all previous records OR to input new
ones (i.e. Data Entry mode is either on or off).  When ...

I have a very complex form with many different users changing and updating
the records in a network. My ambition is to logg the employee who made the
latest change to the record and to set the date of when the last change
occured.

I have a sub form that is set to datasheet view the and the user, uses a
popup menu with the standard Filter By Selection, Filter For and Excluding
Selection to apply filter to the subform.
The problem is if the user has applied filters to several columns when they

I have tried to create a function to make the first letter of user-input in
a textbox uppercase, if it is not already so.
The code I wrote is really very stupid:
Public Function FirstUp(s As String) As String

Using Access 2002, I am using the following code to set the source for a
subform
       Dim strSQL As String
      strSQL = "SELECT * From UnInvStockQ"

I have a table which is used to track mileages. What I am trying to do is if
there are records present, get the hightest mileage reading and insert it
into the form field. If the user is inputting the first record, I want 0
(zero) to be inserted into the field. Below is the code ...