I work in a Real Estate Brokerage Firm.  We need to transfer our
current excel based spreadsheet into Access. Our goal is to utilize
Access for superior Database Management while maintaining Excel's
calculator functions. Is that feasible and if so, how?

I have created several databases for use at the local hospital's ER and they
are very pleased with the results.  They now wish to distribute them to other
hospitals in the province.  Is there a convenient way to copy the database
without all of the accumulated data so that we can ...

After converting from access 97 to access 2000 when I try to open some of my
reports from code I get an 'Enter Parameter Value' dialog appearing. There is
no field name listed in the dialog and when I press the OK button the reports
appears just as in Access 97. Is there any way ...

I need to convert an Excel table into Access however the Excel tabl
contains checkboxes. Does anyone know how to get the values from th
checkbox, ie T/F, referenced. Any ideas will be much appreciated
Thank

I have a cost field in table to let me know the cost of the product.  Using
the word "authorizes" would like to convert the currency to coinciding
letter of "authorizes".  1=a, 2=u, 3=t, 4=h, 5=o, 6=r, 7=i, 8=z, 9=e and
0=s.  Would like this to work automatically in a field ...

I'm converting a 97 db to 2000.
A form has a button that executes a Docmd.Domenuitem command.
This is supposed to invoke Find and Replace. It does, but the subject is
grayed out. I need the find to be based on the control where the cursor was

Are there any issues or concerns I should be aware of in converting from
Access 2002 to Access 2003.  I  have done fairly extensive VBA programming of
a large database and don't want to run into issues with converting.  Any
help/comments would be appreciated.

out look

Hi, hopefully this is a basic no-brainer question.  I've created an MDE file
which allows full menus to be displayed because users want to be able to
export reports into text files (Export is located in the file menu).  One
user informed me that the "export" was not included under ...

This morning my database (A2000 format, running within Access XP on Windows
2000 Pro) worked fine.  Then IT showed up, gave me a new computer, and
upgraded me toWindows XP Pro/Office XP Pro.  Now every one of my maketable
queries throws an "Error 3001 -- invalid argument" error.  ...

I don't know this is the relevant place or not, but i need information about
Access 97 support.
Can anyone tell me till when Microsoft is going to support Access 95 and 97?
Is there any URL that i can know the timelines when and what product will be

All,
    I have created an ODBC entry that links to a new SQL Server
Express 2005 file database (mdf) file.  I have tested the connection
via the ODBC tools in Windows XP and it says everything is fine.  When

I've been given a word document with about 400 names and addresses. These are
in a avery mailing label format. Can anyone suggest a good method for
importing them into an Access table.
I realize there will be some percentage of error, because some have two

Hi I am able create a machine datasource using a MySQL ODBC driver but when I
select import and try to import data I get the error , Microsoft Access
reserved error (-7701).  I used the same driver around 6 months ago and it
worked fine.  Thanks.

I want to write a VB6 tool that (among other) can take a file specification
of an mdb-file and tell me whether it is in Access97-, Access2000- or
Access2002/2003-format. However, all I found out is that I could get the
Jet-Version of the file. I use the following code: