Is there a way to have a command button that will add/remove a reference to
a library?
Thank you very much.

I have a table that is created at run time with an autoincrement field.  
After populating the table, I want to change the attribute for the
autoincrement field to a fixed field (i.e., I want to remove the
autoincrement).

In order to adjust printing of a certificate, I have written a number of
different reports with different margins. The user will input an "X" and "Y"
adjustment, and the output will be one of 36 different sets of reports.
I'm looking for the best way to program this. I could do

I use the following coding to keep a salesman name for entry into a order
entry system:
Public gstrThisUser As String
Is there a way to move that variable into the default value on a form? I

I have a "novice" question in regards to opened databases.  I am attempting
to execute the code below (in Outlook 2003) in order to read records from an
Access 2000 database.  However, if the database has been opened by another
user (which is a distinct possibility), then I ...

In Access2k, I have a form with 3 comboboxes to sequentialy filter records.
When I click on command button to open another form based in a query, return
an error message:
"Compile error.

I need to make a text box (txtfinal) that has an expression like this:
If "txt1" >8, then subtract 8 from "txt1"
and also if lstName is null then txtFinal is null also
"txt1" is a text box from a form that has a mathematical equation on it.  

When i use olAtt.SaveAsFile to save a file, it allways asks me if i want to
save the file (confirmation).
As this is an automated procedure, i do not want to be asked if i want to
save it.

I'm using Excel from Access VBA to create a graph. Access starts Excel and
loads an .xls-file with an Excel Macro. Access the starts the Excel macro.
The Excel macro loads the .xls-file with the data and creates the graph. VBA
in Access saves the graph and quits Excel. During ...

Private Sub btnCreateInvoice_click
Dim db as database
Dim rsD as recordset
Dim qryD as querydef

How will the VBA-code look like to check which version an Office-program
(Excel)has. I need to do so and quit the macro if the Office program is too
old.

pls. give logic or function in excel or access

What code will help me with copying an excel sheet to another ecel file.
I open two excel files with code in Access environment.
Now I want values from one sheet to another (Pastespecial only the values)...
Where can I find info about this matter?

About a week ago, Steve Schapel kindly helped me with some vba code and
the following is the result.
Private Sub cmdCommissionMissing_Click()
On Error GoTo Err_cmdCommissionMissing_Click

I have the database designed by someone with the module which should export
data from the database to Microsoft Project. My problem is that it does not
work the same way on different systems, results are not the same. On some
systems filtering of the data does not work, on others ...