Search results

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...

That makes sense, Bob. I was hoping (bad decision) that the data was in PrimaryKey order, as it is when opening the table through the UI. Once again, quick and sloppy yields sloppy results. Thanks for the answer, Bob.

I've had this problem on several occasions, but I always assumed the error was something else. The current episode is the simplest, so I don't see another error to blame. My goal is to parse several .txt reports. My table has two fields, ID, an autonumber, and strRaw, an 80-character string...

gemma-the-husky (and you too, Dave): Thanks for your encouragement! I want to avoid the overhead a .csv file creates -- text delimiters and field separators would add about 1K to each record in the two largest files, an unnecessary 150MB in total. The "data dictionary" includes dozens of...

jdraw: Thanks for your thought-provoking question. This is a legacy system. My department was the last to migrate to the new system, six months ago; the rest of the organization migrated eighteen months ago. We are still paying licensing fees on the software, which management wants to...

GalaxiomAtHome: Thank you for your thoughtful response! I appreciate the mention of the 255-field limitation. Does that refer to the total count of fields in all tables joined within the query plus the output fields, or does that only refer to the source fields referenced by the query plus...