how to export with format using TransferSpreadsheet
Wed, 23 Jul 2008 04:41:00 -0700
Hi,
Whenever I export a query (with just one text field) using
TransferSpreadsheet and I open the Excel sheet to see the result, I realize
that each field starts with an apostrophe. How can I get rid of it?
I've noticed that if I export this query my means of the option menu
"Export" + with format, the E ...
|
Importing Data with More than One Item per Field
Tue, 22 Jul 2008 14:16:05 -0700
I have a database that has been setup to accept multiple answers for Field A
(combo-box form auto-populated by data in another table). To get the database
started with content, I need to dump an Excel spreadsheet into it. But
here's the issue: I'm unsure how to import multiple items into a single
field. Do ...
|
Pivot chart รข?? Export / send as attachment
Tue, 22 Jul 2008 13:51:04 -0700
I have created a pivot chart and want to send it as an attachment. I see
there is no option to save it as an Access Snapshot when I export it. How can
I distribute the chart to others by email?
I am using Access 2003 ...
|
how to auto synchronize two tables in access
Tue, 22 Jul 2008 06:05:01 -0700
I am using Access 2007, can someone please help me with how to copy data to
another table in the same DB when one table gets updated?
Thanks in advance!
--
Amod Goyal
IT System Developer
NSK Precision America ...
|
Automatically default field on update.
Mon, 21 Jul 2008 13:46:10 -0700
Hi,
I want to do an import and append of a really simple table -- it just has
EmployeeNumber and Status. This will be an import I do once a month. The
table I'm importing it to (tbl_EmployeeStatus) has one more field, though -
Month. I want to be able to select a drop-down on a form and then have the
" ...
|
linked tables dissapear
Mon, 21 Jul 2008 13:10:01 -0700
I am working on an Access database that has linked tables in the 'front'
(Production folder) and 'backend' (Maintenance folder) on a network. When I
close the Access databases down, the linked table in the (Maintenance folder)
is gone. The linked table in the (Production folder) is still there, and
naturally ...
|
Removing References
Mon, 21 Jul 2008 16:55:10 GMT
Hey folks,
Got a problem here and I'm not sure how to fix it. At one time, my
computer's mapped network drives got fouled up. In the end, I got mapped
network drives pointing to the save Server location. One was labled P and
the other N. The problem is that somewhere, my database is pointing to the N
Driv ...
|
|
|
Working with 2 databases
Mon, 21 Jul 2008 06:54:01 -0700
I would like to know if you can automate an existing database (db1). In db1
have a command button that when you click on the command button will run a
query in db2 . Once the query/make table is done export table to db 1. If
this can
be done, can it be done with macros? If so can you give me a start? Th ...
|
Exporting a Form
Mon, 21 Jul 2008 06:20:01 -0700
Hi All
i have set up an export function which is used to create an excel file and
then put the results of the query within that file
now, i am trying to export a standard page on all of these files but the two
ways i tried do not work
i have tried to create the page as a form and export it
i have tried ...
|
Missing Links
Sat, 19 Jul 2008 12:46:54 GMT
Good Saturday Morning to everyone..
I'm struggling with working on a database from home. At work, the database
is linked to a network drive and works fine. I grab a copy of the FE and BE
and bring it home wiht me. I load it up on my laptop, and the FE tries to
look for the tables on the network drive. Sinc ...
|
