ACCESS FEED: Re: [MS_AccessPros] Re: Invoice totals

Rabu, 11 Februari 2015

Re: [MS_AccessPros] Re: Invoice totals

Hi Crystal
My parents named me Bill because I was due on the first.

Just kidding

-Bill

Sent from my Kindle Fire

From: "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Wed Feb 11 13:28:36 PST 2015
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Invoice totals

so many Bills ... on a thread about Invoices ... I just thought that was funny ~

Warm Regards,
Crystal

Projects, Tasks, and Time in contact Template for Microsoft Access (cc)
https://www.youtube.com/watch?v=0PupznJcrWU
- Keep track of projects, tasks, and time spent on projects

~ have an awesome day ~

On Wed, 2/11/15, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: [MS_AccessPros] Re: Invoice totals
To: MS_Access_Professionals@yahoogroups.com
Date: Wednesday, February 11, 2015, 1:11 PM

Bill - If you set yours up like Northwind Orders form and it
still doesn't work, you probably need the hot fix I
mentioned earlier.
Bill

---In MS_Access_Professionals@yahoogroups.com,
<Bill.Singer@at-group.net> wrote :

Bill,

I found a copy of the database. I am going to search for
the form.

Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]

Sent: Wednesday, February 11, 2015 9:55 AM

To: MS_Access_Professionals@yahoogroups.com

Subject: RE: [MS_AccessPros] Invoice totals

Bill, The old Northwind (2003 version) Orders form has a
subform with a hidden total text box and the main form has a
text box that has that hidden control as its
ControlSource.

If your main form is not updating it might be due to a bug
in Access 2010. Hot fix is at <http://support.microsoft.com/kb/2899528>;
http://support.microsoft.com/kb/2899528

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com>
, <Bill.Singer@at-group.net
<mailto:Bill.Singer@at-group.net>
> wrote :

John,

I knew that. What was I thinking? I am a Knucklehead.

Now the field works on the initial calculation when I open
to the record the first time. I can't seem to get it to
repaint as I update the sub form.

On my subform ( sf_InvoiceItems) I have a field called
ItmQty . I would like the field we have been working on
(IncSubTotal on the form f_InvoiceCreation) to update each
time I exit the ItmQty field.

I attempted to put a macro in. No luck. I attempted some
code and it bombed.

I tried this as well as a few other things.
DoCmd.Requery (Forms![f_InvoiceCreation]![IncSubTotal])

I am not sure if the Requery method is the correct way to do
this since the field is not based on a query.

What do you suggest to get that field to repaint?

Thanks

Bill

Minnesota

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com]

Sent: Wednesday, February 11, 2015 4:02 AM

To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com>

Subject: Re: [MS_AccessPros] Invoice totals

Bill-

NEVER NEVER NEVER store the result of a calculation in a
table. If you're intending to store this in the invoice
table, the value will be wrong as soon as anything changes
in t_invoiceitems. Just re-calculate it when you need
it.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On
Feb 10, 2015, at 11:31 PM, 'Bill Singer' Bill.Singer@at-group.net
<mailto:Bill.Singer@at-group.net>
[MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com>
> wrote:

John,

This worked. See below. Yea.

DSum("[ItmQty] *
[ItmPrice]","t_InvoiceItems","ItmIncID=[Forms]![f_InvoiceCreation]![IncIncID]")

Now that I have the field calculating I just have to figure
out how to get it to fill the proper field on the table.

Since I put this in Control Source I do not think the value
is getting back to my field IncSubTotal.

I will see what I can do. I am thinking a hidden field tied
to the table/query which is equal to the field above.

Thanks,

Bill