I have a db that I use to track patient correspondances, its returns a
run-time error 2176, the setting for this property is too long, when trying
to use my date/time stamp after multiple uses for the same patient.   I am
able to use the date/time stamp 11 times with notes for ...

can a mdb file created in access 2000 be used (data edited / deleted & added
and reports produced) using an access runtime version rather than the full
version of access?
Cheers

A question for "best practice" in database design
I use two tables for Jobcard info in my database.   {tblJobCard}   and
{tblJobDetails}.
tblJobDetails is used to store product info used on each job and uses a

I have been moving data from one Access database to another and in my
enthusiasm, attempted to move too much info at one time. As a result, the
autonumbering was altered - it skipped from 875 to 1074. Does this mean that
the database has lost valuable space as a result? Does ...

I am trying to set up a database that has various items
that have a starting quantity.  As I place a new order
how does the table get updated, such that the quanity
remaining reflects what was sold.

I inserted a calendar in a form. It works ok.
However, By default, the month of the calendar is July.
(Whenever I open the form, July always appears on the
calendar.)

New to Access.  Two distant work areas created databases.  Similar, but not
identical format.  Would like to merge data bases.  No luck with linking, or
relationships.   Using Office 2000.  Have MS Press "Access 2002, Plain and
Simple" for guidance.  Either misreading or unable ...

I need to make a listbox or a combobox to find a record on a form.
The wizard does not offer the option "to find a record .. ..  .  " or
something similar which I believe that I have seen in the past.
I have only two options in each case:

I would like to give the user the option of sorting on a field that they
would like.  I have created queries where the user can enter the query
criteria.  But, I am lost when it comes to this.  I have tried a couple
things without much success.

Hola, I would like to open a form as a popup window.  When the popup window
is open I would like the subform to add a new record.  any ideas

I would like to semi hide (behind an opaque box) some optional buttons on a
form, but the transparency setting seems to either be on or off, unlike a
word object where you can ajust the level of "opaqueness". Im I looking in
the worng place to achieve this? thanks Tim

I have created a database in access 2000 where I can log characters in a
story for someone who is writing a book.  They want to use this for other
books that they plan on writing.  Is there a way to make a database a
template where it retains the look in view form every time ...

I have a table that is used to link books and authors. I think I originally
downloaded
the Access file from the Microsoft examples, possibly for books
but maybe for some other collection set. I have made some modifications over

Here is my problem and it may be 2 fold.  I guess I am using coding from 97
which does not always seem to work with 2000.
1) My "Recordset" declaration does not seem to be valid, since it does not
capitalize the method recordset.  It does not give me any errors but it is

I have an application so to speak I have developed using MS Access and I am
wanting to be able to legally distribute it to people without Access or even
with it no mattter... The application will be distributed for profit as well
so I am not sure the rules on this. I know I need ...