Search results

i am having problems with exporting a report as a pdf as the hyperlink to each inventory item is not coming through on the export (works fine on print preview / report). i can get it to export if i include a static link in the hyperlink field however the address changes with each stock item. i...

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

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...

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.

hope that is right.

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.

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.

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.

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 !

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)

i was watching this thinking it might be a solution.

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.

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...

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. :)

thank you - that opens. bedtime here but ill check on it in the morning. much appreciated it looks like it works fine.

il'll do the form thing. sorry tpo sound ignorant but i dont knoiw what the ribbon option on macros is.

this wont open for me - it says unrecognised database format ??

yeah i dont know - sometimes i copy a form to do changes in case it doesnt work out and then i either forget to delete the original or the new failed one (often takes so long to get it right ive forgotten which one im meant to be deleting)

i just checked the primary key and you are right - all records have a unique autonumber but its not allocated a primary key. would that help ?