I'm fairly new to VBA and am getting nowhere.  Performing the task manually
provides options for linked, local, structure only etc., but within VBA
(using DoCmd.CopyObject) all I seem able to do is create another linked
table.

The code below I use to output a field of data as I build it into a SQL
INSERT statement.  When the original table is updated (tPath Field) it is OK,
but when inserting tPath via SQL, after the string gets to 188 charactors it
exports garbage like this: 颼ᩢǡĀ退ꝲ壡锖ϡĀ᠀怈颼ᩢǡĀ .

Is it possible to reference a calculated field in a recordset? Here is the
code i have.
I have a query that searches the email body field and gets a string from
that field. So the only true field in the query is [body].  However, the text

When the following VBA Code is executed I get a run-time error:
   strSQL = "Insert Into myTable Values (" & _
       Chr$(34) & rst.Fields(0) & Chr$(34) & ", " &  _
                        rst.Fields(1) & ")"

I am using a TreeView object to show a Bill of Materials and to output the
views path to excel for analysis.
TreeView does not allow you to use the same key twice in a veiw. My key is
created by concatenating "a" to my part key (this is because treeveiw keys

For some reason, if I insert a breakpoint the code does not stop at
breakpoint, as VBA usually does.  Does anyone know of a setting I must have
inadvertantly changed?
Also, in the same database, if an error occurs in the underlying code of a

Hi;
It is time to overcome this obstacle.
Have an sfrm, (datasheet), that records what a customer purchases; both
inventory items and services.  The user selects either inventory item or

I'm trying to build a report where some fields are created on the fly
using some vba. I've tried using textboxes and labels, but I don't seem
to be able to modify either's values from vba code. How do I do this?
Thanks,

I need to connect to a remote DB so I can make a report making app. I called
my IT people for a connection string and after a month of pulling teeth and
twisting arms, I finally got this .ini file from them that might be useful or
it might not. I cant seem to figure out whats my ...

I have an application in VB 6.0 that uses an MS Access 2000 database. The
application is used for Data Entry, Modifications and maintenance. Some
reports were generated using ASP from the said database, that were made
available through the application as well as Intranet.

I have an interactive form that gathers information from the user. The
questions change depending on the previous answers, so upcoming questions are
hidden until needed.
My problem is the following: on the 'lostfocus' event of each control I have

I have a split, secured, multiuser db running with the AutoFEupdater. I
regularly send updates of the FE to my contact person on site via email and
he places the new FE in the right folder on the network drive.
I think it would be cool to have the FE update itself via the internet ...

I have a MSAccess 2003 database which has a calculated field.  This field may
return a negative number.  Is it possible to have negative numbers display in
a different color (such as red) then the positive numbers in a calculated
field?(I do know how to set the static colors.)  ...

I'm building a form that allows the user to enter a table of about 30-50
records, then click a button to run a couple of append queries to dump the
new records to their appropriate locations in other tables.
To start, when the form opens, I want to create a copy of an existing ...

I get data from a mainframe.  The date is in this format:
20051003.
How can I build a where clause in a sql statement to only return the records
for this month, using the system time.