I have a table that contains 1400 students ID numbers, Last name,
First Name, Grade and Lunch. I want to pull up the students Last name,
First name and Lunch by scanning in the students ID number from the ID
card with a Barcode scanner which I have working and recognizing the

Hi; Where can I get a list of access functions with discriptions and how they
work
Terry

When I import the results are all over the place. e.g.
some records say a city name with a space at the beginning
others say the city name with no space or tow or three
spaces before the city name. How can I trim any extra

Hi:  I am using Access for my first database creation.  My form is complete.  
What I would like to do is create a textbox that would show the running total
of a particular set of records on update of the record textbox.  I have found
directions for a DSUM statement, but I don't ...

Hi Group,
I just want to clarify my understanding on this one...
I have as part of my database a client record with his address; if he
changes address then I want to make sure that his latest address is the one

I have  an mdb that links to a SQL Server Table.  I run a query on this table
on my local machine and the performance is very resonsable.
When I place the file on a server, I have access to it via a file share.  
Opening the mdb is not am issue.  But, when I run the same query, ...

Hi all - feeling my way trying to create first Access database.
Background:
I created a database in Excel, which for various reasons would be better
done in Access (simultaneous access by multiple users, size of database,

Jade,
I have a similar problem. Did you eventually complete your solution?

Someone sent us a file with a MDE extension.  We cannot open this file and
from what I have read, it isn't an actual database file.  We use Access 97.  
Are they sending us something that can only be read with Access 2000 or
newer?  Thanks!

My computer suddenly shows a blue screen. I can read this error on the
screen and some advices like: check vor viruses, remove newly har drives
and controllers, run CHKDSK /F.
I restart the computer, it boots and after that it shows the same blue

How can I easily combine two databases that are identical except that one is
English and one is Spanish.
I simply copied the data from one database to the other, page by page, but
there must be an easier, more automatic way to do this.

I want to use DatePart in a query to group/count the number of items received
per month for 2004.  The data is in a table and daily receipts are posted by
day/date.

i know it is possible to create a button to search for data on access but
couldn't remeber how can u please help me?

A2K,
Here's a simple one I can't get to work.
On a form, the cmdBrowse button displays the chosen destination folder path
in txtFolderName. The user then clicks cmdGO button to call a function that

I have had considerable help from this newsgroup with several combo
boxes that were giving me problems.
Now I have been adventurous by tailoring and my combo box is not
perfect.