Search results

I have just made a couple of changes to the example. The option of viewing the images as Thmbnails or as a Filmstrip has been added.

Try this DateDiff("d",[fldReferDate],nz([fldDischargeDate]),date()) or DateDiff("d",[fldReferDate],date())

Without knowing more about what you application it is difficult to give a full answer but it sounds like a continuous form would better suit. You table should have the following fields. ID CW IW You may want to exapand the fieldnames to a more descriptive meaning. Once you have the table...

Check the data source for your form, thats usualy where the problem is.

Sorry, I don't do 2007 but I am sure it is there somewhere.

Your welcome.

Access 2003 to compact Tools > Options > General tab There is an option for 'Compact on close' Select this and click 'Apply' This option can be set with VBA if you don't want it to compact every time the db closes. Compact and repair Tools > Database Utilities > Compact and repair database.

Is the database split?

Example: An inventory database has (500 items), each item has images taken by the customer (ie the store man). There might only have 1 or it could have 5 images per item. The customer (store man) has taken these pictures and loaded them into a folder on either the local PC or a file server...

Feel free to sugest an automated way (using access) of taking an images of any size/type and resizing them so that they can be displayed quickly on a form from several shared location on a network. Out of curiosity have you actually opened the demo that I attached?

Right click on the combo box and select properties.(design view) Select the Data tab and change the 'Row Source Type' to 'Table/Query' Then click into 'Row Source' and click the three dots to the right of it. From there add the table and the field you want to use. If you are using more than 1...

Thats exactly what this application is actualy doing automatically. It creates a thumbnail of the image and then displays the thumbnail via the web browser.

I can not control what size photo/images either bmp, jpeg, jpg etc etc the customer wishes to use which is why I came up with this tecnique. The beauty of this is that the original image can be 10meg if they want to use it, the shortcut will create a nice little thumbnail for me that displays...

I might be wrong but in my experience the larger the Picture file you are using on a form the slower it takes to display. Even if your unbound image is no larger than a postage stamp it still takes the same amout of time to display as if the unbound image was full screen. Like I said I could...

dbpix is a 3rd party app. I have created apps that use the unbound method and the tecnique works well until the client / customer wants more than 1 picture per record and so you then start to introduce 2 smaller images (using the unbound method), 1 as the preview to the next image and 1 for...

Hi Simon I like the look of dbpix but thought it would be nice to show an example whithout using 3rd party software. Garry

I have been playing around with displaying images on forms by using a web browser instead of using images. As we all know embedding images into a database has a tendency to bloat the db so the usual approach is to store the path and then load the images when required (This can still be slow if a...

I have a large’ish application that is currently running in several companies without issue (Access 2003 runtime, multi-user 5 – 20 users). When I say large’ish the Fe is around 80mb but the largest BE is only 200mb after 4 years of hard use). I have watched, read and listened to the comments...

Do search on this forum for 'ListFiles' and 'FillDir' I you cant find anything then get back to me and I will search though some old sample databases.

Hi Surayo, From what I have just read it sounds as if your DB needs a little normalising. 'Acme Consulting' should not be in hundreds or thousands of records, it should be a number that links to a table ID that has 'Acme Consulting' as a supplier or consultant.