Access to Word or Excel

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have an Access 2003 database that I built. I'ts very basic; it's a single
table with two columns as a primary key (to prevent duplicates), one data
entry form and 5 or 6 reports. I discovered that the organization that I
built this for doesn't have Access, only Word, Excel, Powerpoint and
Publisher.

Can anyone point me to a sample or instructions on how to recreate this very
basic Access app to either Excel or Word?

Any help is appreciated!
 
You can not. Some function of Access can be done in Excel.
You can find duplicates in Excel with the CountIf function like this ---
To check for duplicates in column B enter =IF(COUNTIF(B:B,
B1)>1,"Duplicate","") in A1 and autofill column A.
To check duplicates in multiple-column list you will need to concatenate
them in another column to check.
Check Concatenate Column1 Column2
1A 1 A
2B 2 B
3C 3 C
Duplicate 4C 4 C
Duplicate 4C 4 C
5E 5 E
6E 6 E
6F 6 F
7G 7 G
8G 8 G
IF(COUNTIF(B:B, B12)>1,"Duplicate","") CONCATENATE(C12,D12) 9 H
 
I have an Access 2003 database that I built. I'ts very basic; it's a single
table with two columns as a primary key (to prevent duplicates), one data
entry form and 5 or 6 reports. I discovered that the organization that I
built this for doesn't have Access, only Word, Excel, Powerpoint and
Publisher.

Can anyone point me to a sample or instructions on how to recreate this very
basic Access app to either Excel or Word?

Any help is appreciated!
Click to expand...

1) Even though the organization does not have Access, they can still
read Access reports if they download the free Snapshot report reader
from Microsoft.

http://www.microsoft.com/downloads/...3F-6D74-423D-8274-8B7E6313EDFB&displaylang=en

2) If, for some reason, they do not wish to do that, then you can use
the OutputTo method to create the report in Word .rtf (or other)
format.

DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF,
"c:\MyFolderName\MyReport.rtf"

See VBA help.
Note that the .rtf format does not retain the images, lines, check
boxes, etc., that your Access report might have.
Then send the organization this Word document.
 
Back
Top