Recent content by ipr1

Hi - I want to create a macro that will send an email report ("STATS") to a person ("JOE_BLOW@zzz.com") during the period from 8/13/07 to 8/17/07. For all other times I would like to send out the same email report ("STATS") to a different individual (CHARLES DOE@zzz.com"). I am currently using...

I created a database that performs certain functions ("functional database") and I want to archive the changes I make to that database's structure in a central repository that is nothing more than another database ("repository") that I will create to track all of the revisions made to the 80 or...

Your point is well taken and thanks for voicing it. We run a series of access programs throughout the day and want to automate the process by kicking each database off via a scheduler. Because of the nature of our work, we need to know what programs ran successfully and what programs failed. I...

I am looking for some scheduling software to meet the following requirements: The ideal requirements for a new scheduling tool would be: • More robust than LaunchPad, but less complicated that Maestro • ability to initiate specific Access macros (not using an autoexec macro) REQUIRED •...

I run several databases daily - after running two of them (at different times), the database itself closes but the Access program stays open. In order to close that program, I have to close it out using the Task Manager. Any suggested solutions? Thanks (as always) for your assistance. Bob...

Thanks - yes I tried that - same result. I do appreciate the suggestion, however. Bob

Hi - In the detail section of my report, I have two controls ("Authority" and "Person/Title"). Both controls are set to can grow/can shrink and the detail section is also set the same way (can shrink/can grow). I want both controls to be side-by-side but since the "authority" control is much...

THANKS everybody - I finally got it to work. The problem was in the destination file name (I concatenated the name using a SPACE where, in fact, I should have used an underline. The correct function is as follows: Function Nightly() Dim CurrentDate As String CurrentDate = Date CurrentDate =...

THANKS everybody - I finally got it to work. The problem was in the destination file name (I concatenated the name using a SPACE where, in fact, I should have used an underline. The correct function is as follows: Function Nightly() Dim CurrentDate As String CurrentDate = Date CurrentDate =...

Hi - I am trying to copy one file (the source) to another location (the destination) and. ideally, I would like to add a date to the file as it is copied. This is the code I am using: Function Nightly() Dim CurrentDate As String CurrentDate = Date CurrentDate = Format(CurrentDate, "MMDDYY")...

Thanks you for your response - I appreciate it.

Hi - I would like to output a ".snp" file to another drive and since I will be send a new file each week, I would like to have the file name change by date: e.g. "data_031105.snp" and then "data_031805.snp" the next week etc. I have search the forums and cannot find any solutions; however, I...

Integrate Report to Fax Machine Try this code: Function Name() Dim clsSendObject As accSendObject Set clsSendObject = New accSendObject clsSendObject.SendObject acSendReport, "ReportName", accOutputRTF, "[FAX: RecipientName@ ##########]", , , "Report Name", , True Set...

Have you tried creating a series of queries and then basing the report on the results of the last query? For example, create query 1 and get the results of the product from that query. Next create query2 and join the fields that are common to both. Query 2 will yield the results from queries 1...

Thank you for the response. I modified your suggested query language and came up with the following SQL function which works: SELECT Count(*) AS HolidayDayCount, (CountWeekDays([Forms]![frm1_Main].[StartDate],[Forms]![frm1_Main].[EndDate])) AS Weekdays FROM Holiday WHERE...