Generate TOTAL count from non-database entries

[FriQenstein]

Hello all,

I'm working on a form, that generates a report, for incoming shipments. The incoming shipment has to have an invoice generated for verification of item received. I have the form setup so that the user can input the information and then print the RCVR invoice with the pertinent information.

The issue I am having is, unlike using the =Count(*), I cannot do that with this situation because the items are not physically coming from the DB. The text fields are manually entered and then the report is generated from the corresponding fields. How would I go about counting the total items listed on the form?




I'm assuming I would have to use some VBA code and set variables for each of those Qty boxes that can then be tallied upon the report being generated?

Any assistance would be greatly appreciated.
Thanks.

[CJ_London]

are you saying the each row consists of unbound controls? - 10 rows, 50 controls?

[Micron]

Confusing. You can't use Count, but you want a total? They are not the same thing even though in the sample you show the resulting calculation is the same. Change one of those values to 2 and the count is 4, the total is 5. This is confusing too

the items are not physically coming from the DB

what does that mean? I think you mean the data isn't coming from the db, but then from where if not the db?

[ranman256]

If they are typing in entries ,it's in the database.
then do count().

[FriQenstein]

are you saying the each row consists of unbound controls? - 10 rows, 50 controls?

Currently, yes.

[FriQenstein]

Confusing. You can't use Count, but you want a total? They are not the same thing even though in the sample you show the resulting calculation is the same. Change one of those values to 2 and the count is 4, the total is 5. This is confusing too what does that mean? I think you mean the data isn't coming from the db, but then from where if not the db?

In the example I provided, there is no resulting calculation... the Total field is empty.

"what does that mean? I think you mean the data isn't coming from the db, but then from where if not the db?"
The data is not coming from the DB because it has not yet been entered into the DB. As I mentioned, this form is simply to create an Incoming invoice from equipment that has just arrived so, no, it is not yet in the DB. That happens after the invoice has been created.

[FriQenstein]

If they are typing in entries ,it's in the database.
then do count().

Again, as I already mentioned, no, the data is NOT in the DB. This information is ONLY to create an invoice. After the invoice is created, they will enter the items into the DB accordingly.
So no, just because they are typing in entries does not mean it's in the database.

[CJ_London]

are you saying the each row consists of unbound controls? - 10 rows, 50 controls?



Currently, yes.

in at case you need code something like this

Assuming your qty controls are called qty1, qty2 etc

dim i as integer
dim c as integer
c=10
for i=1 to 10
  c=c+isnull(me("qty" & i))
next i

Have to say, it's not the way I'd do it, but each to their own

[FriQenstein]

in at case you need code something like this

Assuming your qty controls are called qty1, qty2 etc

dim i as integer
dim c as integer
c=10
for i=1 to 10
  c=c+isnull(me("qty" & i))
next i

Have to say, it's not the way I'd do it, but each to their own

They are indeed labeled Qty1, Qty2, etc.
I would be open to hearing your suggestion as to a better way of doing this.

Thanks.

[orange]

Can you post a copy of this so readers can see what you have and what you need?

[FriQenstein]

Can you post a copy of this so readers can see what you have and what you need?

Post a copy of...?

[CJ_London]

I would be open to hearing your suggestion as to a better way of doing this.

use a table - might be a holding table, might be the destination table with a flag field to indicate status - such as not approved/printed/invoiced

edit: further suggestion - if the idea is not to commit to the db until all information is entered, consider using an ado disconnected recordset or with dao use the begintrans/commitrans functions

[orange]

A copy of the database you have. You have a form and some controls and related logic.
I see ajax has suggested a temp/holding table which is where you could/would store values for history/audit purposes.

[FriQenstein]

use a table - might be a holding table, might be the destination table with a flag field to indicate status - such as not approved/printed/invoiced

edit: further suggestion - if the idea is not to commit to the db until all information is entered, consider using an ado disconnected recordset or with dao use the begintrans/commitrans functions

Thanks. I will look into this.

I know this all seems odd, but I do this for a reason. As you mentioned, when equipment comes in, we first create an invoice indicating its arrival. However, there are times where the shipment is in transit or the client may change their mind and now want it repaired, so upon those instances, we do not put the items into the DB until confirmed.

Again, I know this is not the normal way, but I created this form for this entry simply as a go-to method to at least indicate the shipment arrived and is sitting in the warehouse unattended until confirmation from the client has been received.

Thanks for the tips. I will look into the suggestions and get back to this post.