In my database I have 3 tables that show what stock I have or have ever had.
They are called [Teas], [Ceramics] and [Gifts]. Their primary keys are
[TeaCode], [ProductCode] and [GiftCode], resp. (At the moment each of the
above fields has a different format but if it would make ...

Bill a lot of people. Is there any format in word that would help me?

In MA database I have 2 tables - Products and Deliveries - linked by key
field ProductCode. The same product can be delivered many different times. In
the table Products I want to enter the total number of each product. (i.e. 10
pieces of product A was delivered 4/10/04 and 23 ...

I'm trying to sort a database of 146,000
rows by the string length of the row and there is only 1
field in column 1.
The column 1 text is, for example, as follows:

I've been trying to create useable Access applications for about the last
four years and am getting really fed up always running into messy deadends
about a day after trying to create a new .mdb file!  All the text books
follow the same, "If you do this, this, this and that, then ...

I have been assigned two tasks which I hope can be accomplished by using MS
Office.  I am new to all of the programs in the suite except for Frontpage,
and need advice on how to accomplish my assigned duties.
    First, we have a supplier who’s website we download and update ...

I am using a VB calendar  to insert dates on many forms.  It  works very
well. However on a monthly budget form I only need month and year.  I am
using a calendar form and formating date field mmm/yyyy.  When user selects
month and year and clicks enter, it inserts correctly.  ...

This is sort of a wonder why trivia question....
Why do Queries use SQL and not something like VB in expressions etc?
Is it because the database might be used on a network and the query can
access the tables on the back end easier?

I am "getting started" in MS Access, but not in programming.
My problem, a database for entering transactions about trainee teachers that
do some supervised lessons in schools.
Can be "dirty programmed" in terms of interface, but should be easy to use

I'm currently working on the set of data stored in xls sheets. These data
are organized as follows:
There are several (top-)folders, each containing the data for the whole year
(2002, 2003, 2004).

I have inherited a database with telephone numbers entered as:
NN NNNNNNNN
where the common usage is:
NN NNNN NNNN

I have created my first database and I use a shortcut open
up the application and access a form (what is effectively
a home page).
I want this form to instantly appear Maximised on screen.

I need some basic answer for Access97
I need to update some specific field in one table after for example Form
On_Close Event. I don't know how to write a code which will add some value
to specific field in specified table.

Is there a function which acts like the like * or like% statement in SQL.
Your help will be appreciated.
thanks

I'm brand new to VB and just learning.
I have a Command button procedure as follows ( I did not indent because I
didn't know how the text formatting would show up here on the web site):
Private Sub CmdNew_Click()