I have update a database from Access 97 to Access 2003. When I compact and
repair the database db1 creates and is left in the directory, but Access does
not do the rename and delete. So I am left with the original db uncompacted
and db1. I have seen this behaviour on another one ...

I am working on a database that will check different projects for date
conflicts and will be linking to quite a few excel spreadsheets as data
sources for the individual project tables. The problem I am looking at is
trying to automate the process as much as possible through VBA. ...

I need to practice my office skills in excel , word and other microsoft
office applications.  How do I access the practice sheet in the training
module or how do I download microsoft office 2003

If you are using a Mac with Access, is there a place I can find the
substitute keystrokes for the right mouse, alternate key, etc.?
Thanks

I'm new so...I have multiple tables set up each having some simple
information and a # 1, 2, 3, etc. assigned to each piece of data (i.e.
customer abc=1, customer def=2, etc.).  When creating a form, I want to have
a field automatically generate itself by grabbing just the # from ...

I have a table which has packed data in the dollar fields. For example the
price comes in as 124B which needs to be converted to 1242. A = 1, B = 2, C =
3, etc...
Is there a way to update the table to change the last bye of the field to

Has anyone successfully upgraded an Access 2003 with user level security to
2007 and been able to successfully create a package with the runtime files
and have it work properly?

I'm getting an error 2101 on setting my recordsource?  Any clue why?
I get it if I set it to any string value of a table or query name.
i.e.
Me.RecordSource = "tblDonors"

I want to export a report as an rtf file, but want it as a continuous
document with no page breaks. How can I achieve this?

Upon clicking a Button, I'd like to goto the first record in a list box, run
code, then go to the second record, run code..until the last entry in the
List Box has code run...similar to a Do Loop.
Doable??

need to set up a contacts folder for a contractor to send emails to  
individual addresses (all Bcc)  but I dont want him to be able to see the
addresses which are in the folder.

why does access 2007 convert "Like" to "Alike" in my query?

Afternoon,
I have just started using office 2007 and can't seem to enable add in's to
allow me send sent a report to Excel format via the SendObject function in a
macro.

Can we install 2kind of access i,e. ver2000 and veer.2002 in our computer?,
if we can, how can we do it. I want it because I want to convert my MDE one
in ver2000 and one in ver2002.
Thanks for any advices

How can i prevent the form CAP from loading in the following code:
dim a as single
If [Forms]![sw]![FRM] <> "cap" And [Status] = "Open" Then
a = MsgBox("You cannot handle more than one case on the same time", 16,