I'm looking for a way to remove the carriage return characters and
other unwanted characters from barcode data entry. specifically in
access and excel to speed up some of the data entry.

I've got an A2K database with a report that generates any number of
random medical record numbers.  The user inputs how many numbers they
want and report uses the Randomizer function found on "The Access Web"
site to generate these numbers.  Out of 38000 records, there are 900

I have a table that consists of some fields like carNum, ShipDate,
ReleasedDate. I want to select all records, but i want the selection
to start where the ReleasedDate is null/empty and until end of file
table:

I am trying to write a query that counts up the number of accounts a
user is assigned, and then inserts this count into another table.
The table layout is as follows:
tbl_Users:

Hey guys,
This database is going to give me the sh.ts eventually. I have to look
at different ways to implement this accross the company network. As it
stands, the access database needs to be accessed by approximately, 6-8

I have a form as follows:
Main Form (To Select Customer)
Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
form

I want to make a form based on a table with many records. I used the
wizard to make a 'form in table layout'. The wizard is not able to
make the form due to too many fields. I discovered that the standard
form properties gives a maximum form width of 55.873cm (22 inch). How

Background:
Another department intends to ftp a .txt file from the mainframe, for me
to process.
The objective is to write a vb script that would be scheduled to run

I have a query that creates a graph of bookings from the course start date
looking back 20 weeks based on a running sum.
I also have a query that counts the number of bookings before that 20 week
date for that particular course start date.

I can set the ColumnWidth property of a datasheet in VBA like this:
Forms("frm0").Controls(strForm).Form.Controls(strCtl).ColumnWidth = intCw
But when I try to set the RowHeight like this:
Forms("frm0").Controls(strForm).Form.Controls(strCtl).ColumnWidth = lngRh

I have written code to transfer a table to an Excel document.
However, I do not know the code to add some "bells and whistles" to
the document.  Can someone direct me to a reference on the Internet
that I can use for what more can be done?

I've asked about this before, and people were very helpful, and I have
used the advise quite a bit, however I have run into a spot of
trouble...
I have a form that the users uses to change the salary of an employee.

   Since Access doesn't support COUTN DISTINCT, I'm facing a new
problem I didn't take into account: how to get the count of PK's in a
complex query. I create queries on the fly -this means I can't use a
stored macro or even a query view-.

I am running MS Access 2.0 and Access Basic. Do any of
you remember issues where Now() returned a time other than
the system clock value. This just happened to me. Rebooting
cleared the problem. I'm curious as to what might cause this.

Just installed SP2, and Access 97 reports fail to load.
COMDLG32.dll has changed.
Unistalling SP2 fixed the problem.
Is there a work around to have SP2 and Access 97?