I need a solution for the following problem. I have a DAO recordet rcdMtlu
and need to find a record based on two criteria, both criteria are declared
as strings both fileds are text boxes.
rcdMtlu.findfirst("firstname = " & Mname & "" and Lastname =  " & Lname & """

I have added a checkbox to one of my reports and depending on what other
checkboxes on my report are checked off I want the checkbox I added to either
be checked or unchecked.
Here is an example.

Access 2003. Continuous form with a check box (Yes/No) for each record.
Default value for check box is no (unchecked). User selects record by
clicking on check box. Form footer set up to display total number of records.
Using =Count(*) for that number, and it works fine. Also ...

I have a form to calculate daily takings. A button starts the code to open 3
other forms (with Echo False), that each calculates 3 different variables
that should be reported in the first form.
The result is zero from all of them by running. But when I step through the

  I am trying to obtain the names of each control in a form.  I was hoping
to use code similar to the following:
For each x in forms("DataEntry").controls
  debug.print x.name

Hi to all,
I am getting the error 3061 Too few parameters atthe update statement  and I
would like to know what can cause this
the code I use is this:

Hello everyone. Using A02 on XP. Have a form that requires
entry of an amount twice for verification purposes. My
msgbox works fine but this morning a tech called me over.
She was getting the error but was looking at the fields

I'm getting an invalid argument message (run-time error
3001) on the following line:
Set rs = db.OpenRecordset("SELECT * FROM
tblLinesRequested WHERE fldRequestID = " & Forms!

What wrong with this:
Private Sub Command11_Click()
Me.Filter = "[dr_work_competed] is Null"
Me.Filter = Me.Filter & [dr_work_gp].Value =

I have two sub reports. One works fine but the other takes about 10 tens
minutes to run. When I run the query itself which is used as the record
source for the sub report it runs fine. When I run the main report without
the problem sub report it runs in about 3 seconds if I add ...

Hi to all and thanks for the quality work
I have a form, frmPolicies, and on top of it a subform,
fsubClients. On fsubClients a have a combo box,
cboClientID. How do I refer to column(0) of this combo box?

Does some exist it sorts things out of the access to speak good morning?

I split my database into data (tables) and application (forms, queries,
reports, etc.) When I attempt to view the visual basic code behind a form
(on-click event on a button control) I get the following message ...
Error accessing file. Network connection may have been lost.

I gave up please help. I need the correct syntax to change the color of a
trend line. I can add the trendline. I can change its type but I cannot via
VBA change its color.
Second problem is there a way to select more than 6 legends to graph. The

Through this forum, I have just learned how to split my database into data
(tables) and application (everything else). My application would be ideal if
I could have a seperate back-end database for each customer, as each project
is short term, then the data for that customer is ...