Help with a Chart Fill from Access to Excel
Wed, 7 Jan 2009 14:22:49 -0800 (PST)
I am trying to put a nice touch to the background of a chart that I
have, but I keep getting a Error 1004 Application object error on this
part of the code:
.Selection.Fill.OneColorGradient Style:=msoGradientHorizontal,
_
Variant:=1, Degree:=0.36
I am doing Excel automation from Access ...
|
Import Spec and date format
Wed, 7 Jan 2009 12:33:02 -0800
I have been using access 97 since about 2000 and have updated some stuff over
time to 2K and XP but now I am going to 2007 and my import specifications are
having problems.
Most of my data comes from a mainframe and I bring it down as fixed width
and most is good as I use most as â??TEXTâ? but some have di ...
|
Extra blank records in Access which are blank records in Excel Fil
Wed, 7 Jan 2009 11:43:07 -0800
Hi,
When I link my Excel tables to my Access db, I am showing extra records in
Access which are blank records in my Excel Files. I have tried deleting all
blank rows, but this does not correct the problem. Any Suggestions? ...
|
Strange Text Importing
Wed, 7 Jan 2009 10:59:03 -0800
When importing from Ex to Acc I sometimes receive data that looks like
this:This complex will house the Stationâ??s
commanÿä??æ?¨ç?²â¹æ½æ¹©â´æ?²ç?±ç¥ç´æ? æ?¤ç?©æ½©æ?®â¬ç?¦æ?®æ¹©â§æ½¦â²æ¡´â¥ç?°ç¥ç?¡ç?¡æ½©â®æ?¯ç æ?¨å? æ?´æ¥´æ¹¯ç 浥潰æ?²ç¥²ä â?æ¹æ?®â¹¸â?®ä? æ?¨ç?²â¹æ½æ¹©â´ç?¯ .....CAN I
GET ...
|
Import Data to Excel but Keep Chart Format
Wed, 7 Jan 2009 10:21:01 -0800
I have 2 queries in Access and I want to import the data from those queries
into an Excel file (called Charts.xls). Each query and related chart will be
on a different worksheet of the Excel Workbook.
I tries using the do.cmd OutputTo option (tied to a command button) which
allowed me to transfer the data ...
|
Browse for file instead of modifying design every time
Wed, 7 Jan 2009 04:45:01 -0800
Every month, I upload a text file with a different file name into a database.
This is done as a TransferText command within a macro. Every month, I need to
modify the Action Argumen called "File Name" to upload the appropriate file.
I would prefer that the macro allow me to browse for the file. Is there any
...
|
Mi R4ultra ds me va muy bien
Wed, 7 Jan 2009 13:04:19 +0100
...
|
|
|
Import text file into access
Tue, 6 Jan 2009 14:53:00 -0800
I want to put certain parts of a text file into a record in an Access table,
then repeat the process several hundred times. What is the best way to
accomplish this? ...
|
Editing a text file to import into access
Tue, 6 Jan 2009 14:34:04 -0800
I would like to have certain information from part of a text file imported
into Access, and then repeat the process several hundred times. What is the
best way to accomplish this? ...
|
Access export to Excel template with merged cells
Tue, 6 Jan 2009 07:02:58 -0800 (PST)
Hello. I have an Excel template where I need to export data from an
Access database (version 2003). I have the following code
working .... somewhat. There are 294 records to export but when it
gets to Excel only 98 records are visible. I suspect it has to do
with the fact that there are merged cells in the t ...
|
