Howdy,
I have a loop that includes inserting a record to a datasbase.  What I'd
like to to is be able to tell if the new entry successfully wrote to the
database.  I have SetWarnings set to false because I don't want the user to

When I try to upload a database to a new workstation, i get a broken or
missing reference error.  I have tried going into the 'references' and adding
it, but the ones I am looking for do not seem to be there.  Does anyone know
where i can go to get these references and install ...

One of my clients asked me to export thousands of PDF files stored within an
OLE Object field within an Access 97 database so they could import them into
another system.
While I was trying to find the solution, I found many other people in the

I have an Access 97 database that executes a Mail Merge to a Word document.  
This all worked fine on NT machines with Office '97 installed.  However, we
are in the middle of upgrading our workstations to XP machines with Office
2003 installed. The mail merge no longer works. I've ...

I'd like to create a VB module that looks at the table [fullnames] and
deletes records that match in another table [badwords].   Basically, I'm
trying to cull any records that are business related.  The string in the
[badwords] table has such things as Corp, Co, Inc, Inc. etc. I'm ...

Ok, I have tried some info here, but am still having trouble realizing my
goal lol.  So i would like to post what i want and what track i am currently
on, i am having troubles getting the code to work.  
Ok i want to display auto generated numbers on records in the format of

I am making a purchase order database and i want the P.O. # to automatically
increase with each new order. What equation do i use and where do i use it i
can't seem to figure it out. The p.o. # is within an order database.

I need to search for a specific string on each line in a memo field :
XXXAAAXXXXXXXXXXXXXXX
XXXXXXXXXXAAAXXXXXXXX
XXXXXXXXXXXXXXXXXXXXX

Hi folks, this is my first time on this site so I hope you can help me out. I
have a table called "TblZQDeviations". I will enter serial numbers in here in
a field called "DeviationSerialNumbers" (I am tracking product issues be
serial numbers of products that I have yet to ...

Good day,
I am trying to write code to get a sub form table to recogninze the main
table and performe a calculation based on a field. I am using lost focus
Baically My input table (Input_Tbl) is the table I use for inputing standard

I have a database that opens a Word mail merge template and drops a record
into it. (This all works fine)
What I'm trying to do next is this:
After Access has opened the Word Template file and put the returned record

It's been a while since Ive used access and Im completely stumped on this
easy thing! - Well I think its easy thats the whole point! I'm looking to
have an expression/macro to work out the vat at 21% of a value inputted in
another field. If someone could shed some light for me ...

I am creating a 1 to many relationship between 2 tables (in the back end). I
want the record on the parent table to be optional (0 or 1 record). While
creating the relationship programmatically I get an error. "You cannot add or
change a record because a related record is ...

I have created a function, =user(), that captures the user's log in name. I
would like to have this set as a "default value" in the table whenever a new
record is added. I created a field in the table and placed the function,
=user(), in the table, and Access does not recognize ...

I have two tables with no relationship between them Table 1("Lead_1) and
Table 2("Lead_2"). I want to compare Lead_1.Prop_Address to Lead_2.prop_Add
with Like operator. Is this possible?
Thanks