I am a newcomer to using modules in microsoft access. I have written
code to create a table and append other tables onto it. However, with
each step a dialog box appears to ask if I'm sure I want to append the
records. Unfortunately the MS access book is out of the library. Does

I have an Access 2003 .mde sitting on an SQL Server.  The tables for
the application also sit on the Server.  I'm having a problem with
ODBC on only one of about 10 machines. All the other machines using my
Access 2003 .mde see the linked tables without a problem.  I've

I have a form where the user enters the Model info.  The user picks
the Model from either a combobox or listbox which both are filled from
the Models table.  If the Model type isn't in the boxes, then the user
can click a button and add a new Model to the Models table.  When the

Hi, I have an order entry form with a subform attached for order
details.  Whenever you add a product to the Order Details subform and
then you try to add the same product again in won't let you.  Which is
fine.  The problem I'm having is that I'll be using a scanner to enter

I have an Access application that has been running on my desktop system just fine. I
recently tried to move it to my laptop, and on the laptop I get a "Disc or Network Error"
message when I try and open it (after the opening Form has opened but before the data base
information on ...

I've secured my Access database by creating an MDE file because it contains
confidential data.  However, I find that anyone can simply use Microsoft
Access to link to or import the tables in that MDE.  How do I stop my MDE
from sharing it's data to any application that requests ...

Hi, I have an order entry form with a subform attached for order
details.  Whenever you add a product to the Order Details subform and
then you try to add the same product again in won't let you.  Which is
fine.  The problem I'm having is that I'll be sing a scanner to enter

Thank you for your help!
I will try to explain this in a more easy to follow format
First I have 10 test participants who on each of 5 seperate dates will
grade a description.

I have created a form in Access with several controls that have drop
downs for the user to choose.  I now need to create a record in the
table for every combination (eg. one option in a drop down menu means
7 outcomes, and one option in another drop down menu means 3 options,

Hi Guru's,
   I have a login form which when an incorrect username or password is
entered more then 3 times, a mail is sent containing the xp username, the
username they have tried to open the database with, the password they tried

I am trying to make a database for my test participants.  I have 10
participants and have a table with them called participants which
includes an auto number ID and then the participant number and start
date.

I have a form that supplies my query with information on two different
variables. The form uses a lookup to display a list of 5 different
customer types and 5 different types of meetings/activities in two
different combo boxes.

I am trying to delete the temporary files that MS Word leaves behind
sometimes when it fails to clean up properly.  Files like ~$lename.dot.  I
have used the Kill command, but find that this doesn't work for hidden files
like these.  If I change their attributes it works perfectly.  ...

Anyone know how I can access a MS Access database from perl?
Any help appreciated.

This seems very simple but how would you validate that a user
has entered just numbers into a form's textbox.
That is 1234 is good while Wer234 and 234ddd is bad. I would prefer
to use VBA if possible