User Profile

Collapse

Profile Sidebar

Collapse
BeaBea
BeaBea
Last Activity: Mar 18 '10, 07:50 PM
Joined: Jul 17 '09
Location: Windham, Maine
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BeaBea
    replied to Record source error
    in Access
    NeoPa,

    Thank you.

    I pressed Alt F11 to open the IDE or VBA debugging window and this is the only code that is in that window:
    Code:
    Option Compare Database

Private Sub Report_Close()
DoCmd.Close acForm, "ParamForm"

End Sub

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "ParamForm", , , , , acDialog

End Sub
    ...
    See more | Go to post

      Leave a comment:

    • BeaBea
      replied to Record source error
      in Access
      Sorry it's taken me so long to get back to this post. Been away from it for a few days.

      I am not sure what you mean by post the whole module. Do you mean the module under the objects list, if so I do not have one and that could potentially be the problem. Or do you mean all of the code under VB, if so I have posted all of the code I have.

      If i need to have something in the module please let me know.

      ...
      See more | Go to post

        Leave a comment:

      • BeaBea
        replied to Record source error
        in Access
        This is the code I have for the Manager Name combo box.
        Code:
        Private Sub Command7_Click()
Me.Visible = False

End Sub
    
Private Sub FindMgr_AfterUpdate()
    
    Me!FindMgr.Requery
    Me!FindMgr.SetFocus
    
End Sub
        This is what I have in the row source of the Manager Name combo box:
        Code:
        SELECT"All" As  MgrName FROM tblMain UNION SELECT MgrName FROM
        ...
        See more | Go to post
        Last edited by NeoPa; Sep 10 '09, 06:15 PM. Reason: Please use the [CODE] tags provided.

          Leave a comment:

        • BeaBea
          replied to Record source error
          in Access
          I'm not exactly sure what is causing it. The form has an unbound combo box for the Manager Name, an unbound box for the start date, an unbound box for the end date and a command button to run the report. I thought the problem might be that when a user starts to enter the information in the form, they choose a name from the Manager Name dropdown box, enter the start date and then they decide not to run the report and just close out of it. I am...
          See more | Go to post

            Leave a comment:

          • BeaBea
            started a topic Record source error
            in Access

            Record source error

            I have set up a database so that users can run a report by entering the criteria on an unbound parameter form. Sometimes the form works and then other times it does not and we get the following error.

            The record source '~sq_cParamForm ~sq_cFindMgr' specified on this form or report does not exist.

            This error seems to happen if a user starts to run a report and then exits out of it before they complete it. When this happens...
            See more | Go to post
            • BeaBea
              replied to Count checkboxes and text fields
              in Access
              Chip,

              Sorry for the long delay. For some reason I was not able to get the two queries to work. Beacuase either one of the ysnApproved or the ysnNonComp fields need to be checked, I set the query up with a between date and used Sum(IIf([strTypeofClaim]="IL" And [ysnApproved]=True,1,0)) and Sum(IIf([strTypeofClaim]="IL" And [ysnApproved]=False,1,0)). This worked on the report.

              Thank you so very much...
              See more | Go to post

                Leave a comment:

              • BeaBea
                replied to Count checkboxes and text fields
                in Access
                I apologize for the frequent postings but I am just not able to get it.

                The first query, which I'll call qryProductAppro ved I used the following:
                strProduct (group by), ysnApproved (group by), strtypeofclaim (group by) and ysnApproved (where and then in the criteria row I have yes).

                The second query, which I'll call qryProductNonCo mp I used the following:
                strProduct (group by), ysnNonComp (group by),...
                See more | Go to post

                  Leave a comment:

                • BeaBea
                  replied to Count checkboxes and text fields
                  in Access
                  I tried doing two different queries.

                  First query: Selected, product (group by), claim type (group by), ysnApproved (Where and Yes in criteria row), ysnNonComp (Where and Yes in criteria row). I then joined this query to my existing query but it did not count the records correctly.

                  This is what I want my report to look like, if this helps:

                  IL Approved IL NonComp NewApproved...
                  See more | Go to post

                    Leave a comment:

                  • BeaBea
                    started a topic Count checkboxes and text fields
                    in Access

                    Count checkboxes and text fields

                    Hi All,

                    I am trying to set up a report based on a Select Query. I need to do a count based on four different fields.

                    Field 1: Product Type (text field - 5 different products)
                    Field 2: Claim type (text field - 2 different claim types)
                    Field 3. ysnApproved (Checkbox)
                    Field 4: ysnNonComp (Checkbox)

                    I am trying to get a count of each product that has a certain claim type and if checked...
                    See more | Go to post
                    • BeaBea
                      replied to Select from two combo boxes on form to run report
                      in Access
                      Chip,

                      You are brilliant. That worked perfectly. Thank you so very much !

                      BeaBea
                      See more | Go to post

                        Leave a comment:

                      • BeaBea
                        replied to Select from two combo boxes on form to run report
                        in Access
                        Hi Chip,

                        I so very much appreciate all of your help. I am getting closer to finishing this database.

                        I typed the code you gave me. But when I tried running a report by selecting the Managers name and leaving the DBS name blank it did not return any records. This is what I have for my SQL now.

                        SELECT qryMaster.MgrNa me, qryMaster.strSS N, qryMaster.strCl aimantName, qryMaster.strPr oduct, qryMaster.strTy peofClaim,...
                        See more | Go to post

                          Leave a comment:

                        • BeaBea
                          replied to Select from two combo boxes on form to run report
                          in Access
                          Hi Chip,

                          I think the best way would be to leave the FindDBS field blank.

                          Thank you.
                          See more | Go to post

                            Leave a comment:

                          • BeaBea
                            replied to Select from two combo boxes on form to run report
                            in Access
                            Hi Chip,

                            I changed the SQL a little bit and was able to run a report based on 1 Manager Name and 1 Employee Name. Here is the updated SQL.

                            SELECT qryMaster.MgrNa me, qryMaster.strSS N, qryMaster.strCl aimantName, qryMaster.strPr oduct, qryMaster.strTy peofClaim, qryMaster.ysnAp proved, qryMaster.ysnNo nComp, qryMaster.[curr$$Paid], qryMaster.dtmDe cisionDate, tblDBS.DBSName, tblMain.dtmDeci sionDate AS Expr1, Forms!ParamForm 3.FindMgr...
                            See more | Go to post

                              Leave a comment:

                            • BeaBea
                              replied to Select from two combo boxes on form to run report
                              in Access
                              Hi Chip,

                              Thank you for your reply.

                              The SQL view of my query is:

                              SELECT qryMaster.MgrNa me, qryMaster.strSS N, qryMaster.strCl aimantName, qryMaster.strPr oduct, qryMaster.strTy peofClaim, qryMaster.ysnAp proved, qryMaster.ysnNo nComp, qryMaster.[curr$$Paid], qryMaster.dtmDe cisionDate, tblDBS.DBSName
                              FROM (qryMaster INNER JOIN tblDBS ON qryMaster.strDB S = tblDBS.DBSName) INNER JOIN tblManagers ON (qryMaster.MgrN ame...
                              See more | Go to post

                                Leave a comment:

                              • BeaBea
                                started a topic Select from two combo boxes on form to run report
                                in Access

                                Select from two combo boxes on form to run report

                                Hi All,

                                I have been reading some of the threads in your forum and decided to join and post my question. Hopefully it won't be too lengthy.

                                I have created an Unbound Form called paramform2. This form contains two combo boxes, a text box for the start date, a text box for the end date and a command button that runs the report.

                                The first combo box is named FindMgr. The row source of this box is set to:...
                                See more | Go to post
                                No activity results to display
                                Show More
                                Working...