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!

  • Congratulations strongm 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: MwTV
  • Order by date
  1. MwTV

    Start Netmeeting Automatically at Set Time on Mondays

    Yes, I am aware of using Windows Scheduler. However, Is there a way to use Windows Scheduler with a script that also opens NetMeeting, opens the appropriate training session and then screen captures the screen? It appears that I would need to enable three applications at the same time -...
  2. MwTV

    Start Netmeeting Automatically at Set Time on Mondays

    Hopefully, this is considered a good question - Does anyone know if it is possible to setup my computer at work to automatically "turn on" Netmeeting at 7:00 A.M. (EST) on Mondays and connect to a particular training session and take a screen capture every 5 minutes or so? Every Monday...
  3. MwTV

    TSQL-Extract only new clients for current month

    Thanks for the insight. This has really helped tremendously! Now, it appears that I will not have to worry about typing in different dates every month. Several additional questions; Will the formulae work for Access Jet Queries as well? (I assume that it will definitely work for passthrough...
  4. MwTV

    TSQL-Extract only new clients for current month

    Will the formula, "dateadd(mm,datediff(mm,0,getdate()),0)" always result in the first day of the month if I run the query at any time during the month? Also, I assume that there is another formula that will give the last day of the month? Thanks in advance.
  5. MwTV

    TSQL-Extract only new clients for current month

    Assistance Needed: Have the following table named "Client"; StartDate----EndDate----ClientID------Name 1/1/07-------3/31/07----246B----------Sheila 4/1/07-------5/31/07----246B----------Sheila 10/1/07-------12/31/07---246B----------Sheila 10/1/07-------12/31/07---258C----------Jane...
  6. MwTV

    Calculated Field_compute age components in 3 columns

    Well, I understand the advice to not store calculated fields but I am directed to do so. Will test the function.
  7. MwTV

    Calculated Field_compute age components in 3 columns

    Thanks for the functions. At the risk of redundancy; Initially performed the query in Sql Query Analyzer and saved as a text file. Then, I imported the file into the MS Access Db. Prior to the first post, I comtemplated the creation of a sql passthrough in MS Access. Note, the sql script...
  8. MwTV

    Calculated Field_compute age components in 3 columns

    Have a birth date field in a sql server database and interested in calculating the age within a Microsoft Access passthrough query. Is it possible to use three calculated fields in Access so that I receive the Year,Month and Days portion of the age calculation in three separate columns? Other...
  9. MwTV

    Create Knowledge Bank containing frequently used sql scripts

    Thanks. I plan to have two QBFs within my application - one for standard queries and one for P-T queries. Currently implementing and will post back with any additional questions and/or comments.
  10. MwTV

    Create Knowledge Bank containing frequently used sql scripts

    dhookom, What modifications do I need to make to the QBF to allow for passthrough queries? Thanks in advance.
  11. MwTV

    Automate Excel-Based Report

    Currently, still having issues with modifying the code below. Upon opening the Excel template, the data is populated. Then, upon clicking Tools/Macro/"Set Page Setup" there is an error - "Unable to set the Print Area property of the PageSetup class." Sub PageSetup() Dim ws As Worksheet...
  12. MwTV

    Automate Excel-Based Report

    Any VBA options that would perform the desired actions? Specifically, can the actions be performed only if there is data retrieved from the query? Thank you.
  13. MwTV

    Create Knowledge Bank containing frequently used sql scripts

    dhookom, Were the changes made to the code recent? If so, I will download the QBF again. Thanks for the insight.
  14. MwTV

    Automate Excel-Based Report

    Assistance needed for task that I am not able to quite handle! Trying to automate daily MS Excel-based Report using an Excel template that is based on a query of an external data source that is set to refresh automatically. How should the following code be modified if I want to perform the...
  15. MwTV

    Automate Excel-Based Report etc.

    Assistance needed for task that I am not able to quite handle! Trying to automate daily MS Excel-based Report using an Excel template that is based on a query of an external data source that is set to refresh automatically. How should the following code be modified if I want to perform the...
  16. MwTV

    Create Knowledge Bank containing frequently used sql scripts

    Currently implementing. Will this QBF work with passthrough queries?
  17. MwTV

    Records Affected - Member Not Found

    That appears to work. Upon stepping into the code, no error messages occurr. Another question - I am currently modifying the function above so that I can capture errors in a table. Note, I am interested in determining which one of the make-table queries caused an error. What modifications...
  18. MwTV

    Records Affected - Member Not Found

    Assistance needed. Receiving "Member Not Found" error upon trying to run following function with a macro. Specifically, "Records Affected" is highlighted and "Member Not Found" is displayed. (Note, function is used to run 10 make-table queries in sequence using Windows Scheduler) Public...
  19. MwTV

    Microsoft Outlook form selections stored in MS Access database

    Interested in creating a Microsoft Outlook form that the individuals in external department can request reports. Upon report requestor (individual in another dept.) completing the form, is it possible to store the results in a MS Access database or is there functionality within Microsft Outlook...
  20. MwTV

    Create Knowledge Bank containing frequently used sql scripts

    Thanks. I will incorporate the Query By Form technique as well. Really was trying to present a form to the end-user that would display portions of sql code in a image control or something similar. Specifically, the concept would go as follows; The end-user types in a word or phrase (with...

Part and Inventory Search

Back
Top