I love the super easy word merge but I have a question.  In my database
I select multiple records which I then want to merge to a single
document in word.  I use the single word merge and get one of the
items.  If I use the merge all button I get those I selected but they

I need to convert Paradox 7 database to any format that user can consume
(xls, mdb...).
I think that I have a Paradox 7 database (files in folder: .db, .px, .x02,
y02 if that is telling you a thing).

Hi everyone...  I am pulling my hair out trying to do this, and was
wondering if someone could give me some assistance...
I have an Excel spreadsheet containing several worksheets.  I'd like to
be able to take all of the data from the second column (B) of each

Thanks for taking the time to read my question.
I have code that I am using to tell me info about fields in a table. It
is in a loop so I can move through all the fields in the table.
db.TableDefs(x).Fields(i)

     I'm trying to run a sql query on a continous form.  I have the
query working correctly the way I want it.  I want this query to be
displayed on the form in the text box on the load event of the form.
Each record in the continous form should have different results for the

I have created a form which contains a subform.
To cut a long story short, I have created a macro that moves the focus to
the subform (GoToControl) and sets a value (SetValue) in the field on the
subform that recieves the focus.

Is there a way that a user can set the position for a single label to
print within an Access Label report? I guess I would like something
like what is available in Word where the user can select the column and
row position for the single label to be printed. I would like to be

I'm hoping I'll be proved dizzy and there's a rational explaination for
this.
User enters database - makes changes to a table. The changes are there
plain as day. User does other things in the database, comes back to the

Here's one I can't seem to figure out....
I'm trying to automate a report to be printed in Adobe Acrobat and
written to my network so it'll be there when m people come in in the
AM.  I have a macro and get it to run with scheduler but the entire

I have a report that is supposed to be two pages.  The first page
should contain the header, some data from a query, and the footer.  The
second page should contain the header, two subreports, and the footer.
Right now, the report is on 4 pages.  The first contains the header,

...especially if I want to become MS certified
I live in Des Moines  IA
Jerry

MS-SQL 2000, Access 2003, ADO 2.8
Please, consider the SQL string in the following code:
Dim r As ADODB.Recordset
Dim r2 As ADODB.Recordset

Front-end Access 2000
I have a stored procedure that has 2 parameters BusinessUnitID and
Year.
It returns multiple record sets (5 to be exact).

I'm trying to get familiar with the concept of replica's, but it still
confuses me a bit.
Here's my situation:
1) my database application, *.mdb file, should be distributed from time to

I need some help figuring something out. I'm not sure if I heading in
the correct direction. What I'm trying to accomplish is the following.
I have a table that
has id, discrip, and 2 date fields. I am populating this information