I'm using the code below to add a reference library. Is there a vba way to
remove a reference if it exists?
CODE *********
Function ReferenceFromFile(strFileName As String) As Boolean

I need to figure out a way to run a macros in Access that will open
another program and bring in a certain file.  Is there a way to do
this?  I'm struggling.

I have 3 tables that I am entering data into on the same form.
I have the people table with name, date of birth...
There's an occupation table and a children table listing their kids
all three tables use an autonumber as their key and that number needs to be

I built a simple form in Access 2K. It has a textbox, listbox and two
command buttons. I went to the properties window/other tab and named my
controls. I opened the Visual Basic editor and went to the drop down
list of controls and all of the controls were still named with the name

When applying a formfilter in Access,  form controls inherit a value from a
previous input.
How can I clear this (Visual Basic).

I want to perform an action every time the user clicks the add button to add
a new record on a form so I put it within the add button code.  The user can
also use the down arrow key to add a new record.  Is there an event that
fires when the user uses the down arrow key to move ...

I am working through Julitta Korol's Access 2000 programming by example. I
have Office 2007. I made the folder with northwind a trusted location and am
trying to do the very first exercise which is to make ContactName in the
Customers form change backcolor on Got Focus. I have ...

hi
i have five tab control pages in my form, and i want access to take me
automatically to the next form when i exit the last field in the first page .
is this possibe?

I have a query that filters a record using the following code:
DoCmd.ApplyFilter , "[Vault No] =  " & [Forms]![FrmReleaseOffsite]![xVaultNo]
it works but there are some other fields of info I want to capture and use
else where.  I "Dim" xDeveloperName as string, then run this docmd ...

I've got a subform (sfrmRevenue) that contains a combo box called TranType.  
In the After Update event of this combo box, I've got this code...
If Me!TranType.Column(0) = 1 Then
   Me.Rate.Enabled = True

Below I have a function that returns a file name when a full file path is
passed as a parameter. So for example, "c:\temp\myfile.txt" is returned as
"myfile.txt".
How can I do the same thing, except return "c:\temp\" or the path minus the

I just downloaded the toolkit and installed it. When opening it the message
comes up that it is read only. When you try and analyze a database it tells
you it cannot write to the database. What is going on? How can I get the
Conversion Toolkit to work?

In a general module, I have the below code that "Dims" a public variable,
then I sent that variable's value. I'd like to be able to reference that
variable from any of my vba code within Access.
I'm getting an "Invalid outside procedure" error because of this. How can I

Is there an easy way to "pad" the Month() and DAY() Functions? So if
MONTH(dATE()) EQUALS 6, I need 06 as a result.

I have a form that, depending on various options selected, has subforms pop
open.  These pop up forms are used to specify details for the current record
on the main form.
When I am done filling in any one of the particular pop up forms, I close it