hey all.  i have a report for sales commissions that i'm having a little
trouble with.  each transaction may have either 1 salesperson (90% of the
time) or 2 salespeople.  in the event that there's 2, each of them get half
credit for the sale and half of the commissions earned.  my ...

I made a form and when i press F5 show a message "network error
connection".  what is wrong with my access. can anyone help me?

As our database runs, there are occasions where someone in the
organization should be notified about significant events, such as
automatically advising the Design Engineer when a new part has been
added or the Production Manager when some other event has happened.

I have the following which works okay...
   Dim arrayTable As Variant
   Dim varTable As Variant
   arrayTable = Array("SG", "Oakland", "Server")

I've a table called GReg with the fields GNumber, ControlNumber,
ArticleCode, ProdNumber and Date.
In a form I select the ArticleCode from one combo box, and I define the
number of records to create.

Dear,
I have a form that is opened using a sql statement:
Part of the table structure:
-----------------------------------------

I need to make a field put uppercase letters in it when a lowercase
letter is entered into that field. Is there an expression to use or does
it have to be written in code?

Hello group,
I have an SQL statement which pulls data from a table as follows:
   " SELECT tblSites.sites_siteno, " & _
   " tblSites.sites_sitename, " & _

Ok, my problem is the following:
I have very complicated Access 97 databases that link through ODBC to
Sybase databases.
Now in some of the forms controls I had queries that used as "where

i have imported two tables from excel each table  contains information
about a team
what i want to do is display the records on the same form
side by side

This question is off topic but you folks have the answers.  I do Access
development work at clients offices using my laptop. I want to purchase
a new laptop but I am wondering if I need a laptop that offers more
screen resolutions than just 1024x768 anf 800x600?  In retrospec my

Is MS Access a true RDBMS?

I'm trying to do the following in Excel but am having a really tough
time and am wondering if Access will do it....
I have  a database matrix with about a half million rows in it and
about a dozen columns.  I have another database with about 1000 rows in

Access 2003.
I would like to indicate required fields with a special background
color. Easy for parent forms, but I also have several subforms in
datasheet view. For those, I would like to color the vertical column

Each  day a user is supposed to import a list of information into a
database table.  The user only has 30 days to import this information.
After 30 days the information is lost.  I need to be able to create a
form or a report or something that a user would be able to review and