User Profile

Collapse

Profile Sidebar

Collapse
Aarmando
Aarmando
Last Activity: Dec 27 '10, 09:51 PM
Joined: Jul 23 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Aarmando
    started a topic How to check if you the WHERE condition in a report is working?
    in Access

    How to check if you the WHERE condition in a report is working?

    Hi All,

    I have a report where I use the Customer's Name to open a form that shows their contact info ID. I use their ID number for the WHERE condition. For a week it will work, but then it will only open to a New Record. The string was a leftover from a previous debugging exercise.

    Code:
    '_________________________________________________________________________
'   Object: Contact Person Hyperlink
'
    ...
    See more | Go to post
    • Aarmando
      replied to Is there a way to retrieve the response from accmdImportAccess?
      in Access
      Yes, I am using Access 2007. I am sorry for not mentioning it.

      I had a new idea for solving the problem. Maybe if I store how many records there are in the Recordset, then get the new RecordCount after the user made a choice in the Import Wizard.

      If their equal: no records were added, thus the user didn't import an Excel file

      If their unequal: a record was added, then the user did import an Excel file. ...
      See more | Go to post

        Leave a comment:

      • Aarmando
        replied to How to Swap values between two different records?
        in Access
        The purpose of the code is to Import an Excel file into the database under two different cases. I used a couple lines of code from the CarryOver() procedure thats out there, and been trying to re-arrange it to fit my needs. For now, I am using accmdImportAtta chExcel to prompt the user into importing the Excel file. Here are the two cases

        Case 1: Importing a Excel file as "new" record and appending it to an existing table....
        See more | Go to post

          Leave a comment:

        • Aarmando
          started a topic How to Swap values between two different records?
          in Access

          How to Swap values between two different records?

          Hey,

          I'am trying to create a code that will exchange the values of the current record (excluding the ID number) with Record B. So far I have been able to exchange values between the first and last record in the RecordSet.

          The only other idea that I have is that I temporarily create a second table and then copy the values to the current record, then delete the table. Its extra code that I would want to do only if it...
          See more | Go to post
          • Aarmando
            replied to Is there a way to retrieve the response from accmdImportAccess?
            in Access
            Hey NeoPa,

            Thanks for your tip. After reviewing my code some more, I found that I dont get an error at all if the user chooses to cancel the import. BUT i still need to retrieve the response from the Import Wizard Window.

            In a nutshell here is what I want my code to do:
            Case 1: If its a new record, import Excel file and append to existing table. Then go to that newly imported record.

            Case 2: If...
            See more | Go to post

              Leave a comment:

            • Aarmando
              replied to Is there a way to retrieve the response from accmdImportAccess?
              in Access
              hey slenish,

              Thanks for quick response. I had a feeling that will have to use TransferSpreads heet instead. I will give a it a shot later this week and let you know how it went.
              See more | Go to post

                Leave a comment:

              • Aarmando
                started a topic Is there a way to retrieve the response from accmdImportAccess?
                in Access

                Is there a way to retrieve the response from accmdImportAccess?

                Wassup everybody,

                This is my first time posting on this message board.

                I am building a button to import an Excel file. I am using:

                Code:
                DoCmd.RunCommand acCmdImportAttachExcel
                to open import an excel file into Access and append it to an existing table. I have some more code after this that only works if the user imports the excel file.

                My problem is when the user...
                See more | Go to post
                No activity results to display
                Show More
                Working...