I want to create a form that will become a job quote.  I want to enter a item
number and from that number have the description field automatically filled
in.  Can I do this in Access and how.  I also need to do this with states,
i.e. enter a state and another filed automatically ...

I converted a database to Access 2003 and this form is now producing a Write
Conflict trying to save the record and I am the only user in the database.  
It was working fine before the conversion.  The code it is executing is
simply:

I have a .mdb that works for all clients on a network except one.  When
I run a report that has a TRIM function in it is run, the report comes
up with a box asking for a value of TRIM.  On that machine, I notice
that under "References" in VBA it says "MISSING: Microsoft ActiveX

I am using the following code to open up a recordset, add a record then open
a form based upon that table.
           Dim rsImp As ADODB.Recordset
           Dim SQLStmnt As String

Hello: I have two fields, called "qty rejected" and the other "DMR number".
Both of these are number fields. I want to write a code that when the qty
rejeted is filled in, a note pops up stating that there must be a DMR number
input. Would someone please help me?  Seems simple ...

I have an Access 97 database.  The main form is an unbound form with a MAIN
list box (unbound also) that gets updated when a user clicks an option on the
left.  There are 3 hidden fields (2 listboxes and 1 txt box) that are
populated on the OnLoad and click events of the options ...

I have button on my main form that when clicked, I'd like to pass the name
of the current form to the new form that will open.
Does anyone have the code that will do this??
Thanks,

I have the following code as an event tied to a combo box that brings up a
record on the main form.
If Me![DateAndTimeVL] = "" Then
       Me![DateAndTimeVL].Enabled = True

It's not working for me when I use a very simple query?
I've downloaded and taken a look at Steve's A2KConditionalFormattingVer27
database.  It works great and I really want to use it.  Based on my testing
it works great against a data table but not a query.  I wonder why?

I put the following code into my BeforeUpdate event and I'm getting the
following error message:
Run Time error '2465'
Microsoft Office Access can't find the field 'txtThis' referred to in your

I have a form that is based off of a query..The form will initially pull up
the record set and allow me to scroll through the record by using navigation
buttons..however after a couple seconds all the fields go to #Name? and I get
an ODBC error that tells me absolutely nothing.. ...

I have a drop down list box that retrieves values from a SQL database.
Column 1 is bound , it contains the users initials, followed by lastname,
first name. On one user's PC, when he selects his name a completely
different value appears in the list box (should be the initials) and ...

I use VBA automation from my Access 2000 forms to control Powerpoint.
How can I code a "Close" button on my form to absolutely close any open
instance of Powerpoint without saving.
Normally PP will ask if open slideshows should be saved before closing. I

Is there a system variable that can be accessed that will
reveal the current screen resolution? I'd like to know if
the user's resolution is set to 800x600 or 1024x768.
Thanks,

I am having an issue with loading values into a list box.  We have over
26,000 Vendors we use, and I created a look up, that allows you to click on
teh first letter of the Vendor Name.  Once this happens, I send a query to
pull all vendors that have names that begin with that ...