|
How do I import Lotus Organizer 6.1 into Outlook?
I use Lotus Organizer 6.1 for scheduling and contact info. I have been
syncing the file into a Palm Pilot. I want to purchase a Treo for the cell
phone use with the file info in one device. Treo syncs with Outlook. I want
to import the file info from Lotus Organizer 6.1 into Outlook, but the help
info gives direction for importing only Lotus Organizer 4 or 5....
|
2 |
20.09.2006 19:07:56 |
|
|
export specification
I feel dumb, I am not a new user, just a learning user.
I need to create export specification.
all the books and this forum say go to File >get external data.
I cannot find 'get external data' anywhere on database file menu, even when
clicking on item I want to export. Your help will be appreciated, please
don't laugh
Ken...
|
3 |
20.09.2006 19:07:29 |
|
|
Share problem with Access to SQL 2005 table
We're using an Access 2003 ODBC connection to a SQL 2005 database. Once I
added fields to the SQL 2005 table and re-linked the connection in Access the
entire table began generating an error of "This record has been changed by
another user since you started editing it..."
The old ODBC link, although not showing the added SQL fields, can modify the
records without problem.
I've tried ...
|
6 |
20.09.2006 18:39:02 |
|
|
Problem using UNION with linked exchange tables
I have 2 linked exchange tables in my database. These are linked to contact
folders on my exchange account.
I can query these tables one in a time, but when I use a SQL statement
SELECT DB1.*
FROM DB1
UNION SELECT DB2.*
FROM DB2
Acces gives an error, that it cannot find table DB2, although it is linked
under this name. Further testing with other linked tables did not solve the
pro...
|
2 |
19.09.2006 22:23:03 |
|
|
Importing Ecel to Access 2003
Help please
I am trying to import a spreadsheet from my PC to my Laptop, I have saved it
on a stick and resaved it on my laptop.
When I try to import I get the message cannot find or string incorrect!!!
It only happens with this spreadsheet, all the others I try work perfectly
Any ideas, I did not set up the original spreadsheet but it does not appear
to have any security restriction...
|
2 |
19.09.2006 22:21:02 |
|
|
Maintaining Datatypes When Exporting to Excel
I have table in Access with a column with a data type set to "Number". When
I export the data to Excel I want to maintain the data type as numeric.
Instead, after the data is exported to Excel, the data seems to be changed to
text, even if I change the format to "Numeric". The only way to convert the
data to numeric is to press F2 in each cell and press "Enter".
How can I export a N...
|
3 |
19.09.2006 20:31:54 |
|
|
Import NCLOB field from Oracle to MS Access 2003
When I try to import external data from Oracle to MS Access 2003 using Oracle
ODBC Driver, I got error saying "ORA-24806: LOB form mismatch (#24806)".
In the Oracle table, we do have a NCLOB column. It's a LOB and it is
unicode. I wonder whether MS Access has any way to read this kind of info.
Thanks ...
|
3 |
19.09.2006 19:27:01 |
|
|
transferdatabase
I link table from an other access database by : docmd.transferdatabase
aclink, ...
in access 2003 it is very long, when i use on the same computer 2000 it is
very fast why ?
The both base are in access 2003
the Subdatasheet Name property are set to none
The disk format is NTFS
short name are used for both database
thanks for help
...
|
2 |
19.09.2006 18:55:01 |
|
|
Connecting two dB's via switchboards
Is it possible to connect two dB via switchoboards?
I have two dB that have a bunch of forms and queries all set up. each dB has
its own switchboards configured. I would like to go from Db1 Switchboard menu
to Db2 Switchboard. Is this possible?
Thank you,
Vadimbar......
|
3 |
19.09.2006 18:30:01 |
|
|
how i can instal the ole server
when I want to export my report to excel I am see this message " access
can't start the ole server "...
|
2 |
19.09.2006 17:33:49 |
|
|
Importing a range from a spreadsheet
I am trying to import several spreadsheets into an Access database. I have
the following command for each spreadsheet. How would I insert a range from
the spreadsheet instead of the entire sheet.
DoCmd.TransferSpreadsheet acImport, 8, "ImportAccessName",
"fileNameBeingImported", False"
Thanks...
|
3 |
19.09.2006 17:33:26 |
|
|
how do I execute Teradata macros from excel?
I have a requirement to execute macros on Teradata from excel. Every time
we've tried it, we get prompted to select a table and columns in the query
window. How do you override that and make it pass-thru sql only?...
|
2 |
19.09.2006 05:29:21 |
|
|
External image file attributes
I was wondering if it is possible to determine the pixel dimensions of an
external image file (.jpg, .gif, etc.) using Access 2003 on Windows XP Home.
Can anyone help me please?
...
|
2 |
18.09.2006 21:07:18 |
|
|
I want to keep my formatting when exporting to Excel using a macro
When I export a query to Excel using a macro I lose formatting such as
percent, number of decimal places, etc. How do I keep this using a macro?...
|
2 |
18.09.2006 20:10:02 |
|
|
unexpected error from external database driver (22)
Trying to export my query to excel file onmy desktop, I got this error
message "unexpected error from external database driver (22).
also I cannot open the design or make a report from access...
|
6 |
18.09.2006 12:29:03 |
|
|
Access query result (email) to be directly loaded in Outlook "Send
Hi,
I have an Access db that contains email addresses. What I would like to do
is that when I run a query and get a list of addresses. The resulting email
addresses can be loaded directly into Outlook "Send To" field by pressing a
button.
Can someone let me know how this can be done, thanks.
Regards,
MSA...
|
1 |
18.09.2006 11:16:01 |
|
|
ODBC Paradox link
Is it true that once you have set up ODBC correctly in the control panel you
can then link to a table in a different database format (Paradox in this
case) as if it were an Access table.
Its not working for me, I just get the error message "External table is not
in the expected format."
cheers
Rod
...
|
1 |
17.09.2006 20:51:22 |
|
|
transfer my data from a memory stick(excel) to microsoft access?
I am trying to transfer data from my memory stick(it is in excel format) to
microsoft access, is this possible? If so,how is it done?
tom...
|
2 |
17.09.2006 14:56:42 |
|
|
Export to Excel 97-2003 not allowed
I have a query that is opened by the user, who then wants to export the file
to MS Excel 2000. To try to automate this process, I added the following line
of code to the command button that runs the query from a form:
DoCmd.OutputTo acQuery, "DSHSmaiAGGQ", "MicrosoftExcelBiff8(*.xls)", "",
False, "", 0
However, when the user tries to save the file in response to the prompt, the
only ...
|
3 |
17.09.2006 00:00:42 |
|
|
lost files of Excel
Repaired windows and lost all 5 yrs excell 2000 files. I had found all the
old files , went in safe mode and made them assaciable to the new ADMIN. and
than I did a dump thing, deleted the old user accont from the user profiles.
and now all files were lost. I had saved the data before deleting the user.
But at the end, found it was only short cuts it saved not the original files.
I bough...
|
2 |
16.09.2006 05:17:02 |
|
|
Link to selective rows in Oracle table
I am able to link to an Oracle table but I don't want to pull in all 2
million records from the table, only a selection based on criteria.
I cring at asking such a basic question but is there a way when I link to an
Oracle table in Access to only pull data based on criteria (like Fiscal Year,
Account and so on)?
Thank you,
AnnP...
|
2 |
15.09.2006 22:54:43 |
|
|
Opening a .dat file in Excel, then saving as .xls, all From Access
I've seen several threads hint at this, but I can't seem to get any of them
to work. I am downloading data from another source and importing it into
Access. The problem is, I can only save the original data as a .dat file.
This .dat file will open in Excel just fine, but I was hoping there was a way
to bypass manually opening excel and convert the file to .xls format for
import into Acce...
|
2 |
15.09.2006 20:09:48 |
|
|
Problems relating to Ruler and Viewing
I would be thankful if someone could guide me in solving the following
problems:
1. I have checked the Ruler but ruler is showing for the top portion. I
can't see the Ruler on right and left.
2. I can't see the number of pages at the bottom, which we see while moving
a Word file. For example, we come to know while placing our cursor on a page
that it is page no.2 of 16. This has van...
|
2 |
15.09.2006 17:12:02 |
|
|
Import all records from external table
Hi everybody!
Please give some suggestions:
I'm trying to use the following code to bring all data in an external table
to a table in my BD, but it fails and the message is something like: "Error
connecting with MyDSN"
CurrentProject.Connection.Execute "INSERT INTO Clientes (NIT, NOMBRE) SELECT
NIT, NOMBRE FROM " & "[ODBC;DSN=MyDSN;UID=;PWD=;].Clientes
Thanks
Luis
...
|
5 |
15.09.2006 12:06:30 |
|
|
Insert Object Problem
I am trying to insert an object into my form. So far I am able to
insert Excel and Adobe files without a problem but when I insert
an XFDL document the only thing that happens when I double click
on the icon is a blank Pure Edge Viewer opens - the data is missing.
The procedure I am using is:
I selected Insert Object - then Create from File - Selected file I wanted
to insert - selected d...
|
1 |
14.09.2006 20:21:02 |