Converting Access 2000 format to 2002-2003
Wed, 7 Nov 2007 02:22:00 -0800
I have an existing mdb application in Access 2000 format that I convert to
2002-2003 via Database Utilities - Convert Database - Access 2002-03 Format.
No problems with that and a db1.mdb file is duly created containing most of
the objects in the original database with the exception of ALL of the form
objec ...
|
Automate Relinking Tables for Password Protected database
Tue, 6 Nov 2007 12:59:01 -0800
I am using the code found in Access Web to automate Relinking Tables
http://www.mvps.org/access/tables/tbl0009.htm
Problem:
The backend database is password protected
This is just a Database Password - No users or group level security
I get error #3031 - Not a valid password
Question:
Does anyone know ho ...
|
Access Has encountered an error and must close
Thu, 1 Nov 2007 09:28:01 -0700
Hello,
I have several Access databases that run a Windows Scheduler at various
times through the night that run some updates for me. Basically, they all
work the same - and AutoExec macro runs, opening a form which has OnOpen
Event that starts running code doing various items (running queries, copying
ta ...
|
Understanding the constraints of a WITH statement
Wed, 31 Oct 2007 03:40:01 -0700
This one line of untidy code works....
CurrentDb.TableDefs("TableName").Fields.Append
CurrentDb.TableDefs("TableName").CreateField("New_Field", dbDouble)
=======================
However this doesn't....
With CurrentDb.TableDefs("TableName")
.Fields.Append .CreateField("New_Field", dbDouble)
...
|
Compacting Not replacing db1
Thu, 25 Oct 2007 13:23:00 -0700
Hello,
i'm hoping someone can help me with this problem.
I am compacting my access '03 database and its creating the db1 copy but the
copy is not being deleted and my original database is not being compacted.
the original reopens without any error messages but i can see the size has
not changed which leaves ...
|
Funktion mit Recordsetfeld?bergabe
Thu, 25 Oct 2007 11:08:08 +0200
Hallo NG
ich habe eine Funktion geschrieben und möchte in einem Formular einen Wert
aus einem Recordset erhalten.
Ich habe in der Tabelle die ich mit dem RS öffne verschiedene Felder und je
nach dem welches ich übergebe, möchte ich den Inhalt
zurückbekommen. Nun ist mein Problem, dass die Funktion mir einen ...
|
Opening Lotus Notes from Access
Wed, 24 Oct 2007 06:51:01 -0700
Hi.
I need to open a 'Stationary' message from a Lotus Notes mailbox account
(not my/the users account - these have all been disabled).
I have a form in Access with a button that needs to open the standard
message, allow the user to add some text and then send it from the mailbox.
Can this be done?
...
|
|
|
Opening Outlook from Access
Wed, 24 Oct 2007 06:14:08 -0700
Hi. I have a form in Access and want to be able to click a button to open an
Email message in Outlook.
The message is used as 'stationery' and is in a standard format saved in
Outlook.
The user needs to open the message, add some text, then send it to the
relevant contact.
I have some OLE experience ...
|
Access hangs
Fri, 19 Oct 2007 06:52:00 -0700
We have an Access2003 applications which retrieves data from an oracle
database.
We create an ADODB.recordset and set the Form.recordset to this specific
recordset.
The application is running well on a Citrix environment.
In another Citrix environment the application hangs ("Calculating" is
displayed in th ...
|
Backup database
Thu, 18 Oct 2007 08:06:00 -0700
I would like to know the code needed on a form using On Click to perform a
backup of the entire database. I realize that this may force the auto
closing of the database and auto reopening after the backup is complete. I
will need to be able to state where the backup file will go and what name I
will give t ...
|
