Search results

  1. Y

    Help with linking images

    Hi everyone, My database requires profile images and fingerprint images for the entries. Because this will bloat the database size I decided (after consultation with forum members) to link the image files to my database. After my decision however, I realized how little material there was for...
  2. Y

    Storing large amounts of pictures

    Thanks for that. I have decided on going with the linking method especially after you brought my attention to the update query method :) Does anyone know a good video tutorial or written tutorial on making a solid method for linking images ???? I looked at a couple of linking method videos...
  3. Y

    Storing large amounts of pictures

    :banghead: Hi everyone, I am currently working on a database. There are about 25,000 to 50,000 entries in this database and due to management requirements we need to store a profile picture for each of the entries :( Now obviously this presents a difficult problem due to Access's 2gb size...
  4. Y

    VBA code for exporting an Access crosstab query into an excel template

    Hey there, I think I got it working with your idea. Basically in my code in between the lines 'Do While Not rs1.EOF' and 'Loop' I removed the .range statements and instead put .Range("A23").CopyFromRecordset rs1 Many thanks to everyone for their quick and concise replies.
  5. Y

    VBA code for exporting an Access crosstab query into an excel template

    Thank you for that. As I said above, unfortunately I am a bit new to VBA. Would you or anyone else help me with the syntax for creating such a loop. As you can see from my crosstab query, I have set up the Disability Category Number as the Column count. That field has three values (1, 2, and 3)...
  6. Y

    VBA code for exporting an Access crosstab query into an excel template

    Hi everyone, Just to put things into perspective I am new to VBA. I usually learn VBA stuff from net and then customize them to my needs. Recently I tested out VBA code to automatically update an excel template because excel offers a richer set of charts and graphs. I successfully did this...
Back
Top Bottom