Search results

  1. Zigzag

    Use a web browser to view images

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

    DateDiff Help

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

    Unbound Form and SQL question

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

    The form comes out blank with no fields to enter data

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

    How to compact/repair an mdb?

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

    Create combo box in Form to look up values in a table

    Your welcome.
  7. Zigzag

    How to compact/repair an mdb?

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

    How to compact/repair an mdb?

    Is the database split?
  9. Zigzag

    Use a web browser to view images

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

    Use a web browser to view images

    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?
  11. Zigzag

    Create combo box in Form to look up values in a table

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

    Use a web browser to view images

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

    Use a web browser to view images

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

    Use a web browser to view images

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

    Use a web browser to view images

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

    Use a web browser to view images

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

    Use a web browser to view images

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

    Future proof A2003 app

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

    ListBox Populate Directory Based On User Input

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

    Ideas? Looking to replace values with other values

    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.
Back
Top Bottom