I am working on Access 97 database. I am required to provide a facility to
enable update to reports reports through data inputs. Is it possible to
convert the report from Print preview to Datasheet mode?  The aim is to
Timestamp the data entry and then update the additional data ...

I have a search box on a form and a handler for the keydown event, such that
when keydown sees KeyCode = 13 I do a search for a record matching what is
in the search text box.
Now I notice several things going wrong :)

I have a Form with a lot of controls on it.  To the point that not all will
fit on 1 screen.
So I set this Form's "Scroll Bar" property to "Vertical Only".  Yet the
Vertical scroll  Bars do not appear when the Form opens, you can't see the

I have a form with 4 Multi select list boxes and 1 text
box. I need to construct a query that uses the input from
each of these list boxes and the text box. I have code
that builds a successful SQL statement with the in()

I would like to dynamicly set the size (length) of a text field based on the
"trim" string characters.  I am "fitting" the text (box) on a form with a
background that I want to preserve, except for the text box area.  It is a
bound text box.

On a form, I have placed a command button that opens the user's email client
and places the email address from records in a query into the 'To' line. The
process works fine in a copy of the database that I was working in to
develop this, but when imported into the original database ...

Wondering if someone can shed light on a data corruption problem.
I have an Access database reading its data from a back end .mdb file.  The
main data entry form is bound to a query which obtains data from two tables
which have a one-to-one relationship: ie primary key linked to ...

Hello. While I have experience with other types of code, I have never coded
in VBA. I'm assuming that since this would be relatively easy to perform in
other code, it will be here, but feel free to tell me if this is a bridge too
far for a beginner.

I'm in process of converting someone else's database from Access 97 to
Access 2003.  Some of the code is kludgy, but I don't have a lot of time to
accomplish this, so I'm trying to avoid major redesigns of form
functionality if at all possible.  But I've just run into my first ...

I need to say if a particular value is entered, open this form.
I've tried "If [field] = [value] then
             DoCmd.Open [form name]
             End If

My problem (this time) is that the following code ( just as i write it
below), does not return the same records as if it was a query
dim rs as dao.database
   Set rs = CurrentDb.OpenRecordset("select * from print_positions where

Is their a way to Associating more than 1 label with the same control ?  If
so how ?
thank you,
Jeff

I have created a custom menu for a database.  It only has a few simple
things on it (File, Edit & Other).  In the Startup options, this menu has
been set in the MenuBar option.  It works fine on my computer but on a
client's computer, each menu is only populated with 'Other'.  ...

I have two tables that contain a CustomerID field. One of the tables (Table
A) contains the Customers name and address etc.. info - the other table
(Table B) simply carries the customer ID as well as other data...
Is there a better way to display the new customer name info from ...

Hi I need to known what a policy excess should be, how do I go about setting
it up so that the correct excess shows in my ExcessDue field?
The drivers age is in "TextBox480" on form "COEvents"
The field "LicenceHeldFor" and "ExcessDue" are on the above form, all the