This is a bit of a puzzler.  I've built this application that goes through a
network folder full of Word forms and if certain criteria are met, writes the
data from the form to an Oracle db.  I was originally using a UDL file for the
connection because that's the way my colleagues ...

I have a problem opening Excel from MS Access through VBA in certain
situations, that I hope someone can help me with.  The procedure works
correctly if Excel is not open.  It also works correctly if Excel is
open, and no cell is active (by active, I mean a cell in Excel is

I am trying to create a report using design view - When I add a text box and
click on the 3 dots on the properties window so I can add the control source
which works fine -- However When I run the report I am getting the following
error in the text box field "#Name?"

Calculate %
I need some help with calculating the % --
This is what I have thus far --- I created a query and for one of the column
I did a ‘count’ Now I will like to add another column in my query and take

I have the following subroutime that writes a record to a table. When the
assignment statement  - ![ConcWithDrug] = myConcDrug  - is executed, the
field in the recordset is padded with blanks or unprintable characters. The
field that has the original value has no extra characters ...

Hi,  I have tried using the knowledge base instructions on populating a
treeview control, but cannot seem to make it work.
Basically, I want to populate a treeview control with a list of 'Pot names'
which are used to refer to collections of data.  I then want a branch that

OK I have a report where I will generally want to hide the duplicates, except
when it is a specific value.  How would I code it so that it does not hide
dups on one value, but hides it on all others.  
TIA

Hello.  I have two public varibles in a module that have a number assigned to
each one.  I also have a form where, when i press a button, i want the values
of each varible added to a table.  The varibles are Public Record As Integer
and Public License As Integer.  

I am trying to get the path of a file with the office open or the file picker
dialogue using VBA. The file is a lotus notes shortcut. The file works fine
when double clicking on the desktop but when double clicking in the dialogue
box or single clicking and pressing the open ...

Suppose you have two MDBs, one for the GUI, the other for the data. I do not
want to use DAO, I want to use ADO.
Probably simple question, but what do I have to do for using ADO inspite of
DAO? I removed the reference to DAO, and inserted the reference to ADO. What

Thanks in advance.
Here is what I am trying to accomplish...
How can I change the value of the "active" checkbox in tblInventory for a
vehicle that just sold by just clicking on the "save" button on the

I keep getting "Out of memory" error messages when I try to execute or modify
the visual basic scripts in an access database.  I can manipulate tables and
run queries, but the application will not let me run or modify scripts.  The
problem is not script-specific: I can't delete ...

I have some code.  You fill in a table name on a form and press a button.  It
goes through all the queries in a db and reports back those queries that
contain the table name.  I want to alter the code to look for more than one
table at a time.  In effect I have a table that contains ...

I'm sure that most of the Access programmers know that problem. When a
string contains an apostrophe or a double quote, the FindFirst-function
fails. At the moment, I'm using the following command:
rs.FindFirst "Destination='" & Replace("Côte d'Azur", "'", "''") & "'"

I would like to automatically add the last two digits of the year to each new
primary key when a new record is added to a table.
Eg.
If a new record is added to a table with an autonumber field the keys will be: