Recent content by AArt

That gives me something to think about. But I don't want to have to open 65 Visio files. With the dbs, I was able to automate opening all the files (even from other professors' classes) by putting them in one directory. Then by creating a few tables and comparing, it was easy to get identical...

First, I apologize, I'm at a loss which forum to post this to. When my wife was teaching Access, I was able to create a db that pulled in her student projects and compare some key data to see if any were sharing their files (aka cheating). Now she's teaching a class where they turn in IS...

I misread that the first time. Consider me duly educated. Thanks again.

Resume did the trick! Thank you all.

I wrote a function to parse the string, so yeah, that's one way. The error handler just seemed like it should work. Gruuu - I tried err.clear, certain you had solved the problem. But it didn't seem to help. Here's the code. Don't laugh, I'm self taught. Sub BigTest() ' ' BigTest Macro '...

I'm creating and renaming sheets based on the customer name in a cell (truncated). Some of the customer names have colons, which are illegal, causing error 1004. The error code: On Error GoTo fixname Here's the rename code: TryNow: Sheets(cursheet).Select...

Yes, that works fine for code or macros. I don't remember having to confirm action queries when doing them manually, i.e clicking on them...

My company finally upgraded me to Access 2003. When I manually run a query, I get the Action Query Confirmation Dialog Box. I already cleared the Action Query check box in the Edit/Find tab of Options. I even went back in and checked it, then unchecked it again. Access Help just gives me is...

That did the trick!

Create a new report. Use your 1/4 report as a subreport 4 times on the new report.

I'm building a report with a Graph on it. I got it looking good, with all the data on one page in landscape mode (Graph is only 7" wide, report is 7.5). For some reason it prints as 10 identical pages! Not 8, not 9, but 10... Anyone else ever see this?

You can set a field to run vertical, but I don't know of a way to make it upside down. I'm guessing you'd have to convert it to an image file, invert it, then display it. OR - create an upside down backwards font. Then reverse the order of the characters in your field before displaying them. WHY?

I know I've done this a long time a go. I'm trying to join this century and not use DAO. I pulled this right from the help files. I'm looping through all of the DBs in the directory and pulling the database creation date in the MsysObjects file. The looping is successful, but it crashes at the...

This is a strange twist: The report prints fine if there's data. The report prints fine if I remove all code from the Report_NoData sub If I try to trap the error, or even put a breakpoint in the NoData code (even the very first line!), nothing happens. It's as if the code never runs. It's like...

Other stuff prints no problema. Also, I removed the NoData code, and it prints fine, just blank. Not the end of the world, but I hate a gremlin I can't find.