I was trying to export a form as an excel spread sheet, i've never had a
single problem with this in the past.  It would export each listbox on the
form, and then put each value as a row.  For some reason now, its giving me
hte column headings as the listbox names, which is fine, ...

I have a report with repeating lines
I need to have line 1 with look 1 (say background color to black)
and line2 with look2  (say background color to white)
and line 3 with look 1

Running a large 2003 database in compatibility mode. I have always used in
VBA FilterOn =False at the open form event to remove previously applied
filters. Also some forms I use DoCmd.ApplyFilter to open active records only.
Worked OK for years but now in 2007 I get a message ...

I've got a form that displays single records from a table (i.e. one at a
time). It has record selectors and navigation controls.
If I just open it directly in form view the keyboard navigation controls
like Page Down to go to the next record, work fine.

Recently, we converted an Access back-end to SQL server and discoverd
hundreds of connectons per hour for about 25 people using it. Finally, we
figured out that very combo box with a table query as rowsource created a
new login every time the form is loaded. We're using windows ...

I have a form that loads the data directly into a single table. After I
scroll thru all the fields the data moves to the table, that works as
planned. What I am trying to figure out is a short-cut to save re-entering
data in the fields that doesn't change.

I have a Form, I'll call it "4". Within this Form is a sub-Form, I'll call it
"4a". I have a couple different buttons on Form "4" which effect Form "4a" in
different ways.
One of the fields on Form "4a" has the name "comments". I want to add a

I have a table name "Money" with a field named "returned" (yes/No).  I'm
trying to count the lines where "returned" = "Yes".  I'm using this code but
it gives me a -1.
xReturn: DCount("[returned]","money","[returned]")=Yes

I have a database that I enter a number in two columns and need the
difference to be calculated and inserted in another. I want this to happin in
the form I use to enter and not in a query. I tried using a query but I get a
circlular reference error. I can get the right result in ...

Folks:
I have changed a form in that I don't care about a particular option group
anymore.  I don't have any validation rules set at the table level but when I
try to create a new record it pukes my message about "you must have a

Access 2007
Based upon 3 fields. Caller (text field), Status (Combo), Inactive (Y/N)
I want to first sort alphabetically by caller
Then

I have an unbound textbox that I use to search for and jump to specific
records. Everything works fine until the user clears the textbox.
Here is the code I use:
   Dim rs As DAO.Recordset

I have done it in a query. I need to eventually get a table that can be
accessed by an external program and it needs the sum of two entered values.
I'm trying to automate the process. The only way I can access with AutoCAD is
to have the result in a table. I have tried to enter ...

Why won't the following code place the cursor in the field "FundNumber" in
the subform?
Private Sub Command10_Click()
On Error GoTo Err_Command10_Click

One more question!
I am trying to create a listbox on a frmProjects. The listbox would be
called "MyProjects" and be populated by the users that is loged on
according to his/her log on name and it would have to match the