michael lalonde sudbury and 66 bloor
Tue, 20 Nov 2007 18:31:01 -0800
michael lalonde news
michael lalonde sudbury
michael lalonde photos
michael lalonde sudbury photos
michael lalonde sudbury news
mailto:mikelalo...@mysudbury.ca
falconbridge mines
mike lalonde sudbury
sudbury
mike lalonde news
mike lalonde photos
66 bloor rock music
wanderer
wanderer tax sol ...
|
https://digitalid.verisign.com/cgi-bin/OEenroll.exe?name=&email=
Sat, 17 Nov 2007 23:55:10 -0300
https://digitalid.verisign.com/cgi-bin/OEenroll.exe?name=&email=
...
|
Blank line at End of file (Print #1)
Fri, 16 Nov 2007 07:55:02 -0800
Hi. I am using VBA to create a file by writing records to it using Open ....
For Output as #1
Everything writes to file fine but a blank line appears at the end. Is
there any way of stopping this as the file will be rejected by another system
if it contains a blank record.
Cheers,
Steve ...
|
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 ...
|
