Search results

  1. Y

    Setting up network for split DB

    So how would I then go about setting up a network to deploy my DB? Thanks
  2. Y

    Setting up network for split DB

    Hi everyone, I am almost in the deployment stage of my DB. I have a split DB with a persistent connection to the BE. Now I have to set up the network to house this DB. I was thinking of setting up a server/client network where the BE will rest in the server and the FEs will be placed in...
  3. Y

    Autobackup function for Backend

    Thanks for that. I haven't come code that kicks users out before backup. Does anyone know how I can do that?
  4. Y

    Auto-numbering a field incrementally

    To be perfectly honest with I am no DB expert and just jumped into this (i.e. My first DB project). The management I am working with (don't ask why) have no idea what a DB is and what its normalization rules are. So between the two of us (i.e me and management) we have created a DB that will...
  5. Y

    Auto-numbering a field incrementally

    I am doubting whether what I am about to propose is even possible but here goes nothing. I have a DB that records applications from all across the country. These are registered with the ID number (autonumber) but management have also come up with strange resolution. They want to number the...
  6. Y

    Autobackup function for Backend

    Thanks you for that, I will give that a try to see how I go
  7. Y

    Autobackup function for Backend

    Hey guys, So this is the scenario I find myself in. A split database. I would like to make autobackups of our Backend (BE) everyday at 4pm local time?? Since I didn't know how to do that I settled for another option. I already have a function to make backups so I thought maybe I run this...
  8. Y

    Dbl Click function to select file path and then save that path in another field

    Hi sorry for not providing an update as I didn't think anyone was following this thread. I managed to get it to work by removing the loop and uncommenting the following: 'varfile = .selecteditems(1) 'txtSelectedPath = varFile Rest of the code remained the same. For some reason it...
  9. Y

    Dbl Click function to select file path and then save that path in another field

    Ok so I have managed to get there (well I am close) I used following code to save the imagepath in txtImagePath which is linked to the imagepath field in my table. Private Sub ImageFrame_DblClick(Cancel As Integer) On Error GoTo SubError 'Add MS Office 14.0 Object Library in references...
  10. Y

    Dbl Click function to select file path and then save that path in another field

    Another sample that could possibly be tampered with to achieve the above object is below: Public Function GetFileFolder(strType As String, strTitle As String) As String Dim fDialog As office.FileDialog Dim varFile As Variant Dim typeOfPicker As Integer Select Case strType...
  11. Y

    Dbl Click function to select file path and then save that path in another field

    Hi everyone I do apologize for asking too many questions over the last few days but I am almost in the final stages of my program and navigating unchartered territory :D Basically I have set up a simple function for displaying images. I have stored the imagepath in a text field and then used...
  12. Y

    Storing large amounts of pictures

    Wow that's a huge difference between bmp and the other two. Guess will just have to stick to jpg then ;)
  13. Y

    Storing large amounts of pictures

    Oh really. I thought it way the other way around. Access always seems to suggest to use bitmap formats. Also a saw an article that argued that bitmap and DIB (I think it was called) had the smallest footprint since they were windows own versions or something. Guess I will change them back...
  14. Y

    Storing large amounts of pictures

    Yes I decided to use the Image Control and it works perfect. At the moment my Image path is: \\server\foldername\imagename.bmp I am currently using the entries ID number as the image name. For example in the first entry the path is something like: D:\DB Folder\Images\1.bmp I was thinking of...
  15. Y

    Storing large amounts of pictures

    Thanks for that. Our current deployment does utilize the attachment field but unfortunately as the record/entries are quite large (25,000 to 50,000 entries) this made the DB large and cumbersome. Hence my search into the image linkage method.
  16. Y

    Storing large amounts of pictures

    Hi everyone, First of all thank you Simon for providing that info in SQL and the differential image function code. I was thinking about what DOCMAN said regarding having two separate fields for the image display. One containing the folder path and the other for individual images. I think that...
  17. Y

    Storing large amounts of pictures

    Actually as you suggested, I am considering upgrading to a SQL backend database sometime in the future but I don't want to rush into given my limited DB experience. A couple of questions. Can I make an SQL local server (not connected to the internet) ? What would be the advantage of such a...
  18. Y

    Storing large amounts of pictures

    Hi DocMan, Thanks for your post offering very enlightening and 'out of the box' method. Yes I am in the near final stages of my database development and did intend to depoy the split model. As this is my first database development project some of the advice you gave was a bit puzzling :) but...
  19. Y

    Help with linking images

    I gave that one a try as well but unfortunately no success :confused: In the report view the image control remains blank and when I try to go to the print preview, it gives me a generic error message :( What could I be doing wrong?
  20. Y

    Help with linking images

    Thanks for that. Will give this set up a try.
Back
Top Bottom