Previous WorkDay
Tue, 27 May 2008 07:01:04 -0700 (PDT)
I am using some code written by Ken Getz and Mike Gilbert. I am
having a problem getting the previous workday when a holiday occurs.
Here is the code I am using which I receive a overflow error on:
Public Function MyPreviousWorkDay() As Integer
MyPreviousWorkDay = dhPreviousWorkdayA(Date, Array(#1/1/2008#,
...
|
Don't want to access Address book during Outlook automation
Fri, 23 May 2008 09:52:22 -0400
Hello,
I am using Automation on Outlook 2000 with the Outlook 9.0 Object library.
I am also using Outlook Redemption to eliminate the Security Warning,
however I am getting a warning about the address book: The client is using
Exchange Server.
"A program is trying to access e-mail addresses you have sto ...
|
run time error 2427
Fri, 23 May 2008 04:20:01 -0700
HI,
i have a private function to output a report based on the maximum of each
accno. However i would be grateful if someone could help me avoid the runtime
error by stopping all macros if the acc no is null and then displaying a
message box advising printing complete.
my code as it stands is as follows:
...
|
Recordset out of Scope after ALTER TABLE statement
Fri, 23 May 2008 02:57:00 -0700
My VBA module which runs fine in MsAccess 2003 results in an error in
MsAccess 2007.
MY VBA module looks as follows:
Function ExecuteProcesSteps()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Processtap",
dbOpenSnapshot, dbPessimistic)
Do While Not rs.EOF
...
|
What Is A Module?
Wed, 21 May 2008 16:47:58 -0400
Deep into the game for this but, What is a module?
To be more precise do the functions that you store in a module have to be
related? When you call a function does that mean all functions in that
Module run? Or ia a Module like a folder that you can organize functions in
by whatever way you choose. Any cla ...
|
Function Problem
Wed, 21 May 2008 00:46:55 -0400
I have a Query where I'm trying to call a Function that I wrote. Here is
the Function.
Option Compare Database
Dim tblCheckDetails As AccessObject
Dim CDKillTax As Boolean
Dim CDInclusive As Boolean
Dim CDDiscountWhere As String
Dim CDDiscountDP As Integer
Public Sub RepTax()
Select Case CDKillTax ...
|
Access can't find existing table from VB module (run-time error '2
Tue, 20 May 2008 17:55:37 -0700
I have an Access VB module that, when I try to run it, reports "Run-time
error '2482': Microsoft Office Access can't find the name 'LSAYCollVars_ACIS'
you entered in the expression." and highlights the line: par.Value =
Eval(par.Name), which I realize means that the problem is somewhere before
that line.
...
|
|
|
Excel Automation problem
Tue, 20 May 2008 00:22:29 -0700
I am using Access and Excel to import worksheet data. I am closing the
workbook and quitting the excel application and setting both to nothing but
after execution Excel is still running in the task list. If I end the
process and rerun the VBA it leaves Excel running again. Am I missing
something?
I am ru ...
|
fhwe8onbt yewp
Sun, 18 May 2008 09:53:58 -0700
Shut up!
...
|
When is record actually saved?
Sun, 18 May 2008 08:33:01 -0700
I have a bound form in which I issue a docmd.runcommand accmdsaverecord to
save the record that's just been built. Let's call this table "A" and let's
call the "key" sequence field "KEYA".
A bit later, the user clicks a button on the form that causes me to add a
record (using DAO) to a different table (not ...
|
