A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to show image in the form or report?



 
 
Thread Tools Display Modes
  #1  
Old June 28th, 2004, 11:28 PM
JJ
external usenet poster
 
Posts: n/a
Default How to show image in the form or report?

Hi,

I am using Access 2003 and Window XP. In my table, i have a column show's image's location (ex: A:/B/IMAGE1.JPG).

Is it possiable to show all the images in table or report without clicking?

thanks

JJ
  #2  
Old June 29th, 2004, 06:01 AM
Raghu Prakash
external usenet poster
 
Posts: n/a
Default How to show image in the form or report?

Hi JJ,

Create and embed an unbound object on a form or report:

Open a form or report in Design view (Design view: A window that shows the
design of these database objects: tables, queries, forms, reports, macros,
and data access pages. In Design view, you can create new database objects
and modify the design of existing ones.).
Click the Unbound Object Frame tool in the toolbox (toolbox: A set of
tools that is available in Design view to add controls to a form, report,
or data access page. The toolset available in page Design view is different
from the toolset available in form and report Design view.).
On the form or report, click where you want to insert the object.
In the Insert Object dialog box, click Create New if it's not already
selected, and then in the Object Type box, click the object type you want
to create.
Select the Display as Icon check box if you want the object to appear as
the icon for the application used to create the object instead of as the
object itself. Displaying an object as an icon can be helpful when an
object contains supplementary information that doesn't have to be
displayed. Displaying an object as an icon also uses significantly less
disk space.
Click OK. Microsoft Access creates an unbound object frame (unbound object
frame: A control that you place on a form or report to contain an unbound
object. An unbound object is an object, such as a picture, whose value
isn't derived from data stored in a table.).
Create the object by using the application that you chose in the Object
Type box in step 4, and then do one of the following:
If you created the object in place (in-place activation: Activation of an
OLE object's OLE server from within a field or control. For example, you
can play a waveform audio (.wav) file contained in a control by
double-clicking the control.), click the form outside the bound object
frame (bound object frame: A control on a form or report that is used to
display and manipulate OLE objects that are stored in tables.).
Note If you click Exit on the File menu, you'll quit Microsoft Access.

If the object that you created opened in a separate window, click Exit on
the File menu of that separate window. If you're prompted to update the
document, click OK.
To enable editing of the object in Form view (Form view: A window that
displays a form to show or accept data. Form view is the primary means of
adding and modifying data in tables. You can also change the design of a
form in this view.), set the Enabled property of the unbound object frame
to Yes and the Locked property to No. These properties are found on the
Data tab of the form's property sheet, which can be accessed by
double-clicking the form selector (form selector: The box where the rulers
meet, in the upper-left corner of a form in Design view. Use the box to
perform form-level operations, such as selecting the form.).


http://office.microsoft.com/assistan...051878281033&C
TT=1&Origin=EC790000701033&QueryID=b6f5A_d-L0&Query=Add+a+picture+or+object+
that+doesn't+change+from+record+to+record&Scope=TC %2cHP%2cHA%2cRC%2cFX%2cES%
2cEP%2cDC%2cXT

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Push Button to Email form report Brook Using Forms 4 June 19th, 2004 09:11 AM
From a report record to the specific record in a form Sierras Using Forms 1 June 18th, 2004 02:54 PM
Emailing a Report with Image Hasan Setting Up & Running Reports 3 June 10th, 2004 03:18 PM
Query Form: Print Report Dennis Running & Setting Up Queries 1 June 6th, 2004 01:08 PM
external image files on a report (continuation) Veetold Setting Up & Running Reports 1 May 21st, 2004 12:52 PM


All times are GMT +1. The time now is 06:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.