Search:

the Set col = Nothing does release the memory, but when we use the reference again (passing it to ObjPtr) it gets re-instantiated - hence the memory address is different.

i.e. compare it to
Dim...

Mentioning this ties everything together very nicely.

When you unload a named form (ie not instantiated with Set F = New Form1) a reference still exists to the object and as such the memory is not...

I would recommend using the MakeSureDirectoryPathExists API. It doesn't throw errors if the folder exists and will create any subdirectories that need creating too:
Private Declare Function...

wrap command line arguments with spaces in them in quotes, e.g.:
Shell "program.exe ""C:\Test Folder\File.ext"""

Dim isn't a Type, it tells to VB to dimension a variable as a particular type, e.g. for a string:
Dim MyVariable As Stringsince you've been omitting a Type in your declarations VB has been declaring...

if you want to click a button you can just do:
' on Form1
Private Sub Command1_Click()
Form2.Command1.Value = True
End Subhowever, I would recommend doing something like:
' On Form1
Private...

based on this code, click down on the attached form and drag the mouse over the button to generate VB code that'll find the hWnd - you can then just add your up/down bit

The code i posted should (and does) work - is the error definitely occuring on that line? What version of VB are you using?

Regarding using Trim - using implicit coercion as I did ("Text" & 1) is...

Even if redistribution isn't an issue, you shouldn't use the Forms 2.0 object library - it's unstable in the VB6 environment with a tendency for "out of memory" errors - MS advise against its use.

Are you doing this in VB6 or VBA?

@George1111: did you see post #3? it does what you want (the same as gremmy's code) in three lines...

For I = 1 to 20
Me.Controls("Text" & I).Text = rstRecordset.Fields(I)
Next I

set the ComboBox's style to 2 - DropDown List

I used a string in my example.

he was quoting me, and i demonstrated it in my post, also check out ChaosTheEternal's post


@ChaosTheEternal: nice link! :thumb:

True, but you can dynamically load and call procedures within DLLs.

Use LoadLibrary to load the dll, GetProcAddress to get the address of the function, and, at it's most simple use CallWindowProc...

strange, I get a value :ehh:

something like this perhaps:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, ByVal lpWindowName As String) As Long

Private Declare...

GetWindowThreadProcessId

umm, am I missing something?

Private Sub Form_Load()
Text1.MaxLength = 255
Text1.Text = vbNullString
End Sub

Private Sub Text1_Change()
Label1.Caption = "Characters Remaining: "...

AllAPI.net is now http://allapi.mentalis.org/

see this thread @ VBF for more info

SetWindowPos allows you to set relative z-order position also:
Private Declare Function SetWindowPos Lib "user32" ( _
ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, _
...

you need to wrap the opening and closing of the form in a Public function within it.

e.g. in Form1, I have:
Private lRet As Long

Public Function ShowForm() As Long
Me.Show vbModal
...

and here's another hacked version, using API Timers (which does return 1, 2 or 3)

edit: but I would whole heartedly recommend making your own custom form.

well, each character of a string is two bytes, not one - so the string has to be half the size of the byte array. You also need to pass the memory location of the String's byte array, rather than the...

if you're attempting to use the ToolTipText to show the full text of items wider than the dropdown, then I would recommend using CB_SETDROPPEDWIDTH to change the width of the dropdown instead:...