i would like to make a database that could hold information like a customers
name, address, phone, etc. then within the database either by button or thru
word, have it dump that information into a workorder or purchase order
template i've already made. and then after the workorder ...

I have a form with 3 text boxes named contact, telephone and fax,
I want to create a  combo box to select a field named 'supplier' with the
data taken from a table named "supinfo". the table has four columns named
supplier, contact, telephone, and fax.

I have a database with two tables. One is Project and has a ProjectID,
ProjectNo, InvDate and InvAmt. Another table is ROA and has ProjectID, Date
and Amt.
How do I combine these two to make a statement with the data sorted by date?

I have a combo box, when I hit Y (yes) I would like to save a keystroke and
have the cursor move to the next field.  How would I do that?  I tried
ONDIRTY but it gave me an error and couldn't move.
Thanks in advance,

I have data that has information in a field that I need to separate.
Example: Jimmy Ray (2004) (director) (producer)
                Jenny Rich (2000) (Actress)
From this example I need to separate the items in parentheses from the name

I am in the process of created several forms that will merge data to  Word
Templates that are legal documents.  What I need to do is;
1) look in a defined folder in Word and determine if another folder exist if
not create the folder and name it based on a field on the Access Form ...

How can I lock a record after someone changes it in a form so that no more
changes can be made to that record.  I have a database that tracks items as
either being in stock or out of stock.  When we do inventory I would like to
lock a record so that it can not be change back in ...

Hey Folks,
I am having trouble with my DB closing and leaving the .ldb file open. The
users then cannot open the DB until the .ldb has been deleted manually and
the information must be re-entered. What script or macro must I use to make

I have a pop up form from the main form to key some additional info in the
same field that's on the screen in the main form.  I have filtered it for the
secondary form incident no to match the main form incident no - when I try to
save the record in the pop up form I get an error ...

I'm new to coding so please forgive my ignorance.  
I'm needing to change a font color for the field [Employee Name] and a short
date format for the field [Exception Date] which appears in the message body
of an email via DoCmd.SendObject.  I included a section of the code below.  ...

I'm trying to catch duplicates in an access form.  I have a series of queries
that looks for in between dates for contracts.  If the query catches a dup
record then it checks off a hidden dup field in the form.  I want the form to
undo all changes if this dup record field is true ...

I am using conditions to enable and disable record selection command buttons
in a form. I'm doing this to run additional scripts when navigating through
records, which I can't do simply using the standard record selection bar at
the bottom of the form window. It was working ...

What would be the expression to change a letter to a word?
O = Other
B= Bill To
P= Prepaid

Hi- I had a question earlier about replicating columns for a project I'm
doing. There is one column that has the info being pulled from a form.
Another column in the same table needs to pull in the same information. In
excel you would use the equals sign to pull the same info. ...

I'm sure this is simple but am foggy today. I want to convert a string in a
query as follows:
10001 to 1
01000 to 2