use of * caracter in rst.Open strSQL
Tue, 13 Nov 2007 12:00:41 -0500
use of * caracter in rst.Open strSQL
try: strSQL = "SELECT * FROM QrycustomersReport WHERE [cuscompanyName] like
"*test*"
You can use the strSQL to change the recordsource of a form, returns all
company names that include test in their name string.
However when you use the * caracter in an ado statement, the ...
|
5454
Tue, 13 Nov 2007 13:11:22 -0300
Instalar actualizaciones para actualizar esos complementos.
...
|
Jet.OLEDB
Mon, 12 Nov 2007 14:38:35 +1300
Hi
I have a VB6 application which runs fine on my development PC but and fails
on my Test PC at the point I create an ADO recordset.
The error is arises on line 40 below with message "Error number 91: Object
variable or with block variable not set"
I suspect the problem is with the ADO connect string
"Mic ...
|
TransferSpreadsheet path size limit?
Thu, 8 Nov 2007 09:10:03 -0800
Hi,
I'm using a Access 97 to export a query with the transferspreadsheet command:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97,
"qryCBGandPendingReclaims", Destination & FileName
I think the limit to the destination path (Destination & Filename) is 64
characters? Can anyone confirm that th ...
|
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 ...
|
