Help - I am trying to get my head around choosing Primary and Foreign Keys. I understand Primary in that I have chosen the Retailer I.D as my primary in the retailer table. Can this now become the foreign key when found in other tables or am I to look for a completely new field.

I am using Access 2002.  I had the following problem:
Example No. 1
Line 1) SubTotal      : 480.52
Line 2) RoundOff      :    + 0.48

how do I view a form in html?
One field i use to update my web page has data reading: Approx. Size<br> 3
inches
I would like to view the form like it will appear in html:

I keep getting the following error when I try to open a pop-up form from a
sub-form:
The expression On Click you entered as the event property setting produced
the following error: A problem occurred while the Database was communicating

Can anyone recommend a good Access book(s)?
I am a fairly advanced VB, VBA, SQL Server developer and did some Access
projects a few years ago.  Just got a new assignment and am looking for some
advanced Access books.

This is my first time making a database with multiple tables.  I am
wondering how to get all the fields on these tables to one form.  Here is
the information about my database.  I posted about this database before on
5/1 and this is how I set up my tables.  If I didn't set the ...

I'm in the process of setting up a new table and I designated one field to be a lookup using the wizard. I named the field 'business' to match the field name in the customer table and told the wizard to use that particular table and field to 'lookup'. After I clicked Finish, it ...

So I was told how to do what I wanted to know, and well I
almost have it working.  My utter lack of knowing what
goes where is playing against me I think.  Here is my code
that was told to me, filled in with what I beleive to be

I always make combo boxes on my forms for look up lists because I know how
<g> What is the best way to create a look up list, combo box or list box and
why?
Thanks,

I hope this isn't a dumb question, but I have made myself
a nice form and the information that is in the first
record, most of it needs to be carried over to the next
form, and I would prefer not to retype it, just have it

Does anyone know how to quickly modify a bunch of cells? I have many mdbs with tables of numbers (ie 236, 273, 456 ...). I would like to: add 300 to all the numbers in column D, add 450 to all the numbers in column E, add 650 to all the numbers in column F and so on.... Are there ...

I am designing a database for a client that needs the
stock balance of items for a particular date. The items
supplied minus items issued gives the the balance for that
date. This balance now is to serve as the balance carried

Hey all
I just moved from Access 2000 to 2003 and an application of mine doesn't work anymore. It's using VBA which is running vbscript which is running an ftp command. Any ideas on why? (Here's some code:
Dim o As Objec
Dim stSrcFile As Strin

I want to create a -form- in access that will be used for documentin
material that has been recieved in through my department. It will nee
fields such as PO#, Part#, QTY, Supplier, Date, Inspected By, an
Comments.

Can we pulish/enable MS Access Forms and Reports on the
Web?