User Profile

Collapse

Profile Sidebar

Collapse
kazper
kazper
Last Activity: Jan 14 '08, 02:19 AM
Joined: Jan 26 '07
Location: Philippines
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kazper
    started a topic Help in puting numbers for each items on the group
    in Visual Basic

    Help in puting numbers for each items on the group

    Good day to all,

    I would like to ask for your expertise regarding putting numbers for each item for each group on my report (Visual Basic 6)

    Example of report

    Code:
    [B]HR Department [/B] 
[B]No.  EmployeeID    EmployeeName[/B]
[B]1[/B]    2006060621    DelaCruz, Juan        
[B]2[/B]    2006060601    Dantay, Jessie         

[B]Accounting[/B]
[B]No.  EmployeeID    EmployeeName[/B]
[B]1[/B]    2007060621    Orbita,
    ...
    See more | Go to post
    Last edited by Killer42; Jan 15 '08, 09:31 AM. Reason: Used CODE tag to preserve columns
    • kazper
      started a topic Extract datas
      in SQL Server

      Extract datas

      Good day,

      I'm trying to extract some data from our database. I just need to get the list of persons that will be having 5 or 10 months on their contract this coming month.


      Thanks in advance.
      See more | Go to post
      • kazper
        replied to I want to learn VB6
        in Visual Basic
        or..

        you can stay here :D hehe.. you can get some good codes from people around here that are willing to help.
        See more | Go to post

          Leave a comment:

        • kazper
          started a topic Need help fast
          in SQL Server

          Need help fast

          One or more files listed in the statement could not be found or could not be initialized. (Microsoft SQL Server, Error: 5009)
          I keep on getting the same error when I try to Remove the new log file that I accidentaly created on Drive E:
          Is there any way that I can delete this log file?

          Thanks in Advance.
          See more | Go to post
          • kazper
            started a topic microsoft SQL Server, Error: 500
            in SQL Server

            microsoft SQL Server, Error: 500

            One or more files listed in the statement could not be found or could not be initialized.

            I was trying to remove one of my test log files. But every time I try to remove it this error keeps on showing up.. Can someone please help me regarding this problem.

            Thanks in Advance.
            See more | Go to post
            • kazper
              replied to Run-time error '-2147217900 (80040e14)'
              in Visual Basic
              I think I have solved my problem ^_^

              I just have to modify the command of the hierarchicy of the data report.

              [CODE=vb]Option Explicit

              Const preSHAPE = "SHAPE {"
              Const SQL = "SELECT dbo.ReceivingHe ader.RRNo, dbo.ReceivingHi story.DateRecei ved, dbo.ReceivingHi story.ReceivedF rom, dbo.ReceivingHi story.Address, dbo.ReceivingHi story.Receiving Type, dbo.ReceivingHi story.Amount, dbo.ReceivingHi story.ItemType...
              See more | Go to post

                Leave a comment:

              • kazper
                replied to Run-time error '-2147217900 (80040e14)'
                in Visual Basic
                I have tried removing the quotes around the ItemType, it still doesnt work.

                Try using the codes that I have provided above using 1 form, 1 command button, 1 data report.

                remove the Report header of the data report, add a group header and footer. at the group header add a rptLabel and a rptText.

                on the details section add 2 rptLabel and 2 rptText.

                just change the path of the database for...
                See more | Go to post

                  Leave a comment:

                • kazper
                  replied to Run-time error '-2147217900 (80040e14)'
                  in Visual Basic
                  the Shape command is used for grouped reports. I'm also new with this command. As I have done some research regarding the error. It might have caused either by my

                  .CommandText = "SHAPE {SELECT * FROM ReceivingHistor y} AS ReceivingDetail s COMPUTE ReceivingDetail s BY ItemType"

                  or by

                  adoHistoryPrint .Open "Provider=SQLOL EDB.1;Password= Pword;Persist Security Info=True;User ID=User;Initial Catalog=DBase;D ata...
                  See more | Go to post

                    Leave a comment:

                  • kazper
                    replied to Run-time error '-2147217900 (80040e14)'
                    in Visual Basic
                    sorry i forgot to paste the code :D

                    [CODE=vb] With cmdHistoryPrint
                    .ActiveConnecti on = adoHistoryPrint
                    .CommandType = adCmdText
                    .CommandText = " SHAPE {" & adoReceivingHis tory.RecordSour ce & "} AS Command1 COMPUTE Command1 BY 'ItemType'"
                    .Execute[/CODE]
                    See more | Go to post

                      Leave a comment:

                    • kazper
                      replied to Run-time error '-2147217900 (80040e14)'
                      in Visual Basic
                      I'm using Visual Basic 6 the database is SQL Server 2005
                      See more | Go to post

                        Leave a comment:

                      • kazper
                        started a topic Run-time error '-2147217900 (80040e14)'
                        in Visual Basic

                        Run-time error '-2147217900 (80040e14)'

                        Good day,

                        I'm currently trying to print the data in my database using Visual Basic but I have a little problem with the codes, need your help about figuring out what I might be missing. I keep on getting the same error

                        Run-time error '-2147217900 (80040e14)'


                        [CODE=vb]Dim adoHistoryPrint As New ADODB.Connectio n
                        Dim recHistoryPrint As New ADODB.Recordset
                        Dim cmdHistoryPrint As New...
                        See more | Go to post
                        • kazper
                          started a topic Shrinking my transaction logs
                          in SQL Server

                          Shrinking my transaction logs

                          Good day,

                          I have some problems regarding my Hard disk space for my logs in SQL Server 2005. When I try shrinking the database it returns an error not letting me to do anything about the size of the file.
                          Is there any way that I can delete the used transaction logs in my LOG File to free some disk space that I need. I cannot delete or add any new files on my database, because the transaction log file is full.
                          My database...
                          See more | Go to post
                          • kazper
                            started a topic Run time error 3251
                            in Visual Basic

                            Run time error 3251

                            Good day,
                            I hope you guys could help me do something about this problem, it seems like I forgot the right codes to use :D

                            Dim adoRS as new ADODB.Connectio n
                            Dim recRS as Recordset


                            adoRS.Open "Provider=SQLOL EDB.1;Persist Security Info=False;User ID=User;Initial Catalog=Dbase;D ata Source=DBase", "user", "Password"
                            Set recRS = adoRS.Execute(" select * from...
                            See more | Go to post
                            • kazper
                              replied to problem on a recordset for a ADODB connection.
                              in Visual Basic
                              Thanks for the code :) that was the code that i needed ;) thanks alot
                              See more | Go to post

                                Leave a comment:

                              • kazper
                                started a topic problem on a recordset for a ADODB connection.
                                in Visual Basic

                                problem on a recordset for a ADODB connection.

                                I'm having trouble getting the right code for the record set.

                                Dim adoItems As New ADODB.Connectio n
                                Dim recItems As New ADODB.Recordset

                                adoItems.Connec tionString = "Provider=MSDAS QL.1;Persist Security Info=False;User ID=MyUserID;Dat a Source=MyDataSo urce;Initial Catalog=MyCatal og"

                                adoItems.Open ("DSN=MyDSNName ;UID=MyUserID;P wd=MyPassword")


                                my real problem...
                                See more | Go to post
                                No activity results to display
                                Show More
                                Working...