This may be a basic thing to do but im stumped ....so please help
I wish to run a query and then cycle through the results and write
just one field into a text file in cvs format
To date i have used recordsets to cycle data but with the required

I am setting up a Church database but when a marriage date is set, the
Rector would like the dates that the Banns to be read in chuch to be
automatically stated.  The database currently has a married date field
'MarriedDate' and fields 'Banns1', 'Banns2' and 'Banns3' need to be ...

I am trying to run SSIS Package on button Selecting action "Run Application"
I got below string which is not working saying "Invalid Procedure call or
Argument":
stAppName = "C:\Documents and Settings\aab\My Documents\aa.dtsx"

Does anyone already have a programmatic approach to splitting the export of
a dataset larger than 65536 records into Excel?  I understand the nature of
the limitation, so I'm not looking for a dissertation on why it's a problem.  
Rather, I'm  looking for code that will place some ...

I have a number of installations of an mde file I have distributed (Access
2000).  It has a separate backend tables file.  
Several users have asked if they can develop and include their own reports
in the mde database.  As I don't want to provide the mdb file for them to

I'm trying to use the Month() function to extract the month of the date input
by the user.  The user selects their date using a calendar and the calendar
value is placed in a text box on the form.  I'm trying to extract the month
from the date in the text box on the form.  Here's ...

I get an error messge:
compile error: can't find project or library
whenever it hits CHR(34)
Any ideas what references it is looking for?

I use the following code within a module to open excel Spreadsheets as READ
ONLY to update  an  Access database
Set fs = CreateObject("Scripting.FileSystemObject")
Set fp = fs.GetFolder("\\Shared\Write-ups\")

I'm not a full on programmer, but I have written a lot of code over the years
to apply logic, and to filter external tables for import into MS Access
tables.  I'm starting on a new project to write code using SNMP and Telnet to
go out interrogate a Network Device such as a router ...

If I copy a database and send it to another location (server), how do I
reference the references needed to run the program at the other location?  Do
I have to have the user manually go into to the code and select the
appropriate references or is there code I can write to apply ...

I have three buttons on a nomination form, if users click on any of the
button I want the contact name and other information for that particular
record to be inserted into a table. I used the following code:
Dim SQL As String

I created a custom login form but don't know how to create a code that will
require users to change their assigned password on first login.
Please help
Thanks

How do you move info from records from one table to another table

I'm a newb at VB code so go easy on me...
I have a table, of [dept] numbers and [directory paths].
I created a report that pulls those variables and outputs a snapshot
file.

I want to combine 2 memo inside a unique textbox and to display an empty
line between them. The textbox is part of a bound form and high enough to
display many lines. The form is based on a JOIN statement between tblAcademic
and tblClasses.