reconnect mean attach your code. :icon_wink:

Your welcome.

you must reconnect it. attach your sample. i will edit it.

yes.
SUM is a sql function. you must use '(' & ')' for it.

change your code in this way:
"select sum([exam fee]) as total , sum([other fee]) as total_fee from table1"

Standard Solution:


Dim objFrm As Form
For Each objFrm In Forms
If Not (TypeOf objFrm Is MDIForm) Then
Unload objFrm
End If
Next

NOTE:
sum[exam fee] ==> sum([exam fee])

aren't there anybody can help ?

Hi my friends.

I write a program that show sended and recieved bytes in dialup connection.
i use below api function's for get Sended and Recieved bytes:
RasGetConnectionStatistics...

There is a way :

first False Checked property.
Use checkbox picture instead of node's icon ;
when user click on nodes , change node icon , and set it's icon to checked picture and ....

you can't do this.

See this sample :

See this sample

See this sample:

below code Return Active control name in "Form1" :

Form1.ActiveControl.Name

use this:

Ubound(Arr) - Lbound(arr)

you can also use this activex. (it's better than vb listbox)

Download (http://soda.parsaspace.com/MBT925/ActiveX/MBCheckList%201.0.0Sample.rar)

Hi my friend's.

I have a usercontrol and a ScrollBar in it.
this usercontrol can contained other controls.

when i put a control in it , this new control place at front of the scrollbar.
...

see this sample:

see this:

Create a value at this path in Registery:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run

and put your app's path in it.

SELECT * FROM Table1 WHERE Code='" & Text1.Text & "'"

I test it.
it's correct.

Use this solution:



IIf( hex(num) > 1, hex(num) , "0" & hex(num))

use this metod instead Update

UpdateBatch adAffectCurrent

see this:

program dont have any problem .
i dont know what is your problem.

or you mean run from usb?

you can't get data directly from datagrid.
you must get row number from datagrid and move in adodc then show record in textbox.

18.OsenButton

a good button

ScreenShot (http://mbt925.persiangig.com/ActiveX/Other/OsenBScrSho.png)

Download (http://soda.parsaspace.com/MBT925/ActiveX/OsenButton.rar)

19.CalculatorCombo

see this:

I Remove all it's activex unless SMButton.ocx
already must run correctly.

download this

yes , it need 3 ocx file that you can find it in "Need" Folder.



yes.


i donwload it again , it's complete.

you must register it on your pc first.

16.Color Picker

ScreenShot:
http://soda.parsaspace.com/MBT925/ActiveX/ColorPickerScrShot.png

17.EasyGrid

A good grid. test it.

you can get it from below link:

test this simple player:

I upload this ocx for you.
hope it help...

you can download it first , then show it.

you must get it's extension (.xls) and check it with ".xls" str , or each reserved format.

it's created by simple color gradiant.

sample for creating gradiant color attached.