Disable Keys
Tue, 19 Aug 2008 07:26:02 -0700
Is there a way to disable the enter key (~ or {ENTER})? ...
|
access 2000 login prompt
Tue, 19 Aug 2008 07:23:04 -0700
I need to change something in Access 2000. I hold the shift key down when
opening the database and the autoexec macro does not run. I can see all the
forms, tables, reports, and modules listed. When I attempt to view code by
opening a module, a login prompt appears. I can open forms in design mode,
but when ...
|
ODBC Link
Tue, 19 Aug 2008 07:14:01 -0700
I have an application that runs continuously and requerys a database on
regular intervals for updates. However, if the ODBC link is not available or
fails, the program aborts.
How do I check to see if an ODBC link is available and if not, have the
program retry after a period of time?
Thanks,
Mike ...
|
Run-time error '1004'
Mon, 18 Aug 2008 21:13:02 -0700
Dear all,
Would like to seek help from the following VBA programing problem.
I have a form with an OLE object which is an excel with a chart inside.
The function i wrote is to delete one of the Shape on the worksheet of the
OLE object.
The codes are as follow:
Private Sub Command0_Click()
Set o ...
|
Access 2003, Determining which control has been clicked
Mon, 18 Aug 2008 18:36:10 -0700
I've been searching discussion groups (here and elsewhere) for days but can't
find anyone who has addressed my question.
In Access 2003, I've got a form with a mosaic of rectangles representing
various locations in our organization. I change the background color of the
rectangle or text within a rectangle ...
|
Very Difficult Email report as PDF, record looping automation code
Mon, 18 Aug 2008 14:31:00 -0700
I am in need of help. I want create a code loops through a table record by
record and emails each record out as a report that has been converted to a
PDF.
Need to know information:
- I am using MS Outlook 2003 and MS Access 2003
- To create using RunReportAsPDF found online at :
http://www.tek-tips.co ...
|
Loan Function
Mon, 18 Aug 2008 16:49:51 -0400
I have search high and low and cannot find a function that returns an
amortization schedule. I quess this is how you learn. I am starting from
scratch.
How do I get this simple function to print each month in succession. It
prints the same month so I guess somehow I need to redefine the variable to
the ...
|
|
|
Copy table form BE database to BE database
Mon, 18 Aug 2008 13:06:01 -0700
I developed a program that will be deployed in Latin America that has
multiple language capabilities.
I stored the captions in a table in the BE database for each language
(English, spanish, and Portuguese).
To create a new language (there is interest to use the application in Europe
too), I need to create a ...
|
VBA Performance in Access vs Excel
Mon, 18 Aug 2008 12:59:04 -0700
I have a client that wants me to automate some manual Excel file
manipulation. The solution is to use an Access database to completely
automate the opening, editing and saving of an Excel worksheet. I placed all
the necessary data and parameters into Access tables (normalized).
Some of the VBA code used for ...
|
OPENING QUERY Causes error "System Resource Exceeded"
Mon, 18 Aug 2008 11:30:12 -0700
Hello,
Running MS Access 2003 on XP Pro.
I have discovered a very potential root cause for my most recent posting,
about Run Time Error 3035.
I have a query that causes an error msg that says "System Resources Exceeded".
It has never done that before. While I have added data to what this query
woul ...
|
