rocco sardella
Mon, 22 Sep 2008 20:22:47 +0200
...
|
Running a Function Once On Startup
Mon, 22 Sep 2008 13:22:28 -0400
Hello -
Could someone tell me if this is possible...
I have created an update for my front end. As part of the new deployment, I
need to create a new system DSN on the end user's machine. I have a macro
on a form that will create the DSN if the user doesn't have it, but I'd like
to have it created auto ...
|
Shell not working
Sat, 20 Sep 2008 20:57:01 -0700
I have a Shell command in a VB Function, but everytime it is called, I get an
"error #5", "Invalid procedure call or argument".
I have tried:
Shell Filename$,1
RetVal = Shell(Filename$, 1)
Call Shell(FileName$, 1)
FileName$ is read from a form field when a button is pressed, and then a
Macro is called ...
|
Creating a Lookup table with Incomplete Data
Thu, 18 Sep 2008 19:20:01 -0700
Hi Folks, I am trying to create a lookup table with an incomplete table. A
sample of the data is as follows:
ID Field1 Field2 Field4
2195 TOTAL SCH RC-26.B.
2193 107 B6511000010200
2192 107 B6461000020200
2191 108 B6460000020205
2171 TOTAL SCH RC-26. ...
|
Do I need class or function?
Thu, 18 Sep 2008 18:27:31 -0700 (PDT)
Hi All
Every time I use an Option Group I like to write some code to bold the
label of the selected Option in the group - I used to put this code in
the Event now I create a sub so that I can reuse the code within the
form. The problem is every time I use an Option Group I have to re-
write this code - I wan ...
|
mailing daily report with schedule
Thu, 18 Sep 2008 09:30:43 -0700 (PDT)
Hi all,
my task is to create a report as pdf that is automatically mailed
every day to several people.
So the following steps are necessary:
1) Create a scheduled task in the control panel that calls... --->
OK
2) a .bat file with a line like this: "C:\Program Files\Microsoft
Office\Office12\msaccess ...
|
Referencing Office 2007
Wed, 17 Sep 2008 16:58:14 +0100
How would I reference Application.ActiveWindow from an Access 2007 module?
I'm guessing that I need a reference to the Office 12.0 Object Library.
regards
...
|
|
|
Reading email from Groupwise
Tue, 16 Sep 2008 20:39:40 -0400
Is it possible to read emails from Groupwise?
...
|
Module to Print Report to PDF and Save With Specific File Name
Mon, 15 Sep 2008 15:59:01 -0700
Hi,
I currently have two macros which display 10 reports each in Print Preview
view. I then print each of the reports to a PDF file (all 20 in the same
directory) with the same name as in previous periods except part of the file
name uses a one or two-digit field [FiscalPeriod] to differentiate it from
ot ...
|
Parsing MIME mail headers
Mon, 15 Sep 2008 09:57:54 -0500
I have thousands of .EMLX files from a client. I need to parse the To,
From, Subject, Date, and CC fields from the headers. I've got my code
running, and it works. I just can't help but think it isn't as efficient
as it could be.
I'm reading the files, which are plain text, and line-by-line looking for
...
|
