Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DougStevens

    ADP -- Stored Procedures; Views; etc Not Found

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

    Retrieving Log-in Information in a Secure DB

    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)".
  3. DougStevens

    Excel automation from Access?

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

    Changing printers for existing Access 2000 database

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

    run-time error 3021 no current record help

    ...the variable "mmid". Is that what seems to be happening? In other words, it should bomb out when you're on the last record in your recordset. ************************************************ With the "Updates" in the code, its seems if a donor has multiple categories and then multiple...
  6. DougStevens

    Code for dividing name into names

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

    Forcing a User to enter Data into a control before leaving it

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

    creating a table from hierarchical structure

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

    Help with - Compile Error Invalid use of property

    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).
  10. DougStevens

    Best Practice for User Name Change?

    Thanks, I'll try that.
  11. DougStevens

    Best Practice for User Name Change?

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

    MS ActiveSync synchronizing with multiple Outlook Contact Folders

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

    Do we need Crystal Enterprise ?

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

    Create Query in Access Data Project

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

    ER Diagram for MS CRM?

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

    Checking Strings

    ...StrComp(string1, string2, compare) Example StrComp("ABCD", "abcd", 1) returns the value 0. StrComp("ABCD", "abcd", 0) returns the value— 1. ********************************************** Value Constant (for use in VBA code) Description —1 = vbUseCompareOption Performs a comparison...
  17. DougStevens

    Deleteing a crystal report in MS CRM

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

    Determine Client's Previous Site

    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?
  19. DougStevens

    Help with Timeout Expired

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

    Help with Timeout Expired

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

Part and Inventory Search

Back
Top