User Profile

Collapse

Profile Sidebar

Collapse
Quiver
Quiver
Last Activity: Dec 22 '07, 12:09 PM
Joined: Jul 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Quiver
    replied to DAO Recordset Nested Loops
    in Access
    1)
    tblKidCharges
    KidBatchID (AutoNumber)
    BatchID (Number)
    ChildID (Number)
    Dte (Date/Time)
    FamilyID (Number)
    LName (Text)
    Group (Text)

    tblTeach
    TeachBatchID (AutoNumber)
    BatchID (Number)
    FamilyID (Number)
    Dte (Date/Time)
    FamilyLName (Text)

    tblCharges
    BatchID (Number)
    Dte (Date/Time)
    ChildID (Number)
    ...
    See more | Go to post

      Leave a comment:

    • Quiver
      started a topic DAO Recordset Nested Loops
      in Access

      DAO Recordset Nested Loops

      I'm probably going off in the wrong direction, so feel free to offer other suggestions here.

      Overview: I need to look at a common field in two tables and find where they are equal. When equal, I need to UPDATE another table with a value, and when not equal, I need to UPDATE that table with a different value.

      Details: The first table is tblKidCharges and the second table is tblTeach. Both tables contain the field FamilyID....
      See more | Go to post
      • Quiver
        replied to Allow user to choose what file to import
        in Access
        Thanks for the idea. I actually just tried setting the reference to the Microsoft Office 11.0 Object Library (as a learning experience :) and it still can't find it when I debug.
        See more | Go to post

          Leave a comment:

        • Quiver
          replied to Allow user to choose what file to import
          in Access
          Thanks Sysdupe123 and Rabbit.

          I was bummed to hear about FileDialog not being available on A2K.

          I ended up using something like this...

          Code:
          Dim strDate as string
strDate = InputBox("What is the date on the import file?", , "mm-dd-yyyy")

DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "tblMAIN","IMPORT_" & strDate & ".x
          ...
          See more | Go to post

            Leave a comment:

          • Quiver
            replied to Allow user to choose what file to import
            in Access
            It won't compile. It freezes on "Dim sMyPath As FileDialog". FileDialog is not an option. Do I need to reference a specific library? I'm using Access 2000 with VB 6.5.

            Thanks.
            See more | Go to post

              Leave a comment:

            • Quiver
              started a topic Allow user to choose what file to import
              in Access

              Allow user to choose what file to import

              Is there a way to have the user choose what file to import, but set everything else up in VBA?

              The command button that would start the import would have something like this --

              Code:
              DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "tblMAIN",???,True
              -- with the ??? indicating where you would typically put the path and name of the spreadsheet. However, the spreadsheet that will be imported...
              See more | Go to post
              • Quiver
                replied to Stop a form from maximizing
                in Access
                Figured it out! I put a DoCmd.Minimize command in the OnClose event of the report before opening frmMAIN.

                Thanks anyway.
                See more | Go to post

                  Leave a comment:

                • Quiver
                  replied to Stop a form from maximizing
                  in Access
                  Addendum:

                  I have the report maximizing onOpen. If I don't do this the form does not maximize. However, I really want the report to maximize onOpen.
                  See more | Go to post

                    Leave a comment:

                  • Quiver
                    started a topic Stop a form from maximizing
                    in Access

                    Stop a form from maximizing

                    How do you stop a form from maximizing on open. When I close a report, I want "frmMAIN" to open at it's normal non-maximized size. But, it keeps opening fully maximized. Here is my code.

                    Code:
                    Private Sub Report_Close()
On Error GoTo Err_Report_Close

DoCmd.OpenForm "frmMAIN"
Exit_Report_Close:
Exit Sub

Err_Report_Close:
MsgBox (err.Number & ": "
                    ...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...