Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. reycons

    Problem with Datagrid Update

    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...
  2. reycons

    Problem with Datagrid Update

    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...
  3. reycons

    Computation problem in Crystal Report

    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...
  4. reycons

    Computation problem in Crystal Report

    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...
  5. reycons

    Computation problem in Crystal Report

    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...
  6. reycons

    Computation problem in Crystal Report

    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...
  7. reycons

    Logical Error in Time

    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...
  8. reycons

    Updating a table

    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...
  9. reycons

    Updating a table

    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...
  10. reycons

    Updating a table

    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...
  11. reycons

    How to generate and use a counter or switch

    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...
  12. reycons

    Fitlering in Visual Basic Report

    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...
  13. reycons

    Problem with Schema on MySql Server

    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...
  14. reycons

    Problem with Schema on MySql Server

    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...
  15. reycons

    Matching the records

    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...
  16. reycons

    Matching the records

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

    Matching the records

    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...
  18. reycons

    Matching the records

    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...
  19. reycons

    Need a free site to download mysql

    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....
  20. reycons

    Need a free site to download mysql

    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...

Part and Inventory Search

Back
Top