Search results for query: *

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

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

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

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.

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

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

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

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

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.

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

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

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.

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

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

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

Currently implementing. Will this QBF work with passthrough queries?

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

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

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

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