I have been attempting to create a reservation planning form in excel
that imports Data from an Access database and inserts that information
automaticly into the correct spreed sheet and the correct cells within
that worksheet. The Excel Book is made up of 12 worksheets named

I currently have 2 oracle databases that my access database is going
to gather data from.  The IT department wants to give me data snaps in
the form of a flat file.  They will FTP the flat file to the location
that I need and I am wondering how I would be able to check to make

I am  trying to get this function to work.  I keep getting an error on
the line --  Me!G_C_Bidding_Project.Requery  --  I have no clue what I
am doing wrong please help I am so frustrated.  I get this error "Me
can't find the field G_C_Bidding_Project" -

Hello Access Developers,
I'd like to know if it is possible to perform a count in an expression
that defines a control source.
My report is based on a query. In my report, I want a text box to

Hi....
I have created an Access form with a few text boxes,save and close
button. The save button calls a function(funcSave) to collect data
from the text boxes of the form and insert into a table.

This is a very fustration problem.
I have a crosstab query in MS Access that uses a data field (say called
"Brand") as the column headings. As I need several crosstab queries to
output data in a similar structure (basically with the same columns),

Need help with aggregate function...for each unique product, I need the
provider with the cheapest cost factor
Here't the table (Table1)
ID     product  provider    factor

I have a strange one that's making me scratch my head.
The app is written in AccessXP.  The table is a FoxPro 2.6 table.  I
link to it via ODBC.  There is a field called Active, type Logical
(boolean) in FoxPro.

Is it possible for me to open, read and display a specific eMail
message from within an Access database? Perhaps I have
received an eMail from a customer in the customers table that
I wish to save in my mail client's message store. Maybe I don't

MS Access 2002 here. I am just trying to set up a simple database for a
friend who's an optician. Basically, all clients with address details, date
of last eyetest and a drop-down combo box to choose a number of months to
the next eyetest (3,6,12,24). I then have a calculated ...

How can I make access import a tab delimited text file that contains a
special char u (but with the dots over it like a german spelling).  The u
shows with the two dots in the text file but when it comes into access, it
looks like something else!!.

Please help an aging and not-quite so agile brain. I've looked through MSDN
and Googled the planet.
I have a very simple structure and want to get full records for distinct
combinations of various fields. I just don't know the correct syntax. If

Hi::
I have 2 fields, an alphabetic and a number. I wish to combine them so that they form a
field which has 5 positions  in it.
Number can be from 1 to 9999

I am working on a genealogy project in which I have two tables:
Person -- one record for each person in the family.  Each record has a
unique Autonum field (IDPerson).
Partnerships -- one record for each marriage.  Each record has a unique

Hello, can anabody help?
in the following part i cannot pass de desired default value
In the module of the mbd i declared:
    Global datum_Glo As String