Recent content by RYankowitz

Hi all, A few clients of mine have begun to have trouble with reports. Some of the calculated fields show the #Error value. What's important here is they only see this on some of their machines. Other machines still operated correctly. Copying the Access .mdb files from the good to the bad...

Jeff, Thanks. I reviewed the FAQ's, and one in particular applied (How can I limit users to seeing only their own data on a form?), but it actually illustrated my question. The methods it described showed how "loose" Access is in this particular case. For example, while the Jet...

This is a general, architectural, question... I have an application used by multiple salespeople, each one writing orders into the database. Allowing them to see each other's orders would be a bad thing, as they are, after all, salespeople, and gunplay would likely break out if they find out...

Easy as falling off a (really high) cliff. Just follow these steps: 1. In your database, press F11 to open the Database window. Click the Modules label, select your Main Module, and click Design. Alternatively, you can create or use any module of your choice. Click New and a new module...

Happy to help, leclair. Fire away with your questions...

Thanks for the idea, LMRollins. I've seen and tried this fix, but it did not work. The "memory could not be written" error appears to have a large variety of causes, and your fix (the LaserJet 4000 driver) only applies to one of them. I still haven't found the solution for my...

Dennis, I never did receive any answers to my questions. The Microsoft Knowledge Base still shows the bug as current. My solution was to abandon the SendObject method and use Outlook Automation. This has the disadvantage of requiring the use of Outlook (which wasn't a problem for me), but it...

Steve, a) The article you saw is probably this one from the Microsoft Knowledge base, "Number of Times a Custom Function Runs in a Query," Q210554. I had done what you suggested, and found it met my expectations: the function ran once per record, or in my case, 3,300 times. b) My...

Steve, I believe I'm there now. Along the way I found two interesting bits: 1. The five second performance hit only occurs if I run the query directly. It is even worse if I have the VBE editor open (which apparently causes Access to update the Task Bar at the bottom of the screen each time...

Steve, Thanks for the response. What you've described I had already done (see problem #3 in my original message), and it works, but at a frightful cost in speed. A query with 3,300 records that takes about 1/2 second without the function takes over 5 seconds with it. Because of the...

Help, please... I have hit a brick wall. I have a need to allow a user to select any or all choices in a group while entering data, such as: [ ] Food [ ] Water [ ] Air Elsewhere the user will choose one of the items from that group, which will be used to drive a query to select...

Perhaps the following applies to you: The Microsoft Knowledge Base has this article: Q260819 - ACC2000: SendObject Method Fails in Access 2000. To summarize: SYMPTOMS The SendObject method silently fails. That is, the message is not sent, and you do not receive any error message or...

There's another reason for not using Name Autocorrect (with Access 2000). There is a bug in Access 2000 which causes the printer settings for a report to revert to their defaults when the "Perform Name Autocorrect" feature is enabled. To make things more insidious, the problem only...

Is there a recommended or best way to have multiple webmasters using FrontPage? The original webmaster keeps a complete copy of the website on her machine's hard disk and uses the usual FrontPage Publish method to make changes on the host server. She wants to allow another person (or persons)...

I have an application that crashes Access with the following error message: The instruction at "0x77f7d40f" referenced memory at "0x20306674" The Memory could not be written. Followed by a similar error which reads "...could not be read." The conditions: 1...