|
Search Key Not Found Error
All:
Can you please help me? I am getting an error that says "The Search Key was
not Found" when importing a txt file into Access 2003. Do you have any idea
how I can fix this issue and get my data imported into Access? The file size
is too big to import into Excel.
Thank you so much for your help.
...
|
3 |
12/16/2008 10:55:24 PM |
|
|
How do I import new fonts into Word?
I'm making a calendar & want new fonts to work with. I hear it's really easy
but I haven't figured it out yet....
|
2 |
12/16/2008 10:32:21 PM |
|
|
Linking Access to Excel Spreadsheet
I am linking information from an Access database through new link ODBC Access
Database. I have received the following message [Microsoft}{ODBC Microsoft
Access Driver} Too many client tasks.
Am I limited to how many links I can put into a spreashhet. At this point I
am on page 1 of 4 that is needed?
--
Teresa
Norfolk Southern
Roanoke VA...
|
1 |
12/16/2008 4:31:01 PM |
|
|
Import from workbook cells to access table
Hi,
We receive a report in excel twice a year and the information is in non
contiguous cells. I'd like to pull the data from all the workbooks into an
access dbase. here's the cells of the feeder reports.
1-PD 2-PD
D6 G6
D8 G8
d10 G10
D12 G12
D14 G14
D16 G16
D20 G20
I'd like to import it into an access table with column headin...
|
9 |
12/16/2008 1:53:12 AM |
|
|
Using External Text Files (ETF)
I have several External Text FIles (ETF) and several Forms to process the
data. There are MANY things about this application that you will not be aware
of, so to tell me to do it all different or to ask..."why are you doing it
that way" is of no value to me. What I need to know is how can I accomplish
the following:
1) I have ETF's, Tables, Forms and Queries. When the customer opens a Table...
|
26 |
12/15/2008 4:31:01 PM |
|
|
Report Export problems- Access to .RTF
I run a report in Access and it looks fine. When exporting to .rtf however,
some of the fields are truncated. Another user sitting next to me can export
the exact same report to .rtf without any problem - no truncation. Is there
something in my PC that could be causing the problem....
|
1 |
12/15/2008 2:59:01 PM |
|
|
import excel data - scientific notation
Hi,
I've read some of the previous questions about this issue and the
suggestions (see attempted fixes below) did not fix my issue.
Problem:
When I import my data from Excel into Access, the data, which is a very long
digit integer (ie. 123456789654357453), turns into scientific notation in
some cases.
Current Process:
Before I import from Excel into Access, I always do a tex...
|
2 |
12/14/2008 7:07:45 PM |
|
|
Linked Excel file gives #Number! error in table
My code links to an Excel file and copies the data from the linked file to an
Access table using queries.
The problem is that when I double-click the linked Excel file within Access,
one of the rows, on one column there is #Number ! showing up.
I opened the Excel file separately, and it has data in that field. It looks
like Access cannot read that one particular cell. Access interprets...
|
6 |
12/14/2008 7:05:51 PM |
|
|
collect data through email message
I am trying to collect data through email an message. It works great except
it appears that the answer boxes are set to one size and the labels are too
small for my questions. I am doing a survey type questionnaire of yes no
answers and do not need much space for the answer but only half of my
question shows up. Is there a way to change the design of the form?...
|
1 |
12/13/2008 3:21:01 PM |
|
|
data collection message
I have made a survey to email to collect data. It works great except the
labels are too small for the questions. I do not see any way to change the
design of the form. The answer box is too large. I just have yes no answers....
|
1 |
12/13/2008 12:48:00 AM |
|
|
Default e-mail client for sending data
Hi,
Somehow, our users have changed the default e-mail client used when sending
out their daily report. When we set it up, it defaulted to Outlook, now it is
defaulting to Express. We can not find anything that tells us how to set the
default e-mail client in Access 07, and Outlook is the default client on the
system. ...
|
3 |
12/12/2008 11:20:01 PM |
|
|
ArcView Shape Files
Hello,
Is there a way to import ArcView shape files directly from the ArcView .shp
files?
Keith...
|
2 |
12/12/2008 9:59:21 PM |
|
|
email attachments
I need a little help with sending email with attachments. I use Novel and I
am trying to send email with a text file attachment. I’m not sure if this can
be done with the SendObject method as I’m not sending a report or table but a
text file created from a table a DoCmd.TransferText command with a file spec.
Does anyone know how to do this? Access 20002, XP
Thanks,
Mark
...
|
1 |
12/12/2008 5:32:03 PM |
|
|
Build data external datalink based on user
Hi.
Is it possible to build data links "on-the-fly" based on the user that
starts my Access application? Based on user, the application should connect
to different external data sources. In fact, the data might be stored in the
same data source (SQL server), but the user should just connect to data
concerning the users agency.
In short I have a transaction database with one trans...
|
1 |
12/12/2008 9:19:27 AM |
|
|
export to excel
am attempting to export data from an access work order database to an excel
template file. I am using office 2007.
Currently I have a command button with a click event to export data from a
query. I am using the transferspreedsheet method with a defined range in
which to transfer the data too. The data is being successfully transferred,
however, every time that I do this, all of my name...
|
2 |
12/12/2008 6:28:00 AM |
|
|
Access 2007 - Simple Question
Where are the Macro Actions such as "TransferDatabase" that existed in
earlier versions. There must be a simple answer as to why I'm not seeing
them.
Thank you....
|
3 |
12/12/2008 6:27:00 AM |
|
|
How can I import data into an Access 2007 query?
I'd like to import data into a query in my database just like the "collect
data" feature does, but I want to use my own HTML form, created in
Dreamweaver....
|
2 |
12/12/2008 6:25:01 AM |
|
|
Export Record Limitations
Access 2007 will not allow me to export a query with over 65,536 records to
Excel. (65,536 was the limit of rows in Excel 2003), but I have Excel 2007.
Does it matter that when Excel 2007 was installed it was set up to work in
compatability mode? Does it matter that the DB was created in Access 2003
but is being accessed by Access 2007?
...
|
2 |
12/12/2008 6:24:01 AM |
|
|
Table Link Problems in Access 2007
Hi
I've been using Access since v2 but only recently started developing with
2007 and have come to a real halt when table links get broken.
I've imported tried and tested code to check and fix up tables links if the
path to the data changes for any reason and this seems to run ok in Access
2007, BUT... I'm finding that if I move the backend data to a different
path, Access 2007 won't...
|
7 |
12/12/2008 4:46:00 AM |
|
|
TransferSpreadsheet saving file
I am using vba code to save some tables into files.
I have hardcoded the filename that the file will be saved as in case they
type the wrong name. This is what I have used:
strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.xls)", _
"*.xls")
strSaveFileName = ahtCommonFileOpenSave(OpenFile:=False, _
Filter:=strFilter...
|
12 |
12/12/2008 12:45:00 AM |
|
|
Importing with a variable name
How do I specify in a macro the name of a file if I want it to take a
variable name? I have a form that I am getting a variable name from and I
want to run a query and export it to a spreadsheet.
I am putting in c:\planning\ & =[Forms].[My Projects].[PlnrName] &
_projects.xls but the name is exactly that and not the expression.
Thanks....
|
2 |
12/11/2008 9:09:29 PM |
|
|
Unable to import Text file into Microsoft 2007
I am wondering if someone can help me with this. I am unable to import text
files into Microsoft Access 2007. When the Get External Data - Text File
dialog box comes up and I click on the Browse button nothing happens. I don't
get any errors but I don't get to browse for the text file. Also, if I choose
Append a copy of the records to the table : the table names won't populate
for me to ...
|
7 |
12/11/2008 8:08:05 PM |
|
|
what does the error 'property not found' mean in Access 2003?
I am trying to import a txt file into a blank table. The table has all
fields formatted as txt and when I am using the import wizard, I have changed
all the fields to txt aswell. When I get close to finishing the wizard I get
the message 'property not found' followed by an error message stating the
data cannot be imported.
I am not very technical so please bear that in mind when reply...
|
5 |
12/11/2008 4:25:08 PM |
|
|
best approach to import data
i have a database that wasnt designed by me that has 3 tables (Contacts,
Calls, TradeLogs) all linked with a field called ContactID that is the
primary field of the table Contacts. I have eliminated some of the fields in
contacts that were of no use and empty and renamed a few to better fit the
database. At one point we elimintated about 5000 records from the contact
database but left the co...
|
1 |
12/11/2008 3:37:26 PM |
|
|
Export to Excel
Hi,
I am using a query and TransferSpreadsheet to export a table to Excel.
The table column is defined as double with 2 decmial places.
The data is accouting transactions. In the same column there is a negative
number followed by many rows of positive numbers that sum to 0. This series
repeats for about 20 transactions.
The transfer to Excel works fine.
Then in Excel, for only about 3 of ...
|
1 |
12/10/2008 4:27:01 PM |