Just a quick one, does anyone have a good reference or suggestion for
info on integrating MS Graph with Access via VBA code? I have read
some conflicting information and just wondering if someone has a good
reference site that may save me many hours...

I have a package that is a self extracting file to deploy an OCX if
the referance is broke. How can I activate the package with code
(invoke the same behavior as if you Double-Clicked it) and block the
securtity warning if possiable? I have looked and I really can not

I have Access 2007 on my home machine and use Access 2003 at work.
Are there any options available to downgrade my home machine to 2003
(or run both versions) that don't involve paying full price for a new
copy of 2003? I have tried to find the information on that on the

We have a AC2003 split database with <20 users.  When one of the users, my
secretary, logs-in, she received the warning message:
"You do not have exclusive access to this database.  If you proceed to make
changes, you may not be able to save them later."   After that, she must

Is there a way to use a command button to transfer text from one field
to another?  For instance, lets say I have a two fields like
txtCurrentOrder and txtPreviousOrder.    I want a command button that
says, "Add New Order" and when it is clicked, I want to transfer the

Hi all~
Using A97, WinXP
I have a table with the file names of recorded calls.  Table has
nearly a million records in it, and the total db size is 60 MB.

I have a database into which I store results. The database contains
four tables as follow -
lab
plannedTest

I use an MsAccess frontend app that uses a 2 table view defined in
Sql(2005). When i link the view manually I can say (and cache in
Access) what field will be used as as primary key. This way I can
update data in the view (in both underlying tables). In fact the same

To start: I do have several Access-installations on my machine.
For some reason (again) I don't have a context (right click) menu anymore for my controls in designmode.
I DO heave a context menu for the form or report itself, but not for the controls.
I know (I think I know...) ...

Dear reader,
I know there are Table properties (object properties), see next code below:
Function blnSetAccessProperty(obj As Object, strName As String, intType As
Integer, varSetting As Variant) As Boolean

I have a query with a single table. One of the table fields appearing
in the QBE grid is [NPPubDay] containing values from 1 to 127.
Then I have the following calculated field named [Published]:
Published: IIf((1 And [NPPubDay])=1,"Sunday ","") & IIf((2 And

I have a continuous form with a field called doc_type.
On the top of the form is an unbound combo box from where a user can
select the document type.
In the AfterUpdate event of the combo box I've set the DefaultValue of

I have a CustomersDB.mdb which I need to update and have written quite
a long upgrade module in  VBA to add fields, relationships, change
data etc etc.
There is another DB call it Sales.mdb that is used heavily, there is a

Is there a way to program (API...?) a message like in Windows like
when you receive a message in Outlook (blue box)... it comes gradually
and fades out by itself.   Txs.

An unusual spin to this recurring disk or network error in a Terminal
Server environment.  Access 2000, Terminal Server 2000, file server is
windows 2000.  All users have a separate copy of the front end db,
everyone accesses the back-end db via a network share.  To preface,