|
Word to Access Automation
Hi,
An age old question and I have been extensively searching the past
posts and have seen some reasonable suggestions.
I am after some thoughts on the best way to achieve this. I am
building an application suit from scratch that needs to be able to
import Word documents into an Access Database.
The word documents/templates will effectively contain repetitive
information structures t...
|
6 |
30.09.2006 19:25:56 |
|
|
exporting number field with leading zeros
I have a number field in a table that I want to export with leading 0's. For
a number like 100.00, I want to export 0010000. I multiplied the value by
100 to get rid of the decimal and changed the field format property in the
table to 0000000. The data looks fine in the table when I display it in a
form or look directly in the table, however, when I export it as a fixed
length field, ...
|
3 |
30.09.2006 01:08:11 |
|
|
Issues getting data from Excel to Access (2002)
Hello,
I have several Excel spreadsheets. One column is numeric. I have set it to
numeric through the "Format Cells...". When I try to import it, either from
the excel workbook or a tab delimited file, the numeric values are eith:
1. arbitrarily excluded (some get in, others don't)
2. arbitrarily quoted (same thing as above)
It needs to be numeric. That is why the number keeys we...
|
5 |
29.09.2006 23:30:56 |
|
|
Create mutiple tables in remote DB
I have a db (a) that has about 50 linked tables. About 20 of the tables I
would like to create make tables of these 20 into another db(b).
Is there a way to do this without creating 20 make-table quiries and then
running them through 1 macro.
Thanks...
|
2 |
29.09.2006 19:20:24 |
|
|
Importing Adobe PDF Data
How do I import Adobe PDF data to be used as Access fields?
Thank You!...
|
3 |
29.09.2006 09:44:01 |
|
|
VBA in ACCESS abending with run time error 1004
When I execute the code below on the second iteration reading the file
I get run-time error 1004.
Can someone help me correct this problem? I don't understand what I'm
missing.
Thank you - Luis
===============CODE ============================================
Option Compare Database
Public HoldRequirement As String
Public counter As Integer
Public activeCnt As Integer
Public parse...
|
3 |
29.09.2006 03:24:56 |
|
|
unexpected error from external database driver (10019
I have tried to import a DBF database into Access(2000) several times in the
past and was successful. Couple of days ago I tried to do the same with the
same database and got the above error. What can I do to fix this problem?
Please help!
--
Regava...
|
4 |
28.09.2006 18:06:01 |
|
|
problems importing excel 2003 data into access 2003
Hi,
I'm using Office 2003.
I'm trying to import a data table from an Excel workbook into an Access db.
When I navigate to the XL doc and click through the dialogue box I get an
error message:
"The wizard is unable to access information in the file [filepath]. Please
check that the file exists and is in the correct format."
The file does exist, as I can open it in Excel. And the...
|
1 |
28.09.2006 16:36:04 |
|
|
Crosstab Query to Excel
I am trying to export a Crosstab query to Excel using the CopyFromRecordset
function.
The crosstab query is based on another query which, in turn has criteria
from a form.
When I run the code from the form I get a 'No value given for one or more
required parameters' error.
With the code stopped and the form open, the same SQL works just fine in the
query designer.
Can I run the Crossta...
|
1 |
28.09.2006 16:21:02 |
|
|
Search Tables Collection for Text or Whole Field Number
I'm using MS Access 2003 and I am looking for a function that will
search the
entire Tables Collection for a specific string or whole field number
(not part of a field).For example if I enter "widget" or "123456" it
interrogates the entire tables collection and returns the table name
and column name where the data is found.
I have found some excellent code in this group for seaching for te...
|
4 |
28.09.2006 13:39:04 |
|
|
Exporting data from Access into a Word template
I have linked my Access database to a Word template using a hyperlink. Now I
would like to be able to export certain fields from Access into that Word
template. What is the best way to achieve this? Small words big pictures
please- I'm a novice!...
|
1 |
28.09.2006 11:05:02 |
|
|
export query to existing excel file
Hi all,
I need a clue. I am stuck for days already.
I want to export a query to excel spreadsheet, supposedly the excel file
gets replaced each time I export the query. BUT what I found is the records
from the query is only replacing the rows in that spreadsheet and the remain
rows of the exisiting spreadsheet stay.
What do I do wrong? Could someone be kind to give me some clue. Is th...
|
1 |
28.09.2006 10:02:02 |
|
|
csv datafile errors do not create error table
I am importing csv files which may have data errors. I was hoping to use the
error table to identify any errors due to validation rule violations, missing
data etc.
However, when the import is complete the records in error have been omited
but there is no data error table....
|
2 |
28.09.2006 07:08:01 |
|
|
Importing From Excel
My Access application imports a fairly large amount of its information from
Microsoft Excel. Two tables in my database will need to be updated with
large amounts of data from Excel, and data already in the tables cannot be
harmed. One of these tables may be updated fairly regularly, and the import
process must be quick, easy, and reliable.
Now, as with most databases, both of these ta...
|
4 |
28.09.2006 04:24:44 |
|
|
Linked tables from ASP.NET problem: OleDbException (0x80004005)
Linked tables give me an error when used with ASP.NET.
I have linked a few tables from a SQLBase Server an Access Database. I am
using Visual Web Developer 2005 for creating a web application. When I run
the webpages using the developer everying thing seems fine, but I put the
webpages in an external IIS server, the linked tables fail to link or execute
a query and gives me the follow...
|
1 |
28.09.2006 02:10:02 |
|
|
Access link ODBC to SQL table,path to ODBC -recent install?
have new laptop - install window xp pro with 2003 windows office pro , have
odbc data sources created , access database copied from old laptop. existing
links to sql tables via odbc drivers work fine, i can use and refresh without
problems but when i try to add a new link i follow the steps in table /New/
link/odbc sources and then nothing happens - a window should popup and allow
me to...
|
2 |
28.09.2006 01:32:01 |
|
|
VBA in ACCESS abending with run time error 1004
When I execute the code below on the second iteration reading the file
I get run-time error 1004.
Can someone help me correct this problem? I don't understand what I'm
missing.
Thank you - Luis
===============CODE ============================================
Option Compare Database
Public HoldRequirement As String
Public counter As Integer
Public activeCnt As Integer
Public parse...
|
1 |
28.09.2006 00:45:09 |
|
|
Visual Foxpro 6.0
I have a problem with the set filter function in foxpro. I want to make
a query that picks out all entries in an field that contain data.. any
data, but not entries that are empty. Is this at all possible?
...
|
3 |
27.09.2006 22:34:38 |
|
|
TransferDatabase to an EXISTING table
I need to import tables from another MS Access DB to tables with the same
names in my local MS Access DB, and then alter some of the field sizes in my
local tables. Since TransferDatabase appears to import only to a NEW table, I
wrote code to delete the existing local tables first, then import the tables
with TransferDatabase, and then alter the field sizes. This works fine as
long as t...
|
2 |
27.09.2006 19:34:02 |
|
|
object invalid or no longer set error problem
We have developed an access application with a backend access DB on the
network. The application contains forms that display a lot of data. The
problem occurs when the network connection is lost (e.g. when a client goes
into standy). The forms/queries quite naturally cannot access the data from
the backend and starts to display the error-message: "object invalid or no
longer set".
The p...
|
2 |
27.09.2006 17:15:02 |
|
|
Capture RS232 Data
Hello, I work with a system that prints out receipts on a dedicated little
printer whenever there is a transaction.
I want to be able to capture the information onto a laptop that I plug in
instead of the printer, and end up with it all in Access.
The printer connects to a multi-pin socket that looks like a COM port.
The data comes out (and I don't know what any of this means) as RS232, 1...
|
2 |
27.09.2006 15:18:23 |
|
|
TransferText File Name
Here's my dilemma:
I have a query that I need to ouput to a text file. I've gotten that much
to work using the transfertext action in a macro. Now, I would like for the
transfertext action to pick up a piece of data from the form to use in the
name of the file.
For instance:
An index is entered as 03-372. The query returns the records associated
with that index and the macro out...
|
3 |
27.09.2006 13:46:03 |
|
|
HTML Exporting - How to Change Display Name
Hey All,
I currently have a routine that creates a table with a hyperlink reference
to a network location (ACC2003). This hyperlink ends up being lengthy once
I export this table to HTML. Is there a way in the export routine to give
the hyperlinks a "friendly" name? This name would actually be data from
another field.
For instance:
Field1:
087-3334
Field2:
\\server\project...
|
2 |
27.09.2006 06:01:40 |
|
|
Export Report to Excel Fails
When we try to export a report to Excel, Access goes through the
motions, listing the pages it is outputting, one by one. The problem is
that
when it is finished, no file has been created. Exporting to a text file
works just fine. Trying to overwrite an existing file just causes the
existing file to disappear.
Any ideas where we should start to look?
Thank you,
Bud
...
|
1 |
27.09.2006 01:07:49 |
|
|
Import Problem
I have an excel spreadsheet that I want to import into an access table. I go
to Get External Data and choose the file and go through the dialog boxes,
when I click Finish, I get the following error message: "An error occurred
while trying to import file …. The file was not imported". It doesn't offer
me a help menu to suggest why the file didn't import.
Could anyone tell me why this ...
|
3 |
26.09.2006 21:17:34 |