Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2014
    Posts
    12

    Unanswered: Parameter Value dialog pop up when update the query

    ]hi,
    Enter parameter dialog pop up when run the qryUpdateWorkloadAmount

    Below is my SQL view
    UPDATE AuditFees INNER JOIN Workload ON AuditFees.InvoiceID = Workload.InvoiceID SET AuditFees.Workload = [SumOfWorkloadByInvoice].[SumOfWorkloadPerWorkers];

    When i want click run the query, it will show a message box

    Enter parameter meter
    [SumOfWorkloadByInvoice].[SumOfWorkloadPerWorkers]

    This enter parameter dialog box also came out when i key information into form....

    Please have a look for the attachment documents
    5.zip

    Hope anyone can help me. Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    UPDATE AuditFees INNER JOIN Workload ON AuditFees.InvoiceID = Workload.InvoiceID SET AuditFees.Workload = [Enter parameter value];
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2014
    Posts
    12

    Cannot update subform total value into main form

    Hi,
    thanks for you fast replies.
    However, after i change the SQL View til facing same problem

    Actually, I use qry update workload amount to update total value from subform to text box name workload into main form( Audit fees)

    However, after i key all the information from sub form and click button Update workload amount from main form (audit fees).

    The text box name workload from main form does not show out the amount and in blank

    How i want to solve this problem?

    Attachement Documents 6.zip

  4. #4
    Join Date
    Jul 2014
    Posts
    12

    Cannot update subform value to main form

    Hi

    thanks for you fast replies.
    However, i til facing same problem after i change the SQL view.

    Actually, i use qryUpdateWorkloadAmount to update subform total value to main form (audit fees form)

    i will key the information into subform and update the total workload per worker into main form (text box name worklaod).

    However, after i key all information to subform and click the Update workload amount buttoo. The text box name workload does not show any amount and in blank...

    How i want settle this problem?

    Attachement documents
    6.zip

    Thanks.

  5. #5
    Join Date
    Jul 2014
    Posts
    12

    cannot update subform value to mainform

    Quote Originally Posted by healdem View Post
    UPDATE AuditFees INNER JOIN Workload ON AuditFees.InvoiceID = Workload.InvoiceID SET AuditFees.Workload = [Enter parameter value];
    Hi

    thanks for you fast replies.
    However, i til facing same problem after i change the SQL view.

    Actually, i use qryUpdateWorkloadAmount to update subform total value to main form (audit fees form)

    i will key the information into subform and update the total workload per worker into main form (text box name worklaod).

    However, after i key all information to subform and click the Update workload amount buttoo. The text box name workload does not show any amount and in blank...

    How i want settle this problem?

    Attachement documents
    6.zip

    Thanks.

  6. #6
    Join Date
    Jul 2014
    Posts
    12

    Cannot update subfrom value to mainform

    Hi

    thanks for you fast replies.
    However, i til facing same problem after i change the SQL view.

    Actually, i use qryUpdateWorkloadAmount to update subform total value to main form (audit fees form)

    i will key the information into subform and update the total workload per worker into main form (text box name worklaod).

    However, after i key all information to subform and click the Update workload amount buttoo. The text box name workload does not show any amount and in blank...

    How i want settle this problem?

    Attachement documents
    6.zip

    Thanks.

Posting Permissions

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