Why would the following line, when queried in the immediate window (?.cells
(94,1).address) return a value of "$A$187"?

I have a cross tab query that is displayed on a form tied to the table that
houses the raw data for the cross tab query.  Each line in the cross tab
query comes from 3 lines in the table - one for each month in a quarter.  In
the past, I would use the value in the listbox to ...

I want to rename a file that is in a listbox.  How would I do this?
Thanks
DS
Name Forms!frmRestoreData!ListPaths.Column(0) As "C:\ProServ\DB\Data.mdb"

I have 2 date time picker on my form and use those 2 controls in my query
like following.
Select myField from MyTable
Where MyDate between [forms]![MyForm]![dtp1] and [forms]![MyForm]![dtp2]

I am trying to create a database whereby certain information is
automatically filled in for the user based on the day of the week, the
week in the year and the time of the day.  However, I wonder if
there is a way to do this that will not involve lots and lots of

Access2003-I have a DB that logs certain events when a vehicle is deployed.
Each deployment is a record of events during that deployment and a subform
collects the events information.
Now, I need to add names to the primary form by way of a list box. There

i have a table with a yes/no field call "Edited". i have a button that
runs code to set the "Edited" field of a selected record to "yes". the
code also set the rowsource (using SQL  Update and Set statement) of a
combo box to display only records with the "Edited" field = "No". the

How can I convert a number field to Auto number field, The sequence
numbers have some gaps. It is one time work. I made a mistake for my
system. I just try to fix it.
Thank you for your help.

I have an Access 2007 form on which I'm trying to display the body or message
of an email that is selected from a listbox showing email dates and subjects.
The data is coming from a table called tblEmailLog.  Since a textbox is
limited to 255 characters and the actual message ...

I have a form that adds records to a table. On Form_Load I run the
following code to make sure that the user is always entering a new
record at the end:
       DoCmd.GoToRecord , , acNewRec

If my Front End on a FE/BE setup goes south and I reload a new Front End do
I need to relink?  If so can I do it through code?
Thanks
DS

I have a form that shows a specific resume called up by Worker ID.
I have a subform that shows the languages they speak, they are yes/no fields.
I want to only show the fields that have a true value on the subform.
Not sure how to go about this?

Is there a way to save the RecordID of a subform Record to a variable when
the record is selected or has the focus?
Thanks,
Sam

Hopefully this will be a simple bit of ignorance on my part.  I am using the
following code in a general Module:
Function Append2Table(cbo As ComboBox, NewData As Variant) As Integer
On Error GoTo Err_Append2Table

Is it possible to change the field size through coding?
If yes, how do i go about doing it?