Our job control system is generating invoices which we then pass to our
accounting system.
I've got this working OK, except that occasionally we need to create credit
notes, on which obviously the values should be negatives, both stored in the

I am creating a table where I need to set up an auto number field and set
this number to be my key. How can I set that field to start at a specific
number ( ie: 2000)
thank you

Hello,
I am quite new to access and presently creating an employee database.  I
have got the basis of that I wanted to acheive down; however, I have hit a
rock.  I need to be able to track absences (AWOL, SICK, LWOP, BEREAVEMENT,

hello i have a tbl that contains the following
jobid split1con    splitcon £   splitcon2       splitcon £
11       john         300             bob                200
13       bob           200           john                100

Where can I find an example  - tutorial - about a "junction table"?
(or an explanation about how it is used).

I would like to find out if my Access 2003 databases will be compatible and
run if I upgrade to Access 2007.
The reason I am asking is I was trying to run Access Bible 2003 tutorial to
learn more about Access. When I tried to open the sample files on the

I am new to using Access and Publisher.  I am creating my first web site, and
need to create a form for my customers.  I think I can create the form in
Access (so the data may be saved and used), and inserted into Publisher
(which I am using to create my website).  Am I on the ...

I have a table where I enter activities for my fabrics.  the fields are:
FabricId, Date, Activity.  Activites include: ordered, backordered, received
etc.  I want my query to return the most recent activity for a particular
fabric.  I have used the Group by feature, and entered ...

Hallo famillie,hoe gaat het in IJbrug druk aan het inruimen of uitrusten,
Ik heb al flinke wandeling gemaakt met een spetje regen.
Gisteren bij Anne en Maarten geweest s,morgens hadden ze eerst hier koffie
gedronken en Tom was weer blij om opa te zien ,hij is maar gelijk gebleven

I am having a problem with making a new entry
The following trial run worked:
     strSQL = "Insert Into OrderDetails (OrderID, ProductID, UnitPrice)
values (123456, 2, 99.00)"

I don't like 2007 and do not want to purchase it. But I don't see my old Word
program on my computer. If I remove 2007 from programs do I then have no Word
Program? and loose all of my files?

We have a legacy analysis application in Microsoft Access 2003 (X) that
reads a large subset of a second MS Access 2003 database (Y) into temporary
tables and performs certain operations on the temporary data set.  To improve
performance, we have began to port the application (X) ...

After converting to MA 2007 from MA 2002 I am getting this error when I try
to Create a Holding Invoice
Run-Time Error '3709'
The connection cannot be used to preform this operation.It is either

Hello ,
My command buttons were working yesterday, but not today. When I go to
insert a button, I go to Form Operations; Open Form; 3M Form; Open the form
and find specific data to display; then this is where it gets weird. The form

I am using MS Access 2007 and Mozilla Thunderbird. I'am sending automatic
email notofications with Access (DoCmd.SendObject). Today I've installed MS
Outlook 2007 to check how does it work. When Access was trying to send an
email, a window appeared, that says "Warning, something ...