Howdy all,
I'm playing around in a test database I've created and am having a
difficult time setting up a Delete Query that checks for a field in
two other tables and if it's there, it deletes the record in the

I use php & mysql on a regular basis and im wondering how to go along
pulling information from the mysql database and populating a local access
database with the info?
Is it anything to do with ODBC?

I have created a database that my department uses to record credits and
invoices.  The records for each are stored in the same table and I need a way
to search different records to match reason codes.
If a user creates a credit for a given reason, they should create the

I'd like to build an expression in a query that calculates the median of some
cells in the same record/row.  MEDIAN () doesn't seem to exist in Access.  
Any help?

Hi,
Suggestions anyone?
I have created a database for which one function is to input a number into a
text box.  I have currently done this using command buttons (numbered 0-9)

I need to search a table that has phone numbers but it has a  mask like
(000) 000-0000
Basically I want to search for a phone number but I'm not sure if I have the
wrong area code or what so I need to search for a partial number somehow.

I have a form with a combobox that helps the user find a record. I
have noticed that when the form is re-opened it displays the last
record. What code do I need to insert to have the form open with blank
fields.

This is a general question.
Each month we receive an invoice(s) from  suppliers over the Internet. We
use the information provided to us and enter the information into a desktop
Access 2002 application through forms provided with the Access application.

I have a form with a subform in it. The subform has two button on it to add
or delete records. The add button has a little code in it to set up some
defaults. The delete button consists entirely of this code:
Private Sub DeleteRow_Click()

First post so apologies if I get things a bit screwy.
I have built a query that I want to export into excel using odbc, if I
set the critera in the query to show either all records a specific
record number e.g 1234 and build the ODBC link in the Excel sheet, all

In my database, users input records on a form and subsequent sub-form.  The
form has all customer-specific data and the sub-form has the record details
of that transaction.
For various reasons, a user might start a record but not complete the

I am trying to figure out a way to allow a access user create a query for
report through a form.  Can someone help with this?

I’m trying to add a Tab command in a field for exporting purposes. I will be
pasting info from Access to an outside program and to move from field to
field it requires a tab after each entry.
Example (access)

I have on my input forms two input fields defined as Format:Short
Date.
The user sees __/__/____ when beginning to type.
I put in 01/12/2006 and 19/02/2007 (meaning 1st December 2006 and 19th

Hopefully this is a simple one.
I am wanting to set up a link to our manufacturing database using Access.
I have been able to establish an ODBC link through start> Control Panel ->
Admin Tools -> Data Source (ODBC) from this I have been able to import the