I am wondering what tables and relationships  I would have to have to keep
track of one or several employees commissions per transaction.
One tracsaction can have one or several employees work on it, and the
commissions for each employee depends on how many employees worked on it.

Access 2K
dim MyStr as string
What is the maximum amount of text or bytes that this variable can
store?  Does anyone know?

Anyone that may be able to help.
I have MS Access 2000 installed.  I need to convert some MS Access 2002
database files to MS Access 2000 needed for a course.  Does anyone know how
to convert?  I tried but just get an error message to upgrade, but the MS

I'm running Access 2002, split database client server.  If a client
crashes or doesn't sign off cleanly, how does this adversly affect the
database?
I copy my database and client forms to CD-rom each day, once per week I

Hi and TIA!  I have a field that I want to convert from Julian to a short date.  I've tried several
procedures, but can't come up with the right solution.  What I'm trying to do is convert
4023 to 01/23/04.
If you know of a solution or somewhere I can find the answer I would ...

Im new to access+sql server.
I know i can easy export my access database to sql server. But is it
possible to easy modify data structure on sql server from acc(adding
deleting field, modifying forms). I mean is it possible to modify

I have a table that holds customer contact information.  The table has
three email fields (Email1, Email2, and Email3).  So each customer can
have up to 3 contact email addresses.
I need a query that will return the customers name with each of their

Hello everyone.  I am pretty new to Access and writing SQL in Access, so
bear with me.  I have two tables, CUSTOMER and INVOICE, linked by a customer
code field.  The customer table includes all customers, while the invoice
table includes only the customer codes of those customers ...

I am creating a report / letter that automatically fills in fields from
a form when a command button is pressed on the form.....
  The idea is to create a report /letter containing member address and
specific vehicle details from data displayed on form...  (member can

I am starting a project to track inventory for a medium size business.
The business would like to start off running the Access database on a
single laptop and move the laptop from one area of the warehouse to
another area of the warehouse as the database is needed.  They want to

I just got my first Access project that I am getting paid for.  I have
done other Access work for non-profits that I did not get paid for.  I
definitely have the work but we did not settle the price yet.  Can any
of you give me some advice on how much to charge?  What factors

I have a form that allows the user to selct items from a listbox and combo
box.
how do I reset them ready for the next set of entries. I thought I would
have a clear button.

In a multi-user environment, I have a table that stores hyperlinks to
documents that are stored on the machine that hosts the mdb database.  The
table entry looks like this:
ProductDescription.htm#file:\\DBHOST\C$\Documents and

I have created a pretty straight forward database for one of the
departments where I work. It's based on a design I used sucessfully for
my own department so all of the components are  tried and tested.
Everything was working swimingly until now. Whenever a user opens the

I had to take a Access 97, 2002 and 2003 test for a temp agency. One
of the questions was to "filter the hospital macro to show only the
hospitals associated with hospital ID #"  Can't remember the number.
Since it was one of those stupid ProveIt tests it would not let you