Dear Programmers,

I have snaps of my club members in a folder named each snap as per member code for exapmle for a member who's code is
04-02-03-0100921 his snaps is saved as 04-02-03-0100921.jpg.

All Data of My members is in My Mcard Field I want to get a report that for which codes Snaps are not available in the folder as i
have round about 1400 members here.

Hoping a Nice Solution

Thanking You,

Amjad Saeed

Hi,

What exactly is a "snap" ?

Vlad



*******************Confidentiality and Privilege Notice*******************

This email is intended only to be read or used by the addressee. 
It is confidential and may contain legally privileged information. 
If you are not the addressee indicated in this message (or 
responsible for delivery of the message to such person), you 
may not copy or deliver this message to anyone, and you should 
destroy this message and kindly notify the sender by reply email. 
Confidentiality and legal privilege are not waived or lost by
reason of mistaken delivery to you.

Qantas Airways Limited
ABN 16 009 661 901

Visit Qantas online at http://www.qantas.com.au

Snap = picture.

Amjad, you need to explain your situation a little better.

**************************************
I have snaps of my club members in a folder named each snap as per member
code for exapmle for a member who's code is 04-02-03-0100921 his snaps is
saved as 04-02-03-0100921.jpg.
**************************************

Are they saved in a folder called 04-02-03-0100921.jpg or is that the name
of the file. In that case, what is the folder called, and what are the
actual images called if there is more than one for each user.

**************************************
All Data of My members is in My Mcard Field I want to get a report that for
which codes Snaps are not available in the folder as i have round about 1400
members here.
**************************************

So you want a report showing the members who DONT have a picture?  Well if
you have listed in the database the names and location of the files that DO
exist then you can simply 'subtract' them from the list of all members.

If you don't have any info stored in the database as to who has a picture
and who hasn't then you'll need to use some code such as an API or
FileSystemObject to search through folders on your system, which isn't easy.

Cheers,
Andrew


-----Original Message-----
From: Vlad VRA09 Rakic [mailto:vrakic@q...]
Sent: Wednesday, 19 March 2003 2:15 PM
To: Access
Subject: [access] Re: Search a snap



Hi,

What exactly is a "snap" ?

Vlad



IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.

Dear Snaps Means Pictures of member are stored in a folder named as allsnaps
and each member picture is named as membercode.jpg eg(04-02-02-00001.jpg)

I need Following
1.    List of Members who who's snaps are available or vice versa
2.    Report which contains Member code Member Name and Member Picture
(Picture should be taken from allsnaps folder


Thanking You
Amjad Saeed

----- Original Message -----
From: "Haslett, Andrew" <andrew.haslett@i...>
To: "Access" <access@p...>
Sent: Wednesday, March 19, 2003 7:52 AM
Subject: [access] Re: Search a snap


> Snap = picture.
>
> Amjad, you need to explain your situation a little better.
>
> **************************************
> I have snaps of my club members in a folder named each snap as per member
> code for exapmle for a member who's code is 04-02-03-0100921 his snaps is
> saved as 04-02-03-0100921.jpg.
> **************************************
>
> Are they saved in a folder called 04-02-03-0100921.jpg or is that the name
> of the file. In that case, what is the folder called, and what are the
> actual images called if there is more than one for each user.
>
> **************************************
> All Data of My members is in My Mcard Field I want to get a report that
for
> which codes Snaps are not available in the folder as i have round about
1400
> members here.
> **************************************
>
> So you want a report showing the members who DONT have a picture?  Well if
> you have listed in the database the names and location of the files that
DO
> exist then you can simply 'subtract' them from the list of all members.
>
> If you don't have any info stored in the database as to who has a picture
> and who hasn't then you'll need to use some code such as an API or
> FileSystemObject to search through folders on your system, which isn't
easy.
>
> Cheers,
> Andrew
>
>
> -----Original Message-----
> From: Vlad VRA09 Rakic [mailto:vrakic@q...]
> Sent: Wednesday, 19 March 2003 2:15 PM
> To: Access
> Subject: [access] Re: Search a snap
>
>
>
> Hi,
>
> What exactly is a "snap" ?
>
> Vlad
>
>
>
> IMPORTANT - PLEASE READ ********************
> This email and any files transmitted with it are confidential and may
> contain information protected by law from disclosure.
> If you have received this message in error, please notify the sender
> immediately and delete this email from your system.
> No warranty is given that this email or files, if attached to this
> email, are free from computer viruses or other defects. They
> are provided on the basis the user assumes all responsibility for
> loss, damage or consequence resulting directly or indirectly from
> their use, whether caused by the negligence of the sender or not.
>
>

Here snap Means Picture of Member

Thanks

Amjad Saeed

----- Original Message -----
From: "Vlad VRA09 Rakic" <vrakic@q...>
To: "Access" <access@p...>
Sent: Wednesday, March 19, 2003 8:45 AM
Subject: [access] Re: Search a snap


>
> Hi,
>
> What exactly is a "snap" ?
>
> Vlad
>
>
>
> *******************Confidentiality and Privilege Notice*******************
>
> This email is intended only to be read or used by the addressee.
> It is confidential and may contain legally privileged information.
> If you are not the addressee indicated in this message (or
> responsible for delivery of the message to such person), you
> may not copy or deliver this message to anyone, and you should
> destroy this message and kindly notify the sender by reply email.
> Confidentiality and legal privilege are not waived or lost by
> reason of mistaken delivery to you.
>
> Qantas Airways Limited
> ABN 16 009 661 901
>
> Visit Qantas online at http://www.qantas.com.au
>
>
>

1. You'll need to find some code which searches through directories.

2.
* Create a query which holds the data for your report. 
* Add a field called 'URL' and create it so that it holds the entire path
the image. 
* eg. URL:="c:\AllSnaps\" & membercode & ".jpg"
* Create a report and add your required fields from the query as normal
* Add to the report an invisible textbox which holds the URL field. Call it
txtURL
* Add to the report an image control, but remove its 'Picture' path so that
it is blank. Call it ctrImage.
* In the OnPrint event of the DETAIL section add the following code:

If Not IsNull(Me![txtURL]) Then
    Me![ctrImage].Picture = Me![txtURL]
End If


Cheers,
Andrew
-----Original Message-----
From: Amjad Saeed [mailto:amjadsaeed@b...]
Sent: Wednesday, 19 March 2003 2:18 PM
To: Access
Subject: [access] Re: Search a snap


Dear Snaps Means Pictures of member are stored in a folder named as allsnaps
and each member picture is named as membercode.jpg eg(04-02-02-00001.jpg)

I need Following
1.    List of Members who who's snaps are available or vice versa
2.    Report which contains Member code Member Name and Member Picture
(Picture should be taken from allsnaps folder


Thanking You
Amjad Saeed

----- Original Message -----
From: "Haslett, Andrew" <andrew.haslett@i...>
To: "Access" <access@p...>
Sent: Wednesday, March 19, 2003 7:52 AM
Subject: [access] Re: Search a snap


> Snap = picture.
>
> Amjad, you need to explain your situation a little better.
>
> **************************************
> I have snaps of my club members in a folder named each snap as per member
> code for exapmle for a member who's code is 04-02-03-0100921 his snaps is
> saved as 04-02-03-0100921.jpg.
> **************************************
>
> Are they saved in a folder called 04-02-03-0100921.jpg or is that the name
> of the file. In that case, what is the folder called, and what are the
> actual images called if there is more than one for each user.
>
> **************************************
> All Data of My members is in My Mcard Field I want to get a report that
for
> which codes Snaps are not available in the folder as i have round about
1400
> members here.
> **************************************
>
> So you want a report showing the members who DONT have a picture?  Well if
> you have listed in the database the names and location of the files that
DO
> exist then you can simply 'subtract' them from the list of all members.
>
> If you don't have any info stored in the database as to who has a picture
> and who hasn't then you'll need to use some code such as an API or
> FileSystemObject to search through folders on your system, which isn't
easy.
>
> Cheers,
> Andrew
>
>
> -----Original Message-----
> From: Vlad VRA09 Rakic [mailto:vrakic@q...]
> Sent: Wednesday, 19 March 2003 2:15 PM
> To: Access
> Subject: [access] Re: Search a snap
>
>
>
> Hi,
>
> What exactly is a "snap" ?
>
> Vlad
>
>
>
> IMPORTANT - PLEASE READ ********************
> This email and any files transmitted with it are confidential and may
> contain information protected by law from disclosure.
> If you have received this message in error, please notify the sender
> immediately and delete this email from your system.
> No warranty is given that this email or files, if attached to this
> email, are free from computer viruses or other defects. They
> are provided on the basis the user assumes all responsibility for
> loss, damage or consequence resulting directly or indirectly from
> their use, whether caused by the negligence of the sender or not.
>
>



IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.

Dear Andrew

Thanks for right suggession Please Tell me How Can I Check wethere Picture
of desired member is available or not if not then picture box must be blank
in present case it gets picture of last member

Thanks

Amjad Saeed

----- Original Message -----
From: "Haslett, Andrew" <andrew.haslett@i...>
To: "Access" <access@p...>
Sent: Wednesday, March 19, 2003 10:21 AM
Subject: [access] Re: Search a snap


> 1. You'll need to find some code which searches through directories.
>
> 2.
> * Create a query which holds the data for your report.
> * Add a field called 'URL' and create it so that it holds the entire path
> the image.
> * eg. URL:="c:\AllSnaps\" & membercode & ".jpg"
> * Create a report and add your required fields from the query as normal
> * Add to the report an invisible textbox which holds the URL field. Call
it
> txtURL
> * Add to the report an image control, but remove its 'Picture' path so
that
> it is blank. Call it ctrImage.
> * In the OnPrint event of the DETAIL section add the following code:
>
> If Not IsNull(Me![txtURL]) Then
>     Me![ctrImage].Picture = Me![txtURL]
> End If
>
>
> Cheers,
> Andrew
> -----Original Message-----
> From: Amjad Saeed [mailto:amjadsaeed@b...]
> Sent: Wednesday, 19 March 2003 2:18 PM
> To: Access
> Subject: [access] Re: Search a snap
>
>
> Dear Snaps Means Pictures of member are stored in a folder named as
allsnaps
> and each member picture is named as membercode.jpg eg(04-02-02-00001.jpg)
>
> I need Following
> 1.    List of Members who who's snaps are available or vice versa
> 2.    Report which contains Member code Member Name and Member Picture
> (Picture should be taken from allsnaps folder
>
>
> Thanking You
> Amjad Saeed
>
> ----- Original Message -----
> From: "Haslett, Andrew" <andrew.haslett@i...>
> To: "Access" <access@p...>
> Sent: Wednesday, March 19, 2003 7:52 AM
> Subject: [access] Re: Search a snap
>
>
> > Snap = picture.
> >
> > Amjad, you need to explain your situation a little better.
> >
> > **************************************
> > I have snaps of my club members in a folder named each snap as per
member
> > code for exapmle for a member who's code is 04-02-03-0100921 his snaps
is
> > saved as 04-02-03-0100921.jpg.
> > **************************************
> >
> > Are they saved in a folder called 04-02-03-0100921.jpg or is that the
name
> > of the file. In that case, what is the folder called, and what are the
> > actual images called if there is more than one for each user.
> >
> > **************************************
> > All Data of My members is in My Mcard Field I want to get a report that
> for
> > which codes Snaps are not available in the folder as i have round about
> 1400
> > members here.
> > **************************************
> >
> > So you want a report showing the members who DONT have a picture?  Well
if
> > you have listed in the database the names and location of the files that
> DO
> > exist then you can simply 'subtract' them from the list of all members.
> >
> > If you don't have any info stored in the database as to who has a
picture
> > and who hasn't then you'll need to use some code such as an API or
> > FileSystemObject to search through folders on your system, which isn't
> easy.
> >
> > Cheers,
> > Andrew
> >
> >
> > -----Original Message-----
> > From: Vlad VRA09 Rakic [mailto:vrakic@q...]
> > Sent: Wednesday, 19 March 2003 2:15 PM
> > To: Access
> > Subject: [access] Re: Search a snap
> >
> >
> >
> > Hi,
> >
> > What exactly is a "snap" ?
> >
> > Vlad
> >
> >
> >
> > IMPORTANT - PLEASE READ ********************
> > This email and any files transmitted with it are confidential and may
> > contain information protected by law from disclosure.
> > If you have received this message in error, please notify the sender
> > immediately and delete this email from your system.
> > No warranty is given that this email or files, if attached to this
> > email, are free from computer viruses or other defects. They
> > are provided on the basis the user assumes all responsibility for
> > loss, damage or consequence resulting directly or indirectly from
> > their use, whether caused by the negligence of the sender or not.
> >
> >
>
>
>
> IMPORTANT - PLEASE READ ********************
> This email and any files transmitted with it are confidential and may
> contain information protected by law from disclosure.
> If you have received this message in error, please notify the sender
> immediately and delete this email from your system.
> No warranty is given that this email or files, if attached to this
> email, are free from computer viruses or other defects. They
> are provided on the basis the user assumes all responsibility for
> loss, damage or consequence resulting directly or indirectly from
> their use, whether caused by the negligence of the sender or not.
>
>