Recent content by johnsonhuo

  1. J

    Huge table checkbox and bugged table hyperlink

    Hi folks, I just had 2 problems with access table. One is the table yes/no checkbox. When I increase the size of the cell, the size of checkbox increases as well and it becomes very big and ugly. The other problem is the table hyperlink. This only happens when I use access 2010 and it works...
  2. J

    Can't update field after requery

    Hi Pat Hartman, Thank you so much for your advice. It is really important and I will rename all those text boxes and buttons and make my code more professional!
  3. J

    Can't update field after requery

    Oh My World, this is exactly the solution! You really helped me again arnelgp! It is so great to have you here and I guess you know everything about VBA and access. You are a real talent! Thank you very much!
  4. J

    Can't update field after requery

    Hi Arnelgp, Thank you so much for your reply. The complete code is Private Sub Command16_Click() If Me.Command16.Caption = "Add" Then If Nz(Me.Text6, "") = "" Then MsgBox "Please input Set Number" ElseIf Nz(Me.Text10, "") = "" Then MsgBox "Please input Car Number" Else CurrentDb.Execute...
  5. J

    Can't update field after requery

    Hi folks, just have a stupid question to ask for help When I try to update some of records from subform by code Me.Text10 = .Fields("Car") This one will not work after code me.subformA.form.requery it indicates that the value isn't valid for the field. I really have no idea how this...
  6. J

    Need Help with VBA code

    Thank again you arnelgp for your advice. Trimming the leading and trailing space could be my problem as well. It will be very helpful for some raw data! Thank you again for your help and it is so great to have you here!
  7. J

    Need Help with VBA code

    Hi Mark, Thank you again for your very clear and professional explanation for the set order part. I used your method and it does work very well. Additionally, the debug print is a very powerful tool for error finding and testing. It is really helpful for beginners like me. For the sBody, it is...
  8. J

    Need Help with VBA code

    Hi mark, thank you for your advice. It is very professional and useful. As a beginner, I really made many mistakes and could not consider all scenarios. I will follow your instructions and do things in a better way while programming. I have another concern about your comment in regards of the...
  9. J

    Need Help with VBA code

    Hi arnelgp, thank you very much for your help and it does work well after using your code. I think both my problems are related to the string length and it was really great to have you to help me solve it.
  10. J

    Need Help with VBA code

  11. J

    Need Help with VBA code

    I really need help with my VBA code problem 1 Dim sBody As String Dim rst1 As DAO.Recordset Set rst1 = db.OpenRecordset("Select * From OilSampleEmail") While Not rst1.EOF sBody = "<html><body><p>" & sBody & Nz(rst1!Set, "") & " " & Nz(rst1!Car, "") & "</p></body></html>" rst1.MoveNext...
See more
Top Bottom