My client wants to make their Access 2007 database available to
offices around the country with multi-user permissions set to control
access to the tables and forms, etc. The easiest thing would be a
client/server app, but they are concerned that accessing the backend

I am working with a multi select list box in access.  The code is:
Sub MoveToCustomer2()
   Dim frm As Form, Ctl As Control
   Dim varItem As Variant

I'm trying to size a subform control to display all of the records (thus
eliminating the vertical scroll bar). I know that the CanGrow property is
only for printing.
My thought was to determine the number of records in the subform and the

Let say I have a data table that list a name, ID for the last name, a
field linking it to another table, and a field listing if an optional
LinkStatus.  I want to run a check to determine if each last name ID
has a Link to the external ID and exclude ones that have a linkstatus

i have a check box on a form.
when this checkbox has a tick in it , this must enter certain text into
another field of the table that the form is bound to.
how can i do this?  with some code in the checkbox properties ???

I'm sorry to post twice...but I just traced the problem again and found
additional information
Problem:  Attempt to open a form on top of already opened forms results
in screen flash but the desired form does not appear.

Having upsized my client's back-end DB to SQL Server, the following
query does not work ("Operation must use an updateable query").
UPDATE tblbookings INNER JOIN tblREFUNDS ON tblbookings.TransFromID =
tblREFUNDS.BookingID SET tblREFUNDS.[MOVED TO NEW BKREF] = tblbookings!

Has anyone had experience with these or other Access recovery software
products for use with replicas?
Kernel for Access
http://www.nucleustechnologies.com/Access-Databases-Repair-Software.php

Can it's possible to use a customized QAT in Access 2007 with a Ribbon using
"USysRibbons" ?
because in Access options i can't select 2 ribbon name.
Thank's

Does a querydef object's returnrecords property automatically
equal true for all SELECT queries? Or, must the QueryDef Object
ACTUALLY return at least 1 or more records WHEN RUN in
order for the ReturnRecords property to equal True? I'm speaking,

Suppose you have tblVehicleJobs with [VehicleJobID] keyfield.
And say there's another table used to keep records of inbound
letters you receive on each car. That table is named tblinLttrs
and has [InLttrID] as it's keyfield and has [VehicleJobID] field

I have a form that is longer than the screen size, so there is a scroll
bar to the right of the form.
Inside the form there is a memo field that is longer than the height of
the screen.  It allows text to be entered adjacent to various checkboxes.

I am trying to send mail using CDO.
The line below ("objMessage.Send") blows with this error:
-21472200960 "Send Using" configuration is invalid"
Here is the link where I got this code:

I hope somebody can help.  I can't get into the specifics of my
project, but I'll try to create a simple example:
tblVehicle
*    VIN (text box)

I use Stephen Lebans modReportToPDF. In it is a function
declared as Boolean. Inside the FN, there's a line assigning
the FN name a value that's not True and not False. I'm thinking
that's an oversight so I changed it from "" to False. Just wanna