I'm automating an import done manually through Get External Data
I have assigned the below code to the onclick event of a command button
on a form but I am getting errors.
DoCmd.TransferSpreadsheet (acImport,acspreadsheettypeexcel97,

I am currently inputting codes from a product list, some codes every so
often are the same, is there a way ms access can flag up if i've
inputted the same code in? I don't want to be inputting the same codes,
this would save alot of time.

I'm using findfirst in code as below. It searches a query that shows
appointment date and account name and should return the account name of
the first appointment on each day into the same date in a calendar
form.

Here I need a help. I have two tables 1) Mis_A  2) Mis_B
Mis_A                                      Mis_B
Location   Revenue                   Location          Sale
Mumbai           10                     Mumbai               5

I am developing an HR package under Access 2003 for a client but do not
want to give him the source code.
I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing

Brio and Toad are, as I understand them,  front end query tools for server
level data.  An application I am working on requires that I move data from
these tools to MS Access for reporting.  The existing process involves
copying the data to the clipboard and then pasting to Excel ...

We have recently added another PC to the network and have run into
difficulty when trying to open access files from the server using the
new box. We get the error message
'MS Access cannot open this file. The file is located outside your

I have created a command button on a form that prints a filtered report and
e-mails the report to three people when "clicked". The three email addresses
are selected on the form by three combo boxes that populate the following
three fields - "ContName", "ContName1" and ...

If the user dbl clicks the field "vendor" I want it to open frmContacts to a
blank record if there is nothing in the current field and if there is, open
frm Contacts to that record. I have the following code...
If Me.Vendor = Null Then

A client that I developed a database for about 5 years ago and continue to
do annual updates for has just requested "all intellectual property rights
related to the database". I believe he just wnat me to say "OK, here you go,
it's yours"

A client that I developed a database for about 5 years ago and continue to
do annual updates for has just requested "all intellectual property rights
related to the database". I believe he just wnat me to say "OK, here you go,
it's yours"

I posted an answer to someone's question, and realized I have more
questions than answers. Thus, I am going to post my scenario to get to
the question that I have:
I have a challenge, to figure out what part of the vehicle to relate

I have a situation I can't find any old messages or web-help on.
I have a split database with a bizarre quirk.  When I open up the
front-end file, the main form opens up fairly quickly (~2-3 seconds.)
If I copy my front end in Windows Explorer, the first time I open it,

I have several different vouchers for the purchase of exciting
activities stored as Word templates into which I want to insert data
such as the name of the person, the activity and the expiry date. I
want to do this from the record of the purchase in Access. I can see

What I want with the combo box ive created is for the user to select a
name from a list and the user jumps to the selection.
Currently Ive got the page to sync using the current event in the form.
In the after update event for the combo box im using: