View .tif with MODI

MS Office Access

    Sponsored Links


  • 1. Select year from a query
    I have the following SQL for my query but I want to have the user be able to select the year only for this query. How would I write this into my SQL statement? SELECT DISTINCTROW tblNCMR.DiscrepancyCode, Format$([tblNCMR].[DateCreated],'mmmm yyyy') AS [DateCreated By Month], Sum(tblNCMR.TotalCost) AS [Sum Of TotalCost], Count(*) AS [Count Of tblNCMR], Month([DateCreated]) AS MonthNum, tblDiscrepancyCodes.[Code Description] FROM tblDiscrepancyCodes INNER JOIN tblNCMR ON tblDiscrepancyCodes.Code = tblNCMR.DiscrepancyCode GROUP BY tblNCMR.DiscrepancyCode, Format$([tblNCMR].[DateCreated],'mmmm yyyy'), Month([DateCreated]), tblDiscrepancyCodes.[Code Description], Year([tblNCMR].[DateCreated])*12+DatePart('m',[tblNCMR].[DateCreated])-1 ORDER BY Month([DateCreated]);
  • 2. Report Structure
    I am trying to prepare a report that lists committee member scores by students. The query that I am using has the student name listed with committee member scores. (example) Student 1/Committee Member Name 1/CM 1 score Student 1/Committee Member Name 2/CM 2 score Student 1/Committee Member Name 3/CM 3 score Student 2/Committee Member Name 1/CM 1 score Student 2/Committee Member Name 2/CM 2 score Student 2/Committee Member Name 3/CM 3 score Student 3/Committee Member Name 1/CM 1 score Student 3/Committee Member Name 2/CM 2 score Student 3/Committee Member Name 3/CM 3 score I want to print out a report that shows the following: (example) [Student][CM Name 1][CM Name 2][CM Name 3] (this is a header) Student 1/CM 1 score/ CM 2 score/ CM 3 score Student 2/CM 1 score/ CM 2 score/ CM 3 score Student 3/CM 1 score/ CM 2 score/ CM 3 score I can only get it to do the following (which I don't want): (example) Student 1 CM Name 1/CM 1 score CM Name 2/CM 2 score CM Name 3/CM 3 score Student 2 CM Name 1/CM 1 score CM Name 2/CM 2 score CM Name 3/CM 3 score Student 3 CM Name 1/CM 1 score CM Name 2/CM 2 score CM Name 3/CM 3 score Any suggestions would be greatly appreciated. Thanks, Chris
    How do I open a pdf file that is listed on my form in a text box. The file is different for every record but must be able to be viewed in full.
    -- Viv

View .tif with MODI

Postby bHVjeWs » Sun, 02 Sep 2007 04:30:03 GMT

How can I view a .tif file using the Microsoft Office Document Imaging 
control? Does anyone have example code? 

Re: View .tif with MODI

Postby Stephen Lebans » Sun, 02 Sep 2007 05:49:56 GMT

Do a GoogleGroups search on:
lebans MODI

Several of the threads point to sample source code you can download.


Stephen Lebans
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Re: View .tif with MODI

Postby bHVjeWs » Wed, 05 Sep 2007 23:48:02 GMT

I still cannot get it to work.  Following is the code.  The image will not 

  Dim miDoc As MODI.document
  Dim myViewer As New MODI.MiDocView
  Set miDoc = New MODI.document
  Set myViewer = New MODI.MiDocView
  'open existing document
  miDoc.Create "C:\print\myfile.tif"
  'attach document to viewer
  myViewer.FileName = "C:\print\myfile.tif"

  Set miDoc = Nothing
  Set myViewer = Nothing


Similar Threads:

1.Using MODI to convert multi-page tif to single page tif

I have thousands of multipage tif images in many subdirectories that I need 
to convert into single page tifs.  I have vba code to do this (written in MS 
Access) that loops thru the directory tree and I can access info about the 
tifs using MODI.  What I'm looking to do now is convert/save the existing 
multiple page tif to a series of single page tifs so they can be imported 
into our image repository.  Anyone know how to do this?  For example, if the 
current multiple page tif is six pages is would create six single page tifs 
(e.g. sample1_page1.tif,sample1_page2.tif,...


2.MODI - tif file stays locked after .Close

I'm using a MODI reference in my VB .Net 2003 project, creating an MODI 
document object instance and using the .Create("myfilename.tif") method to 
load the document with a single image from a tiff file. After OCRing the 
text, I call the close method.
Problem is that MODI doesnt appear to release the file lock until the 
application closes, and i need to reuse the file name.

dim myMODI as MODI.Document
myMODI = New MODI.Document
{ does some work looking at the words in the myMODI.Images(0).Layout.Text 
property }
myMODI = nothing
Kill ("c:\testfile.tif") 

The kill statement fails saying that another program has the file open.
How can i get MODI to let go of the file?

Any help is appreciated.

3.MODI v12 can't open a .tif file that v11 can open without difficulty

When attempting to open a .tif file with MODI 12.0.4518.1014 I get the error 
"the selected file is not a valid microsoft office document imaging file". 
Opening this file on any machine with MODI 11.something works fine.  Is 
there a patch/fix/workaround for this?

4.Universal view of MODI files

Which PC's can view MODI (Microsoft Office Document Imaging) files (extension 

We have Office 2003 on a WinXP PC.  I wish to publish/distribute 
non-editable views, and might print PDF files (spin wheels eliminating page 
truncate in free/$20 PDF995 or spend $300 on Adobe Acrobat 7.0 Standard).

Or can everybody with a WinXP PC view/print the MODI files?  Or only if they 
have Office 2003?


-- GeneM
Knowledge Spunge (need spill-checker)

5.Viewing Tif files

6. Tif images created from MS Document writer cannot be viewed

7. Viewing tif and mdi files on Pocket PC 2003

8. How to view TIF on Access form?

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 43 guest