Howdy.
   Using the NotInList event of the ComboBox, is it possible to use the
code cmd_click.
I was having alot of problems with the Not In List event running the code

Yes, I know I can't do that! Here's what I've got:
tblVehicleMakes - lists car makes with ID# (which I shoulld have set up as
an Autonumber but didn't)
tblContacts

Could someone pleas tell me what the benefits of having
microsoft access are?

I installed Access 2003 yesterday as an upgrade to Office 203 standard and am
trying to import from and link to an Excel 2003 spreadsheet. However Access
2003 does not list Excel in its import from, link to or save as dialogue
boxes. Help please

I am a new Access user--don't use code, just the wizards & design views.
I have two main tables with a 1-to-1 relationship (couldn't fit all the
fields in one table--property value too large), and several lookup tables. I
created multitable forms using a query that contains both ...

i have developed an application in Access 2000 format but
needed to convert to 2002 format for me to make an mde
file before deploying the application. i need to
determine minimum system requirement for my application,

I have a table called Attorney Information.  On my form I have a field for
the Attorney Name, Atotrney Address, Attorney City, State, Zip Code, and
Contact Person.  When I choose an Attorney Name, I need their address , city,
state, zip code, and contact person to automatically ...

I have two databases, crop 2004 and permittees 2004. Both tables have permit
numbers fields that match. I want to merge the two tables so that all the
info in crop 2004 is added to and matches the table in permittees 2004 by the
permit field. How can I accomplish this? I need to ...

I  tried to add a row to a table from access that I analyzed in excel, when I
went back to acces the row wasn't there, is there anyway I can make changes
while analyzing tables from access in excel.

I am confusing myself...are the joins in "Relationships" going to be the same
joins in a query?

I'm just learning code for VB.  All my databases in the past used macros.
Do you think it would pay to convert the macros to VB now that I'm beginning
to understand code?
Many of the macros are simple "form.open.maximize" type procedures.

Hello list.
         I'm using the NotinList event of a combobox to tell the user that
their item is not in the list.  Unfortunately an alert box appears
automatically generated by access.  I was wondering if it is possible to

I can't get my UPDATE syntax to work when the SET and WHERE clauses
reference another table.
Here's a quick example:
CREATE TABLE Table1 (

I open up one form from another, the reocord on the form
I open is based on the customer id. At the the top of the
form the customer number from the customer details form
won't show up if it is a new reocrd. I have to go into

Could someone tell me how to do the following.
Seems like a simple thing, but have given up.
You input a word in a field in table "A" and it goes to
table "B" and gets data from other fields and automatically inputs three