I have a Form and a SubForm
on the Subform I have many datas that I want the users does have access to
delete them, I have changed Shortcut Menu to "NO"but if the select the row
and press DELETE key of the beyboard then deleting is allowed,

I am trying to create an MDE file and I'm getting an error on the following
code.  I'm getting a Complile Error on the following code.  I'm not quite
sure where to go from here.  Is the code not compatible with the MDE file.  
I'm new to Access so I am not sure what is really ...

Please let me know what's wrong with the below, its giving error in
the last where the value is "True". Error is "Syntax Error in Insert
Into Statement"
INSERT INTO tblPOTracker (transDate, buyerName, businessGroup,

hi, im running vista, and now i cant open incoming mail, other than mail
with text only. when i try, a box informs me to "set associations". how do i
do that ?

Hi I have created an 'events' db for use at work.  When starting the db I
would like to be able to display a dialogue box that gives a warning if there
is an event scheduled for that day.  Is there a simple way to do this or do I
have to undertake some form of programming, which ...

I'm new to Access and using Access 2003.  I'm setting up my tables and have 2
questions.  1) I have a table for customer names.  I set up Customer ID with
Autonumber as the primary key.  I want to use Customer ID in another table
again as the primary key.  Do I set it with ...

I want to update a table with the data of another.  Is there some way to pull
data from one to the other.  Each table has a common field.  Where would I
start?

I can't open anything that I saved onto an external hard drive now that I
have the Vista system prior to this I had XP
Help

  I have a form called assignment,this form contains 4 unbound controls:
agent (combobox),sort(combobox),cases,language(combobox).
  I want to use this form to assign a certain number of cases to the agent
selected in the agent combobox..

Sorry basic question but I am going around in circles.
I have a simple supplier table with Supplier ID as key. I open a new table
with a form in preparation to add a new record in the second table
(Contacts). Form opens OK and you can add entries but I want to copy across

I have built a database and tested it thoroughly. I deleted the test records
but now my first record has an automunber or 15 and this is winding me up.
Can I re-set the autonumber back to 0?

Can I create my own personal logo using Windows XP?

I'm asking you to look at this:
I'm doing an export from  A2000 to Excel2007 from VBA in Access2000
using
an app as Excel.Application object:-)

I am struggling to create a form which is initally for customers to use, for
them to enter in their details and for the database to accept this. Then for
them to be taken to another form, presenting them with more options. Im sure
this is an easy process, wondering if you could ...

I tried to use update query to update data that I didn't have prior to
inputting the rest. I get the data whenever my supervisor can give it
to me which is hours worked. I made a query with the criteria as null
hours. When I change the query to update query the date and employee