Search results for query: *

Private Sub frmGridFinal_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing Dim cb As New OleDbCommandBuilder(data_adapter) If m_DataSet.HasChanges() Then Dim data_adapter As OleDbDataAdapter...

Imports System.Data.OleDb Imports System.Data.OleDb.OleDbDataAdapter Public Class frmGrid Private Const SELECT_STRING As String = "SELECT * FROM departmentprofile" Private Const CONNECT_STRING As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and...

flemard (TechnicalUser) 8 Dec 08 22:50 This may help you get started: Open the Field Explorer Create a new Running Total field: VL TOT with the following parameters: Field to Summarize = # of Hours Evaluate Beside "Use a formula" click in the X-2 and enter: if {Remarks}="VL" then true Click...

Thanks for your help. I already solve the problem but there's another problem that arise. Let me show you now the format of my report and the problem that arises. Name of Employee: Mark Cuevaz Indate Timein Outdate Timeout # of Hours Remarks 09/16/08 8:00 AM 09/16/08 6:00...

I tried exploring the Running total. But could you give me some sort of simple coding which shows the comptation. I find it difficult to get the answer. I used the formula in the running total. numbervar totalvl; whileprintingrecords ; totalvl := 0; if {TempDTR_Total.Remarks} ="VL" then...

Indate Timein Outdate Timeout # of Hours Remarks 09/16/08 8:00 AM 09/16/08 6:00 8 VL 09/17/08 8:00 AM 09/17/08 6:00 8 VL 09/18/08 8:15 AM 09/17/08 6:05 8 --------------------------------------------------------- Total no...

Dim li As ListItem Dim LV As ListView Dim rs As Recordset Dim rsfullLogs As Recordset Dim cn As New Connection Dim dlogindate, dLogOut, t_AmTimeIn, t_AmTimeOut, t_PMTimeIn, t_PmTimeOut, t_AmtimeIn2, t_AmTimeOut2, t_PmTimeOut2, t_PmTimeIn2 As Date Set rs = New...

Dim objconnection As New ADODB.Connection Dim objcommand As New ADODB.Command Dim cn2 As String Dim cSQL As String objconnection.Open cn objcommand.CommandType = adCmdText...

cn.connectionstring = "Provider=MSDASQL.1;" & "Persist Security Info = False;" & "Data Source=Timekeeper;" cn.Open rsview.Open "SELECT DTR.PK, DTR.EmpPK, DTR.LoginDate, EmployeeSchedule.starttime, DTR.AMTIMEIN, DTR.PMTIMEIN, UTOS.fromdate...

Table 1 EmpID Logindate Undertime_From UnderTime_To 1 8/27/08 8:00 AM 10:00 AM 2 8/28/08 10:00 AM 12:00 PM Table2 EmpId Logindate Undertime_From Undertime_From 1 8/27/08 2 8/28/08 Good day. I cant update table 2. The record should update in table2 that matches all the empid and...

Table 1 EmpID Logindate Undertime_From UnderTime_To 1 8/27/08 8:00 AM 10:00 AM 2 8/28/08 10:00 AM 12:00 PM Table2 EmpId Logindate Undertime_From Undertime_To 1 8/27/08 2 8/28/08 Hi... Good day.. I have two tables. The concept is this, there will be an SQL code where would...

I have a textboxt and which I input the lastname of a particular person like for example Cortez so all the record that has a lastname of cortez thats only it shows in the table Can anyone give me a sample code in visual basic that filter the records in the table and that record that it filter...

I copied the schema name geneticdatabase in c:\AppServ\MySQL\data\geneticdatabase from one PC and paste to another PC in c:\AppServ\MySQL\, when I open the schema in the MySQL Server and the table named class_setup, the fields cannot be loaded and I've got an error message saying: SELECT...

I copied the schema name geneticdatabase in c:\AppServ\MySQL\data\geneticdatabase from one PC and paste to another PC in c:\AppServ\MySQL\, when I open the schema in the MySQL Server and the table named class_setup, the fields cannot be loaded and I've got an error message saying: SELECT...

Well... Thanks guys for your assistance I think that help surely guide me in searching a record.. the logical problem is only a slight problem in vb.net... Thanks to: assimang (Programmer) gmmastros (Programmer) jebenson (TechnicalUser) earthandfire (Programmer) Thanks to you guys... I've...

Sorry... The Messagebox User found is working. The only problem is the Else statement because the User not found mesagebos does not display...

Public Class LOGIN Dim conn As MySqlConnection Private Sub cmdLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdLogin.Click 'Setting of Variables... Dim LoginCmd As MySqlCommand Dim SqlLogin As String Dim LoginRdr As...

Option Explicit On Imports MySql.Data.MySqlClient Public Class LOGIN Dim conn As MySqlConnection Private Sub cmdLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdLogin.Click 'Setting of Variables... Dim mycommand As MySqlCommand conn = New MySqlConnection...

Thanks to ingresman (IS/IT--Management)-------------- I can now save data using MySQL Server.. I browse the site he gaves me and I use it as the connection string that has been there and its working.. Thanks.... Thanks also to vacunita (Programmer)...... Thanks a lot....

1st Yup I already downloaded MySQL Server in my computer. The MySQL already working. I can create now a database in MySQl Server. I already downloaded a connector which is the MySQl Connector/ODBC 3.51 The only problem now is the procedure on how to connect MySQl Server to my VB...