Basically as a school project I have to do a database. At school we are using
Access 97. At home I have Access XP. Now you cant open Access XP Databases in
97. But you can open 97 files in the XP version. But you cannot save them as
97 files once youv'e finished with it (I hope ...

At the end of processing I export out a fixed length record using a query.
There are nine different queries that I run.
Sometimes the text file is created and sometimes not. It appears the problem
is that one query isn't finished before the next one starts.  I have tried

I am trying to write a macro that uploads a csv file.
Field 7 is a price e.g 1.6500 but Access is cutting off the decimals giving
1 in field 7 of the table and not the complete 1.65. Can somebody help?
Thanks

Streamlining paperwork preparation for a small law office that generates two
kinds of word documents: those that go to clients via snailmail and those
that get put into Adobe Acrobat to send to court electronically.
Current dBase III database will get put into Access 2003. Goal ...

I have been trying to download a Visual Foxpro driver to help read Visual
Foxpro tables in Access. I have downloaded the Microsoft OLE DB Provider for
Visual Foxpro 9.0 SP1 from the downloads section in Microsoft.
When I go into Control Panel/Administration Tools/Data Sources to ...

We receive a parsed csv file that I import into a access table.  I have 2
records that won't import because that parsed file has a field with extra
quotes, like some of the words in a field have quotes around them.  If you
open it in excel, it works fine, you just lose the quotes ...

I am working in an asset database. When I dispose of assets I want it to
pre-load information into Excel spreadsheet and then go back and update the
record in access to say disposal submitted. Can anyone help?

We save the same excel file with production data with names that describe the
production run.  We could have up to 20 files a day and  I would like to
import all of these files into Access in a simpler way. Any Ideas?

I have designed a tri-fold page in Publisher where there is shading from dark
to light going from bottom to top.  But when I go to view it or print it out,
it comes out as a solid color, which is the color on the bottom of the page.
Please help I don't know how to fix this.

Some help for a novice!
How do I copy an inport (or export) specification from one Access database
to another?
Thanks for any help - as ever!

I have a table called tbl CATS which I have imported from a spreadsheet I
have then used table analyser to split the table inorder to normalise it.
The table was originally in the following format below:
tbl CATS

I export my results like this:
DoCmd.OutputTo acOutputQuery, "q_RNtoExcel", acFormatXLS, "C:\PAD\.xls", True
But if the user does not have the dir "C:\PAD" as you know it cannot write
it out.

Life would be so good if::
"DoCmd.openform" as you know, will open the form, based on the previous code..
Is there a way to say "DoCmd(output results in xls format)"  ?????

I am trying to send a MS ACCESS Page via email. Is this possible?

I want to build an Access front end for a MySQL database.  I have downloaded
the MySQL ODBC driver, but I get an error every time I try to link to the db.
Any help would be appreciated.