Search results

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

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

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

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

Although I work in a functional department (not IS), I've been instructed to develop an archive for our portion of our legacy system. (Other departments aren't interested in the historical data, for reasons that I can't fathom) That system was developed in DEC VAX and is a cobbled-together...

I have opened a snapshot-type recordset against a lengthy query. I want to query against the recordset, but I can't get recordset.openrecordset to work for me. Here's the code: set rst1=currentdb.openrecordset("tbl",openforwardonly) set rst2=currentdb.openrecordset("qry",opensnapshot) do set...

I am trying to perform input validation on a textbox. I was hoping to alert the user as soon as an invalid character has been entered. I have been frustrated using the OnKeyPress and OnKeyDown events, so I am considering a new tack: full field validation. My questions are two. First, does a...

I have a database that is used in a data mining system. After compacting-on-close, it is over 800MB. Each week, the data is refreshed by deleting all records from the tables, then appending new records by way of queries against linked text files. Those files total nearly 500MB. Before the...

I'm running Office 2007 under Windows xp. I have an unbound Excel chart in the detail section of an Access report. I use code to push specific fields to certain positions in the related spreadsheet. At the end of the code, I switch to the chart. When I view or print the chart, the datasheet...

I am running Access 2007 under Windows xp. I have embedded two Excel chart in my Access report using unbound object frames. For each chart, I added Sheet1 to store the data; Chart1 refers to that data. I have selected Chart1, formatted the chart, escaped the frame, and saved the report. I have...