I have an access 97 app which I have the option to upgrade to either access
2000 or access 2003. Which one should I choose. I have heard nasty things
about access 2000.
Thanks

I currently have three list boxes on my form, the information on each
one is determined on what was selected on the one before it.  The
problem I'm having is the information that is used is pulled from
another program and is duplicated a lot.

I am having some trouble with recording a [Total] field on a form into my Table after formatting it to calculate several fields on the form.
If i just put the amount in the [Total] field and have it linked to the correct field in my Table, it will record it. But not the other
if I ...

Can anyone tell me how to remove or change the automatic rounding of numbers in a box.
The box has already been tested with General Number, Fixed, and Standard Formatting
with the decimal place being selected for 2.
Ex. If I key the number 2.25, or 2.5, I get the result of 2 .

I have been running make-table queries to create 10 tables (one for
each unit) that are exported to Excel spreadsheets. Because of my
limited knowledge with code, I've created 10 separate queries to do the
job and then run a macro to do the exporting.  I know there must be a

Is there any way I can tell which key was pressed in VB Code using the
OnKeyPress event?  I'd like to know if the user is pressing the up, down,
left or right arrow.
Thanks!

I am attempting to use AppendChunk() to write binary data to a memo field
in Access 2000. My initial call to AppendChunk() results in a data type
conversion error. Any suggestions? Here is a VBA function which demonstrates
the problem.

I am attempting to write binary data from a file to an
OLE Object field, and then write the file back out from
the database. I am reading and writing the files in
binary mode, and using GetChunk and AppendChunk to read

When executing a Crosstab Query I see only rows (defined in a row heading) that have values (defined in value field) in at least one column (defined as column headings). How can I make a Crosstab Query that shows all rows, regardless they have values in column headings.
For ...

Is it possible to print varying numbers of labels from Access?

If I want to build the same on click event on several labels do i have to
build it one by one or I can group label_1, label_2... somehow in vba and
than proceed with writing on click event?
Thanks

I would be grateful for help with the following:
For a booking system
tblBook(BookedItemId,DateBooked)
tblBookingPeriodAllowed(PeriodName, PeriodStartDate, PeriodEndDate)

I have a progress note table where a person's social is entered, the
current date and then the note.  I can have serveral notes entered
under the same date and I can have several notes entered on the same
social.  My question, how do I lookup and display a certain note based

I am confused to my situation of having an access database 25 mb  on a wan
due to the situation of telephone line cost per minute. I have tried indirect
replication with modem 50 kbps but it is slow about 20 minutes even when
there is no changes in the two database!

I am stuck with this problem. I need to create  form with checkbox that
must be populated dynamically from a table. For example, if I have a
table called Fruits, and the values are "Apple", "Orange", "grapes", I
need a form with 3 check box (should be able to view all in the same