User Profile

Collapse

Profile Sidebar

Collapse
ladybug76
ladybug76
Last Activity: Apr 24 '09, 06:34 PM
Joined: Mar 5 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ladybug76
    replied to Emailing various Reports (via CMD button) from an Option Group
    in Access
    I also had to tweak the original call from a sub to a function and make the PrintMode Optional. But I finally got it to work

    THANK YOU THANK YOU THANK YOU!!!

    I've said it before, I'll say it again.. thescripts ROCK!!!!!!!!!!! !!!


    Here's the code in case anyone else ever runs into this again:


    Code:
    (vb)

Option Compare Database    'Use database order for string comparisions.
    ...
    See more | Go to post

      Leave a comment:

    • ladybug76
      replied to Emailing various Reports (via CMD button) from an Option Group
      in Access
      Hi PuppydogBuddy.

      First and foremost, thanks for your guidance. It is extremely appreciated!!!!
      Now, back to busines... :)

      I tried replacing my DoCmd.SendObjec ts line with your suggestion and I'm still getting the same error. When I put your code in the immediate window, I got a Runtime error 2487.

      You wouldn't happen to know any other tricks, work arounds or other suggestions to get this working,...
      See more | Go to post

        Leave a comment:

      • ladybug76
        started a topic Emailing various Reports (via CMD button) from an Option Group
        in Access

        Emailing various Reports (via CMD button) from an Option Group

        Hello.

        Okay, so I have an Option Group with 6 reports on the Right hand side of a form. On the left, I have 4 command buttons. 1) Preview 2) Print 3) Save off 4) Email.

        I want the user to be able to select a report's radio button and click one of the four command buttons. Currently, Preview and Print work. But the Reports have parameters in their queries. I'm prompted for the values for the Print and Preview...
        See more | Go to post
        • ladybug76
          replied to Trouble with OpenForm action was cancelled
          in Access
          Hello Stewart.

          Guess you drew the short straw (re: answering one of my posts) :)

          F_ADJSelect is the Selection form the user keys their two parameters (Line and Claim number) into, then click the Command Button to launch the F_ADJ form. The F_ADJ form needs to be filtered on the Line and Claim numbers from the prior form. I had put the "Close" command on the F_ADJSelect so their weren't a bunch of forms...
          See more | Go to post

            Leave a comment:

          • ladybug76
            started a topic Trouble with OpenForm action was cancelled
            in Access

            Trouble with OpenForm action was cancelled

            Hello Again.

            I'm so close I can TASTE IT! I'm working in Access 2003. I've read a bunch of posts, but still can't get to the bottom of this.

            I have a "Selection Criteria" form (with Two free form Text Boxes Named Line_Num and Claim_Num).

            Based on the entry in both fields, the users want to click on a button that launches and filters the returned results of the "Main form" by...
            See more | Go to post
            • ladybug76
              replied to Need Help: Exporting more than 65k records to a fixed width text file
              in Access
              I just wanted to let you know, I never did get it to work. But I really appreciate your help. I ended up scrapping the 2 parameter thing and hard coded one of them into my query. Then I used the original suggestion you gave me in the beginning of this thread. I got it to work and I'm a VERY happy camper!!

              Thank you so much for all your help and patience!!!!

              TheScripts Rock! :)
              See more | Go to post

                Leave a comment:

              • ladybug76
                replied to Need Help: Exporting more than 65k records to a fixed width text file
                in Access
                Hello Again.

                I corrected the misspelling
                Thanks for catching that one!! I've obviously been staring at this too long. :)

                The [Rebate_Period] is a string, so I used the second example, but I'm still getting the "Item not in Collection" error.

                I'm trying to see if i understand (pardon my quasi-layman terms), you think I should split the strWhere into two parts, then put them together....
                See more | Go to post

                  Leave a comment:

                • ladybug76
                  replied to Need Help: Exporting more than 65k records to a fixed width text file
                  in Access
                  Thank you for your response!!!! It's greatly appreciated..

                  Maybe you can help with my current problem regarding the same code. Or I can post to a new thread if you prefer.

                  Here's the situation.:

                  I went another route trying to get the button to launch the query that was run based on a combo box (named Combo0 below ) and Multi-Selection (Simple) list box (named Combo2 below). But I continue to get...
                  See more | Go to post

                    Leave a comment:

                  • ladybug76
                    started a topic Need Help: Exporting more than 65k records to a fixed width text file
                    in Access

                    Need Help: Exporting more than 65k records to a fixed width text file

                    Hello.

                    I'm working in Access 2003 and I'm new to VBA.

                    I'm trying to create a button on a form that will run my query (based on the 2 drop down box parameter selections made by the user). The query runs in the background and needs to be exported to a fixed-width (as in fixed width columns) text file. The text file will be loaded to a mainframe for ftp to our client.

                    I was able to get the button and query...
                    See more | Go to post
                    Last edited by ladybug76; Mar 11 '08, 02:34 PM. Reason: forgot to add email notification
                    • ladybug76
                      replied to Is there VB code or a Macro for duplicating a record then changing one field's value
                      in Access
                      Never mind.. I figured out what I did wrong...

                      Thank you SOOOOO much for your help!!!
                      See more | Go to post

                        Leave a comment:

                      • ladybug76
                        replied to Is there VB code or a Macro for duplicating a record then changing one field's value
                        in Access
                        Ok. I don't know where I went wrong.

                        I'm getting the following error
                        Method or data member not found.
                        *(The error message launched my code and highlighted the"Me.FirstFie ld" section of the code)*



                        Some info that may help to understand what I'm trying (unsuccessfully ) to do
                        • There are 49 fields in the table that need copied.
                        • Only 10 show on the form.
                        • Only 1 needs updated.
                        • The QTSeq
                        ...
                        See more | Go to post
                        Last edited by ladybug76; Mar 5 '08, 08:07 PM. Reason: forgot to add email notification

                          Leave a comment:

                        • ladybug76
                          replied to Is there VB code or a Macro for duplicating a record then changing one field's value
                          in Access
                          I'll give it a whirl!
                          I can't thank you enough!!
                          See more | Go to post

                            Leave a comment:

                          • ladybug76
                            started a topic Is there VB code or a Macro for duplicating a record then changing one field's value
                            in Access

                            Is there VB code or a Macro for duplicating a record then changing one field's value

                            Hi.

                            I'm working on a database and I though I tinker with Macros and VB, I am not very versed in them. So ANY help would be HUGELY appreciated!!!
                            (I'm using Access 2003)

                            What I need to do is, from a form I've created, I need to add a button so the end user can duplicate the record they are viewing, then update either the original or the duplicate record's field ["Status"] from its current value...
                            See more | Go to post
                            No activity results to display
                            Show More
                            Working...