While working on an access database I discovered that it is possible for a dropdown list to contain values returned by a query. I also noticed that this is not possible for a frame with checkboxes, although i need that.
Thinking off solutions I thought it might be possible to modify the...
When calling a macro from within another macro is it possible to determine the name of the first from the second macro?
When your running macro B from macro A, is it possible to find the name of macro A?
Thanks in advance!
Jonathan
Is it possible to do something like events like in userforms when pressing a commandbutton? It would save me a lot of extra (double) coding.
I would like to use a tag from the button to specify the action taken, as I have a range of buttons whit very similar code I would like to reduce it by...
Hi,
I'm looking for an explanation, preferably with a schematic/picture of the Poole-Frenkel effect.
I specially like to know what is the difference between the Schottky and the Poole-Frenkel effect.
I hope someone can help me with finding something like that...
Kind regards,
Cactus...
I have been bashing around with Excel again and have a peculiar situation, in my opinion I'm doing everything right but still Excel makes a difference. Welle here's what I want:
I have about 150 files with data. In these files there are about 50000 samples. In this data there are peaks, I want...
Hello,
For the forensic investigation of documents a certain technique is used to make indented writing visible. To improve this process we would like to buil this in to a copier.
As you might know the copier consists of a charged ciliner coated with polymers, the photoreceptor, on which the...
Hello,
I'm trying to sort a list of data and found the following code (for a Quick Sort routine) on the devx domain (http://www.devx.com/premier/mgznarch/vbpj/2000/04apr00/cs0400/cs0400.asp) but unfortunatley it's not working in my VBA application. Can some one please help me?
At the bottom is...
I want to make an add-in for Excel and therfore like to automatically add and remove a menubar if the add-in is loaded.
Can some one tell me how to add a menubar by VBA code and how to change properties like name, assigned macro and shortcut key?
Thanks in advance!
Jonathan
I have written a program which saves information in an Excel sheet, a database. In the current version I write the information after opening the database file.
Is it possible to do this without opening the file and moving the cursor through it? I mean like just saying:
write (file, column...
