|
l
j
...
|
1 |
24.08.2006 15:18:04 |
|
|
Mail merge-send data of 3 person to 1 person in 1 letter
I have an access database where 1 manger handles multiple accounts. I need to
send letter via mail merge where only 1 letter will be send with multiple
data. Do not want to send 3 letters. For example
Dear Mr X
Mr Y has a 500 balance
Mr P has a 200 balance
Mr N has a 100 balance...
|
1 |
24.08.2006 14:34:02 |
|
|
Linked table on shared computer
I have a database that resides on a shared drive (e:) in computer A. That
computer has Access 2002 SP3 installed. In the database, there is a linked
table to a txt file located on the same drive, but a different directory in
Comp A. I use computer B, that has Access 2003 SP2. While using comp B, I
had added and updated the linked file to the database which is on the e:drive
of compute...
|
3 |
24.08.2006 05:39:27 |
|
|
How do I export outlook emails from one computer to another?
My main computer hard drive bit the dust. I have a copy of my Outlook on my
laptop computer. How do I export the messages from that computer to my main
computer. All questions I have seen posted show exporting OE to Outlooks -
not Outlooks to Outlooks......
|
2 |
24.08.2006 05:32:11 |
|
|
Export to Excel & write back to Access
Hi All,
I have a query on Access 2002 that pulls data from 2 tables. I would like to
export the query to an Excel file that's already been designed. Initially I
have about 30K rows of data to export, and after that about 2k rows of data
every week. Users will manipulate and analyze data on Excel, and would like
to write new results back into access (may be in a new field).
1. what's th...
|
4 |
23.08.2006 21:26:02 |
|
|
double emails
Since importing e-mails from Outlook express to ms outlook my incoming emails
are doubling in my in box. What do I need to do?...
|
2 |
23.08.2006 19:28:38 |
|
|
Create a Spreadsheet with a macro in it?
All,
I am trying to do the following:
Export 2 queries into 1 workbook (I've done this)
Insert two modules with the code I need into excel (no idea. I don't know
excel very well)
Open the workbook and start a macro.
Any suggestions or similar code frame work that some has and wouldn't mind
sharing??
Thanks,
Lee...
|
2 |
23.08.2006 19:27:32 |
|
|
Method 'Columns' of object 'IImexGrid' failed
When I try to import an Excel worksheet into my existing Access database, I
am getting this error message: Method 'Columns' of object 'IImexGrid' failed
It won't allow me to load the file. Anyone every had this problem?...
|
2 |
23.08.2006 19:25:41 |
|
|
Excel Link Questions
I have an Access table with a link to an Excel spreadsheet. When I change
records on the table, the spreadsheet updates properly. But when I add
records, the new records do not carry over to the spreadsheet. Is therea way
to have the size of the 'table' in the spreadsheet expand along with the
Access one?
Also, did I read correctly that the newer versions of Access do not allow
the li...
|
1 |
23.08.2006 17:01:01 |
|
|
Link to Excel Sheet
Hi at all,
i developed an Access Database with Access 2000
and i have queries that changes date in a linked Excel
sheet within Access.
Now i tried the update queries in Access 2003 but
the linked excel sheet is not longer to update in Access 2003.
Does anybody know the reason for this look and how to
solve that ? Even if i open the linked excel sheet in access 2003 i can not
make an ...
|
2 |
23.08.2006 12:36:12 |
|
|
Numbers importing from Excel as text
I have an inventory sheet that I've been keeping in excel and I'm trying to
import it to Access. My problem is that the part numbers are alpha/numeric
and just numeric. The alpha/numeric part numbers are coming over fine, but
my 10 digit numeric part numbers come over like this 8.70002e+009.
I've tried changing the data type to number and my alpha/numeric part
numbers get deleted, and...
|
3 |
23.08.2006 12:26:01 |
|
|
exporting from a querry in access to a .xlt
I was wondering if you can export from a querry to a file with .xlt extension...
|
2 |
23.08.2006 06:16:28 |
|
|
TransferText Importing Txt file
I'm trying to using the DoCmd.TransfrerText VBA on an access2003 ADP with a
SQL 2000 backend.
I'm trying to import into an existing table named "ABC", but I get and error
message saying "Microsoft Jet cannot find table dbo.ABC" so it creates it.
When I'm logged on as say any other user, and look at the database window I
see this as the table name "ABC(dbo)"
Any help out there???
...
|
1 |
23.08.2006 00:01:02 |
|
|
FoxPro ODBC
How do I import or link to DBF files using the FoxPro ODBC instead of the jet
data engine?...
|
3 |
22.08.2006 21:23:02 |
|
|
Export access table to ODBC - not prompted for datasource name
I am running Access 2003 SP2. I right click on a table in my access
database, then select "Export...". In the resulting dialog, I change the
"Save as type" to "ODBC Databases ()". I am then prompted for the name of
the object to create in the ODBC Database. I enter a reasonable value and
click "OK" - and then that's it. I do not get a dialog asking me to identify
the ODBC data sourc...
|
1 |
22.08.2006 21:03:02 |
|
|
using TransferDatabase action to import
This is going to be my first attempt to import data from one Access database
to another. While it may be a simple and routine task, having never done it
has me unsure of what to do. I really appreciate any guidance anyone has to
offer!
I want to import a recordset based on the field JobNumber and anther field
BidStatus. I have identified a total of 17 fields from 3 different tables in
m...
|
4 |
22.08.2006 17:55:02 |
|
|
How to create a local index
Access 2003: Problem: I cannot append to a linked Excel spreadsheet. From
what I've read in the posts, that's because there's no primary key. The link
wizard did not prompt me for a primary key, so I suspect the answer lies in
creating a "local index". How do I do that? (Or any other suggestions you
may have.)
Thanks,
Dorci...
|
3 |
22.08.2006 15:50:02 |
|
|
Placing image link in access fails
Hi all.
I am trying to place a small image in an OLE field
in an Access table. When I link to it on my PC it
works fine, but the image is not visible when doing a
search with a Front page generated search.
When I try to link to the image on the server I get
an error message that the file does not exist. I know
full-well that the file is there. What am I missing?
Any guidance apprecia...
|
1 |
22.08.2006 14:41:08 |
|
|
Replace worksheet when Exporting to Excel?
I have a macro that automatically exports the results of an Access query to
an Excel Spreadsheet. It does this on a daily basis.
Up until last week, the tab on the spreadsheet would be overlaid with new
data.
For example, the query name is "Replenishment". Each day the tab called
"Replenishment" within the Excel spreadsheet would be replaced with the
current day's data. Now instead of re...
|
3 |
22.08.2006 14:22:58 |
|
|
Import and 2G limit
There is a large amount of waste space that accumulates during import. My
database has gotten large enough that I have to compact & repair the database
half way through the file imports in order to avoid the 2Gig file size limit.
Is there any way to set up Access to minimize the amount of waste space that
accumulates so I can eliminate the extra compact & repair step?
Thanks...
|
5 |
22.08.2006 14:18:30 |
|
|
can I write a letter that has fields filled in from a database?
I want to have a letter that will import information from a database (names,
addresses, and such) so that I don't have to spend time cutting and pasteing
as I do now. Is there an easy way to do this?
Thanks....
|
2 |
22.08.2006 06:01:39 |
|
|
Importing Data
Hi all
I'm trying to import data from a db I created that has the VB code
password protected, when it gets to importing the forms with the protected VB
code it comes up with an error saying I must enter the password for the VB
code but it does give me an opition or say where the password must be
entered. Anyone any idea's??
--
Don...
|
2 |
22.08.2006 05:38:36 |
|
|
Is there a way to embed an .avi file and use media player to play
Is there a way to embed an .avi file in an Access database and use media
player to play it on a form?...
|
2 |
21.08.2006 19:11:02 |
|
|
Import Specs
I have an existing import spec, and I am trying to add fields to it. Once
the field is added I choose Save, and the new fields are removed. I can
change existing fields, but am unable to add anything. This is incredibly
frustrating. Does anyone know what is wrong?...
|
4 |
21.08.2006 19:05:31 |
|
|
Importing from outlook
Hi,
I seem to have fallen over at the first hurdle and need your help:
I receive an email first thing every morning with a data link in it
like this:
https://esales3.nj.ssmb.com/esalesauth/ReportAccess.smvc?Resource=/ftp_p
ub/FsaRep4_20060815.xls
when you click it, it requires a user name and password before opening
as a excel spreadsheet.
wondered if you knew of a way of importi...
|
3 |
21.08.2006 19:01:29 |