Microsoft Access Debugger Freezing
Fri, 18 Apr 2008 08:18:43 -0700 (PDT)
Hi,
When I try to debug VBA code in Microsoft Access 2003, I keep running
into an issue. I'm trying to debug some code found in a module which
is accessed by a form. When I try to stop the debugger (and the form
from running), the whole application hangs. It doesn't do anything and
I have to kill it with Task ...
|
Subscript out of range error
Wed, 16 Apr 2008 11:07:49 -0700 (PDT)
Hi guys,
Can you look at my code and see why I am getting a 9 - Subscript out
of range error on my code? I can't figure it out. It works using the
Full version of Access & Excel 2003, but when I try to use Access 2003
run time, I get this error. I am using late binding. The error happens
at the AuditSummary F ...
|
Automatically run a process at a specific time
Wed, 16 Apr 2008 01:52:45 +0100
Hi,
I need to automate a specific routine at a specific time, I have found the
following article for excel
http://www.cpearson.com/excel/OnTime.aspx
But I need to run this from Access, I havent tried the Win API version yet
but Im searching for an access coding way of doing this??
...
|
HELP: How to Display ODBC dialog box??
Fri, 11 Apr 2008 22:08:59 -0400
I know there must be a way to call the ODBC dialog box so a user can
select a dsn and return its name.
Many thanks in advance. ...
|
Re: Absolute v Relative Path Help...
Wed, 9 Apr 2008 11:21:46 -0600
"Albert D. Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message news:...
> do know however if you're going to have multiple users in this application
> at the same time, you'll not get any reasonable reliability or Steve bill
> it E. and less you split the application. I talk about splitting your
> ap ...
|
Absolute v Relative Path Help...
Wed, 9 Apr 2008 09:53:12 -0700 (PDT)
Hi. I have an Access DB that resides on a network drive. Not
everyone in my company maps the network drive the same. Anyone can
map it with any letter (ie - drive H: M: etc). The database looks for
a text file in the same root directory where the DB resides to email
it. Since anyone can map there drive lett ...
|
Error 2455: .Application property is not available on list
Tue, 8 Apr 2008 17:12:38 -0400
Hello,
I am modifying a procedure that I copied from one DB to another. It is
bombing out at this method:
With Application.FileSearch
with error message:
Error 2455: You entered an expression that has an invalid reference to the
property fileSearch.
.FileSearch isn't available on the list of prop ...
|
|
|
Windows Live Mail & Microsoft Access
Tue, 8 Apr 2008 13:54:59 -0400
I have Access 2000, 2002, 2003, and 2007.
I use Outlook Express and code I've found on the Internet to allow
attachments and sending emails from Access.
With Vista comes Windows Live Mail. Short of SendObject, is there any
interface that exists to Windows Live Mail, similar to Outlook
Express, where I can a ...
|
Covert Hexadecimal to Decimal value
Mon, 7 Apr 2008 13:17:50 +0530
Res.All
There is a function called Hex to convert any decimal value to Hexadecimal
value.
But is there any function to covert hexadecimal value to decimal value?
Is there any other code for this?
Thanks in advance
Prashant
...
|
Detecting Access 2007 Runtime
Sat, 5 Apr 2008 06:38:22 -0700
Hi ...
In versions of Access prior to 2007, I was able to test for whether Runtime
was being used or not based on the existence of the following registry key
... for Access 2003, for example:
HKEY_LOCAL_MACHINE\'Software\Microsoft\Shared Tools\Access Runtime\Office 11
But with Access 2007 Runtime, this ...
|
