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 ...
|
|
|
Export Query to Excel
Tue, 14 Oct 2008 07:15:02 -0700
I am exporting a query to excel using the following code:
DoCmd.OutputTo acOutputQuery, "AllOut", acFormatXLS, , True
It creates a new excel file called AllOut and places the information in a
worksheet that it names AllOut. Where that works I would like to take this
to the next level and just cant.
What ...
|
Export Queries and Tables to Excel
Mon, 13 Oct 2008 23:46:01 -0700
Hi,
I have 2 list box in a form
1st lisbox display all the table in my database.....
RowSource: SELECT [Name] FROM MSysObjects WHERE [Type]=1 AND [Name] NOT LIKE
"MSysACEs" AND [Name] Not Like "MSysObjects" AND [Name] Not Like
"MSysAccessXML" AND [Name] Not Like "MSysQueries" AND [Name] Not Like
"MSysAccess ...
|
run saved IMPORT specification from a button in a form
Mon, 13 Oct 2008 12:16:13 -0700
I need to run a saved IMPORT specification from a button in a form. How is
this possible?
I was able to run an EXPORT "specification" from a button in a form by using
an embedded macro throught the RunMacro action. The macro leveraged the
'OutputTo' action where I was able to define all the necessary para ...
|
