Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wekkew
  • Content: Threads
  • Order by date
  1. wekkew

    Dynamically added control Excel sheet suddenly freezing/unresponsive and can't view properties.

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

    hardware and/or software spec

    [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...
  3. wekkew

    hardware spec for large DB

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

    excel 2007 - web queries - bloated file size & memory

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

    Excel Web Query #1004

    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 =...
  6. wekkew

    retrieve color conditional format cell - excel 2007

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

    read FAT/NTFS, write directly to hard disk

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

    powerpoint image (not shope) visible query

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

    FileOpenDialog flags

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

    pasting clipboard picture into OLE object on form

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

    dynamically change text in table cell

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

    adding records - speed issue

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

    any way to run vs.net on win98

    Hello I know the official os for .NET is win2k but is there any way it (or vb.net) will run on win98? thanks
  14. wekkew

    re: procedure argments - setting referenc/pointer

    Hello such a simple problem but it's driving me mad. Code is below, just need to set up pointer (gimme C...) to variable c passed into proc and then use than pointer (var2) to updated value. Have tried declaring things as objects, integer, using set, not using set, byref, not byref etc etc...
  15. wekkew

    MCT daily rates

    Hi anybody like to provide DAILY rates (please state currency) for following MOC courses delivered by experienced MCT: Visual Basic desktop/distrubuted C++ SQL ASP (not that I'm after a pay rise or anything....) thanks Kate
  16. wekkew

    Any details on the "new" MCSD

    Hi app Misrosoft are due to release a new premier qual to sit alongside the MCSD. The new qual will be aimed at programmers - but with the core exams for MCSD consisting of VB/C++/FoxPro isn't it already aimed at programmers? Kate
  17. wekkew

    Sometimes you just have to smile...

    Hello colleagues running win2kprof - asked to help with problem of shared folder with one user unable to see files from other user. It turned out that user1 was in My Network Places | Computers near me and was puzzled at not being able to see the files on users2 machine, as "both...
  18. wekkew

    DynamicArray vs LinkedList

    Hello I've been away from C++ for many years now, but when I did work with C++ (prior to STL) I always believed that arrays were bad and linked lists were so GOOD. Now that the STL offers dynamic resizing of arrays, what's best for the following situation: A collection of records (objects)...
  19. wekkew

    Word 2k - truncate FILENAME field code

    Hi Am trying to return the first seven chars of filename as returned by the field code. I did try using the left function as shown below: {LEFT({FILENAME \* MERGEFORMAT},7} but no luck Any ideas? Kate
  20. wekkew

    shareware db to read paradox db files?

    Hi Have information held in series of paradox db files which I *urgently* need to read the structure of, but no copy of paradox. I know I can import *.db files into Access but I need to see the whole structure (keys, relationships etc) of the entire db. Anyone know of any shareware; other...

Part and Inventory Search

Back
Top