Search results for query: *

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

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

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

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

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

This might not be possible but I will post my request; I am interested in storing frequently used sql scripts in a Microsoft Access table and having a form available for the users in the department to query on certain "key" words (using wild cards, etc.) and then the sql script would display at...

Have several update queries that will be set with Windows Scheduler to "run" at 2:00 A.M. in the morning. Is there any way to capture the time that each query began, time that the query ended, and the number of records that were updated and store in a local Access table. For example...

Context: Would like to run two MS Access make-table queries in sequence in vba code. The make-table queries are based on pass-through queries. (Once this is successful, I will eventually try to automate the querying of the SQL Server database and exporting the query result to a MS Excel...

Currently exploring the use of an Access form (as opposed to a auto-exec macro) to schedule approximately 10 make-table queries in sequential order on a weekly basis. The make-table queries are based on pass-through queries that are used to extract data from a SQL-Server database. For...

Producing 4 reports per month by importing data into Excel (Using Microsoft Query) from tables within a Microsoft Access 2002 database. The tables within the MS Access database are created with make-table queries. Each of the make-table queries require three or more parameters. For example...

Is it possible to have vba to store all make table queries in an Access table along with the number of records created by the query? Then, I envision an Access form that will display the make-table-queries, the number of records created and then upon depressing a command button, I can delete...

Have the following code within a module that I am trying to modify so that I will be prompted to enter the filename of the Excel file. ActiveWorkbook.SaveAs Filename:= _ "C:\Reports\Rpt_FranchiseDate______________.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _...

Using Excel 2002 and occasionally run complex queries and drop the result in Excel templates. Problem is when the order of columns in the query result do not coincide with the column headings in the Excel templates. Therefore, I have to manually cut and paste the columns in the query result to...

Hopefully, this can be done; Occasionally, I run complex queries and drop the result in Excel templates. Problem is when the order of columns in the query result do not coincide with the column headings in the Excel templates. Therefore, I have to manually cut and paste the columns in the...

Just had a thought, Have a 2 megabyte MS Excel file that I need to send to 20 people via MS Outlook every week. I thought about using a hyperlink within the body of the Outlook e-mail so recepients can access the file without having to attach such a large file. Questions: 1) If I attach the...

Just to ensure that I am following the appropriate steps to query related information from a SQL Server database using data within a MS Access table. I performed the following steps; • Imported 4000+ records from MS Excel into MS Access table named "ContractNumber" • Within MS Access, I linked...

Don't know if this is possible. Used the following sql script previously to obtain a "draft data dictionary" of the sql server database. There are two separate sql server databases that are on different servers. Is it possible for the sql script to be altered so that I can pull just one data...

Using the sql script displayed below in SQl Query Analyzer to extract the primary care physician (PCP) and the physician that provided the services to the patient. If the PCP has a tax id of ‘3006562’, then the PCP has a CV_Physician medical group. The provider id for the PCP is stored in the...