Export a List of Reports in Microsoft Access
Thu, 18 Mar 2010 11:22:29 -0700 (PDT)
I have an Access application which contains many reports(100+). I'm
trying to get a list of the reports without having to manually look in
the application to make the list. Is there a way to export a list of
the reports with, perhaps, the fields utilized by the reports? ...
|
Select Next Value from a DB2 System table
Thu, 18 Mar 2010 09:20:01 -0700
Hi all -
I'm developing an Access 2007 front-end for a DB2 backend, and I need to
call an in-memory DB2 table to generate an ID for new records. I've been
told that the following SQL works, but I can't get Access to use it. (I'm
not a SQL guru, so I'm trusting the people who are...they just aren't Access ...
|
Keep conditional formatting when exporting
Thu, 18 Mar 2010 06:49:01 -0700
Hi everyone. I use Access 2003 in Windows XP.
I have a report which contains a Text Box with conditional formatting.
Unfortunately data lose formatting when I export the report to Excel.
Is there a way to keep conditional formatting?
...
|
Populate primary key into imported tables
Wed, 17 Mar 2010 03:21:30 GMT
I've recently designed a fillable PDF file that users can type in and send it
back as a xml file.
I want to import the xml into Access database so we can keep track of records.
Unfortunately, it comes out a number of tables. And only 1 table has a
primary key, other tables do not. Is it any way I can populate ...
|
Linking to a table on a web server
Tue, 16 Mar 2010 13:34:01 -0700
I have an Access 2007 database setup on a web server that is accessed by an
ASP.NET program. I would like to be able to access the database from my
computer. Is there any way to link to a database on a web server? ...
|
In Access 2007 what is format "Double"?
Tue, 16 Mar 2010 12:10:02 -0700
When importing data from Excel to Access I get a format of Double for some
fields that contain numbers. Where can I find descriptions of the various
formats? ...
|
Problems Exporting a table
Tue, 16 Mar 2010 08:52:02 -0700
Hi,
I'm trying to export a table from my database into an excel spreadsheet, but
it keeps saying it can't find the object 'ExportData'. It definitely exists &
the rest of my code is quite happy to use it, so I'm really confused as to
what I'm doing wrong!
This is the code:
DoCmd.TransferSpreadsheet ac ...
|
|
|
How to download address fields from Outlook contacts
Mon, 15 Mar 2010 10:14:01 -0700
Starting with the basic contacts table downloaded from Microsoft, I added the
address, city, state/province and ZIP fields. Then I clicked on "Add from
Outlook" and selected the contacts to add.
The contact info was imported into the Access contacts table, except for the
address info. How does one include ...
|
Windows Scheduler to trigger import macro
Mon, 15 Mar 2010 09:46:01 -0700
I have a macro that will trigger a .txt file import process which works fine.
It doesn't seem to work assigning a scheduled windows task to a shortcut of
this macro however.
Is this a known problem? The macro is also set to close the database and
compact it and I seem to remember reading that the close func ...
|
Reading data from a txt report file
Mon, 15 Mar 2010 09:30:01 -0700
I have two text based reports that are 150+ pages. I need to "read" the data
off of the report and put it into a table. The first 14 rows of each page
are header stuff. I'll need to read some information off of the first header
(report name, job number, reprort dates) to verify that the file being
imported ...
|
