Hi All. I have a User form in Excell VBA. It have many control such as textbox, check, combobox..... And I want to use tab to change from this control to another control in the form. I have done -set Tabstop of all the control to true - Set tabindex for all control in the right order. But I can't swich between control. Please help

I have tried your suggestion but I fail. Do you have any OTT application such as Viber, Whatsapp, line...... We can contact easier. Thank for your help.

Do you have skype. I want to contact with you for detail solution.

I have tried. If no selected (user does not do anything with the combobox) selected.index=0 the same when user select the first row. I use Visual Studio 2013 and populate combobox from database using datatable like this

Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
Dim myDataSet As DataSet = New DataSet()
myDA.Fill(myDataSet, "MyTable")
Cbx_PhoneType.DataSource = myDataSet.Tables("MyTable").DefaultView
Cbx_PhoneType.ValueMember = "ID"
Cbx_PhoneType.DisplayMember = "Model Name"
cmd.Dispose()
con.Close()

The combobox I populated from DB. WHen I add, update DB, this combobox is one field but if user doesn't select anything. The insert/update sql will not correct. So how to detect this situation then warning the user.

Hi ALl. I populated combobox from DB. And now when user select the value, how can i get the ID back.Because the selectedindex id diffirent from the original ID. Thanks.

Hi All. I Create a window form in which it have 4 tab. Each time User click on a tab. I show some control in the form. Which event is raise when user change the tab. Thanks.

I Use Android Studio to write my application using telephonymanager . The manifest is here.

I have remember to add permission. And The Main Activity Java code is here package com.example.myapplication; import android.content.Context; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.telephony.TelephonyManager; import android.widget.TextView; public class MainActivity extends AppCompatActivity { TextView tv; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); tv=(TextView)findViewById(R.id.tv); TelephonyManager TM =(TelephonyManager)getSystemService(Context.TELEPHONY_SERVICE); String IMEI= TM.getDeviceId(); String SubcriberNumber = TM.getLine1Number(); String ISO = TM.getSimCountryIso(); String Operator = TM.getNetworkOperator(); String SimoperatorName = TM.getSimOperatorName(); int Phone=TM.getPhoneType(); String StrPhoneType; switch (Phone) { case (TelephonyManager.PHONE_TYPE_CDMA): StrPhoneType ="CDMA Phone"; break; cas

Thanks. I have modify it. But the problem the same. Run-Time error '-2147467259 (80004005': [Microsoft][ODBC Driver manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. And warning Microsoft ODBC for Oracle. The Oracle (tm) client and networking componets were not found. These components are supplied by Oracle......

Hi All. I Want to use VBA code to get data from Oracle DB The code is here but I fail

Const IPServer = "123.168.YY.XXX" ' Server hosting the Oracle db
Const DBNAME = "NMS" '"DatabaseName"
Const ORACLE_USER_NAME$ = "user"
Const ORACLE_PASSWORD$ = "pass"
Const port = "1521"
Sub ConnectTOOracle()

Dim oRs As ADODB.Recordset
Dim oCon As ADODB.Connection
Set oCon = New ADODB.Connection

Dim mtxData As Variant
Dim strConOracle As String

strConOracle = "Driver={Microsoft ODBC for Oracle}; CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) "
strConOracle = strConOracle & "(HOST=" & IPServer & ")(PORT=port))(CONNECT\_DATA=(SERVICE\_NAME=" & DBNAME
strConOracle = strConOracle & "))); uid=" & ORACLE\_USER\_NAME & " ;pwd=" & ORACLE\_PASSWORD & ";"




oCon.Open strConOracle



'Cleanup in the end
Set oRs = Nothing
Set oConOracle = Nothing

End Sub

Please help.

I Mean I Want to update Oracle DB through SQL Server Management Studio via Link Server.

I also want to create a new table in oracle DB through SQL Server such as. Select * from SQL Server into OracleLinkDB.

Hi All. I Have a SQL Server.This server have link server to Oracle DB. I can select anything from oracle DB through this SQL server such as. Select * from [ORacleDBName]..[SIDName].[OracleTable] But now I don't know how to update oracle db from SQL. Pleas help me.

HI all.I am new beginer to android.I Want to write an android app. WHat do I Need now.I Have read some books but may be it is out of date so I ask here. First I need to install Java JDK to my PC. Second I need Android Studio. Is that all now??? THanks.

The Data like that of course there is more ID ID1,14/04/2016, 5 ID1,13/04/2016, 2 ID1,11/04/2016, 1 ID1,10/04/2016, 4 ID1,08/04/2016, 7 So the Result like that. ID1, 14/04, 19 (19=5+2+1+4+7) ID1, 13/04, 14 (2+1+4+7) ID1, 11/04, 12 (1+4+7) ID1, 10/04, 11 (4+7) ID1, 08/04, 7

Hi All. I have a table in Microsoft SQL Database like that. date,UserID,number_of_product, number_of_sale Every day User sale number of product. Now I Want to count consecutive for each user, each product, and each day the total number of sale in number of day (for example 7 days) Thanks

Hi All. I Have a Parent Gridview like a gara.And child gridview like a car in the garage.I Can expand and collap the parent gridview (Gara) to see the child gridview (the car in side) but some gara doesn't have anycar at all. How to add an images to show that this gara doesn't have any car instead of expand it to see nothing.

Original type of field in Oracle Database is date.Now I select this and insert to SQL server.Then show in gridview. The question is How to get exactly data from oracle database link? And How to show exactly data to the user?

Hi All. Firstly.I use Database link from my SQL to Oracle to get Data.In The Oracle the field sta_datetime is date type. Now I use convert(varchar(10),sta_datetime,111) as Sdate, convert(time,sta_datetime) as S_Time, To get data to Sdate field date type and S_Time field is time(0)type. Now I show them in the gridview and then get them back when user lick on the row to show on another child gridview. So many convert time.So it is so difficult to get them back.

I Mean JS on the page, not in a separate file. The js is only use in Content Page.I Know I have to put it on the content page.But I don't know where to put it. I am a beginner.