I am very fascinated with the control one can have over what goes in by the
use of the BEFORE UPDATE EVENT of a control on a form or the form itself.
Unfortunately, I do not have the proper knowledge of how to use the procedure
so that I do not get error messages when I am ...

I’m trying to design a database to serve as a quick way to compare our
products with the competition; I created a table with just a couple of
entrees to test weather this database would provide us with desired results.  
I’m unable to get the data from the table into a format that ...

I have linked to a mainframe DB2 table and when I try to open the table or
run a query against it, the only thing that display is "#Deleted" in every
cell.  I know there is data in the table as I can query using Excel and get
the correct results.  Using the same simple query in ...

I have a table called MasterData with a field called Originator.
The field data looks like this...
Lou Santana
Steven Sentry/Miami/PU/WC/US

Hello again,
back last Thursday I made a post about and Access 2k database the will
periodically take a record and insert "#Delete" into each filed. I appreciate
the posts I got on this and tried all suggestions and read each article, and

I have a query that finds the running sum of Inventory
using the dsum function.  I have another query that
finds the running sum of Accounts Receivable again
using the same method.

In my form Souls field Age I want to have this field calculate the current
age of the soul from the field DOB that is also in the form. DOB is a
formated date and AGE is formated General Number 0 decimals.  What is the
best event to use when adding or updateing the record.  The ...

I have messed up my Office 2007.  Yesterday I was removing a trojan horse
that I believe must have come in the horrible e-mails we get in huge quantity
at work .  I had made a backup of the registry, but because I had disabled
the system restore in order to prevent the virus from ...

As you know in Excel you could quickly copy the information you needed with a
drag of the mouse.
Because I need information copied repeatedly and easily for my access
unfirmiliar co workers.

For each job there is a quote number (ex. 110701)
Everytime I add a row for a new job can the list keep going accurately?
ex.
PROJECT    CUSTOMER    Quote

I'm completly jammed here, I've been trying to find a way to add
control box to a form by clicking a bottom.
Unfortunately, I've keep failed.
Could someone help me on this matter.

step by step
I enter in all my project information for Job A including all the customers
under that project
So I begin Job B

I'm trying to automatically insert some data copied from an Access table
into an Excel spreadsheet into another Excel spreadsheet.
Both sheets are open and referred to as objExcel & objExcel1.
I get "Copy method of Range class failed" with the following line.

I have a query that returns one value.  I want this to take
as small a space on the form as possible.  How to put
it on a form without the scroll bars and all that stuff
I do not need?

I am in the process of creating a database to used in a small office to track
ongoing projects.  I am trying to get the next new record to automatic
populate with the next number.  Currently I have row set up as a number,
field properties I have set Format to 0"7-"000.  However, ...