Recent content by TeneQuodBene

  1. T

    Bound Object Frame & Clear

    Hi, I use a bound object frame in my project and linked pictures... Whenever I create a new record the picture of the previous record is still in the bound object frame... Here's my code Private Sub Form_Current() On Error Resume Next Me!Imgwindow.Picture = Me!FotoPad.Value...
  2. T

    Wait until Call Shell is finished

    Thank u this helped me a lot Thanks
  3. T

    Wait until Call Shell is finished

    Hi I'm a Newbie, below is my code which first calls a batch file and then a filecopy of values... But I want to batch file to be ended first before the filecopy takes place... Dim stAppName As String stAppName = "d:\website\occasi~1\batch\delpics.bat" Call Shell(stAppName, 0)...
  4. T

    Cycle through all records (Newbie)

    With some try and error I managed to get this code working... Maybe some remarks.... (I'm Newbie with no knowledge of VBA) Private Sub btn_publicatie_Click() On Error GoTo Err_btn_publicatie_Click Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs =...
  5. T

    Cycle through all records (Newbie)

    Hi, I'm making a database for used cars... Example : I've got 15 records with used car information. One of the fields contains path information to a file on my harddrive with a picture of the car (eg: record1 = c:\vwgolf.jpg; record2 = d:\cars\opel.jpg; etc..). What I want to do now is...
  6. T

    Button to update all records

    Hello, I want to create u button. It's function is to filecopy a value out of a field into a specified folder and trigger a batchcommand afterwards which compresses the images so they are optimized for webpublication... Once this button is pressed it should start with the first record and end...
  7. T

    Files & Paths & Filecopy command

    Hello, I'm not so familiar with VBA but what I'm trying to do here is... : 1) I've got a database with used cars. 2) Every car has a picture (linked -> not embedded) wich is stored in a field. 3) When I select a picture and automatic filecopy is done to a subdirectory where I keep my...
  8. T

    Browse Button passing Path & Filename

    Thank U very much, this helped me a lot. TeneQuodBene
  9. T

    Browse Button passing Path & Filename

    Hi, First of all, I'm not so familiar with VBA and stuff. But I've managed to get a browse button (to select images) fully working on my form. The entire path OR only the filename are passed through a textfield (see Microsoft KB 303066). My question : Is it possible to retrieve the...
Back
Top Bottom