Recent content by Dragunsfyre

The data for the report is in one table - tblTimeCards. The critical fields are [ProjectID], [WorkDate], [Description] and [BillableHours]. For audit purposes, I need to create a report for each [ProjectID] which will display the [WorkDate], [Description] and [BillableHours] in chronological...

Thanks for the help, Roy. I really appreciate it. I also received a suggestion to try using a DAO procedure and I'm going to experiment some with that and see what I can do.

That worked as far as OpenDataSource line of code is concerned, I was able to get to the fully merged document, but, in the process, the query did not pick up the matching criteria WHERE tblClients.FileNumber = Me!FileNumber I was prompted for Me!FileNumber before the query executed. It...

My Access 2K to Word 2K mail merge module is: *********************************************************** Function MergeDoc(varDocName, varQryName) Dim objWord As Word.Document Set objWord = GetObject(varDocName, "Word.Document") ' Make Word visible objWord.Application.Visible...

I have an Access 2000 database with two critical tables, tblClients and tblChildren. I am trying to generate a query which will produce a one record recordset for use with Word 2000 Mail Merge documents. The desired recordset would include the needed client information and the names and DOBs...

I am using Access 2000, Excel 2000 and Word 2000. In Access, I collect various personal income and expense data, then, through the use of a command button, export that data to an Excel workbook with several sheets, the two which use the Access data being "Data" and "Form". The command button...

Geez. Works like a charm. I've spent more hours trying to solve this one than I care to count. You've been a great help. Many, many thanks.

When I enter the query in SQL as SELECT * From [tblClients] Where [FileNumber] = "05-003", the appropriate record returns. Does the fact that the file number is stored as a text value rather than as a numeric value matter?

That was a typo. I meant "Count" not "Set".

If I had read the first sentence of your post a little more closely, I would have seen the reference to the form field [txtFileNumber] being unbound. No matter what file number I enter, the Me.RecordSetClone.RecordSet argument always returns a 0 and the message box appears. I modified the...

I'm getting a Runtime Error = 3022. The field, [FileNumber], is the primary key for [tblClients] and is indexed with no duplicates allowed. When I debug, Me.Recordsource is returning [tblClients] and Me!txtFileNumber is returning the selected filenumber, but execution stops there. Any...

I am using Access 2000. My database consists of client personal info data (name, address, SSN, DOB, etc) [tblClients] and is used primarily for document prep using Word 2000 mail merge documents. The primary key is the Client File Number [FileNumber]. I use a TAB CONTROL form to enter new /...