Duplicate Values (1 Viewer)

[PearlsBooks]

goodluck!

just had a p[lay for half hour and its great - thank you so much. im gonna try and understand the code one day - it kinda makes sense when i see it but i am a bunny trying to write it. anyway much appreciated. come and grab a book when youre in Cairns.

 

[arnelgp]

had to quickly google the place and wow what a nice place.
i only do virtual travel.

 

[PearlsBooks]

goodluck!

thanks - hey just one last query - is it possible to have images on that form ? the pictures for each item are stored on a different folder - imagepath, picture name . jpg. i was trying to do that with continuous forms but only 1 picture would display (seemed to be related to oncurrent condition).
Alternatively could i link to a single form which has a picture on it ?
i was just messing with your form but i couldnt seem to put a button that was visible either on the footer or under the list of items.
rob

 

[PearlsBooks]

when i mean click a link i mean click on the product and have a single form with a picture pop up.
so like if there is a match with multiple barcodes then i could see an image by clicking on the relevant item.

 

[PearlsBooks]

i was watching this thinking it might be a solution.

 

[arnelgp]

on your Table add a Field (if you don't already have) that will save the "path" of the image (for that particular record).
you add an Image Control to your form (continuous or single item).
make sure your to Set the ControlSource to the Field name above.

 

[PearlsBooks]

on your Table add a Field (if you don't already have) that will save the "path" of the image (for that particular record).
you add an Image Control to your form (continuous or single item).
make sure your to Set the ControlSource to the Field name above.

yeah i tried with the form multicode - it works from a query when the 'addstock' field is true - it lists all different items but the picture for all is the same and then on the next page the picture changes tp the picture for the next item (i attached some screenshots)

 

[arnelgp]

you should Bind your Image control (controlSource is Set to a field in your table that has the path of the image).
see this demo and see the Controlsource of the Image control in design view.

 

[PearlsBooks]

i got your form to display 2 correct images but it came up with an error message (and the 2 items listed done have the same barcode NOR is their 'addstock' field true !

 

[arnelgp]

i also encounter that error while i am in A2007.
it is better to create new db and import all your tables, forms, queries, modules, macro, etc to this new database
before the worst comes in.

you should also try a New db with sample form with images
to see if there are no error.

 

[PearlsBooks]

you should Bind your Image control (controlSource is Set to a field in your table that has the path of the image).
see this demo and see the Controlsource of the Image control in design view.

members.iinet.net.au/~unclemeat/access forum (2).accdb
i uploaded it again with your form how i changed it a bit but now it gives the error.

 

[arnelgp]

what version of access do you have?

 

[PearlsBooks]

i also encounter that error while i am in A2007.
it is better to create new db and import all your tables, forms, queries, modules, macro, etc to this new database
before the worst comes in.

 

[PearlsBooks]

so i imported everything to a new db. i also changed the 'oncurrent' to [event procedure] which has got rid of the error message but it stil only displays 1 item instead of both with the same barcode.

 

[PearlsBooks]

i kept a copy of the old samebarcode form - when i run that it still shows 2 listings (without pictures). not sure what i actualy did to change that though.

 

[arnelgp]

upload the new one. you have enought post so you can zip the db and attach it.

 

[PearlsBooks]

hope that is right.

 

[PearlsBooks]

it seems to change it when im changing the form from split to continuous. it changes from a list of the inventory to a single item with correct picture.

 

[arnelgp]

see if this continuous form will do for you (sameBarcode2)

 

[PearlsBooks]

not sure what i have done but im getting a glitch - i copied the forms/queriy to the database and they worked.
then i close and reopen and get this message when i scan a code.
so i go into the design mode, go to the [event procedure], build event, i just look at the code without editing and close then back to form and scan and it all works fine again.
close database and restart and we go back to the error.
any idea what i could have done ?