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 derfloh 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: *

  • Users: MCuthill
  • Content: Threads
  • Order by date
  1. MCuthill

    VBA Excel 2003: "Method or data member not found" on Exiting Excel

    Greetings Fellow Tek-Tippers, I have a (hopefully) simple question of the group concerning Worksheet Protection and Control Objects. I have developed a calculator of sorts for our staff to use, where a driver Combo-Box will set the Visibility, Link Cell, Cell Link Range of other Combo-Boxes...
  2. MCuthill

    Excel 2003: "Member or data not found" on Exiting Excel

    Greetings Fellow Tek-Tippers, I have a (hopefully) simple question of the group concerning Worksheet Protection and Control Objects. I have developed a calculator of sorts for our staff to use, where a driver Combo-Box will set the Visibility, Link Cell, Cell Link Range of other Combo-Boxes...
  3. MCuthill

    Displaying only if 1 or more of 3 flags has True results

    BigDaddyE, Just a quick idea... what about having the default value of StringVar message being "No" instead of ""? (if you still need empty space for the "No"s, you could conditionally supress the "No"s) Hope this helps! Mike --------------------------------------------------------------- "To...
  4. MCuthill

    Efficiency Question: Large Recordset Looping

    Greetings Fellow Tek-Tippers! I have a theoretical question to ask fo the group, hoping someone may know if I can speed up a function I have developed. I have a two-phase macro set up, the first step generates a very large table (1.1M+ records), the second step analyses the first to generate a...
  5. MCuthill

    Filling Table - Create Records for Gaps in Database

    Greetings All, I am trying to develop a means of "filling" in missing data from a table, and would like some guidance as to the best approach to take. I have thought of a few differing approaches, and do not know how to implement or which method is most effective for the data structured as...
  6. MCuthill

    Active Directory Connection

    Hi Everyone, I am posting this here as the code is VB, but as code-behind for an ASP.NET website. What I am trying to achieve is the retrieval of information about the current user from Active Directory via an LDAP query string. In testing on my development machine, the site worked flawlessly...
  7. MCuthill

    Table Joins - Should Be An Easy Solution

    Hi Everyone, I feel foolish even asking, but my mind refuses to co-operate this morning, so here goes my question: I have 3 tables (in this scenario) tbl_BudgetItem ~~item_financetype ~~item_financesub tbl_FinanceType ~~fint_id tbl_FinanceSubType ~~fints_id ~~fints_type ~~fints_fint_id I...
  8. MCuthill

    Error When Viewing ASP Pages w/ ConnectionString

    Hi All, I have been developing an online library for our HR department, and all works just fine on my (development) machine, but I am getting a runtime error after moving it to the IIS server. Any basic page (just textual information) works just fine, but the pages that utilize a...
  9. MCuthill

    Changing Page Order for Printing

    Hi All, A question was posed to me regarding the ability to change the order the sections a report are printed. Now, before you laugh, I know that you can re-order sections within groups and such to change order, but my issue lies within that the data generated relies on several shared...
  10. MCuthill

    Programatic Maintenance of Rolling History

    Hi Everyone, I have an SQL question regarding the maintenance of a "rolling" database. At any given time, I would like to thave 1 year of transaction history held in my database. Data is downloaded from the system at monthend and placed into SQL. The month end updates only have 2.5 months of...
  11. MCuthill

    UPDATE of smalldatetime field not working

    Hi Everyone, I am using Visual Studio to develop a web page which has to interact with an SQL server database. The problem I am running into is that when I am trying to UPDATE (or INSERT) a date, it is showing up in the database as "1/1/1900" when i enter a date in this field manually on the...
  12. MCuthill

    ConnectionString Error

    Hi Everyone, I am building a webpage using Visual Studio, ASP pages, VB code behind. I tested the pages by connecting to a MS Access DB, and now I am using a new ConnectionString to the SQL data and get the following error: This error occurs on this line of VB Code: SqlDataSource1.Update() I...
  13. MCuthill

    Word 2003 - Duplex Printing Modification

    Hi Everyone, A co-worker raised a question regarding duplex printing a large document. What was requested was that the document be printed Duplex, but that the beginning of each Appendices always begin on the "front" of a page. Any advice or direction is greatly appreciated. Thanks, Mike...
  14. MCuthill

    Numeric Overflow Error - Workaround?

    Hi Everyone, I am working on a formula to calculate the time (Term) in months it will take to pay off a loan. I am getting a data overflow error on 1 record in my test sample, is there a way to work around this? The formula is as follows: {@Term_Curr_Pmt}...
  15. MCuthill

    A Means To Create Field During DTS Execute

    Hi Everyone, I am not sure if this is the correct forum, but here goes. Software Involved: - Microsoft SQL Server 2000 Background: - Currently utilizing 3 SQL Databases for 1 Crystal Report. - Have to use Subreports (about 20) in order to link (via Formula Fields) all the Data together (there...
  16. MCuthill

    Differences from CRX to CRXI ?

    Hi Everyone, I am looking at taking the BOCP-CR at some point this year. Up until now I have worked exclusively with Crystal Reports 10, but the certification testing is all based on Crystal Reports 11. Are there any significant differences that would impede my understanding of testing...
  17. MCuthill

    Database Logon Credentials

    Hi Everyone, I have encountered an issue that has come up before and I cannot remember how I fixed it previously. I have a Crystal Report loaded on to Crystal Enterprise that runs off of 3 SQL Databases. It is giving me the "Database Logon" prompt for 2 of the 3 DB's (These two are newly...
  18. MCuthill

    Crystal Reports / Visual Studio .NET (ASP)

    Hi Everyone, I am having some trouble with launching a web site. I do not know wherein the issue lie, but here is the situation. The project itself is very simple: 1 page, display a profiling report I have developed in CR10. I am getting "Page Not Found" errors when going to the default...
  19. MCuthill

    Running Total Variable Spanning Multiple Subreports?

    Hi Everyone, I am building an Assets/Liability section on a client profile report. The database houses these two sections in multiple tables each. For example: Assets is made up of Real Estate, Serial Numbered Goods, Investments, Inventory, etc etc etc. What I am wondering is if I can set...
  20. MCuthill

    Reseting Shared Variables

    Hi Everyone, I am developing a CRM report using Crystal Reports 10 & Multiple SQL Databases. The entirety of the report is driven by a Customer Number Parameter field: {?CIF_Number}. This field is set to accept discrete values only, but also multiple discrete values. The report successfully...

Part and Inventory Search

Back
Top