I use xp professional and msaccess 2003.  Used access for ten years but don't
know programming language.  
Problem:  Assume ten records in table.  I want to export to word information
only from record 3 to then mailmerge into MS Word a specific form.   How do I

http://i53.photobucket.com/albums/g80/es336td/TEMP/Computer%20Errors/MDBError.jpg
The path and filename in the pic have been deleted for privacy.  I am the
DBA off this database.   I have a shared back end on a network share and each
user has a copy of the front end on their ...

Hi, I am new to Access, I have Access 2000.
I need to create a query, hopefully append, to add only "new" records to my
existing table and not just append "all".
I want Access to find "new" records and then just append the "new" records.

Hey why does everyone dislike lookup fields so much?
The root of the problem.. is that you guys CAN'T see the data
_WITHOUT_ the lookups, right???
In SQL Server; I can use 2 tools to look at the data _WITHOUT_ Lookup

I imported an Excel table into Access in which the year, month and date are
in separate fields. The month field was formatted as text, i.e. "July", but I
couldn't generate a report by month in order from Jan - Dec, so I replaced
the month name with it's associated number and ...

I have an Access Database (2000, but I could upgrade to 2002).
I would like to limit the access to one of the tables in the d/b so
that only certain users can access it. Ideally, the access would be
linked to the user logon/pass, but that's not an absolute requirement.

i would like to start the autonumber at a number greater than 1.  Is this
possible?

I have a field defined as Memo in a table. When running a query, the content
of this field got cur off comparing the original field in the table. Would
anyone please let me know how to get the complete contents of Memo field
carried over in the query without the cut off? If the ...

When I import the PDF it will only display the first page of the PDF. I am
creating a database and currently have to hyperlink to my website when I have
a multiple page PDF but i would like to import the PDF and be able to see all
pages and not just the first page. Is this ...

I need to export a query containing fields with different number of
Decimal Places into a delimited txt file. The query contains numeric
and text types, so the text fields has to be exported in quotes("). If
I use "export formatted", I get all numbers according to the query

I have a very simple db.  When I cose it using Access' close button or the
Exit button I put on my switchboard (which calls docmd.quit) the application
disappear from sight (no longer visible) but the process remain in my task
manager.  What could be the cause of this?  Is the a ...

thx in adv for help
I've built a 1 table database that's purpose is to keep track if invoicing
dates for 4 different accountants. each accountant has invoicing due, for
1particular account, monthly, quarterly, or annually.  I would like to

Has anybody else had an issue when SP3 is installed, where you have a form
with multiple tabs and each tab has a subform and if you leave the first
tab's field blank and go to the second tab, the system gets stuck.  It
doesn't lock up because I can see the hourglass blinking.  As ...

I know this should be easy but for some reason I am lost on how.
I have a field that I want to pull only if value is not 0 or 47.25 "Delivery
Difference".  When I put "<> 0 or 47.25" it doesn't work.  It continues to
pull all of the fields with 47.25 in that field.  For those who ...

Here's the situation.  I'm trying to make an addition to an old (and non
ideal) DB
There are tables named for different pannels they nave spaces and sometimes
hypens in the name.  ex "ABC-DEF C123 Aux"  and "ABC T2345"