Search results

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

Obviously, the module is extremely helpful but how can you improve its focus to not only calculate weekdays but also to delete from that count any holidays that might occur in the interval? For example, there are 21 weekdays from 11/1/03 to 12/1/03 but there is also a Thanksgiving Holiday in...

ODBC What is really wierd is the fact that a select query works and a make table does not - I just cannot see what is wrong.

Here you go: SELECT TRC_LOAN.ICU, TRC_LOAN.PLAN, TRC_LOAN.LOAN_ID, TRC_LOAN.PARTICIPANT, TRC_LOAN.ORIGINAL_AMT, TRC_LOAN.START_DATE, TRC_LOAN.INTEREST_RATE, TRC_LOAN.PAYMENT_AMT, TRC_LOAN.PAYMENT_FREQ, TRC_LOAN.PAYMENT_CNT, TRC_LOAN.PARTICIPANT_TAX_ID INTO Loans_Refresh FROM TRC_LOAN; Thanks...

I have a linked table with about 160K records in it. When I execute a select query, the query returns the desired results. However, we I change the select to a make table query, I get a message that says I have an invalid argument. Any suggestions about a cure? (No rush - I have some time to...

Thanks for your suggestion Wayne. Any chance you could provide an example of the Bat file? (If I am right, I would have to have a Bat file for each database I wanted to compact; if I put all databases in one Bat file, we would still have the timer issue to resolve.