Search results for query: *

my add-in sets the application icon to an icon of my choosing when it runs, as per the following standard code. i have two questions: 1. the icon change works for the application in the top-left part of the application window and for the small window which appears when the Excel taskbar button...

i follow the advice to use the following syntax: for each obj in collection.count ... next obj rather than for i = 0 to collection.count -1 ... next i because it is said to be quicker. but if, with the first syntax, i stop code execution part-way through the loop, how can i examine which...

i have a workbook which some of my team will use. i'd like that workbook to have a button on a toolbar which runs a macro in that workbook. but i don't want the button (or the toolbar) to appear with other workbooks. i'm not familiar enough with the excel interface to know how to achieve...

i am storing some images "in" an Access database. please could you let me know whether it would be better to store them as OLE objects in the database or to store a relative path to a folder? i am vba-proficient so would probably choose the flexibility of the latter unless there is a...

please can someone remind me how to search in a query for records starting with an upper case character? thanks gusset

i have a strange problem. my code does things with various worksheets in this way: worksheets("shtOne").DoStuff worksheets("shtTwo").DoStuff i find that whatever stuff should be done to shtTwo is being done to shtOne unless i activate shtTwo first. activating it every time...

why are there two properties: .formula and .value of cell ranges? i find that i can say either... .value = "=sum(A1:A3)" or .formula = "=sum(A1:A3)" ...and the result is the same thanks gusset

we have just moved to Office XP and i notice that this version doesn't have a feature that i found very useful in previous versions. in the open file (etc) dialog box we used to be able to enter part of the file's name and retrieve a list of files matching the description - now i need to enter...

if the above error message is of interest to you, please would you check out thread222-733328 many thanks gusset

i am executing a stored procedure with this code: Set com = New ADODB.Command With com .ActiveConnection = cnn .CommandType = adCmdStoredProc .CommandText = "ex_TimeEntries" End With Set rst = New ADODB.Recordset Set rst = com.Execute and i get the message "could not...

i have been told to use ODBC instead of a dsnless connection string as it is safer. is this true? what danger is presented by using a dsnless connection string? thanks gusset

please could someone let me know the usual suspects for shutdown failure in XP? symptom is that the OS splash just hangs. many thanks gusset

just for fun, i am doing a small project which involves a game which is a bit like minesweeper. i would like to play over the internet with some friends, just like you can on msn. trouble is that i don't know anything about connecting comupters in order to send the move data - grid positions...

just for fun, i am doing a small project which involves a game which is a bit like minesweeper. i am used to using flexgrids and the like in database applicatoins but need a grid which holds icons rather than text. i am not aware that the flexgrid can hold small images such as icons. please...

is there any way to tell in what language an app was written? or does the fact that the windows api is used at a lower level mean that interfaces are identical? thanks

this is slightly above my ability. i guess there must be an elegant solution to this but i don't know what it might be and i suspect that even if i did, i wouldn't know how to implement it, so any help very gratefully received. i have, in my table, an integer field which stores a number...

here's my setup: i have a continous form and i would like to have 10 unbound checkboxes on the form for each row of data. the checkboxes are just a GUI tool and the data of a field (hidden from the user) is dependent on which boxes are checked. row 1 might have boxes 1 3 and 7 checked; row 2...

i am running xp pro on a laptop with only 6gb of disc space. it has become cluttered and so i deleted all the files i created and re-installed the OS in order to start again. however now, the add or remove programs dialog is empty, though i didn't (to my knowledge) remove any programs... and i...

some of my rows have carriage returns in them, which i'd like to get rid of. do you know how i can replace them with an empty string? thanks gusset

sometimes the EM won't let me do this, sometimes it will. Is this a but or am i overlooking something? thanks gusset