User Profile

Collapse

Profile Sidebar

Collapse
relicx2004
relicx2004
Last Activity: Jul 2 '20, 01:28 AM
Joined: May 8 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • relicx2004
    replied to Sum question with excluding condition
    in SQL Server
    Check both query below:

    Code:
    select sum(t1.Amount) as Amount
from tblTest as t1
where t1.KeyID = (select max(t2.KeyID)
                      from tblTest as t2
                      where t2.UserID = t1.UserID
                     );

    Code:
    ;with cte as (
    select KeyID, UserID, Amount,
           row_number() over(partition by UserID order by KeyID desc) as RowNum
    ...
    See more | Go to post

      Leave a comment:

    • relicx2004
      started a topic Sorting Traditional Chinese Characters differs from 2003 and 2013
      in Excel

      Sorting Traditional Chinese Characters differs from 2003 and 2013

      I created a VBA code to automatically sort(ascending order) a column containing Traditional Chinese characters on Excel 2003. It works well but when I tried running the code on a Excel 2013 version the sorted values differs versus on the sorted values on the Office 2003. I tried using
      Code:
      Range("A2:A30").SortSpecial SortMethod:=xlPinYin
      and
      Code:
      Range("D182:D187").SortSpecial SortMethod:=xlStroke
      but still the values are not sorted...
      See more | Go to post
      • relicx2004
        replied to Report Column format Right to Left
        in Access
        Thanks for sharing your thoughts, I guess that's the only approach I can do (assuming that the report is always filled up in every column in each row). I'm switching to VB.NET/Crystal Report since it allows Right-Left layout.
        See more | Go to post

          Leave a comment:

        • relicx2004
          started a topic Report Column format Right to Left
          in Access

          Report Column format Right to Left

          Hi,

          I'm doing some simple program for creating and printing of ID's.
          I need to create a multi column report to print more ID's on just one go. With that I created 1 report for the front part and another report for the back portion of the ID. The aim is to print both reports on a single sheet back to back, and the front page should match the details of the back portion. The problem is that I need to reverse the layout of the...
          See more | Go to post
          • relicx2004
            replied to Connect Crystal Report to Access MDB with security MDW file
            in .NET
            Problem solved. It turned out to be an easy task.
            Changed database connection of the crystal report from DAO to ADO and filled the connection information. Then modified code to:

            Code:
            With (crConnectionInfo)
    .UserID = "MyMDWWorkgroupUserName"
    .Password = "MyMDWWorkgroupPassword"
End With
            See more | Go to post

              Leave a comment:

            • relicx2004
              replied to Query Not Working As It Should
              in Access
              Just a quick response, your parameters are not correct.
              It should be "[Forms]![Searchcriteria]![Textitem]" not "item",etc. As per the second question create a action query(insert query) when you click the Edit tab to populate the table that is connected to the EditGarments form.
              See more | Go to post

                Leave a comment:

              • relicx2004
                started a topic Connect Crystal Report to Access MDB with security MDW file
                in .NET

                Connect Crystal Report to Access MDB with security MDW file

                I'm using VS2010(VB.NET) and Crystal report IX
                The report is connected to a MS ACCESS .MDB with a .MDW system database file.
                Since I want to dynamically change the database path programmaticall y, I'm having a hard time figuring out the correct ConnectionInfo settings in viewing the report.
                I tried searching on the net but failed to come up with the correct solution.
                Below is a sample of my ConnectionInfo code. Appreciate...
                See more | Go to post
                • relicx2004
                  replied to Access Automation
                  in Access
                  Thanks for the quick response. The link that you have provided was similar to my first method but my problem with that was since shell already opens the access database, .OpenCurrentDat abase wont work since it will open again the same database.
                  See more | Go to post

                    Leave a comment:

                  • relicx2004
                    started a topic Access Automation
                    in Access

                    Access Automation

                    I want to open another MDB database with BOTH database password and workgroup user level security enabled without prompting user to login and input a database password. My solution at this moment is to open it with the shell command to bypass the login prompt then use SendKeys functions to provide the database password. Is there a better approach instead of using SendKeys in setting up the database password. Any suggestions are welcome. Thank you....
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...