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 =...
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
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...
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
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...
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
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
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...
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)...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.