Recent content by DougStevens

Need assistance with an error on a ADP file. A week ago I've installed a SQL server and with a ADP file as the front end. The installation and tests were successful. Now, whenever the user is experiencing errors with this ADP file. Here is the gist of the issues/errors that appear to be...

The CurrentUser() function will return a string of the user's login name. You can declare a WorkSpace variable to get to the "Users" and "Groups" collections. First set the WorkSpace variable to "DBEngine.WorkSpaces(0)".

Okay, here's one site that used often to find help on MS Access. Check out this article on using Excel Automation from within Access. http://www.mvps.org/access/modules/mdl0007.htm Hope that helps.

Once had a client who had several identical dot matrix printers, but each printer had a different shipping label (e.g. Airborne, FedEx Ground, FedEx Air, UPS, etc. etc.). We created unique printers depending upon the custom paper size. Then simply created the report to specifications of the...

Just guessing, and a shot in the dark. Let's say you have two records 5 and 6. Outer most loop, you loop through the recordset. In the first pass you start at 5. You set "mmid" to 5. Then you move to the next record. (Not sure yet). Now you're on record 6. Then you're in the first inner...

I've written several functions like these. It almost always depends upon the nature of the data set that determines the best approach. However, my favorite function involved passing the full name as a string and a coded valued to return the part of the name that I wanted. (e.g. 1=FirstName...

Out of curiousity, couldn't the AfterUpdate event work better? The value of the control is, I assume, NULL prior to getting focus. The user enters some keystrokes, the value of the control is not committed and still is NULL. Therefore, in the BeforeUpdate code, that Sanan had earlier, will...

Can you modify your VBA code so that passing any RegionID and it will recursively calculate its total population for all of its children and grand children? Sounds like you've got the recursive side done. Assuming you have some code that looks like this psuedocode: Function...

Is AuditTrail even on the calling form? If it is and if its bound to a text box control (guessing that). Then make sure that the text box control has a different name from the control source. (e.g. name the control txtAuditTrail).

Thanks, I'll try that.

Need some help/insight on the best practice for a user's name change. We are currently running Windows 2003 Small Business Server, with MS CRM, and MS Exchange 2000. We have a user who recently gotten married. (Congratulations to her!!!). She would like to use her new name for emails...

We have someone here who organizes her contacts into multiple Contact Folders within her Outlook. She is using an HP iPaq with Pocket PC 2002 Prem and Outlook 200 on her PDA. We are also using MS ActiveSync. (We are using Exchange Server, but not synchronizing through the server.) Only her...

I am curious about a viable solution as well. We have CR 9. We've been creating reports, reports with parameters hitting off of several SQL databases. Is there a solution to put these report onto a intranet site within the office so that other people can pull up these reports and view them...

In MS Access you've got queries of all types, but basically in two major categories. They are Select or Action queries. Select queries simply pulls information together so that it can be displayed. Action queries usually performs some work (e.g. append, update, delete, make-table, etc.) In...

Here's the thing, we have implemented MS CRM at our office. I am tasked with creating custom reports in Crystal. I am poking around, hunting down fields all over the place to look for the information that I need. Is there a ER diagram of MS CRM? Something that would show the default fields...