I have imported an excile file into a new table.  I chose my own primary key,
which was the field that had Patron ID numbers.  There are no duplicate
numbers.  When I create a new Patron, I want Access to generate the Next
Patron ID number in sequence to the last ID number?  I ...

Hello!  I have a new computer & I have been using & saving ALL my business
files to Corel W/P Suite 8 for years.  Does anyone have or can I download the
software for free?  Or can I convert files to Word? Come to find out I'm
pretty illerate when it comes to setting up a new ...

I have a large *.dbf file
I need to get into Excel.
I presume the file is about 140,000 records
therefore opening in Excel or MSWorks will not

I am trying to create a report based on a query. I have a form with
unbound text boxes, one for last name (whatPerson) and one for meeting
name (whatMeeting). The form has a command button that runs a macro
(macro_search) that opens a query (qry_search). If the user enters a

i'm trying to use the code of this site to return the version of access that
is being used.  I want this displayed in a form.  I've managed to
successfully do this in the past when i was working on access 2000.  Now i'm
using access2003 to develop an mdb and having problems with

Salutations,
My client has unicode errors in his emails.  The apostrophe in his emails
makes the email look like he is misspelling his data. Please see

I have a field that holds Patron ID Number.  I want Access to automatically
generate the next ID number when I create a new record instead of me manually
inputting the number.  Can this be done?

I would like to have the ability to creat tables in Onenote and then be able
to copy and paste into other office docuemnts if needed.  Somthing like send
to excel or word

I wonder if you could offer some advice please.
I have set up a very very simple database that hopefully i can use with
barcodes.
It consists of one table that has the following fields

I have an mdb called SCU that's stored on a network drive, R: which is
mapped to a directory on the server.  When I open SCU, it starts running
then gives the error message Can't find R:\SCU.MDB!  The program continues
to run behind the error window.  I click OK and the message ...

Wizrds don't work in spite of installing upgrade to 2003.  They didn't work
in earlier versions either!

Hi All.........
I have a new Database to create that will get all of it's data by manual
input, all taken from one hand written form that is filled out daily by
Machine Operators.  There will be no reference to any other Databases.  It's

Hello and thanks in advance.

I have a database I use for a racquet stringing business. I work mostly off
one main form called Customers that has several tabbed pages. On the first
page is a list box with customer names. Selecting a name brings up the
customers data on the other pages where I have subforms with ...

I have a date field on my form, sometimes the user will enter a date in the
past.
how do you set the validation rule so that you must enter todays date or
later, I tried >=now() but it wouldn't let me enter todays date. Thanks for