I have two fields currentQuantity and orderQuantity.
    currentQuantity holds the current quantity for a particular item
    orderQuantity holds the quantity for an order about to be taken
What I'm having trouble with is decrementing the current quantity

I'm trying to write VBA code that will allow me to print mailing lables in
Access. Here's an example of what I need to print:
School ID    School Name         # of mailing labels
223    Bunche Academy    37

Hi, does anyone know of a way which I can query a sql server directly from
vba?  i would rather do that than go down the linked tables route.  Also if
it is possible for me to have the sql server login and password saved so that
I am not prompted that would be great.  Security is ...

there are 3 columns in a table, col1, col2 and total, try to update the
total to sum of col1, col2 and previous total, every time a new row has been
added. Any help will be appreciated.

I am using the following code to create a batch file and then run it from
Access.  The batch file is sucessfully created and it then proceeds to run
but the output fie of the batch is never created.  The batch will only work
when I run it with my mouse.

I use a database on a 4 user peer-to-peer network on XP machines.  I have
been being locked out of the application from just about all stations of the
network.  Shortcuts have been rendered inoperable, requiring a re-boot of all
machines to regain access to the program.  It is ...

I have a situation where I need to 1) open a specific workbook from Access 2)
run a macro in the workbook; all from an Access form.  Ideally I would like
to create a button that, when clicked, will open the workbook, run the macro,
then close the workbook.  Two sheets in the ...

I am trying to get data for a field in a table from another table
using
DLOOKUP function. In the DLOOKUP syntax, my domain field is a
recordset that

I am trying to get data for a field in a table from another table using
DLOOKUP function. In the DLOOKUP syntax, my domain field is a recordset that
is created in the coding using SQL. For some reason, I keep getting error
that the recordset which I created using SQL is not in ...

I am working on developing an application for my company and I have got
struck up with a step where, it looks like, I need to do a loop through my
records. I have given a sample recordset similar to the one I have below
where I have 5 fields and the fifth field in that, which is ...

I'm having a little trouble with the function below.  When use it in a query,
the query only accesses the function once and returns the one value for all
of records.  How do I get it to call the function for each record and return
a counter?  BTW, I reset the static variable ...

My problem, If a user chooses to close a form before all the data is entered,
the form is closed, then is does it checks for form_before_update.  This sub
will catch possible errors and alert the user, but after the alert is shown
the form is already closed.  If the user was ...

I have created a form where user scan upload their files. Users select their
files with the function: ahtCommonFileOpenSave and this result is set into a
variable called “strInputFileName”.
What I want is that the file will be copied to a directory, using FileCopy

The error message says "Could not find installable ISAM".  but I just did a
full install of Access XP?!?!?  All I know is that this error is preventing
me from linking to excel or textpad and most importantly, I can not export to
excel or textpad!!!

I have an access application using an access database.  The data is split
from the application.  The data file size is 9656KB, the application file
size is 5820KB and is installed on individual workstations.  Everything has
been working smoothly until recently when the entire ...