i dont understand why i have that type of error, because colume have the
same data type (number).
thanks,
currencySQL = "SELECT * from Currencys "

i want to convert "marks obtained" by students, entered to database as
"numbers" into their text equivalents. e.g 11 to "eleven" and so on

I have a table with a list of Agent states in it; Available, On The Phone,
Data Input, Post, Toilet, Break etc etc.
I want for my form to generate a toggle button for each of these when it's
loading;

Is it possible at all (presumably in a form) to create the value to be
stored in a key field based on another field (or two).
For example, to have the form insert
mitchp    for a Customer ID based ona surname of mitchell and a first name

Im trying to get a command button which will, when pressed, copy information
from a certain field in one form, and then paste it into a different form in
the same project.
Any help will be greatly appreciated. My limited knowledge of visual basic

how can I enable multiple users to access my database at the same time? I
work with a network of 5 computers.

Is it possible to create a search button to search the whole of my access
database without removing the filter?  I would like it to search for all
matches, even if the entire word isn't the same, i.e. if I type in 'tech' it
finds all matches to technology, technician etc..

Where I work I can only purchase Access 2007 licenses at this time, can I
chose to install and use access 2003 if I want? Will I be legal.  All my
scripts where written and test in 2003 and Now I have a need for another
machine to process more data and so I have to order the ...

I am trying to remove the ms office reference library, but have used the
following throughout my application, which requires this reference library:
Application.CommandBars("contactsmenubar").Controls("&Actions").Controls("&Suspended Account").State = msoButtonUp
The problem being ...

Using WinXP and Access2K2
On a form I have this code to check if a control has data and checkboxes
have been checked. The form is based on a Query of the underlying Table so I
can alphabetize the names on the form level.

Not sure where else to ask this question . . .
As a small-time database programmer (I do jobs for several non profits) I
recently had a discussion about charging by the hour or by the job.  I've
always charged by the job, but put my estimated hours on my estimates.  I

 I have a problem with my chart,i used the following code in its rowsource:
SELECT [Month2],Sum([Cases]) AS [Number of Cases] FROM [RMonthly]   GROUP BY
[Month2];
But actually the months are put in alphabetical

I am Access programmer. Now I had a problem that I can't find a way
for a long time.
In the Open event of a form, I give the format of a text box related
with records a value. It is similar with the statement below.

I copy code from visual basic help start at Dim Fd as Filedialogue ....until
end of example. When I run it by click event it show error type not defined.
How to solve this problem

I have a table that keeps case records and one of the columns store the
vehicle no. It is possible that the same vehicle will appear in different
case records.
CaseID  |  Vehicle No