User Profile

Collapse

Profile Sidebar

Collapse
apank
apank
Last Activity: Aug 18 '09, 12:38 PM
Joined: Sep 9 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • apank
    replied to Updating Pivot Table Page Fields based on another page field
    in Access
    Thanks NeoPa. But I found some code on line. I forgot the link, but here is the code that worked for me.
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim pt As PivotTable
     
    If Not Intersect(Target(1, 1), Range("Branchcode")) Is Nothing Then
        Set pt = Sheet9.PivotTables(1)
        pt.RefreshTable
    With pt
        .RefreshTable
        .PivotFields("Office
    ...
    See more | Go to post

      Leave a comment:

    • apank
      replied to Looping through Combo Box to Print Reports
      in Access
      Thank you very much for this Adezzi. Worked great.
      See more | Go to post

        Leave a comment:

      • apank
        started a topic Updating Pivot Table Page Fields based on another page field
        in Access

        Updating Pivot Table Page Fields based on another page field

        I have been working with VBA for less than a year, but mostly in Access. I have come accross an issue in Excel that I want to solve programatically .

        I have several pivot tables on one work sheet that feed several pivot charts.

        I am looking for code that will update each pivot table based on the page I select from the first pivot table on that worksheet.

        Basically, once I update the first pivot table,...
        See more | Go to post
        • apank
          replied to Looping through Combo Box to Print Reports
          in Access
          The series of events should go as follows.
          1) Have the report print based on the first branch code in the combo box
          2) Close the report
          3) Change the branch code in the combo box to the next branch code
          4) Print the Report
          5) Repeat until the report has been printed for all the branch codes listed.
          See more | Go to post

            Leave a comment:

          • apank
            replied to Looping through Combo Box to Print Reports
            in Access
            The combo box has a list. I would like the procedure to go through the list, choose each office code listed and print the report(The report prints based WHERE office code = the combo box). I can do it if I hard code the office codes in the procedure and do a set value, but would like it to loop through the combo box instead. That way if new offices are added the report will print automatically.

            Thanks...
            See more | Go to post

              Leave a comment:

            • apank
              replied to Looping through Combo Box to Print Reports
              in Access
              The procedure you described worked but I cannot get it to update the combo box, then print the report based on the combo, then close the report and print the next one. I am sure the answer is close but I can't seem to find it.

              As always your help is much appreciated.

              A...
              See more | Go to post

                Leave a comment:

              • apank
                started a topic Looping through Combo Box to Print Reports
                in Access

                Looping through Combo Box to Print Reports

                I have a report that opens based on the where the office code on the form matches the office code on the report. that works fine.

                I have written code that sets the combo box value opens the report (acnormal), then closes report, then sets the combo box value again, opens the report and then close the report.....on and on.

                The combo box grows monthly and instead of having to keep updated the code with new office codes,...
                See more | Go to post
                Last edited by NeoPa; May 25 '09, 01:12 PM. Reason: Please use the [CODE] tags provided.
                • apank
                  replied to OR statement in Access
                  in Access
                  Excellent.

                  Thank you very much.
                  See more | Go to post

                    Leave a comment:

                  • apank
                    started a topic OR statement in Access
                    in Access

                    OR statement in Access

                    Is there a way to the an OR statement when doing "If, than" statements in Access. I know how to do it in Excel, but can't seem to do in in Access.

                    Example: iff ([a] or [b] >1,"Yes", "No")


                    Thank you for any direction you can provide.

                    A
                    See more | Go to post
                    • apank
                      replied to TransferSpreadsheet
                      in Access
                      Thank you very much. This helped me out a lot.
                      See more | Go to post

                        Leave a comment:

                      • apank
                        replied to TransferSpreadsheet
                        in Access
                        Sorry......I am tring to do a transferspreads heet from a workbook that has multiple worksheets. How do specify which worksheet I would like the code to pull?
                        See more | Go to post

                          Leave a comment:

                        • apank
                          started a topic TransferSpreadsheet
                          in Access

                          TransferSpreadsheet

                          Is there a way to differenciate between multiple Excel Spreasheets in an Excel Workbook when writing the code to TransferSpreads heet?

                          When I do the command now, I only have one worksheet.

                          Example:
                          Code:
                          DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Test", "c:/test.xls", True
                          Now suppose the workbook had 3 worksheets: "test1", "test2" and "test3"....
                          See more | Go to post
                          Last edited by NeoPa; Feb 17 '09, 02:16 PM. Reason: Please use the [CODE] tags provided
                          • apank
                            replied to Suppress Sub Report when a field in that sub report is blank
                            in Access
                            I believe my spelling was correct. I did find a way around my issue. I put "is not null" criteria in the queries behind the reports. So now the subreports do not generate, and are not linked to the parent report. Thank you for the time you put in on my problem. This site has been a great help to me.
                            See more | Go to post

                              Leave a comment:

                            • apank
                              replied to Suppress Sub Report when a field in that sub report is blank
                              in Access
                              I still get the same Run Time Error

                              I am getting an error that states: " Run-time error '2465'

                              Microsoft Office Access can't find the field 'New Broker 1' referred to in your expression.

                              What I am trying to do is have a batch of letters print, and each of the letters has up to 6 Cc letters. Each of the 7 letters should be grouped together (that is why I did the sub reports). If there are only to...
                              See more | Go to post
                              Last edited by apank; Dec 10 '08, 08:00 PM. Reason: I wanted to add a bit more detail of what I am trying to do.

                                Leave a comment:

                              • apank
                                replied to Suppress Sub Report when a field in that sub report is blank
                                in Access
                                I will give that a whirl and let you know. Thanks.
                                See more | Go to post

                                  Leave a comment:

                                • apank
                                  replied to Suppress Sub Report when a field in that sub report is blank
                                  in Access
                                  I did replace the illustrative names with my actual names (I used customer as a common example). I put the code in the "on open" event of the report that is being used as the subreport.

                                  Below is the code. The actual fields name is [new broker 1]

                                  Private Sub Report_Open(Can cel As Integer)
                                  'does not show broker 1 letter if new broker 1 is null
                                  If Nz([New Broker 1], 0) = 0 Then
                                  ...
                                  See more | Go to post

                                    Leave a comment:

                                  • apank
                                    replied to Suppress Sub Report when a field in that sub report is blank
                                    in Access
                                    Thank you very much for your response.

                                    I am getting an error that states: " Run-time error '2465'

                                    Microsoft Office Access can't find the field 'customer0' referred to in your expression. Is that because the report is not open yet? Is there a way around that?
                                    See more | Go to post

                                      Leave a comment:

                                    • apank
                                      started a topic Suppress Sub Report when a field in that sub report is blank
                                      in Access

                                      Suppress Sub Report when a field in that sub report is blank

                                      I have a report that has 6 sub reports, each separated by a page break. I am looking for a way to suppress any of the sub reports from printing when a certain field, say customer#, is null. I do not want any blank pages either. Any help is much appreciated.

                                      Thanks

                                      A
                                      See more | Go to post
                                      • apank
                                        started a topic Declare a varable for the entire database
                                        in Access

                                        Declare a varable for the entire database

                                        I am trying to declare a maximum # of characters that can be inputted into multiple Memo fields. I have a len counter displaying the # of characters.

                                        When the count gets to 10 lets say I want a msgbox to pop up. This is working. Instead of saying:
                                        if lencounter >10 then
                                        Msgbox "You have reached the maxium # of characters"

                                        I would like to set the maximum # of characters once globally so...
                                        See more | Go to post
                                        • apank
                                          replied to VBA Len Counter when I go to a new record
                                          in Access
                                          You were right. I got it to work. I really appreciate your service. This site really is great.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...