Accessing Excel file in Access
Wed, 14 Jun 2006 03:51:02 -0700
Hi,
I am unable to connect to an excel file stored on the c: drive of my
computer in an access module using the CreateObject method.
I have also tried ADODB connection however, in this case the recordset does
not connect to the sheet1.
Please advise.
Thanks,
Roger ...
|
Snapshot / PDF Outputing
Tue, 13 Jun 2006 11:59:01 -0700
I have a report that I have setup to automatically generate and save as a
snapshot report on our server. The report is around 20 pages and has several
pictures (total size of pictures saved as JPEG format is 35 KB). When I
output to snapshot, for some reason the file size bloats to 20 MB. If I
remove al ...
|
Access 2003 Crash on Compact with MDE Reference
Tue, 13 Jun 2006 08:36:03 -0700
I have a simple database that I was working on over the last month. It is a
data entry style MDB right now in the default 2000 format. I work on it with
Access 2003 SP2. All updates applied. I have Admin Privileges. It references
a preexisting 2000 MDE that contains lookups to additional tables/database
fi ...
|
run time error 3003 could not start transaction when no trans acti
Tue, 13 Jun 2006 08:26:01 -0700
I am using Access 2003 and XP. I started getting this error when I tried to
use DAO object in my code. After creating qry string, when I execute the qry,
I receive this message. However, I have no codes that deal with transation
actions. Do you have any idea why this happens?
Thanks a lot in advance,
Ko ...
|
loop adodb recordset export to excel works but very slow.
Mon, 12 Jun 2006 03:47:02 -0700
Server = SQL Server 2000 SP4
Client = Access 2000 SP3 (Windows 2000 SP4)
Im using vba in Access to loop through adodb recordset (simply select * from
my_sql2000_view) and output the result to Excel 2000.
The problem is the time, it works, but takes way too long, can someone
explain what I may be doing w ...
|
Treeview Control Problem
Thu, 8 Jun 2006 08:36:02 -0700
Hi folks,
I am brand new to the treeview control. I followed the instruction from
Microsoft “How to use TreeView control Drag-and-Drop capabilities in Access
2000” to build the form and it worked great. When I change the data type
from autonumber and number to text for the fields of EmployeeID and Repor ...
|
Great time in France
Wed, 7 Jun 2006 15:05:21 +0100
Hello
I had a fantastic time in France, hope to visit again soon.
I found a holiday cottage from these guys www.looktogo.co.uk http://www.looktogo.co.uk
Regards,
Dancer: ). ...
|
|
|
Get List of Control/Properties of Form from another Access DB
Tue, 6 Jun 2006 23:55:01 -0700
Hi,
I am programming in VBA and using DAO to connect to another Access DB
(working fine).
What I am trying to do is get a list of the Controls and the Properties for
those controls for a Form on the other Access DB.
I can get a list of the Forms via the SysObjects, but can't seem to find a
way to ac ...
|
GetRows works fine until there is only one record in query
Mon, 5 Jun 2006 17:39:34 -0400
What's wrong?
rst.Open "qryCableAutoCAD", , adOpenDynamic
varData = rst.GetRows()
...
|
counting dots
Mon, 5 Jun 2006 07:31:02 -0700
Is there a way in VBA to open a recordset, and count the number of dots in a
text field? For example a value of 1 would return 0, but a value of 1.4.2.1
would return 3. I am trying to determine at what level of a hierarchy a
particular record falls. Thanks.
Adam Milligan ...
|
