|
Access data sharing using automatic e-mails
I have a graphic that contains data that I would like to use to share access
data: I would like to update this graphic automatically with data that I am
inputing into Access, then I would like to automatically share this graphic
with updated info via e-mail. Can this be done?...
|
1 |
17.07.2006 14:47:01 |
|
|
Importing Excel, more data type problems
The Excel file I have to import is generated automatically by QuickBooks so I
have no control over the format, etc., it comes out in. That said, I have
(at least) two problems importing this data.
1) I need to use the first row of Excel data as column names in my imported
table -- except not all the fields in the first row have data in them. Is
this a potential problem?
To create th...
|
4 |
17.07.2006 14:07:46 |
|
|
Importing contacts from Access
Different fields are displayed when I open the linked table on different
computers. Anybody know why this is?
Thanks...
|
2 |
17.07.2006 12:46:01 |
|
|
GET #Name? ONLY ON PRINT OR EXPORT
I have a date field that reads from an the input form that gives the query
information for the report generation. Preview of the report shows the
correct dates. When I export to .snp or to the printer for hard copy the date
fields return #Name?. ...
|
1 |
17.07.2006 12:15:01 |
|
|
read and display the columns in import file and allow the users t.
I'm trying to program a command button cmdImport that when user click it
(after check all the conditions such as check table if it existing, file path
is correct, file type is right) it should read and display the columns in
import file and allow the users to match them with the corresponding columns
in the existing table. Is it possible in access?
I need code as i am very new for this...
|
3 |
17.07.2006 11:00:43 |
|
|
Export data with open sheet
Good things to alls.
I want to export an access 97 table to excel in this way:
after path request and "OK" by user, I would open Excel application (in
foreground) and show data processing.
Someone would help me?
many thanks in advance.
(I beg your pardon for my bad English)
Giangi ...
|
3 |
17.07.2006 08:21:02 |
|
|
How this access file connect to another database?
I have 2 Access mdb files. (File A and B)
One contains all forms that edit the data in File B. (File A)
Another contains the actual data and tables. (File B)
However, I didn't created these files. Now we are trying to move all the
data and tables into the SQL server. So I need to update File A to make it
connect to the database in SQL server instead to File B.
However, I can't foun...
|
4 |
17.07.2006 06:19:54 |
|
|
Access Email Alerts
in access d'base, how does it email users to perform a task/updates?...
|
2 |
16.07.2006 22:00:22 |
|
|
Can't find IPCChristmas font in Publisher 2002
I have in the past had Publisher 97, Publisher 98 and now have Publisher 2002
in my computer. I have always had, in all 3 Publisher programs access to the
fonts IPCChristmas, IPCThanksgiving and IPCNew years. These fonts and some
others are no longer in my computer that I can find. I had to do a complete
Restore a little while back and maybe that is the problem, I don't know.
These 3...
|
2 |
15.07.2006 23:34:16 |
|
|
IAS Import
I have devices that are listed in an Excel Spreadsheet which includes the
device names, IP Addresses and shared secret. How can I import this in my
IAS console as RADIUS Client without retyping the 200 and something device
info?
--
Chi...
|
2 |
15.07.2006 21:36:34 |
|
|
how do I import a MS Word Template to MS Access as a form?
I would like to import / link existing MS Word 2003 Templates that i've
created to MS Access 2003 as a form for users to simply save onto their pc's
but they must not have the ability to edit the forms. I've managed to link
the template but when users open the document it actually allows them the
ability to edit the original template....
|
5 |
14.07.2006 20:20:05 |
|
|
Delete a table in a different database
Good day.
Looking for some code that will delete all the tables from a different
database than the one that the code is running in. In other words, open an
..mdb, click a button and delete all the tables from a different database on
the server.
Any ideas? Thank you....
|
2 |
14.07.2006 19:56:51 |
|
|
Delete rows from Excel spread sheet While importing to table
I would like to delete the first 12 Rows of the excel spread sheet, that I'm
importing to access table.
--
Bob...
|
2 |
14.07.2006 14:20:01 |
|
|
select file dialog box for dummies pls
Hi, ok i've been checking out the howto 'open file dialog box' posts,
and have checked out the api, howeve i'm stymed on how to actually use
the code, yes you paste it into a new module, but then what, how do you
call this from form button. Sorry if this is a bit basic, but I've only
been doing this for two weeks now, its all rather new, any pointers
would be appreciated.
kind regards
ion...
|
4 |
14.07.2006 12:58:02 |
|
|
Export and email Field layout
We have a vendor who needs the field layouts for many tables for a access
database.
The vendor is askng us to email the layouts to their programmers. They need
the field names, data type and size.
Can anyone tell me how I can export all this info into a excel or .csv so I
can email the info to them?
We use Access 2000.
Thanks for any help!
...
|
2 |
14.07.2006 12:51:29 |
|
|
Upsizing Wizard Priviledges in SQL Server 2005
An ISP I am using for a client tells me that my user requires sysadm
priviledges to run the upsizing wizard on a database on a shared server
(i.e. my user is dbo for the database into which I want load my local Access
database).
Does anyone know if this is correct and if not exactly what priviledges are
required by the wizard user to upsize a local Access database?
I'm using Access...
|
1 |
14.07.2006 09:16:01 |
|
|
what does "parse error data" mean?
I am trying to import data from excel into another program and I get the
above error message....
|
2 |
14.07.2006 05:46:36 |
|
|
ImportXML Question
I have XML formed as follows (this is just a part of the XML)
- <players>
- <player id="814090">
<name>Brian</name>
<surname>Bradford</surname>
<countryfrom id="4">USA</countryfrom>
<age>27</age>
<value>587000</value>
<salary>7400</salary>
<cards>4</cards>
<injuryda...
|
1 |
13.07.2006 22:49:08 |
|
|
Importing XML File - Some Data Is Truncated
I'm importing an XML file into an Access data base. One of the xml
tags that will be imported as a column of data typically has more than
255 characters.
When I import the XML into Access, it creates a table with Fields all
set to Text, which only allows 255 characters.
Is there a way to specify what you want the data type to be for each
thing when importing into Access.
The text dat...
|
2 |
13.07.2006 22:42:01 |
|
|
length of imported text fields issue
I have some databases being imported to access from csv text files. Even
though I have Access set to have any txt field to a maximum 30 integers, the
imported text fields all come through at the maximum 256 characters, creating
larger than life files. They are big tables (up to 1gb) and if I try and
reduce field sizes once they've been imported then I get insufficient memory
issues etc...
|
2 |
13.07.2006 22:36:51 |
|
|
link Outlook contacts to Access limited to Category
I have a link to a Outlook Contact folder located in Public folders in an
Access database. The category field is not available. Is there a way see
the category field or to limit the contacts linked by the category the appear
in?
The result I am looking for is to show only contacts that appear in certian
categories to the database users.
--
Dar...
|
1 |
13.07.2006 20:48:03 |
|
|
Importing large text file to version 2003 versus 1997
A majority of our databases are created by importing existing data in either
txt or csv file formats. When using Access 97 I never had a problem
importing these files. Since we have converted to 2003 I am unable to import
large files and have some trouble with even smaller files. When attempting
to import it will either time out and throw me into a not responding mode or
it shows the ...
|
4 |
13.07.2006 20:44:22 |
|
|
Import a set of values from Excel given a match on a criteria
Hi all
I have an access table with a set of power values against product
(amongst other fields) e.g.
Product Power
pig 45
cow 100
sheep 450
I have an excel spreadsheet with the same fields, field1 is always the
product and field 4 is always the Power value. How do I get access (or
excel) to update the Power values for pig, cow, sheep and so on based
on the values in the...
|
2 |
13.07.2006 20:14:59 |
|
|
Export to Excel
Is there a way for me to run the TransferSpreadsheet macro then have it
automatically pull up the file in excel once the data has been exported? I
like the way that OutputTo works but it only allows me to have one worksheet.
The transferSpreadsheet allows me to input two different worksheets in the
workbook. Do i need to do some VB coding in order to accomplish this? If
so, what code...
|
1 |
13.07.2006 19:55:02 |
|
|
command timeout in Access 2002 and SQL Server
I have an Access 2002 adp program that uses a very large SQL Server database.
I am running into an issue where the sql commands are timing out when
selecting large recordsets. I have added the following code prior to opening
recordsets:
set cn = currentproject.connection
cn.commandtimeout = 0
This doesn't seem to work for users that are running the .adp file with
Access 2002 runtime...
|
4 |
13.07.2006 18:20:47 |