User Profile

Collapse

Profile Sidebar

Collapse
Lirsy
Lirsy
Last Activity: May 25 '17, 03:21 PM
Joined: Jan 23 '17
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Lirsy
    replied to Recordset read only problem
    in Access
    Ep!!!!

    So evident!! :-(

    You can't update anything you don't have!!! :-(

    Thanks a lot!!!
    See more | Go to post

      Leave a comment:

    • Lirsy
      started a topic Recordset read only problem
      in Access

      Recordset read only problem

      Hi all!!

      I would greatly apreciate any help in this!!

      I have problems with a recordset (it says that it is read only and I need to modify some of its values) and then I tried to create the simpliest version to see where is the problem. I keep having the same problem.

      The simplest version is just:

      Dim Rs2 As DAO.Recordset
      Sql_Str = "SELECT 0 As Id, '' As Cod, 0 As IdOff, 0 as...
      See more | Go to post
      • Lirsy
        replied to Query translate from MySQL to Access
        in Access
        Thank you VERY much!! Let me go for in now!! :-)

        BTW, quite better ussing Nz!!
        See more | Go to post

          Leave a comment:

        • Lirsy
          started a topic Query translate from MySQL to Access
          in Access

          Query translate from MySQL to Access

          Hi!!

          I am becoming crazy trying to pass a sentence from MySQL to Access.

          The issue is as follows:

          I have one table (BoQ) with codes (Cod) and quantities (Q) and another table (BD) with codes (Cod) and invoices (Sub).

          I want a query that gives me one line for each code, containing the code, the sum of all quantities for the code and the sum of all invoices for the code.

          I have...
          See more | Go to post
          • Lirsy
            replied to Problems with UPDATE statement
            in Access
            WOW!!

            Thanks a lot!!! Working now!! :-)
            See more | Go to post

              Leave a comment:

            • Lirsy
              started a topic Problems with UPDATE statement
              in Access

              Problems with UPDATE statement

              Hi!!

              I am becoming crazy with this update statement:

              Sql_Str = "UPDATE [BoQ] SET [BoQ].[ID_Ch] = " & Lista20.Value & ", SET [BoQ].[CHCod] = '" & DLookup("[Ch].[Ch]", "[Ch]", "[Ch].[Id] = " & Lista20.Value) & "' WHERE [BoQ].[Id] = " & Lista20.Value & ";"

              the debug.print is the following:

              UPDATE...
              See more | Go to post
              No activity results to display
              Show More
              Working...