Search results

Can you post your DB and I will take a look.

If your Dlookups are returning 'null' then try the following code.

Try this instead.

Ken Getz has this one covered for you. http://www.mvps.org/access/api/api0001.htm

Not sure but don't you need somewhere!

Try adding Me. If cboLocation, cboDX, cboExchange, cboReceiver exist on the main and your Dlookups are good then it should work. If not put a breakpoint at 'Me.Refresh' and hover over cboLocation, cboDX, cboExchange, cboReceiver to view the values of you Dlookups. Garry

Andrew You say that your form is base on a query :- In that query you have a field 'IsImportant (True/False)' In the criteria section of that field you add It will look at what you have set in the option group and return only the results that match. If you select 'no' in the option group...

Instead of filtering the form, Query the form. Change you query to query on the Option Group that you created. Add code to the on change event of the option group If you need more help post back and I will elaberate

You might find that certain code will not run without these references but you will only find that out when it happens. Well done.

What version of MS Access do you have installed on your machine and what what version of MS Access was your DB created with?

Once you are into you database Pree CTRL + G When the Visual Basic Form opens Click on Tools > References It will now display a list of references , one of them will say missing. Post back with the information of the missing one.

Hi Could you try this version for me with the Jpgs you are testing with. Cheers Garry

Chris From the Crash Pic that you sent I can see that it has created the first Shortcut (face-IMG_0502) so the 'thumb' folder exists. Does 'IMG_0502' exist in your Inventory folder? Garry

Hi Chris Targetpath should not be "" GetimagePathAndName should be returning the path to the second 'Back' image. Has a new folder next to 'InventoryPictures_11_Web_Version.mdb' been created called 'Thumbs' and are there any shortcuts in it? Does 'targetpath' have any value and what is it...

Chris The yellow highlighted code is on the creation of the 2nd Shortcut so 1 must have already been created. Has a new folder next to 'InventoryPictures_11_Web_Version.mdb' been created called 'Thumbs' and are there any shortcuts in it? Does 'targetpath' have any value and what is it? Garry

Chris - Stacey Ive taken Version 11 and had a play around with viewing the images on a web browser. It allows individual images to be manually rotated on the form. Its not been fully tested but let me know what you think. Garry

Cheers Chris I will have a play around with it tomorrow. Garry

G'day to you to :) Is version 10 the end of the development or are you still working towards version 11? If - when you have finished I would like to play around with loading the images with a web browser if you don't mind? Garry

Hi Chris I don’t want to step on any toes or teach granny how to suck eggs but you might be interested in a little db sample that I posted on here recently. It displays images within a web browser, the images load faster than they do in an unbound image and they also allow the original picture...

Have you tried APPLICATION.FollowHyperlink (URL), "", False