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  

Attn Arvin



 
 
Thread Tools Display Modes
  #1  
Old May 11th, 2009, 09:56 PM posted to microsoft.public.access
mark
external usenet poster
 
Posts: 5
Default Attn Arvin

Arvin

You very kindly sent me an Access database that you wrote that I can use for
cataloguing digital photographs.

The only problem is when I try to use 'Print Images (Report)', the print
preview clips the photograph. When I go to Design View and look at the
Properties of the 'Print Images' button, on the Event Tab, 'On click' and
look at the 'Event Procedure', it takes me to what looks like VB, which
unfortunately I have no knowledge of. Is it a simple task to amend the VB
so that when I print the picture, it zooms to the whole photograph, and
doesn't clip it? Thanks

Mark


  #2  
Old May 11th, 2009, 10:19 PM posted to microsoft.public.access
John Smith
external usenet poster
 
Posts: 39
Default Attn Arvin


derick hello
  #3  
Old May 11th, 2009, 10:34 PM posted to microsoft.public.access
mark
external usenet poster
 
Posts: 5
Default Attn Arvin


"John Smith" wrote in message
...

derick hello


??


  #4  
Old May 11th, 2009, 11:00 PM posted to microsoft.public.access
Arvin Meyer MVP
external usenet poster
 
Posts: 640
Default Attn Arvin

You can fix that in the property sheet. Select the image control, and change
the SizeMode from Click to Zoom.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Mark" wrote in message
...
Arvin

You very kindly sent me an Access database that you wrote that I can use
for cataloguing digital photographs.

The only problem is when I try to use 'Print Images (Report)', the print
preview clips the photograph. When I go to Design View and look at the
Properties of the 'Print Images' button, on the Event Tab, 'On click' and
look at the 'Event Procedure', it takes me to what looks like VB, which
unfortunately I have no knowledge of. Is it a simple task to amend the VB
so that when I print the picture, it zooms to the whole photograph, and
doesn't clip it? Thanks

Mark



  #5  
Old May 11th, 2009, 11:06 PM posted to microsoft.public.access
Graham Mandeno
external usenet poster
 
Posts: 593
Default Attn Arvin

Hi Mark

I haven't seen Arvin's database, but I am willing to bet that he is printing
the photos using a report with an image control.

Find the report and open it in design view, and then select the image
control and show the property sheet. If "Size Mode" is set to "Clip" then
change it to "Zoom".

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Mark" wrote in message
...
Arvin

You very kindly sent me an Access database that you wrote that I can use
for cataloguing digital photographs.

The only problem is when I try to use 'Print Images (Report)', the print
preview clips the photograph. When I go to Design View and look at the
Properties of the 'Print Images' button, on the Event Tab, 'On click' and
look at the 'Event Procedure', it takes me to what looks like VB, which
unfortunately I have no knowledge of. Is it a simple task to amend the VB
so that when I print the picture, it zooms to the whole photograph, and
doesn't clip it? Thanks

Mark



  #6  
Old May 11th, 2009, 11:28 PM posted to microsoft.public.access
mark
external usenet poster
 
Posts: 5
Default Attn Arvin

Sorted !!

It's a great database routine. Thank you


"Graham Mandeno" wrote in message
...
Hi Mark

I haven't seen Arvin's database, but I am willing to bet that he is
printing the photos using a report with an image control.

Find the report and open it in design view, and then select the image
control and show the property sheet. If "Size Mode" is set to "Clip" then
change it to "Zoom".

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Mark" wrote in message
...
Arvin

You very kindly sent me an Access database that you wrote that I can use
for cataloguing digital photographs.

The only problem is when I try to use 'Print Images (Report)', the print
preview clips the photograph. When I go to Design View and look at the
Properties of the 'Print Images' button, on the Event Tab, 'On click' and
look at the 'Event Procedure', it takes me to what looks like VB, which
unfortunately I have no knowledge of. Is it a simple task to amend the
VB so that when I print the picture, it zooms to the whole photograph,
and doesn't clip it? Thanks

Mark





 




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


All times are GMT +1. The time now is 06:41 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.