I have a form that shows suppliers and a subform that shows the products
they supply. Some companies supply products in Bin sizes and other
companies supply products in lot sizes.
When a companies details are up on screen the following code shows me only

Following on from a recent post regarding Identity fields with David Portas,
I was discussing a few issues with a collegue and an interesting issue was
raised.
Namely, creating an audit trail in which every row is assigned a unique,

I try this as row source for a listbox
Dim sql as string
sql = "SELECT * FROM tblClients"
With myListbox

I'm sure the answer to this is easy but it's eluding me!
I have a field that I want operators to only be able to
enter numbers into. I have set the input mask to zeroes
and that works fine.  The problem I have is the length of

I have an old access-database (97) that can't be converted to a newer
version. How cam I compact and repair this database. I have no machines with
Access 97?
regards

From a textbox on a form that is the "criteria" field for the query, I want
to be able to find records with names starting with the letter : Like"xyz*"
from a textbox on a form so the query will return a *bunch* of records that
match that user input. this maybe 2 letters or even ...

Any help on the following problem would be very much appreciated.  I'm
using MSAccess 2000 and have just a smidgen of experience with coding -
enough to know that something can be done, but not enough to figure it
out quickly.  Thanks!

I have a Form with a ListBox and a Command Button.  On the Form, I selected
the OnKeyDown Event and placed a Stop in the vba code to stop when it was
reached.  When the form was open, I tried press any key and the OnKeyDown
Event never got to the Stop.

My form is a preview record form.  The Users cannot update the form, but
can preview the records.  When the User clicks on the navigation button at
the bottom the record changes for each record, but when they click on the
drop down for the "name" the record is locked.

I can't scroll thru records using my combo drop-down.  When I click my drop
down with the code below, the record changes, but not the recordid.  What
happens is that the new record overlays the current recordid.  What I would
like is for the User to click on the combo box and pick a ...

How can I goto the record I select in my combo box?  If I select "student
id12", I need the form to pull in the records for "studen id12".
Thanks for your help!
Denise

I have a main form "Rental Details" with a Tab control. Each Tab has a
subform that is linked to the main form. Both subforms are linked to the main
form by the fields CustomerID and TransactionID. The problem I am having is
when I enter data in Tab "Received", subform ...

We have a small DB called "Worklog" that is stored on a local network drive.
The front end and back end are stored in the same folder.  The DB uses a
Main form, which we use to log in and track incoming jobs.  The Main form
contains tabbed subforms.  The Main form is accessed ...

I am using code from post of 11/4/2004 Manipulating Excel via Access by Ken
Snell.
I need to be able to import the data into tbltapes that is has relationship
to tblTracker. When the record is being created the date and requestorname is

I figured out my first question on how to have text display bold and
underlined when I send it to a email maessage.  It is called HTML.  Now the
next question.  I need a function to parse through a memo field and
everytime it finds a Line break I need to insert <br> when passing it