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 ...
|
|
|
Access 2007 and the MS Forms 2.0 Scrollbar control
Thu, 18 Oct 2007 06:00:01 -0700
I am trying to use this control and it doesn't appear to be firing at all and
doing some research, I have discovered that this feature is not complete. Is
there an update to this? This is a critical component to the database I am
developing to keep 2 forms in sync.
Thanks! ...
|
Linking tables in access 2007 runtime
Wed, 17 Oct 2007 21:29:02 -0700
I am trying to deploy a runtime version of a split database to a number of
users. I have employed an error trap to check linkages to the be database and
if not there it opens the "Linked table manager" dialog so that the user can
point to the correct location. This seems to wok fine when operating on my
mach ...
|
"The field is too small to accept" error in Access 2003 using Foxp
Tue, 16 Oct 2007 10:34:02 -0700
I am trying to link a foxpro table in Microsoft Access 2003 using ODBC. The
package I'm linking to is in VFP 9 (I believe).
When I do the link, and then try to open the table, it says:
"The field is too small to accept the amount of data you attempted to add...."
When I view the structure in Access, I no ...
|
