I'm having a problem that I know must be really easy to solve but I just
can't find the solution:
I have a report and I need to sort the results first by last name, then by
nationality and last by age.

Hi people, I am fairly inexperienced at this so please use laymans terms and
be gentle with me.
I have a preconstructed Word form for change notes.
I have an access table and form set up with the same data as on the Word doc.

I have the following code in my unload event.  Even though ls_SQL is set to
a value which works OK when copied into the query window, only the first of
these actually updates the tblParameters table.  Any idea what's going on
and what I can do about it?

I need to create a survey form and create a database to link it to, I have no
experience or knowledge of databases and so will need a step-by-step guide!!
The survey is to collate information such as gender, nationality so will
need tick boxes and text boxes.

I have an mdb which is a front end using an odbc connection to read and
write some back end tables (non access). If I open the linked Table
manager I can see the varios tables listed (the remote ones) with entries
like;

I want to move 1000@ cells in a .xls column to access. - If I try to copy and
paste I am told that the text is too long.

I have a form with a combo box that selects the drg from a table...works just
fine:
select distinctrow
[DRGtable1].[strdrg],[DRGtable1].[strDRGdescription],[DRGtable1].[intWeight],[DRGtable1].[drgstartdate],[DRGtable1].[drgenddate] from [DRGtable1];

I have always been an Excel guy and have never used Access until just
recently when a friend showed my how to use it to identify duplicates in
some very large spreadsheets I was working on.  Now having seen just a small
sampling of what Access can do, I was wondering what other ...

My form runs a query
I have an option group on the form which returns 1, 2 or 3 accordingly
My query contains the criteria below
like "*" & Choose([Forms]![Form1]![OptGrp],"Ops","Eng","")

Is there anyone that could break down in laymen terms how to work with MS
Access? I have trying to make relationship with different table and I keep
getting this message "The index or primary key can not contain a null value"
but when I attempt to correct the fault it tells me that ...

Thanks for reading this post.
I am new to MS Access and currently learning Access 2003. The best way to
learn a new subject is through practice/exercises. Can anyone recommend a
source where I could find few practice/exercise questions with answers?

Is there a way using VB to reopen a DB ,
some sort of command button to "reopen" it?
thank you all

In my Control Source I have
=[Qty 2]*[Master Type Factor]
My problem is this. If [Qty 2] is left blank it doesnt show a 0. I want it to
show a 0 for it to work since this is linked to other queries, but will not

I am trying to put an IIf statement together.  What I need it to basically
do is if a carrier arrives before 13:00 (1 pm), it's early.  If it arrives
after 16:00 (4 pm), it's late, between 13:00 (1 pm) and 16:00 (4 pm) it is on
time.  It does not error in design view but when I ...

I have a simple database form used to collect numerical values(p1, p2 ....up
to p8).  I want to perform some calculations on the values that are input but
all the boxes are not always used so I want to ignore unfilled boxes.  As a
simple example: I would like to calculate the ...