Inventory Audit Form

[Lou]

Good Day!

I am trying to create an inventory udit form that will
give me the totals of my coupon and a cell in which they
type the physical inventory and then I will create a
balance cell.

What I need help on is how to show each coupon name, with
a total, beginning Coupon Number and Ending Coupon Number.

I have a query which my form will be based off of and
currently it has these 3 results.
[Type]
[Coupon Number]
[Issued] - to ensure that it is present..

I have 150,000 coupons of one kind and various amounts on
others, I have created an inventory report which gives me
this data but I dont know how to do it in a form.?
Ideas and suggestions would be great.

Access 2002
Thank you.
Lou

 

[Pavel Romashkin]

I am very sorry, but I have not the slightest idea about what is it that
you have in the database. Whet would be helpful to know is, what fields
you have in what tables, and what the relationship is between the
inventory and coupons.
I know this sounds silly but people have no idea about your database,
and often ignore the question if it assumes some familiarity with the
particular database.
Pavel

 

[Lou]

Thank you Pavel;

Ok,
Table name is "Master Table"
Fields are as follows;
[Log Number] - Auto number
[Type] - Type of coupon, text field
[Coupon number], number field
[Issued] - has it been issued, number field
[Issued date], date field

The query I have built "qryAudit" draws of the "Master
Table" from the following fields, [issued], [type] &
[coupon number]. Criteria in the [issued] field are set
for 0 identifying only coupons that have not been issued.

I am trying to build a form that will show each [type] of
coupon with a total amount of that type and the beginning
number and ending number.

I have a report built that gives me inventory sheets with
this information currently, I want to be able to go take
an inventory with my report then open a form which looks
almost identical to the report where I can enter my
physical inventory count of each coupon. Then I want to
formulate a text box to take the system reported total for
that coupon and calculate the variance against the
physical inventory.

I hope this makes sense. Let me know your thoughts and
thank you for your help.

Lou

-----Original Message-----
I am very sorry, but I have not the slightest idea about what is it that
you have in the database. Whet would be helpful to know is, what fields
you have in what tables, and what the relationship is between the
inventory and coupons.
I know this sounds silly but people have no idea about your database,
and often ignore the question if it assumes some familiarity with the
particular database.
Pavel

Good Day!

I am trying to create an inventory udit form that will
give me the totals of my coupon and a cell in which they
type the physical inventory and then I will create a
balance cell.

What I need help on is how to show each coupon name, with
a total, beginning Coupon Number and Ending Coupon Number.

I have a query which my form will be based off of and
currently it has these 3 results.
[Type]
[Coupon Number]
[Issued] - to ensure that it is present..

I have 150,000 coupons of one kind and various amounts on
others, I have created an inventory report which gives me
this data but I dont know how to do it in a form.?
Ideas and suggestions would be great.

Access 2002
Thank you.
Lou

.

 

[Guest]

*bump*

-----Original Message-----
Thank you Pavel;

Ok,
Table name is "Master Table"
Fields are as follows;
[Log Number] - Auto number
[Type] - Type of coupon, text field
[Coupon number], number field
[Issued] - has it been issued, number field
[Issued date], date field

The query I have built "qryAudit" draws of the "Master
Table" from the following fields, [issued], [type] &
[coupon number]. Criteria in the [issued] field are set
for 0 identifying only coupons that have not been issued.

I am trying to build a form that will show each [type] of
coupon with a total amount of that type and the beginning
number and ending number.

I have a report built that gives me inventory sheets with
this information currently, I want to be able to go take
an inventory with my report then open a form which looks
almost identical to the report where I can enter my
physical inventory count of each coupon. Then I want to
formulate a text box to take the system reported total for
that coupon and calculate the variance against the
physical inventory.

I hope this makes sense. Let me know your thoughts and
thank you for your help.

Lou

-----Original Message-----
I am very sorry, but I have not the slightest idea about what is it that
you have in the database. Whet would be helpful to know is, what fields
you have in what tables, and what the relationship is between the
inventory and coupons.
I know this sounds silly but people have no idea about your database,
and often ignore the question if it assumes some familiarity with the
particular database.
Pavel

Good Day!

I am trying to create an inventory udit form that will
give me the totals of my coupon and a cell in which they
type the physical inventory and then I will create a
balance cell.

What I need help on is how to show each coupon name, with
a total, beginning Coupon Number and Ending Coupon Number.

I have a query which my form will be based off of and
currently it has these 3 results.
[Type]
[Coupon Number]
[Issued] - to ensure that it is present..

I have 150,000 coupons of one kind and various amounts on
others, I have created an inventory report which gives me
this data but I dont know how to do it in a form.?
Ideas and suggestions would be great.

Access 2002
Thank you.
Lou

.

.

 

[Pavel Romashkin]

Lou,

I apologize for not replying sooner - I have been out of reach for a
while. Too bad none of the MVPs replied - your explanation is now more clear.
I think that parts of what you want to have on the form may not be easy
to implement. In particular, to get totals, beginning and ending numbers
for the coupons per type is trivial (using a GROUP BY query), but the
resulting recordset is, alas, not updateable. Therefore the form will
not work for inventory data entry.
There are worarounds. I think you could either use the form based on the
GROUP BY for displaying the data to the user, and place the actual data
entry form right below it. You could even populate fields in code. But
the simplest I think would be, to make a separate, simple, popup data
entry form that you can launch from the main form (which would look kind
of like your report).
As far as doing the audit, seems to me it is a simple duplicate query.
Care to give more details on that? I think one way to do that would be
to group by coupon number, then list the count and the dates the c.
number was entered.

Hope this helps. Again, sorry fo the delay.
Best of luck,
Pavel

Thank you Pavel;

Ok,
Table name is "Master Table"
Fields are as follows;
[Log Number] - Auto number
[Type] - Type of coupon, text field
[Coupon number], number field
[Issued] - has it been issued, number field
[Issued date], date field

The query I have built "qryAudit" draws of the "Master
Table" from the following fields, [issued], [type] &
[coupon number]. Criteria in the [issued] field are set
for 0 identifying only coupons that have not been issued.

I am trying to build a form that will show each [type] of
coupon with a total amount of that type and the beginning
number and ending number.

I have a report built that gives me inventory sheets with
this information currently, I want to be able to go take
an inventory with my report then open a form which looks
almost identical to the report where I can enter my
physical inventory count of each coupon. Then I want to
formulate a text box to take the system reported total for
that coupon and calculate the variance against the
physical inventory.

I hope this makes sense. Let me know your thoughts and
thank you for your help.

Lou

-----Original Message-----
I am very sorry, but I have not the slightest idea about what is it that
you have in the database. Whet would be helpful to know is, what fields
you have in what tables, and what the relationship is between the
inventory and coupons.
I know this sounds silly but people have no idea about your database,
and often ignore the question if it assumes some familiarity with the
particular database.
Pavel

Good Day!

I am trying to create an inventory udit form that will
give me the totals of my coupon and a cell in which they
type the physical inventory and then I will create a
balance cell.

What I need help on is how to show each coupon name, with
a total, beginning Coupon Number and Ending Coupon Number.

I have a query which my form will be based off of and
currently it has these 3 results.
[Type]
[Coupon Number]
[Issued] - to ensure that it is present..

I have 150,000 coupons of one kind and various amounts on
others, I have created an inventory report which gives me
this data but I dont know how to do it in a form.?
Ideas and suggestions would be great.

Access 2002
Thank you.
Lou

.