ADO and Form Requery
Thu, 13 Mar 2008 11:18:00 -0000
I am writing some transactions into a couple of Access tables using ADO and
wrapping the transactions with BeginTrans/CommitTrans, all recordsets and
connections are correctly closed when finished.
The sub is called from a command button on a form and after the transactions
are committed I am trying to requ ...
|
transferspreadsheet export to named range in excel
Wed, 12 Mar 2008 16:30:17 GMT
I've done this before but I can't remember exactly how to do it.
Here's the line of code:
docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Op_Com", "T:\
Storage\1.Reporting\DB\ReportPivots.xls", False, "A2"
I have a query, "Op_Com" and a corresponding worksheet, "Op_Com". This is
just the lat ...
|
Query Timeout Expired Eror
Mon, 10 Mar 2008 01:33:08 -0400
Hi There,
I sometimes get the following error when I execute a SQL 2005 stored
procedure using ADO VBA in Access 2003.
-2147217871
MS ODBC SQL Server Driver
Timeout Expired
The ODBC Query Timeout Reg key is set to 0 and the SQL Server remote query
timeout options are configured as in this arti ...
|
google adsense website for sale
Sat, 8 Mar 2008 06:53:04 +0530
Dear friends,
Earn from google adsense. A complete ready made google adsense website
package for sale @ Rs. 1000 only.
100 Content Rich Adsense
Web Sites containing more than 16000 web pages for Rs.
1000/only.
click here http://www.googlead.xtreemhost.com/ for sample website ...
|
How can I rename files on the HD from Access VBA?
Mon, 3 Mar 2008 21:26:39 -0500
I'm running Access 2000.
I download files for import on a dialy basis. I would like to automatically
rename the files from a function in my database before importing them.
The file names are always different, but they follow a pattern. There are
two files in the import directory before I run the import.
C ...
|
ADO querydef
Mon, 3 Mar 2008 21:24:44 +1300
With:
Cnxn = Server.CreateObject("ADODB.Connection")
Cnxn.open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createobject("adodb.recordset")
Can I use:
rs.open("qryMyStoredMSAccessQuery1", Cnxn, 2, 2)
instead of:
rs.open(str ...
|
2003 MDE not working properly in 2007
Sat, 1 Mar 2008 18:45:00 -0800
I have an apps that works well in 2003. The users receive and MDE from me
and and it all works if they are using Office 2003. In 2007 I get some
syntax errors and Date() gives #Name? instead.
I have checked the References in 2003 and they are as follows:
Visual Basic for Applications
Microsoft Access 11 ...
|
|
|
Data.mdb on external web server
Tue, 26 Feb 2008 06:22:00 -0800
I'm trying to access data that resides in a .mdb that resides on an external
web server. I have the IP address and file name.
Something like http://123.45.67.8/folder/data.mdb
I have an Access 2003 application that I am running on my local and would
like to link to the external database or transfer the th ...
|
Attach Tables - Too Many Fields
Sat, 23 Feb 2008 13:04:01 -0800
Is it possible to difine which fields to attach on a Oracle ODBC linked
table? The table has 300+ fields but I only need data from about 20 of them.
I can't see the complete filed list since Access will stop at 256 fields. I
was wondering if it's possible to create a tabledef with the fileds I need
and us ...
|
How to reference existing ado connection to BE
Fri, 22 Feb 2008 11:26:15 -0000
How do I reference an existing Connection to a seperate BE database
I'm using OpenSchema from a FE to see who's connected to a shared Access BE
Dim cnn As New ADODB.Connection
cnn.Provider = "Microsoft.ACE.OLEDB.12.0" 'both FE & BE are A2K7 but same
problem occurs with A2K*
cnn.Properties("Jet OLEDB:Datab ...
|
