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

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

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

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

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

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

I have the following code: Option Explicit Function Wait (Delay As Integer, DispHrglass As Integer) Dim DelayEnd As Double DoCmd.Hourglass DispHrglass DelayEnd = DateAdd("s", Delay, Now) While DateDiff("s", Now, DelayEnd)>0 Wend DoCmd.Hourglass False End Function This function work when I test...

I want to compact a series of databases. Currently, I use a combo box and set it to run a macro to open and compress each database (run app command with a path as follows: "c:\programs\msoffice\msaccess.exe" "c:\documents\dbname.mdb"/compact Currently, I have to individually select each...

I hope my title adequately conveys the gist of my question. I have a form that merely takes the user to a second form from which the user can perform designated tasks. The second form has a "go back" button that returns the user to the Main introductory form. When I "go back" and then go...

I found a way to show percentage increases/decreases in reports and am passing it along: Create a text box and insert in it the following (no quotes): "=(IIf([CurrentAmount]=0,([BaseAmount]*-1),IIf([BaseAmount]=0,([CurrentAmount]*1),([CurrentAmount]-[BaseAmount])/[BaseAmount])))" I hope this...