Search results

Thanks, everyone, for your insights! I never cease to be amazed by our worldwide interconnectedness. I have to dash away for a doctor's appointment, after which I'll have follow-up for each of you.

My youngest of four turned 21 this year; he'll be married in June. The next youngest is in her third year of medical school in Chicago, three hours away. The next-to-oldest shares a house with three other guys, but still comes home to do laundry. The oldest has a wife and our two grandkids...

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

Thanks for the quick response, gal. I was afraid that I'd have to use a temporary table. This is a data-mining application, so I have the large table (1.6GB) separated from the queries, reports and code, but I hadn't thought about another database for the temporary tables. That's a great...

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

Wonderful, folks! I've a couple of tricks to try!

Thanks, Bob. Everyone is at attention today, huh? The validation is contextual. Can I see the previous characters in the control when the KeyDown event occurs?

Thanks for your quick response, Kryst. This is an unbound form. Are the before- and after-update events relevant? I thought (perhaps mistakenly) that those events related to updating a field in a record.

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

Thank you for your response, Trevor. That's a new forum to me. It's excellent! I've bookmarked it (below, of course, Access World :p) My database is a utility back-end that will be used in a variety of mining projects. What I have done is placed an update shell in the manipulating .accdb...

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

Thank you for responding, Trevor. Yes, the database file is in Access 2007 (.accdb) format.

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