Search results for query: *

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

Found the following in the Help section. Is this what you're looking for, a string comparison that checks for case as well. StrComp Returns an integer indicating the result of a string comparison. In other words, the function compares one string to another string and returns a value based on...

Not sure if this will help, but I found something in Microsoft KB article 834791. It applies to MS CRM v1.2

We would like to know where the client is coming from before they come to our site. Is there a object property, method or anything that will tell me where the client came from?

I've tried setting those values to zero and at 300. Even rebooted the computer to ensure that the values took. But still got a timeout around 30 seconds, it was as if those settings were ignored. I ended up doing the following: (1) Created a DTS Package to run the stored procedure. (2) Had...

Created a MS Access project, in MS Access XP. Later found that it needs to be in MS Access 2000. So all my stored procedure that are action queries will not work through code or through a macro. So I created a function that will run the stored procedure in VBA using a ADO Connection, and...