User Profile

Collapse

Profile Sidebar

Collapse
Shogun
Shogun
Last Activity: Jul 23 '07, 07:41 PM
Joined: Jul 3 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Shogun
    started a topic Change RecordsetType at running time
    in Visual Basic

    Change RecordsetType at running time

    I've created a database with RecordsetType Snapshot, so the user can't modify the data displayed on the text boxes. However, I'd like to create a button "Update" that could allow the user to update data if necessary. But to do so, I guess I would have to change the RecordsetType of my database to Dynaset, and once the update is done, make it back to Snapshot. How can I do this? Is there another way to solve this?
    See more | Go to post
    • Shogun
      started a topic Problems with (not) updating database
      in Visual Basic

      Problems with (not) updating database

      Hey guys, i'm trying to do a confirmation msgbox asking the user if he's sure about updating his database. The problem is... wathever the answer (Yes/No), the database is updated anyway! My code is something like this:

      Private Sub update_Click()
      Dim modify As Integer
      modify = MsgBox("Are you sure you want to modify your data?", vbYesNo, "Update")
      If modify = Yes Then
      ...
      See more | Go to post
      • Shogun
        started a topic Problems with VB4 and Access 2002 (compatibility)
        in Visual Basic

        Problems with VB4 and Access 2002 (compatibility)

        I'm having problems with compatibility between VB4 and Office XP. VB4 only recognize Access 97 or below format, so I can't work with database files I create with my Office XP. Even if I convert the file to Access 97 format, I just can read the file, without modify it. How can I solve this problem without updating VB?
        See more | Go to post
        • Shogun
          replied to I cannot find ADO Control
          in Access
          Ohhps! I really made a mistake here and posted on the wrong place! Well NeoPa, there's no need to move the post, I'll take a look at the VB forum. Thank you guys!
          See more | Go to post

            Leave a comment:

          • Shogun
            replied to I cannot find ADO Control
            in Access
            Humm..There's no "ActiveX Control" on my Insert menu..Maybe 'cause i'm using VB4.. Guess i'll have to update it afterall .__.
            See more | Go to post

              Leave a comment:

            • Shogun
              replied to I cannot find ADO Control
              in Access
              I had the same problem, so I have to install the ActiveX Data Control 6 too, but...how? Where do I get it?
              See more | Go to post

                Leave a comment:

              No activity results to display
              Show More
              Working...