User Profile

Collapse

Profile Sidebar

Collapse
Gilley178
Gilley178
Last Activity: Sep 27 '22, 05:03 PM
Joined: Jun 8 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Gilley178
    started a topic python, when I load a dictionary using pickle, only the first key and value print when I try to print all contents of the dictionary
    in Python

    python, when I load a dictionary using pickle, only the first key and value print when I try to print all contents of the dictionary

    Good day,

    The purpose of my script is to create a small dictionary that is saved to a file using pickle and print the entire contents of the dictionary for the user. My script prompts the user to make 1 of 3 choices:

    Selection 1 is intended to print all contents of a dictionary loaded using pickle. Selection 2 appends to the existing dictionary and prints what was appended. Selection 3 creates a file and adds an entry...
    See more | Go to post
    • Gilley178
      replied to add generic pages to access generated report to export to pdf
      in Access
      Thank you for the suggestion. I have been working on it for the past couple of days. Its good to have learned about sub reports and forms. I unfortunately ran into the same issue though. The main body has a maximum of around 21 inches. The reports are quite difficult to get to generate correctly when sticking into the header and footer. It cuts them up and into multiple pages due to conflicts with the margins. I also experimented with converting...
      See more | Go to post

        Leave a comment:

      • Gilley178
        replied to add generic pages to access generated report to export to pdf
        in Access
        I generate individual PDF documents from a report in Access. For example report 555 generates with report 555’s group associated information. So there is generally around 300 of these individual PDF files. I need to add 3 generic pages with each pdf file. Generic, meaning that the information on them is the same for each of the 300 PDF files. I need to combine the generic 4 page document with each report. I’m thinking that there has to be a way...
        See more | Go to post

          Leave a comment:

        • Gilley178
          started a topic add generic pages to access generated report to export to pdf
          in Access

          add generic pages to access generated report to export to pdf

          Right now I can generate a report that groups data per each sub group. I then export them to individual PDF files by a VBA code. So the report with group ID 555 generates with group 555’s data and so on. I need to add generic full pages to each group document. I tried a few things but it doesn’t really work. I’ve ran into random problems/glitches trying different quick fixes. I figure there has to be a correct way to do it. Does anyone know?...
          See more | Go to post
          • Gilley178
            started a topic add generic pages to access generated report to export to pdf
            in Visual Basic

            add generic pages to access generated report to export to pdf

            Hello,

            Right now I can generate a report that groups data per each sub group. I then export them to individual PDF files by a VBA code. So the report with group ID 555 generates with group 555’s data and so on. I need to add generic full pages to each group document. I tried a few things but it doesn’t really work. I’ve ran into random problems/glitches trying different quick fixes. I figure there has to be a correct way to do...
            See more | Go to post
            • Gilley178
              replied to Access VBA generate individual PDF for each row
              in Visual Basic
              One of the queries was not pulling data from the right table. At least that is my theory but it works now. I would now consider it to be working.
              See more | Go to post

                Leave a comment:

              • Gilley178
                started a topic Access VBA generate individual PDF for each row
                in Visual Basic

                Access VBA generate individual PDF for each row

                Hello,

                I don't really know anything about VBA. I need to generate a pdf for each groupid named with the groupid. I found some code and repurposed it. Someone was doing the same thing as I but it is not working. The groupids do not match the groupid and that groupid's associated data in the pdf. So for example groupid 555.pdf file does not contain groupid 555 associated data. Each generated pdf contains the same groupid data while the...
                See more | Go to post
                • Gilley178
                  replied to Run-time error 3075 syntax error (missing operator) open on double click from listbox
                  in Visual Basic
                  Thank you for the advice! I made the following changes and it worked:

                  Code:
                  Private Sub SearchList_DblClick(Cancel As Integer)
    DoCmd.OpenForm "profileForm", , , "[Claim ID 15]='" & SearchList & "'"

End Sub
                  See more | Go to post

                    Leave a comment:

                  • Gilley178
                    replied to Run-time error 3075 syntax error (missing operator) open on double click from listbox
                    in Visual Basic
                    Thank you for the response. I updated the code and it to:

                    Code:
                    Private Sub SearchList_DblClick(Cancel As Integer)
    DoCmd.OpenForm "profileForm", , , "Claim ID 15= '" & SearchList & "'"

End Sub
                    However it still resulted in a runtime error with the same message.
                    See more | Go to post

                      Leave a comment:

                    • Gilley178
                      started a topic Run-time error 3075 syntax error (missing operator) open on double click from listbox
                      in Visual Basic

                      Run-time error 3075 syntax error (missing operator) open on double click from listbox

                      Hello,
                      My goal is to open a specific record from a list box to populate a different form with that specific data that was double clicked on. My column name is Claim ID 15 on the list box and in the master table that contains all data. This column contains values such as C123456789. On the Master table, Claim ID 15's data type is short text. When I double click on the row in the list box it gives me the following error: Run-time error...
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...