Search results

Well thankfully this is the only one I currently need to and likely the only one I will ever need to navigate. So if I could just suss this little problem out then I will be laughing 👍

Hi Pat, Thanks for your suggestion. I'm happy with the DB as it stands it's just this bit I really need to sort.

Okay thank you had a read of the link there certainly seems to be some disadvantages to lookup fields. So my next question is how, if I'm not too use the wizard?

Gasman, I follow now what you are saying after a think about it. I've used look up tables as I need the end user to be able to add and remove items from the combobox so unfortunately I don't think your suggestion is going to work?

Gasman, Appreciate the prompt response. Your going to have to assume your talking to a noob here and so therefore I say, you what???? Is table lookup the method used when using the Access wizard?

Hello fellow Access peep's, I have a list box on my main menu which has a query behind it showing me all leads that require a follow-up. The list box contains First name, surname, lead date & status. All but the status column are displaying correctly. The value however in the status column...

Would you look at that, worked a treat 👍 Made button and border transparent and left label behind as this gives the same appearance that I was originally looking for. Thank you for all your help

Plog, That makes sense I shall give that a go and let you know how I get on. Thank you

It's also worth noting that if you single click the FileName first then the view button it works but if you click the FileName field of a different file and then click the view button on about file it does not work!

Interesting, I have you tried opening it from within the existing/new lead forms where end users will be operating it?

CJ_London thank you. I've done my best but cant guarantee I've done it properly! @plog please find attached 👍

Apology for the delay. This the code behind the double click event on 'FileName' which as previously stated I've tried behind the click event of the 'View' label: Dim sBasePath As String Dim sBaseFileName As String sBasePath = CurrentProject.Path & "\ContactProofs\" If...

Does nothing! I'll upload them code when back home in a bit. May I ask why it is necessary for you to see the whole database?

Hi Plog, Thank you for your suggestion. I have tried your above suggestion and unfortunately copying the code for the click event on file name to the view label does not work! Regards

Hi fellow Forum'ers, I have a tabbed control containing a subform. On the 'Contact Proof' list I have a list of all the proofs attached to the record, this is a continuous subform. I have it working almost the way I want it, however, you will note from the screenshot attached that I also have...

Updated my code with your suggestions, thank you 👍

No that's my surname, my first name is David 👍

PS only when it is .HTMLBody = Msg & .HTMLBody But NOT when it is .HTMLBody = Msg I only found this out by trial and error so I can't really take credit for it!

Yes it does 👍

Just tested it, moved ahead of display and didn't pick up signature!?