Recent content by HartJF

Stupid error... it always is. myquery was adapted from a working query, but I missed one adaptation. My VBA approach is valid. Thanks for the effort, Paul.

That makes sense to me. But if I try to open a recordset against the querydef, I'm getting Error 3061 Too few parameters.... I've successfully used Execute against a querydef with set parameters in other projects, but I need to inspect the recordset in this project. Here's the code: With...

Before I compact, the database is 1.66GB; afterwards, it is 1.19GB

It tops out at 1.66GB before the Compact on Close. It did touch 2GB, but that's why I split components of the base system into pieces. It once dropped the last 10, another time the last 14, another time the last 26. It's inconsistent. That's what so wacky! I've created the Indexer database...

This is as marvelous a tool as it is unfortunate a need. Is this an issue of which Microsoft is unaware? Is it limited to a specific environment, or do many developers commonly encounter it? I love Access, but it surely is inclined to jump up and bite us! Thank you for a wonderful assist!

I cannot cause a database to refrain from dropping several table indices during a Compact on Close operation. I am running Access 2010 under Windows xp. I have created a database that merges data in a linked text file with data in a linked database, appending the results in a local table...

I have a portion of an application that asks the user to select a file (.txt, .csv, or .xls_), establishes a link to that file, and adds records to a table using a query that includes a batch identifier. My difficulty is with connecting to an .xls_ file. I am able to derive the Connect...

Thank you for your reply, DirMex. I see more and more professionals having the need for cross-program integration but neither having the skill nor finding the resources to implement it... and, as a result, performing the interfaces manually. I have created code in Access to link to the text...

I'm confident that a simple answer exists, but, after consecutive twenty-hour days, I can't find it. I have a report based upon a parameter query. The parameters are determined programmatically. I need to set the parameters when I open the report. I have placed the following code in the...

report.recordset is only available in an ADP. What about the rest of us?

Your scenario sounds wonderfully similar to mine! I agree that Word is the best application in which to house the report, and that Excel is the best tool to create the chart pieces. Not only are Excel charts "easiest to set up," but I feel like I have better control over the formatting. My...

I created a one-time (I thought) comprehensive performance report. I mined 1.5GB of data in a back-end database with seven principal tables. My front-end has more than 25 queries, some nested, that produced summary output that I copied and pasted into an Excel workbook. The workbook...

It worked beautifully! I went a step beyond your solution: I placed a label with the "No data" message in the report footer and set its .Visible property to False. In the NoData event procedure, I set the .Visible property of the .GroupHeader(0), .Detail, and .GroupFooter(0) sections and the...

So, Paul, I've reviewed your responses to this post and your error-trapping routine, and found, with great anticipation, your report-filtering example. I'd like to merge the concepts. I have a set of weekly reports dispatched via Automation. I have a broad query upon which the reports are...

Thanks for your reply, Dave. This data are reports from an unattached system. (It's a DEC VAX system run on users PCs by terminal emulation. It's been phased out, but I have legacy data to retrieve.) The only way I could retrieve it without re-entering it manually was by this import/parse...