|
Exporting data from access to excel
A report I use to export to excel from Access using "DoCmd.OutputTo acReport,
ReportName" is now providing me with different values. Data like 12-1369 is
returning a value of -193607. Note: not all the values are changed. It is
very inconsistent. Thanks! ...
|
4 |
30.06.2006 20:37:20 |
|
|
Linking to a link table
I need a linked table going to another linked table that goes to a master
table. All within Access. I have not been able to get this to work but I
am not sure if I am missing something or not. Does anyone know if this is
possible?...
|
2 |
30.06.2006 19:21:21 |
|
|
Import Export translators for data unavailable; can't create new d
If I try to import or export data from any application in Office 2003, an
error appears stating that the required translators are not available. If I
launch Windows repair utility, it fails to install or repair anything. Does
anyone know if the original CD is required for this, or can I download the
required files to update? Perhaps there are files that reside somewhere on
the local driv...
|
5 |
30.06.2006 13:35:22 |
|
|
How do I auto transfer one record of a form in access to word?
I am looking to transfer one record at a time out of access in to a word
template (fax template). I would like to be able to do this by pressing only
one button on the form - how do I do this?...
|
6 |
30.06.2006 09:52:15 |
|
|
Importing a file becomes out of sequence
I am processing MS/Access 2000. Ocassionally when I import a file that has a
sequence numbers in it the (output) file becomes OUT of sequence after the
IMPORT
Any ideas??? Appreciate any feedback
--
Eddie Mac...
|
4 |
29.06.2006 17:47:26 |
|
|
Argghhh NOVICE Pulling hair out
As access cannot create a radar chart of more than 5 fields i created a excel
template ( with radar chart ove 35 fields) with the expectation for the range
cells to be populated by creating a link from a access query.
Is this possible, as I am now struggling.
I only need the excel data to be refreshed and not the access data....
|
4 |
29.06.2006 14:54:02 |
|
|
format of .txt files converted from Word forms
I want to convert multiple (100's) of forms containing many types of data
into .txt files acceptable to Access 2003. The import function converts the
data into .txt in a notepad file, in a single column, that Access reads as
"fixed width" (without formatting and form field names). Seems that a
delimited format is best for my needs, but does that require formatting the
the notepad file? A...
|
3 |
29.06.2006 13:31:02 |
|
|
values in an exported file
Hey!
I've exported a file from access using transferspreadsheet. One field in
access which has a data type of "Number" with a field size of "Single" is
populated by an update query to be 0.04. When I export the spreadsheet to
excel the value becomes: 0.0399999991059303 which rounds to .04 in excel
but when I use this percentage against large numbers and then sum them I have
issues....
|
11 |
29.06.2006 07:32:56 |
|
|
ODBC and 'real time'
Good Day!
i have a db that connects to an SQL Server, and the ODBC should be real time.
I have a form with fields that track info that is not currently being tracked
in the SQL system, so I created an Access db to be an 'extension'. the
problem is one field on my form needs to be 'real time'.
I have a drop down box that is connected to look up a field right to my odbc
connection tab...
|
2 |
29.06.2006 00:45:26 |
|
|
Use data field in Access with email address as list in Outlook
I have created a database in Access to manage registrations to a conference.
One of the fields is a contact email address. I want to use the data in this
field as a contact list in Outlook to send updates, confirm registration etc.
I would like to have changes in the database be automatically updated into
the email address too... thanks....
|
3 |
28.06.2006 23:18:01 |
|
|
formatted excel into access report
For reasons unknown at this time, my supervisor wants to see the output from
a very detailed and highly formatted (style and color) Excel spreadsheet as
an Access report. I have no trouble using TransferSpreadsheet to get the
data from Excel into Access in table form, but does anyone know if there is a
way to automatically transfer all the formatting without reprogramming it to
go directly ...
|
3 |
28.06.2006 23:09:04 |
|
|
Moving a newly designed database table and for to another system
I have recently designe a new database table and form on my Windows XP system
using Access 2003. I would like to move these objects to another similar
system and use them there. I attempted simply to "copy" the database to a CD
and open it on the other system but was given an error that stated the copy
was read only.
Your help would be appreciated....
|
2 |
28.06.2006 21:37:03 |
|
|
iAcces 2007 creating relationship after linking contacts from Outl
I tried to link contact information from outlook 2007 with an Acees 2007
database.
This operation seems to go well and in Acces a new table is created with a
primairy index field called Normalized Subject. However if I establish a
relationship between this new table and an existing one using the field
Normalized Subject as foreign key in the existing table the relationship ends
up bein...
|
4 |
28.06.2006 20:05:07 |
|
|
Turning off import errors
Hello all,
I have a tab-delimited file where the first 4 fields are data that is specific to a single account. Fields 5 thru 20+ are the
account balances at month end through a time series of many months. The problem I'm having is if there is no balance in a month,
instead of having a zero, there is a single decimal point in the text file. Well Access' import wiz can't convert a single d...
|
5 |
28.06.2006 19:51:01 |
|
|
Error 3626 when linking ODBC database file
When linking a ODBC table to Access I get the error message that "there are
too many indexes on table ...." Other tables from the server link fine, it's
just one (that I'm currently aware of) that is giving the error. I was able
to link this same table late last year and the queries based on that table
still work just fine. I can also copy the database and use the existing
table. Thi...
|
1 |
28.06.2006 18:34:02 |
|
|
Import TXT files
Dear all,
I have a directory containing 10,000 txt files that I have to import
for excel.
Any file have two lines and I need that they appear in excel as the
following:
1-First column = File name;
2-Second column = Second line of all the txt files since the first line
contains only headers.
Filename Values
A.txt 235
B.txt 454
C.txt ...
|
2 |
28.06.2006 13:12:40 |
|
|
Appending Access data from regularly updated Excel data
I am currently using Excel's MSN Money plug-in to retrieve stock price
information daily into a spreadsheet. On one worksheet I keep updating and
adding to the data and on another I do various calculations based on the
data. Because the quantity of historical prices is getting rather large I
have begun investigating whether it would be possible to output the striclty
raw price informatio...
|
2 |
28.06.2006 12:13:01 |
|
|
Appending two or more text files to the one file
Hi,
I am trying to export out multiple files with different width settings to
one text file.
I am looking for the code to do this within access. Some one told me to
export the files and then shell to the windows copy command to concatenate
them , but I can not get this to work.
Thanks
Nadine
...
|
10 |
27.06.2006 22:21:03 |
|
|
How do I add columns in outlook linked table to Access
I have linked my outlook contacts to an Access database. I am trying to get
all of the columns that I have in outlook to come over to Access. How do I
add columns or choose columns to bring over?...
|
1 |
27.06.2006 22:12:01 |
|
|
Link to Oracle Database using ODBC - Table Name Problem
Using ODBC I am able to link to Oracle database. The table name in
Oracle is ITEMS. When I do the link the user name is added to the
Name. Now the table name in Access is PPS_ITEMS. The problem is that
if I need to move this Access program and connect to another database
the table name might be come STEVE_ITEMS and because of this change in
name none of the queries would work.
Ideally...
|
2 |
27.06.2006 21:11:07 |
|
|
upgrade xp
i have upgrade my system from windows 2003 into xp.
at the present i am unable to import vack up files saved into D
not am i able to locate any files , folders and or the drive D.
help and thanks...
|
2 |
27.06.2006 20:58:31 |
|
|
Read and write to a .txt file from ACCESS VBA
Hello,
I have been reading and searching trying to find how to do this. I need to
read a table and create a text file with one row for each row in the table.
Then I need to read a CSV .txt file in and place those values in a table,
row for row.
From the reading, looks like I may OPEN for INPUT or OUTPUT, and then do a
read or write? I am having trouble finding specifics or even better...
|
4 |
27.06.2006 20:26:06 |
|
|
How do I import an openoffice base 2.0 database into Access?
I've created a database in openoffice base 2.0. It has odb as an extension
and doesn't give me any other save options. Is there any way I can get it
into MS Access?...
|
2 |
27.06.2006 20:22:18 |
|
|
automation to copy records from excel to an existing excel
I have the following code that i found online. What i am wanting it to
do is automation to copy records from excel to an excel. Please show
me how to change this code to bring recordsets from another excel file,
versus from a access table.
Dim rs As Recordset
Dim intMaxCol As Integer
Dim intMaxRow As Integer
Dim objXL As Excel.Application
Dim objWkb As Workbook
Dim objSht As Workshee...
|
4 |
27.06.2006 20:20:33 |
|
|
How can I link a pdf file into an existing database?
I want to add pdf files into an existing database. I want to do add a button
and by clicking on it access these files that I import into the database. How
can I do this?...
|
4 |
27.06.2006 20:19:23 |