I have an excel database that is constantly being updated with new records.
For ease of access I have now set it all up in an access database. My problem
is that I have to use excel for the updates but I am concerned about linking
my access tables to the excel worksheets as i'm ...

Is there a way to make the default value of something 1 greater than
the last value of that column in the table.  For example, that last
"OrderNo" is 208, is there a way to make the next time I enter an order
it automatically defaults the "OrderNo" column as 209?

I'm having trouble adding a column to my database. I have tried the help
option in Access, but it doesn't give me the option to insert column. Can
someone please help?

I was asked to look into a problem with the access find box not finding
some records, when searching thru records via a form.  The "missing"
record could be found if the partial name and wildcard * was used.  I
checked the actual record and could find no leading or trailing

When trying to construct a lookup table in access, I get the following
message "ActiveX component can't create object"
After doing some investigating, I learned that by default the
"Microsoft ActiveX Date Objects 2.1 or 2.5 Library" should be

I'm trying to convert an old booking system to Access for Children's Theatre
of Charlotte's school performances (professional productions for youth).
Tables will (should?) include Schools (i.e. customers), ShowTitles (i.e.
catagories), PerformanceDateTimes (i.e. products), ...

I have a task which has been giving me grief; specifically, Access
would hang when I was trying to add or remove records from a subform
when using an SQL update query. Subsequent research and investigation
has revealed that the query forming the RecordSource for the subform is

I am experiencing a problem where the Access application hangs after an
update query that I am performing via code.
I have a form with two subforms; one subform lists the courses that
form part of the package students will take, the other subform lists

I have created a customers  table that feeds from another Acesss database's
customer list table.
The other database is constantly being updated -new records (customers) are
added daily.

When you open a form, how do you set it to automatically bring up a report
centered in a full page, with 150% Zoom?  I use Access 2000.
Thanks!

I need help figuring out how to draw an x and y axis graph, on graph paper in
Excell.  Please.

Thanks to those who offered advice in previous "find not finding records"
post, as you set me on the right track to start resolving the problem.
I did find the culprit - about 200 records out of the 8000 in the db have a
"chr(10)" attached to the end of the data, in the field that ...

I've posted my cry of help before with my old database, and it doesn't seem
like nothing I did was working, so I've decided to scrap it and start from
scratch.  But, I need help with creating my tables so I can do what I need it
to do.  Any ideas will help.  This is what the ...

I've created a query that list all Access Reports that were written for
various departments. The query works fine but is displaying duplicate
department names (one display for each Access Report written for that
department).

I want to search for a name in a simple spreadsheet.  I don't understand the
Lookup function and don't think the "Go to" function works either.  Any
suggestions?