User Profile

Collapse

Profile Sidebar

Collapse
Parsa
Parsa
Last Activity: May 14 '09, 12:51 AM
Joined: Jun 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Parsa
    replied to Autoupdate all records in a table using VBA and SQL
    in Access
    Thanks Rabbit,

    I changed it to UPDATE and it's fine now... thanks :d
    See more | Go to post

      Leave a comment:

    • Parsa
      replied to Autoupdate all records in a table using VBA and SQL
      in Access
      I have come up with this code so far, can anyone tell me why it is not working?

      [CODE=vb]
      Private Sub cbo_ThesisPlanD ueDate_AfterUpd ate()
      Dim strDueDate As String
      'I use vbNullstring just in case there isn't anything in the textbox.
      strDueDate = Me.[Thesis Plan Due Date].Value & vbNullString
      If IsDate(strDueDa te) = True Then

      Dim rst As DAO.Recordset...
      See more | Go to post

        Leave a comment:

      • Parsa
        started a topic Autoupdate all records in a table using VBA and SQL
        in Access

        Autoupdate all records in a table using VBA and SQL

        Hello everyone,

        I have been looking on the net to solve my problem for several days now, but i couldn't find what I was looking for.

        I'm designing a database for a university and in one of the forms I have a text field called "Thesis Plan Due Date". User will enter the due date for submission of student's thesis in this text field.

        What i want to do is that when the user has specified the due...
        See more | Go to post
        No activity results to display
        Show More
        Working...