Recent content by MrM121

xlbo, Your's is a fantastic solution as well - I am torn between which one to use. Thank you. PS - I just need to find a way to programatically add buttons at runtime on a spreadsheet now. Cheers

byundt, Thank you very much - it worked like a dream - I can't believe I didn't think of trying it to be honest - I feel a bit silly now. Once again, thank you. Nick Meacoe

Hi Everyone, Got a bit of a problem and I have been racking my brains out over it! Essentially the problem is this: I want to be able to create validation drop-down boxes dynamically, say for instance, when a commandbutton is pressed. Code is: With Range("E2").Validation .Add...

Please, can anyone help with this? Can anyone suggest a control to be used, and preferably explaining basically how to use it? Thank you, Nick

Is it possible to edit things in a web browser control? That was something I considered, but was unsure. Nick

Something like the design view mode of MS Frontpage would be ideal, I think. Nick

Hi everyone, This is a related question to one I proposed last week. This time, I need to ask if anyone knows of a suitable container/control which will allow me to save both text and graphics. I know that a Rich Text Format control will do it, but that saves it in RTF format, which, with...

Cheers for that, I'll give it a crack and see what I come up with. That code seems fine, but I was just hoping that Access wouldn't try and be so 'clever'. Nick

Thank you, I still don't really know how to correct the problem, without creating a custom control/ validation routine. I don't know what I was thinking about with January instead of December - my bad. Nick

Here's an interesting question. I have set up a date field (ordinary, bog standard date) and used the format dd/mm/yy to store it. Here is the problem. A normal date, say 12 January, 2004, would be entered as such 12/12/04 - fair enough. However, lets say when the user is typing in the...

That's just it, I don't want them to have to open up any dialog file, as that means having to save the image. What I want them to do is to simply be able to hit the print screen button, and paste the image - it is for non-technical users as much as myself. Nick

As I said, I really didn't know what I was doing with the Word Oject library, and so I didn't really go into it too deeply. I am not sure how to then save the data as HTML code, or whatever to preserve the formatting, and I have no idea how to then pluck the images and save them as files in a...

Harleyquinn, I was thinking the exact same thing last night, and I even tried playing around with the Microsoft Word control last night. I don't really know how to use it properly though, and I could only edit the document when double-clicking, which isn't too much of a problem. The main...

You see, that is what I was thinking, but my problem is that the users, not just myself, will also need to be able to create/append records, hence the reason I would have liked for them to be able to type in themselves, and paste images into the file. Basically, what would be good is if it...

I think that storing the images seperately on the file server is the way to go, but the problem is now the generation of the HTML code, and what to put the output into, as I want it to be within the program. Then, on top of that, I want the user to just see a nice HTML format kind of...