Whenever I try to populate my Treeview control, I get an error 35602 "Key is
not unique in collection".  The table I am populating from has 1 record and
the primary key is an autonumber.  Here is the code:
Private Sub FavMenu()

I'm think i just might be trying to do something here that seems to be
difficult, or poorly documented. I am trying to build a query based on one
table (hardware). The table hardware contains fields like manufacturer,
model, type, ipaddress, mapping, location, etc...

The below code is breaking out on the line of:
             pcdFormToDrs False
I have no idea as to why this is happening, cause in the earlier tests, this
worked fine and had no such issues.  VBA option is setup to break only on

Has anyone tried to convert AccessBasic97 code to AccessBasic 2007.  Is it as
simple as cut and paste or is Access Basic2007 really different from
AccessBasic97?

I have been doing some reading to try figure out the best way to get reports
to a web page from an Access data base. Everyone suggest that I use ASP.
One problem, I do not have access to a web server. The web page would be on
a network drive.

I have a procedure that uses TransferText to import file(s).  After they have
been imported I need to update those records.  I have the update query below.
In my procedure I have:
   With qdf

I have a Access form with option buttons that is completed by the user.  I
want to make the process as easy as possible for the user to click on the
options that is applicable for the customer.  Then when I create a report
that if an option button is selected it will actually ...

I have the following code to read through a text file
   Dim FileNumber As Integer
   Dim sFile As String
   FileNumber = FreeFile

I have successfully writen a data import script that appends excel data to
an exisiting table.  I wrote the script to operate on the button-click event
for a command button.  When navigating my code in the VBE, I notice that the
code is duplicated in different form objects, which ...

I have a form to which employees add , delete or update locations (addresses
) each month for 12 months for each customer.  There is a main form with the
basic customer information for each month and a sub form with all the
locations for each month.  A location must be on each ...

Long story short... dealing several legacy access databases that I inherited
and now I have run into a brick wall (caused by one data field).
I need to find a quick/simple way to convert a NUMBER field to a text field
for comparison within an update query.  I realize simplest ...

I have a peice of code that has become unacceptably long-running and ties up
the UI for too long.  I'm looking for a solution.  It used to be just the
task that had start and complete dates but now it is each person working on
the task has a start and complete date.

I got the following code from Paul Sadowski's web page.
 Set objMessage = CreateObject("CDO.Message")
 objMessage.Subject = Me.Subject
 objMessage.From = "MikeShipp@aol.com"

I hope someone can help.  I have read through the posts on regular
expressions and am still at a loss.
I have a field in a table that contains text data that looks like:
HPWLY  CXLUMA       81  295  10930149                      RJ 66 CHTM

I have a question regarding updating a table.  I am currently converting
dbase to access but do not know how you would update a table directly before
it's seen in a form.  In dbase i can run a program(which evaluates each
record with a do while not eof() and replaces blank ...