User Profile

Collapse

Profile Sidebar

Collapse
Drahy
Drahy
Last Activity: Feb 3 '15, 12:08 PM
Joined: Jun 24 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Drahy
    replied to Recordset Looping
    in Access
    Sorry, one of the attachment is missing. I send it again the codes and the result in the immediate window.
    But i want the expected result based on my previous attachment.

    Here is the Codes:

    Code:
    1. Option Compare Database
2. Private Sub Command0_Click()
3. Dim db As Database
4. Dim rstab1, rstab2 As DAO.Recordset
5. Set db = CurrentDb
6. Set rstab1 = db.OpenRecordset("Table1", dbOpenDynaset)
    ...
    See more | Go to post
    Last edited by NeoPa; Nov 4 '13, 08:11 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data. Made pic viewable (NeoPa)

      Leave a comment:

    • Drahy
      started a topic Recordset Looping
      in Access

      Recordset Looping

      Good Day to all,

      Can anyone help me for my programming difficulty regarding recordset looping. I want an expected result as shown in my attachment "Sample Expected Result.txt"
      I have 2 recordsets using two tables named "Table1 and Table2". I am also using do while loop as shown in my attachment. The result of my code was shown in an immediate window.
      Can anyone provide me as an exact code to show an...
      See more | Go to post
      Last edited by zmbd; Nov 6 '13, 09:12 PM. Reason: [z{made pic viewable, added portion of text file to post}]
      • Drahy
        replied to Run-time error '13' Type mismatch
        in Access
        Thanks for your advised
        Its working.
        I already converted the data in numerical value
        before i add the data
        I reformat my code block based on your suggestion
        It is big help for me.

        Thank you very much
        See more | Go to post

          Leave a comment:

        • Drahy
          started a topic Run-time error '13' Type mismatch
          in Access

          Run-time error '13' Type mismatch

          Hello

          I have difficulty in solving the run time error 13 type mismatch. I do not know how to solve it.
          If i write this code "JOR_No.Val ue = Right(List225.I temData(icount) , 4) + 1". The error will appear.
          If i remove " + 1" in the code, no error will shown and the whole code works normal.
          Can anyone review my codes.

          Please see attachment

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