how to parce out part of a string and replace it with another stri
Wed, 14 Nov 2007 13:20:00 -0800
Problem:
I have sereral files with simular names.
I would like to be able to replace part of the file name with a persons name
I want to replace the "Master" in the file name with [LastName]
Example:
November5MasterAssignmentFile1.xml --> November5JonesAssignmentFile1.xml
November12MasterAssignmentFile3.x ...
|
Using InStr Function to Parce a string
Wed, 14 Nov 2007 13:12:05 -0800
In inStr function and using it has always caused me a headache.
I did the following to get the [personName] from the datafile path. I would
like to know if there was an easier way to accomplish the same.
------------------------------------------------------------
'Get the Person name from the file path
' ...
|
Treeview performance slow in MS Access after upsizing to SQL
Tue, 13 Nov 2007 10:59:02 -0800
Frustrating situation I'm facing.
I've upsized my data tables from within Access to SQL. The data is queried
instantly from within VBA, so I have no complaints about establishing a
recordset.
The problem I'm encountering, however, is that a treeview I have on a form
now populates quite slowly. I haven't ...
|
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 ...
|
