I build automation that is working from access on an excel
file(object).when i'm trying to open another excel file,the automation
is stoping and i'm getting an error.
is it posible to isolate the automation so it will not be disturbed

I know I've asked this question befoe and find it amazing that I haven't an
answer yet.  One last attempt.  How do I set both fields in a two field table
as the key index.  The answers I got refer to icons on the screen that just
don't appear for me in access 2007.

I was informed that you must run code from an object or macro and the
"Run" or "Debug/Step" won't work when looking at the code development
window.
Then I was told that is not always true.

I create a macro using the TransferText action and at the File name, i would
like to add the date.  I use the following syntax:
Use the syntax...
[file path/filename] & Format(Date(),"[format string]") & ".xls"

Same as per the subject line; simply want to know how to highlight my entire
resume, is there a way to do this that doesn't take a long time?

I have this line of code in my database and I don't know what it means.
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
What the hell is a FormBar?
Thanks

I am using a database that was developed in Access 2003 and when I try to
print a set of labels, it asks me for the parameter "TRIM" as if I wanted to
input a variable value.  I went back to Access 2003 and the database still
works properly and prints out the labels.

I have 1 Main form with more than 20 subforms. I have created a code below
on every the On Exit event of every subform to move to the next field of the
next subform.
Private Sub Corporate_Objectives_Exit(Cancel As Integer)

I have been away from database programming for a little while and cannot find
the right terminalogy for this.  I have to setup a table that will have
varible number of entries.
ie:  I want to group my movie together by actor they have in them.  Sometime

This is kinda strange.  Access XP database, it's been split and linked into a
front-end with all of the forms and reports and a back-end with all the data.
The links are through explicit drive letter/directory pathing, not UNC
names.  Multiple people are using this.  And there's ...

I found the link to http://www.mvps.org/access/modules/mdl0001.htm suggested
in an earlier question. How do I attach this to a specific field? I have a
dollar amount that I need to print in words and I don't know how to
accomplish that. Thanks for any help.

The date format seems to change when i install the application on another Pc.
This causes problems as i need to export this field in the yyyymmdd format.
Cheers

Is it possible to turn the SubForm upside down so as you have the blank Text
boxes at the top then the last entry underneath it
Thanks for any Help......Bob

I have some basic questions about Access. I hope you can give me a
hint:
-Can I define derive attributes? How? I think I can get a workaround
by defining a query that selects some attributes and computes

I'm exporting data from Access using an external XSD. When I export the
fields - fields where there isn't any data, are not exported. Can someone
please explain how I can export fields with null values.
Could you also explain how I can export XML data into a particular XSD.