Search results

  1. L

    Lock an object after update

    Hi I have setup bound objects on a form which I will be linking files from server. After I have inserted the files I want them to be locked so nobody can change them. I have tried various bits of code in "after update" but I keep getting errors. Can anybody help? Thanks
  2. L

    Update Notes with datetime stamp using memo fields

    Hi, I have a form with a section for notes that I want to keep a diary of. One text box is used to enter the new notes and the other is used to store historical notes. To update the historical notes, I want to use a command button to update with everything in the new notes + a datetime stamp so...
  3. L

    Insert PDF on to Form

    Hi I have a 3 queries that I need help with: 1. I would like to be able to insert PDF forms in to a tab on a form as an icon. What I had in mind was a command button which would call up explorer so that I could select a file to insert as an embedded icon in the tab. I would also like to be...
  4. L

    Export table to fixed width text file

    I am trying to export a text file to be imported in to excel but whenever I export as fixed width all by number columns get cut to 2 decimal places, does anybody know how to get around this? Thanks
  5. L

    Open form with filter

    I have a simple bit of code below but I need something added. All the code is doing is opening a form and filtering on a combo box value. It opens all cases where the status is open but if there are no open cases it takes me to a new record, how do I get my code to recognise that there are no...
  6. L

    Display Date on form 6 months ago

    If I key in to the control source of a text box "=Date()-184" I will get the date 6 months ago but if I tried the same of 06/10/05 I will lose a day because of the 30/31 day months. Does anybody know another way around this?
Back
Top Bottom