Results 1 to 15 of 15
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Formula Problem (2000)

    Pat,

    Here's the database you asked me to post to see about geting past the error message when frmPaymentAdd is opened up.

    Thanks,
    Leesah

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    What database?

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Problem (2000)

    Oops, sorry, was on my face from work.

    Leesha
    Attached Files Attached Files

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    You had at least 4 references to frmPayment rather than frmPaymentAdd in the subform frmPaymentAllocationsAdd. This is always a problem if you copy a form to another name.
    The AmountRemaining on form frmPaymentAllocationsAdd pointed to frmPayment.
    The record source of xxx needs to be tblPaymentAllocations.
    In your code behind the form in the Form AfterUpdate there are 2 occurances here.

    You also have to make frmPaymentAllocationsAdd a continuous form.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    I cannot seem to edit my previous response.
    You will have to change the record source of your form frmPayments to include just tblPayments. What is your idea of including the Invoice number in the form header? I believe that this is not required, however, you will correct me I'm sure.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Problem (2000)

    >> What is your idea of including the Invoice number in the form header?

    <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20> Pat, I am probably to blame for that. In the database I posted in the "CustomerID not found" thread, I put it in the header of frmPayment (as it was called there) temporarily to be able to see if it would be filled automatically and correctly.

    >> I cannot seem to edit my previous response

    If you don't see the customary buttons in the right hand side of the subject bar of your own post (see screenshot), you may need to log out and log in again, or perhaps delete your wopr.com cookie (it will be created anew next time you log in).
    Attached Images Attached Images
    • File Type: png x.PNG (1.5 KB, 0 views)

  7. #7
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Problem (2000)

    OK, I'll go back and take a look for all those things. Jeeze! So much for copying forms. I keep telling myself I'll learn to love Access but....................................
    BTW Hans, thanks for responding to Pat's question. I've reworked this stuff so much I couldn't remember if it was me who put it there or not!!!

    Toodles,
    Leesha

  8. #8
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Problem (2000)

    Hi Pat,

    Back again. I went through and tried to find all the references to frmPayment and changed them to frmPaymentAdd.

    l wasn't sure what you meant by ...."The record source of xxx needs to be tblPaymentAllocations" What does XXX refer to??

    Alas, I'm still getting that error message on open. This is like a word search puzzle. I simply can't find any other places where there is referecne to frmPayment, but I'm confident I missed one and you'll let me know!! <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

    At least this time I remebered to attach the file!!

    Thanks,
    Leesha
    Attached Files Attached Files

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    Hi Leesh
    There are 3 remaining problems:
    1. The record source of frmPaymentAllocationsAdd should be tblPaymentAllocations.
    2. The record source of frmPaymentAdd should only reference tblPayments, take out the references to tblBilling and tblPaymentAllocations.
    3. The Child and Master links of frmPaymentAllocationsAdd should be PayID.

    I think that's all there is.

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    Thanks for your input Hans.

    >>If you don't see the customary buttons in the right hand side of the subject bar of your own post (see screenshot), you may need to log out and log in again, or perhaps delete your wopr.com cookie (it will be created anew next time you log in).

    I think I know what the problem is, I find I need to Refresh screens quite (heaven knows why) often and sometimes I forget to Refresh and I get an old message to change. In other words if I change a message more than once and I don't refresh it screws me up. The buttons are there.

  11. #11
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Problem (2000)

    Oh God Pat, it works!! Thank you yet again!!! Of couse now it frees me up to move on to the next step and of course you know it will mean more questions tee hee.

    Leesha

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    After receiving your DB via email, I have noticed that when frmPayments is opened it asks for AccountID.
    I believe you should reintroduce AccountID in tblPayments, then change the SELECT statement in the record source of frmPayments to include the AccountID. The list of o/s invoices shows all invoices in the system, unless you want to do this of course, but it doesn't make sense to me. Why select an Account to go to the frmPayments?

  13. #13
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Problem (2000)

    >>After receiving your DB via email, I have noticed that when frmPayments is opened it asks for AccountID.

    Uhm, you mean frmPaymentAdd asks for AccountID. frmPayment opens from frmAR to the specific InvoiceNo on frmAR. That's working the way I want. (I hope)

    >>I believe you should reintroduce AccountID in tblPayments, then change the SELECT statement in the record source of frmPayments to include the AccountID.

    Let me be sure I understand, I'm going to add a field called AccountID to tblPayments. Will this field be linked back to AccountID in tblDemographics?? I originally had a field called CustomerID (so I keep them straight) in tblPayment but took it out based on advice of the lounge.

    >>The list of o/s invoices shows all invoices in the system, unless you want to do this of course, but it doesn't make sense to me.

    Nope, I want it only to show the invoices for the AccountID selected from frmPaymentName. AND I want frmPaymentAdd to open to a new record so the user can post a new payment. This is where new payments are posted/allocated. frmPayment which opens from frmAR is simply used to edit payments that were entered incorrectly.

    >>Why select an Account to go to the frmPayments?

    Consistency Pat, consistency. Besides, I figured it was the way to then ensure that only the invoices that pertain to that AccountID are in the list box.

    So, do you regret asking me to send the whole database??? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Leesha

  14. #14
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Formula Problem (2000)

    >>Uhm, you mean frmPaymentAdd asks for AccountID.
    Yes, you are right.

    >>Will this field be linked back to AccountID in tblDemographics?? I originally had a field called CustomerID (so I keep them straight) in tblPayment but took it out based on advice of the lounge.
    Yes for the field to be linked back to tblDemographics, but it's now AccountID not CustomerID.

    >>Nope, I want it only to show the invoices for the AccountID selected from frmPaymentName. AND I want frmPaymentAdd to open to a new record so the user can post a new payment. This is where new payments are posted/allocated. frmPayment which opens from frmAR is simply used to edit payments that were entered incorrectly.
    You will need to filter the SELECT statement in the list on AccountID. You can force frmPaymentsAdd to go to a new record by changing the OpenForm command, it has a parameter that can force this.

    >>So, do you regret asking me to send the whole database???
    No.

  15. #15
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Problem (2000)

    OK, I'll give these things a shot and see if I can get it working. I'm sure to be back!!!

    Leesha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •