Duplicate Values

[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 ?

 

[PearlsBooks]

ignore that - it seems to have fixed itself. not even sure what i did.

 

[arnelgp]

usually this error occurs when the original forms/report where made from "another access" language other than
english. even if you copy it over to the new db it will still exists.
the only solution is to re-create the form/report using english office and delete the old form/report.

or check the VBA if you have any "missing" reference.