To clear up my previous post (much confusement in them!) I have a form where
all navigation buttons have been created manually (hidden navigation bar).
I want a combo box to allow user to both SEARCH and ADD new values.
I can SEARCH with a combo box after using the button wizard ...

Eg. I have all the courses numbered uniquely like first course of year
2008 course nam SMS will be given course no. 001SMS08 by the user. now
if the user enters 001 SMS 08 and saves the course number. Then some
else when queries about course no. 001SMS08 then it will not show any

hello, can anyone explain how to add worksheets or "tabs" to a workbook so i
can have several worksheets to a workbook in microsoft works spreadsheet.
thank you
derek

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database"  The next question is "What
SQL Server would you like to use for this database?" I ...

I've poked around and found that an expression I make in a form is unbound to
the table where I would like it stored.  Other posts have stated that method
is a waste of disk space and it's better to do in a query or leave it in the
form.  Here's my problem:

Hi, I was just wondering if someone could tell me how to enable the task
manager?  When I (ctrl, alt, del) to open it it says that the administrator
(which I am) has disabled it (which I don't remember doing).  How do I
enable it again?

I am a very new user to Access and didn't know if anyone new if I am in the
right place to do a drip letter campaign to my clients?  Thanks very much.

Bare with me on my explanation, its kinda tricky.
The user would like ONE screen to add and edit information.
The screen is as follows :-
Main form (source is the tblModule)

I have  database program split into a FE and BE.  The BE is on a server.  I
have installed the FE on five computers in various locations.  On three of
the computers the program works great.  On the other two, I have the
following problem/situation.

On my main form after the last combo box is populated I display my subform,
and I want to move the last record.
After searching the web I found the following code and tried it, Even though
the subform is populated (subform is based on a query matching values on

I have a subform that is linked to a report that I will run for 2003 Access.
When it runs and prints out, I receive a print-out for each record that is
found in the subform, (ie. 1 record = 1 page. 15 records = 15 pages)  How can
I limit the report to printing out 1 page for all ...

I have two fields on my report, one is "PaymentMethod" and the other is
"ExpenseAmount".
The PaymentMethod can be either "AMEX" or "CASH". How can I create an IIF
statement to sum the totals for each method?

I am a developer of software for schools.  I have a developers edition of
Access 2000 and create applications that are distributed with a run-time
version of Access.  They work fine in a PC environment, but many of the
schools have Macs.  It is my understanding that a software ...

The database I have created using Access 2002 works perfectly fine on the
computer I created it on. It is password protected with the user names and
groups, but when I try to use it on another computer it does not ask me for a
username or password.

I am having problems.  this is my second question today.  One of my reports
had an invalid (non-existant) field for a sort.  I deleted it and the error
message goes away.  I am prompted to save the changes. I say yes, but the
report will not close and the changes have not been ...