Recent content by RichS

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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

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!

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!

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.