The following applies to VBA with ADO and SQL Server 2000
I want to use a trigger to manage the deletion of records in a table.
However, I have a procedure in VBA that creates a new connection with the
server, which can be run by any user, and where I don’t want the trigger to

is there a function  for the cumulated standard normal distribution in Access, like the NormSDist in Excel? Or is there a way to use the excel function in access, e.g. by referencing the excel object library?
Thanks a lot for your help!
oliver

The original data is a query, for which I am subsequently performing an SQL
query upon it. The field in the original query dataset is a String or
Character, yet when I perform an ADO SQL and print our using Debug.Print the
output is an integer. The query field is definitely a ...

Can i put different public subrountines in a modules and run it by thorugh
forms but that name is stored in a table?
e.g.
In module:

i'm currently doing a fixed asset db, extracting the data from the SQL
server. as the depreciation for the fixed assets changes every month, i would
like to store the previous months of the fixed assets in a table. every
month, the user would press the update button on the form ...

i asked this once in a different way, so i will try it this way:  I made a
split database and distributed a copy of the front end to all the users.  
some of my users are getting an error message that someone has the database
open in exclusive user mode.  how can i fix this?

Thanks for taking the time to read my question.
I want to use labels for buttons instead of buttons. That way when the mouse
moves over the button, I can change its appearance.
That being said... instead of having code on all my label buttons, I'd like

Could someone please give me a hand - I have written the following code to
compare an audio test with a previous test to see if two consecutive
frequencies have a change of 15dB or more to set a field to 'Abnormal Shift',
or to 'No Change' if untrue.

i've been on the threads for the last two days, and i'm not making any
headway. I want to place on an Access Form a button that launches an Excel
Spreadsheet.  I see that this question is asked quite frequently, but all the
answers are not working for me.  Here's what I'm doing:

I have two seperate questions regarding FileSearch & an Excel Instance.  I'll
start with the latter.  Thanks for the assistance.
I have a module that opens an Excel instance (objExcel) and closes it at the
end of the module by using objExcel.Quit & objExcel = Nothing.  However, ...

Hi--
I have a checkbox in the detail section of a report.  I need to make it
visible or invisible programatically.  I believe that I can do this using
the On Print event of the detail.  My problem is that I cannot determine the

I've posted a few times and been reading the boards for a while and I'm
scared by how much the MVPs know.  But in a good way.  So I'd like to pick
your brains on a book question.
Can you suggest any particular books that you feel Access programmers should

 I am trying to find a way to copy a field value from table "A" to a field
in table "B". I realize that this causes duplicate entries but it is reqired
because at a later date I need to be able the change the field value of table
"A" and not have it affect the value already ...

Can Access vba create / modify / read INI files?  I would like to put some
general environment options in an INI file outside of the database so that
relinking to a backend and the various backend locations can be easier along
with some other environment variables.  If yes, can ...

I am working with a treeView.  Tree view keys must start with an alpha
charactor and does not allow you to use the same key twice in the treeview.
My key field is a numeric field that I am appending an "a" to  like this:
set treekey = "a" & strTreeKey