|
Importing text to put into columns headings
Not sure if this is the right forum. I have a pdf file (you can exit and
delete text in the pdf file so it's not an image) more than 2200 pages of
records some are 3 records per page some are 4 depending on how much info
each record has.
So it looks something like this:
Master - Master on Main
Name - ABC Company
Address - 123 Anywhere St. Jacksonville, FL
Description - RE: Sf Install...
|
1 |
5/25/2007 11:20:01 AM |
|
|
Import Outlook contacts "User Defined Fields'
While importing contacts from OUTLOOK to ACCESS, any 'User-defined Fields' do
not import. In fact, it appears OUTLOOK is not exporting them.
Does anyone know how to work around this to get the User-defined fields into
ACCESS? Thx!
--
FirstVette52...
|
3 |
5/24/2007 9:50:47 PM |
|
|
VFP Ole DB provider for Access?
I've installed the VFP Ole Db provider on my machine, but it doesn't show in
the list of drivers when creating a new odbc data source. I can import data
into an Excel file using this driver, but not in Access. Can someone point me
in the right direction?
Thanks.
Danny S....
|
10 |
5/24/2007 8:59:51 PM |
|
|
Incomplete and missing Email Addresses
I'm using the SendObject action in a macro to try to create emails to send
query results through Lotus Notes. The macro opens Lotus Notes, and creates
the email with the results and the subject line and message text the way it's
supposed to. However, when I put in more than one email address in the
address fields in the macro, it include in Lotus Notes part of the first
address, and th...
|
2 |
5/24/2007 7:18:00 PM |
|
|
Advice on Exporting to Excel from Access
Hi, I've been doing some hunting on line but this is new to me and I'm
wondering if anyone has any advice before I tackle this.
I have a User who currently works in a number of large Excel Spreadsheets
that she distributes regularly to the company. She also exports the data
from her spreadsheets into Excel forms that other staff must then fill out
remaining data on.
I have built a d...
|
2 |
5/24/2007 2:36:00 PM |
|
|
How do I export a table from 1 database to another using a macro?
...
|
4 |
5/24/2007 12:42:28 PM |
|
|
Exporting w/ specific paramters
I need to export data in an access table to a text file with strict fixed
width parameters...but I have no idea how to do this.
I need to export the data in tblUpload to a file named TMIMPORT.REC (save as
type must be "All Files" as opposed to .txt or .xls) so that the file looks
as such
(must be fixed widths)
Field 1 (not in Access table), Length 1, Value "D"
Field 2 (in Access table...
|
2 |
5/24/2007 10:19:00 AM |
|
|
ODBC Link to SQL 2005
I am trying to link table to Access 2003 from SQL 2005
Some tables come across ok but others just have the word deleted in all the
fields
Any ideas?
...
|
4 |
5/24/2007 8:16:42 AM |
|
|
Autonumber stopped incrementing to next highest number
I have been having this strange occurence on one of my relationship table -
not frequently but 2 times is enough for me.
Apparently the Autonumber seems to stop incrementing to the next available
highest number and begin to give a number
that's already in existence . That of course will give the error on "Unique
identifier - blah blah blah"
To temporary correct this problem I have bee...
|
12 |
5/24/2007 7:00:01 AM |
|
|
Text file import with mixed data
I have a rather large text file and because of the way the data is
retrieved, some columns have alpha and numeric data. The alpha characters
will always be "NF" (without the quotes). The numeric will be in dollar
format.
When you import the only way I know of so that I do not lose the "NF"
records, is to format those columns as text. My problem is I do need to
make calculations on t...
|
2 |
5/24/2007 2:14:03 AM |
|
|
Unable to Update Sharepoint list from MS Access
I have linked some WSS 2.0 lists to an Access 2003 mdb. I can open the
linked tables and manually update the data without any problem. However, I
want to update the WSS list from an Access query but I keep getting an
Operation Must Use an Updatable Query error message. I have tried updaing
just one field and still get the same error. Any ideas on how I can
troubleshoot.
TIA
Dean
...
|
2 |
5/24/2007 12:56:29 AM |
|
|
Parse Names
Hello all...I need help. I need to parse data which is formatted as follows:
First Name Middle Name Last Name - Example:
John M Doe
I can parse data by using the mid/left functions but I am at lost with this
example above.
Any help is greatly appreciated.......
|
2 |
5/23/2007 8:26:02 PM |
|
|
Error messages when Access queries fail.
Hey,
I'm trying to program a few queries in MS Access using VB. For my
insert query, I'm importing an Excel spreadsheet using the
'transferspreadsheet' function of VB. Now, if I try to insert two
rows with duplicate primary keys, the program only inserts one of the
rows. How do I show a message box that alerts me that ONE row was not
inserted? So, this message box would be dynamic in t...
|
4 |
5/23/2007 6:17:25 PM |
|
|
importing with forms/macros
Hello,
Currently I have some forms & macros in place that allow a user to import a
text file to the database. The problem, however, is that the user is forced
to put the file in a particular directory, and rename it to a specific name
so that the transfertext function used in the macro will be able to find and
import the text file (using a spec, also).
How can I change this so that ...
|
4 |
5/23/2007 5:05:48 PM |
|
|
Error Linking to VFP Tables
Running Access 2003, trying to link to Visual FoxPro tables through ODBC, I
get this error:
Could not execture the query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver] Not a table.(#123)
The ODBC data source is using the MS VFP driver, referencing a database
rather than a free table directory.
Help......
|
4 |
5/23/2007 2:56:24 PM |
|
|
Connection Time Out
Hi,
I am using SQL 2005 Standard and linked tables through ODBC with Ms Access
97 , which is working.
When I run long query it doesn't work it says 'Connection Timeout' is there
any way to fix the problem ??
...
|
2 |
5/23/2007 12:59:40 PM |
|
|
ODBC --> Access : "Cannot define field more than once.
I'm using Access 2003 and connecting to a SQL Server (version unknown)
database. I'm able to link or import every table but one. This one table
must have fieldnames that are very close in name because when i attempt to
link or import that table to Access, I the message, "Cannot define field more
than once."
This happens whether I'm trying to link or import. I don't know what the
fi...
|
2 |
5/23/2007 12:58:16 PM |
|
|
Locking/conflicting INSERT/VIEW
I have a back-end sitting on a web server. The web form does INSERTS to a
table in the back end. This works fine.
I also have a front end that links to the same table in the back-end (on the
web server). The front end has a view-only datasheet on the table. Whenever
this datasheet is open, all inserts to the table via the web form fail. If
the front end is open but not accessing the table...
|
2 |
5/23/2007 10:31:01 AM |
|
|
move files without overwriting
I have a form displaying external documents (non access) in different
folders.
Folders: Draft, Active, Archive.
I have buttons to move files from the draft to the active folder and
from the active to the archive folder. So far it works pretty fine,
but if someone would put a document in the draft folder which has
already the filename as in the active folder, the new draft file would
overwri...
|
2 |
5/23/2007 10:18:00 AM |
|
|
Error Counting Check Boxes
In database #1 report I use the following expression to count checked check
boxes and it works.
=Sum([Attachment Pre-test Completed Child1]+[Attachment Pre-test Completed
Child2]+[Attachment Pre-test Completed Child3]+[Attachment Pre-test Completed
Child4]+[Attachment Pre-test Completed Child5]+[Attachment Pre-test Completed
Child6]+[Attachment Pre-test Completed Child7]+[Attachment Pre...
|
1 |
5/23/2007 12:46:02 AM |
|
|
I want to take away the white back ground
I have a picture of a chili pepper and want to take away the white back ground ...
|
2 |
5/23/2007 12:24:23 AM |
|
|
Import the Excel Row Number
How can I import the Row Number from Excel into Access?...
|
2 |
5/22/2007 10:20:38 PM |
|
|
Import CSV, and add field and data according to user entry...?
Hello,
I am setting up a import process, and I need some assistance. I need the
user to be able to import a CSV, but with certain automated processes added.
First, I need a DATE field to be added. Second, I need Access to prompt the
user to enter a date, then enter that information to every record of the
field that was added.
I hope that makes sense. Any suggestions?
Thanks in adv...
|
4 |
5/22/2007 9:13:00 PM |
|
|
Linking to back end on a web server ?
Does anyone know how to link my front end to a back end sitting on a web
server?
There is a userid and password required for the web server and the back end
is also protected by an Access password.
Can this even be done?
Thanks....
|
13 |
5/22/2007 7:42:54 PM |
|
|
Access 2007 rich text import
I want to import or copy an MS Word 2007 table into MS Access 2007. The MS
Word table table included rich texts (e.g. bold characters). When I manually
copy one cell from the table into the Access 2007 database (into a rich text
memo), the formats are kept by Access (no problem). If I select multiple
cells from the MS Word table, copy them and then paste into the Access 2007
database, t...
|
1 |
5/22/2007 6:31:01 PM |