I have an attribute-centric xml file which can't be imported directly into
Access.  In addition have have look into KB article#285329 and I don't know
how to change the xsl stylesheet to bring in the xml data I have.
Let me describe what I need to accomplish:

I'm hoping someone can help me on this?
I think i'm brain dead here!!!
I have complex calculation within text boxes on a form that same information
needs to go to a report.

I have an unbound field that is a memo field type.  As the user types in
characters I want to have another unbound field counting the length of the
memo field.  I know this can be done but I can't think how to do it.  Do I
need some code on the memo field updating the word count ...

I have 10 files that I need to export in a certain format.  The format is
consistent for each of the files.  My thought was to create a form and
onclick of the button, I would open the recordset for that client then call a
subroutine to export the data.  Currently, I have a ...

I have a form "frmLocation" the form has a list box so the user can select
the location to run a query "qurEquipLocation"  that is used to produce a
report "rptEquipLocation"
I have it set up so frmLocation opens you select the location and then click

How can I have the ID picture of the specific person who's record is being
reviewed, without hardcoding it for every single person in table?

I obtained the following code from this site. It doesn't work. Most likely my
fault. I believe it is in the configuration. What do each of the .item fields
mean?
Sub CDOTestFive()

I have the following code that I thought should export my data from a
continuous form to an Excel Spreadsheet. The sql statement basically emulates
that which is used within my continuous form as the forms record source.
However, on

Anyone use wget to grab FTP files with their VBA modules before?
If so, any sample lines?
Thanks!

Hi! I would like to sum [Price]*[Qty] in the footer of my subform and the
problem is that [Price] is an unbound field with a Dlookup function in its
control source.  (Actual source is:
=IIf([Type]="Material",DLookUp("[Price]","qryCurrentMaterial","[MaterialID]="

I have a form that has two subforms it is for software.
The main form is based off the Software Table, 1 sub Form contains the
License Information for the Software (not problem with this one) the second
subform has System Assignment(s) "ie the system tag that is assigned to the

I'm firing off a report using a command button, but I want to make sure there
are not any null values on my form.  I have 3 combo boxes that all need
values in order to generate the report properly.  I have setup my code as
follows, but it is not producing the results.  The ...

My code sends an e-mail using our SMTP server:
Set objCDOConfig = CreateObject("CDO.Configuration")
sch = "http://schemas.microsoft.com/cdo/configuration/"
With objCDOConfig

I've done this before but I can't remember exactly how to do it.
Here's the line of code:
docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Op_Com", "T:\
Storage\1.Reporting\DB\ReportPivots.xls", False, "A2"

I have the following code for a click event on a command button:
Private Sub Command86_Click()
On Error GoTo err_command10_click
Dim strfile As String