|
|
|
forms to table
Thu, 9 Oct 2008 12:45:01 -0700
I need to move the data from a form - checkbox, description, dates to a
table. I have the form created. I have a submit button - which needs to
submit to the table.
HELP!! ...
|
Need to import picture/pdf into form
Thu, 9 Oct 2008 09:36:08 -0700
Fire district has access db for runnings cards (directions) of streets. I
need to put a map/drawing on the form also. We will be scanning the
maps/drawing into the computer. What is the best format to save these and
then put these into the form. There will be 1 map for each record.
Thanks in advance! ...
|
linking to excel, my fieldnames from excel won't import correctly
Thu, 9 Oct 2008 02:38:07 -0700
I am sure this used to so not sure why I now have a problem. I am linking an
excel spreadsheet, around 500 rows. Top row has column headings including
SchoolName, N1, N2,R,2,3,4,5,6,7,8,9,10,11,12,13. These headings come from a
crosstab query in someone else's database that I cannot use directly, so will
nee ...
|
Images distorted/resized during insert in Jet 4.0 database applica
Wed, 8 Oct 2008 18:53:02 -0700
I support a jet 4.0 database application that is deployed out to multiple
users. These users have different types of Windows Operating Systems. There
is some support from the vendor for this system, but they are not able to
answer all problems. The data files live on a central server and are accessed
from ea ...
|
Query then Export. Numbers turn to Text. Why?
Wed, 8 Oct 2008 17:35:01 -0700
Why might numbers be converted to text during an TransferSpreadsheet export
process? I know the data is in number format in the table! It goes through
a query, formatted as Currency, but then when I open the spreadsheet the
numbers are text...and this causes zeros to appear in an Excel Pivot Table.
So biz ...
|
Access export to excel produces "unreadable data"
Wed, 8 Oct 2008 16:35:01 -0700
I have a spreadsheet saved as an Excel 97-2003 workbook and am trying to
export the contents of a query from Access 2007. The exported data is
referenced in about 400 sumif statements in several calculation sheets.
I've tried
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, stDocName,
"Outpu ...
|
Date in Access table
Wed, 8 Oct 2008 08:57:20 -0700
The date in the text file transposes the month and day when I import into my
Access table?
How do you set advanced specs when importing? ...
|
|
|
Importing Excel files that are automatically updated into Access
Wed, 8 Oct 2008 07:13:13 -0700
I am in the process of creating a data base where I have some existing files
in Excel that are automatically updated from an AS 400 query. If I link the
tables will the update take place when I open Access? Or is there a command
that will ask Excel to up date when run?
Pete ...
|
question about Exporting multiple tables from Access
Wed, 8 Oct 2008 05:27:01 -0700
Hello,
I haven't been working with Access for very long, so I am just at a learning
level. I am working on analizing how to export multiple tables from Access
into a flat file or othe ODBC Data source (most likely teradata or DB2). I
can do it one table at a time, but this will be very time consuming. Is th ...
|
Speed issues while exporting data to Excel pivot tables...
Wed, 8 Oct 2008 05:20:15 -0700
Hi All,
I am trying to import a query in Access to Excel into a pivot table but it
takes ages to get exported. The problem is with my machine only as all other
users do not seem to have that problem. For them, the data gets refreshed
very quickly but in my machine it takes ages. Likewise, my machine takes
l ...
|
|
|
