Search results for query: *

well after wasting most of yesterday on this... the penny finally dropped today! The dynamically added ws + controls are arranged with the main data ws (so I had a workbook.xlsm:1 and workbook.xlsm:2 window configuration), and it was that which was causing the problems! If you click a...

Ok, code adds togglebutton (Forms.ToggleButton.1) and event to Excel worksheet - code was working fine, no problems... and then for some reason I can't fathom... the toggle button will no longer respond. It's not locked, it's enabled - so should be able to press/depress it with a mouse click...

[orginally posted in "other access" by mistake - sorry) hi have a series of dbs containing sport results and details that I've been collecting for many years now - getting on for close on 900,000 in total. The data is a mess at the moment, some of it in .txt files, some on spreadsheets, some...

hi have a series of dbs containing sport results and details that I've been collecting for many years now - getting on for close on 900,000 in total. The data is a mess at the moment, some of it in .txt files, some on spreadsheets, some in tables - plan to bring it all together and tidy it up...

Hi macro-enabled sp which is built through vb/ie7 calling web queries. After the data has been pulled, all querytables are deleted. Despite the above, the sp takes an age to open and is currently running at 409k in memory. Anything else that should be deleted in addition to the queryTables...

following on from thread707-1462259 I was having the same problem - as it's random it's hard to be sure this fixed it, but since I changed the refreshStyle property I haven't had any problems. .RefreshStyle = xlInsertDeleteCells when I was having errors it was set to .RefreshStyle =...

I've already written the CF in vba - what I'm trying to do now is to READ the colour that's been applied to cells.

hi, what i need to do is to "read" the color of a cell that's been formatted with a conditional format. As you know, activecell.interior.colorindex returns the NON conditional formatted colour. All the solutions I've seen involve checking for the format conditions again and deducing the...

hi - ok, not a hacking query although I admit it sounds like it. Seem to recall an API that would allow you to pull HD location of file from FAT. Anyone know the api that will do this in NTFS/XP? Also, api that used allow me to write directly to HD in 98x days - anything similar in XP? ta

ok ... well seemed to come up with a sort of fix of sorts ActivePresentation.Slides(1).Shapes("Image1").Visible = msoFalse Although why I can't just say image1.visible = false when I can set so many other properties this way is beyond me. ah well.

Hi PPT presentation contaning one label and one image control. Both of these were added via the Control Toolbox. following code behind click event of label: image1.visible = false Now this is where the fun and games begins :-) this code is def. being executed but the image doesn't disappear...

go to http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=436&lngWId=10 sample code you can download

Dear Scking yesss... I know that, but the users (bless em) find that having to position AND click the mouse (twice!) is just too much of an effort. so - are you saying that if I alter some flags for Explorer they will be picked up by the common dialog control? No prizes for guessing the...

Hello using standard windows api file Open Dialog (ahtCommonFileOpenSave) to select file. Is there anyway to switch the view of files to "Details" and to sort in descending order on "Modified"? I guess there must be some flag somewhere but I can't seem to track it down...

Hello Have form with bound ole object. I need the user to be able to take screen dumps (via printScreen key) and then paste them into the bound ole object control on the form. I've played with clip/stretch/zoom but the quality is yuk. what I want to try and avoid is having to first save the...

Hi I'm using dreamweaver and I'm trying to replicate the effect of the code shown below - that is to dynamically update the contents of a table cell when a user clicks, mouseover etc. The problem with the code below is that it doesn't work under Netscape. Presumably DreamWeaver has it's own...

Hello vb front end on access db - have approx 4000 records (a record is approx 255 chars) to be fed from vb to access. Don't really want to do this with addnew and update statements due to speed. Any suggestions - the faster the better :-) thanks

Hi Think of a vb.net form as a child from in VB6 and that should give you some idea of whats going on. getimran is correct when he mentions classes/objects - and that's exactly what you were doing with child forms in vb6. The child form in the project explorer window needed to be instanced...

Ok here goes my two cents.... I agree with the comments about horses for courses but even so.... rob - have you even used vb.net? You might just be surprised - it is far superior to vb6 and if you think that Microsoft will continue to support your classic vb in the future I think you're...

Hi you could use SendKeys to simulate the PrintScreen key and then, when the picture is on the clipboard copy/save from there. Not sure about how you'd crop just a part though cos depending on resolution you wouldn't know the area would you? Kate