Recent content by RichS

  1. R

    Importing a letterhead into an Access Report

    I have a letterhead that I wish to use in Access on a form and have the images for the header and footer as jpg files. When I import them, they always come out double the size the image is saved as, so I am assuming it is down to the dpi of the image. Can anyone advise what the default dpi is...
  2. R

    Referring to text in a table on a subform

    Thanks again for your input. After re-reading your previous post and the article you provided the link to, I understand the way to link to fields on a subform in general. I am now using: Forms![mainform name]![subform control].Form![field name] However, my subform is not based on a standard...
  3. R

    Referring to text in a table on a subform

    Thanks for your reply. The subform has a table with the fields 'Description', 'Details' and 'Cost'. I am opening a new form by double-clicking on the 'Description' field. I want to be able to display the fields related to the 'Description' field I clicked on in the pop-up form. I tried...
  4. R

    Referring to text in a table on a subform

    I have a form with a subform that has a table on it. The subform table is a price list with the fields Description, Details (which is hidden as it's too big for the table) and Price. I want to be able to double-click on a chosen item from the table to display a pop-up showing the same details...
  5. R

    Extract postcode from string - No other filtering

    UPDATE! I have sorted it by doing things the other way round... I found the second-from-last space in the whole address string and replaced it with a comma. I then used my routine to split the resulting string into lines using the commas. Thanks for your support that helped me to cure this...
  6. R

    Extract postcode from string - No other filtering

    Because of the way I am arriving at the string I need to split, I may have to approach it with a different method. Basically, the background is that the whole address is imported from another program. All the lines of the address are separated by commas, so I have code to split the address into...
  7. R

    Extract postcode from string - No other filtering

    Thanks for your reply Minty. Some of that might help but it still seems a little complicated. One thing that will hopefully help is that the postcode will ALWAYS start after the second-to-last space as the string has already been formatted by it's source. Therefore, I just need the best way to...
  8. R

    Extract postcode from string - No other filtering

    I have tried to find this on the forum but it seems all the answers are to do with manipulating the strings based on what the postcode is whereas I just want to extract the postcode as a separate string as simply as possible. Basically, I have a text field called Add5 which has the last line of...
  9. R

    Auto dismissing messages

    Thanks for you comments. The code I had in my original post was supposed to do this, with the value of the time delay included in the parameters. I was mainly curious as to why this didn't work, as it's posted as a solution on several forums.
  10. R

    Auto dismissing messages

    I wish to use message boxes that pop up when certain options are chosen, that can either be immediately cleared by clicking the 'OK' button or that disappear by themselves after a short period (10 seconds in this case). After searching the net for various options, I found the following code...
  11. R

    Custom message for when record locking is set

    Cheers for the reply Dave. Basically, the main reason I'm using record locking is that my database is used by several other people (not at the same time) but I am constantly making small improvements as it evolves for our business needs. I was finding that if somebody had entered some data...
  12. R

    Custom message for when record locking is set

    Hi, My database has been set with the 'All records' locking option set to prevent two or more people editing files at once. This is working fine but I wondered if there is a way to make a more personal message appear instead of the default Access one, just to maintain a uniform look. Thanks, Rich
  13. R

    Exiting a report when there's no data

    Not to worry... Another forum was able to help me by providing the vba code I needed and all is working fine now. Edit: Thanks for that last post. It came in just as I was typing this!
  14. R

    Exiting a report when there's no data

    That's a bit sarcastic... Yes, I have looked into it but could not find any help or advice, which is why I posted here!
  15. R

    Exiting a report when there's no data

    I'm using the 'On no data' event of the report to show the message box, but not sure what it is I should follow it with.
Back
Top Bottom