Using saved exports in Access 2007
Thu, 16 Oct 2008 02:36:12 -0700
I have experienced some problems when using a saved export.
I have made the export manually afterwards and noticed that my destination
file contains a different content compared to running the saved export.
The correct content, that matches my quiry, only works when running the
export manually.
I have also us ...
|
Exporting to Outlook 2003
Wed, 15 Oct 2008 22:10:00 -0700
Hello,
I have 3 list boxes that displays all my report, tables and queries in my
database...
lstReports - display all my reports
List207 - display all my Tables
List209 - display all my Queries
cmdEMAIL - command button
i want that if i select from the listboxes i have and click cmdEMAIL it will
be att ...
|
Linked table field limit problem
Wed, 15 Oct 2008 15:09:01 -0700
Access 2003 SP3 linking to an Oracle table with 360 fields via ODBC. Need
data from field 265, can't reach because table field limit is 255. Is there
a workaround? Access 2007 has same limit so upgrade sounds like it wouldn't
help.
Best,
Eric ...
|
Exporting a text file WITHOUT the field names (header row)
Wed, 15 Oct 2008 12:24:03 -0700
I am running Access 2003. I am attempting to export information based on a
select query to a fixed-width text file. I am using a macro to accomplish
this with the TransferText command and an export specification that I had
saved. While the export works, I need to create the text file WITHOUT the
field nam ...
|
Multiple users opening linked .cvs files
Wed, 15 Oct 2008 12:08:05 -0700
I have a combo box on a form that uses linked tables. If more than one
person clicks the combo box, they get an error msg. that only one person can
have the linked table open at once. I need multiple users to be able to use
the form that's linked to the linked tables. Help! Thanks. ...
|
Table Link Problems in Access 2007
Wed, 15 Oct 2008 18:01:01 +0100
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 ...
|
Linking SharePoint data to Access - Access File become corrupted.
Wed, 15 Oct 2008 09:06:03 -0700
I have my database link to Sharepoint Listitem with the 'Window Sharepoint
Service'. If one use try open the database and accessing anything that deal
with Sharepoint, the database would hang for moment to check for authication
for Sharepoint. At this point, if someone else try to do anything with the
data ...
|
|
|
Export Query using Access 2007 to Excel 2003 Users
Wed, 15 Oct 2008 06:47:01 -0700
I have (Office) Access 2007, my users have (Office) Excel 2003.
Previously, I was able to set up a macro to send a query out to Excel by
selecting Output to "MicrosoftExcelBiff8(*.xls)". In Access 2007, I don't
have the option to select "MicrosoftExcelBiff8(*.xls)" as an Output type.
Rather, the choice is ...
|
Import data into Tables of new DB
Tue, 14 Oct 2008 18:41:01 -0700
Hi All,
As my DB is improved I need to import historical data into the new version
of my DB from the previous DB version.
This has not been an issue untill I gave other users a copy of my DB to use,
now that I am about to send them an updated version I realised the need to
import their historical data in ...
|
Exporting Each Record to Separate Excel File
Tue, 14 Oct 2008 11:13:02 -0700
I have an Access table with approx. 2,500 records.
I want to export each record into its own Excel file that is named by the
key field.
Is there a way to automate this process in Access?
--
blg ...
|
