Link Between Navigation Button and List Box

[a_20120]

Hi everyone,
Could u plz have a look at the attached file, and help me how to create link between List Box and Navigation Button?

 

[a_20120]

Hello EveryBody,
Plz anyone Help me with the above Problem

 

[MStef]

Hello Abdul!

Here it is!
You have to change PATH NAME in Sub SetPic().
"C:\razno\Picture\" change with your Path name.

I don't know what you mean with PROBLEM 2.

 

[a_20120]

THANKS VERY MUCH MR. MStef
That is what I wanted, Could u plz have a look here too
http://www.access-programmers.co.uk/forums/showthread.php?t=126095

 

[a_20120]

THANKS Mr. MStef

This is only for four records,
1. if there are more than four records then How could we navigate through the list box?
2. if we manually select a record of the list box, then the navigation not work correctly
3. if we filter the list box, how can we select the first record of the list box?
4. at last, could u plz tell me how can i select the first and last record of the list box?

 

[MStef]

Hello Abdul!

Do something jourself, look at VBA and addapt for more pictures.
You must learn something.

 

[a_20120]

Hello Mr. MStef
could u plz tell me how can i access the first and last record of the list box?

 

[MStef]

Look at VBA
Private Sub cmdNext_Click
If PicN = 4 then ..............it means last record, change 4 in 600.
........


Private Sub cmdPrevious_Click
If PicN = 1 Then ........it means first record.
......

 

[a_20120]

I know that is 4, but How did u know that there might be 4 or more, bcoz records are added gradually...

 

[MStef]

Hello Abdul!

Remember, you have got all the pictures in "tblPicture".
Via this table you can catch how much picture you have.
Look at "PICTURE DB.mdb" a new one.

 

[a_20120]

Me. MStef

Could u plz have a look at the new attached file...it works well as think

But when u manually select a record of the list box, then the navigation not work correctly...what I want is that when u select manually a record of the list box, then the next record should be one after the selected record, and the previous one above it...

 

[MStef]

When I try it work correctly.

 

[a_20120]

plz select a row of the list box, then use the navigation button...see the result

 

[a_20120]

Plz some one help me with the above problem...

 

[MStef]

As I can see, it works well.

 

[neileg]

I can see the problem but not the answer.

If you use the mouse to select a record, it does not set PicN to the record position, so PicN stays wherever it was set to bfore the manual record selection.

 

[Oldsoftboss]

Wonder how many private messages I will get on this one while I am away over easter.

Quote (from 1 PM I got the next day) "I wait 2 hours in internet cafe and you no reply. Why not"

 

[Oldsoftboss]

Pity this guy doesn't folow the line in his tag, rather than getting everyone else to do his research.

 

[a_20120]

I can see the problem but not the answer.

If you use the mouse to select a record, it does not set PicN to the record position, so PicN stays wherever it was set to bfore the manual record selection.

after you use the mouse to select a record of list box, then if u use the navigation button u see the problem

 

[a_20120]

PROBLEM when Select List Box Records By Mouse

I think the Problem is obvious when u use mouse to select the records, then the navigation button not work correctly