Query/form help

[e51lrrp]

I am really in need of some expert help and hope that SOMEONE can provide it. I have been working on a project for some time and I am nearing the end but have a HUGE problem with one of my detailed forms.



I have developed a POS database with a frmCustomer, frmOrders and two detail forms. Two forms works frmTrophyDetails and frmPlaquesEngravingDetails. Both of the working forms work off of one table.

Here is the rub. The frmNewApparelOrderDetails does not work. I can see that the information get from the Customer to Order forms/table but my qryApparelOrderDetails will not pick up the orderID. I have rebuilt the tables, query and table trying to solve this issue but I must be doing the same thing as I get the same results. When you go from the Order form through the Apparel button the orderID is there but the minute you try to use the form it disappears. WHY

I am so frustrated and don't know where else to turn. I am developing this for my son's business and I would like to turn the database over to him soon.

I would be forever in your debt if you could look closely at my data base and try using my process to enter an order to the end. The Engraving & Trophy's work it is the APPAREL sequence that WILL NOT WORK.

Thanks in advance for any consideration you can offer.
Sharon
I do no see where I can attach my database as I am in the message area so if you could help me I will attach my database in a thread. I have asked June7 but he is out until March 26th and I am here in Michigan with my son and want to get this resolved so that I can teach his small staff. I am from Myrtle Beach, SC. THANKS

[Ruegen]

I am really in need of some expert help and hope that SOMEONE can provide it. I have been working on a project for some time and I am nearing the end but have a HUGE problem with one of my detailed forms.

I have developed a POS database with a frmCustomer, frmOrders and two detail forms. Two forms works frmTrophyDetails and frmPlaquesEngravingDetails. Both of the working forms work off of one table.

Here is the rub. The frmNewApparelOrderDetails does not work. I can see that the information get from the Customer to Order forms/table but my qryApparelOrderDetails will not pick up the orderID. I have rebuilt the tables, query and table trying to solve this issue but I must be doing the same thing as I get the same results. When you go from the Order form through the Apparel button the orderID is there but the minute you try to use the form it disappears. WHY

I am so frustrated and don't know where else to turn. I am developing this for my son's business and I would like to turn the database over to him soon.

I would be forever in your debt if you could look closely at my data base and try using my process to enter an order to the end. The Engraving & Trophy's work it is the APPAREL sequence that WILL NOT WORK.

Thanks in advance for any consideration you can offer.
Sharon
I do no see where I can attach my database as I am in the message area so if you could help me I will attach my database in a thread. I have asked June7 but he is out until March 26th and I am here in Michigan with my son and want to get this resolved so that I can teach his small staff. I am from Myrtle Beach, SC. THANKS

Your setup

I am guessing you set up a customer first, then make an order then make a new apparel record and put the order ID into each item?

[e51lrrp]

I finally figured it out...it basically was my set up. I was trying to have two detail tables and I was confusing Access. I fixed it by only have ONE large detail table. So now my process is to fill out the Customer form then Order form and then go to the three different forms for the details but they all work off of ONE table. By being new and not understanding all of the workings of access I have spent MANY months bumping my head against the system.

I do have one other problem at this time and that is an expression problem. The following statement works but produces will not produce any data if there is a price missing in either of the price fields. ApparelTotal: (([XS]+[SM]+[M]+[LG])*[RetailPrice])+([XL]+[2XL]+[3XL]+[4XL])*[RetailXLPrice] After reading I know I have to use the Nz function but cant seem to make it work properly. My attempt: ApparelTotal: Nz(([XS]+[SM]+[M]+[LG])*Nz[RetailPrice])+([XL]+[2XL]+[3XL]+[4XL])*Nz[RetailXLPrice]

Any help you can give me would be appreciated. Thank so much for your last help. Sharon

[Ruegen]

I finally figured it out...it basically was my set up. I was trying to have two detail tables and I was confusing Access. I fixed it by only have ONE large detail table. So now my process is to fill out the Customer form then Order form and then go to the three different forms for the details but they all work off of ONE table. By being new and not understanding all of the workings of access I have spent MANY months bumping my head against the system.

I do have one other problem at this time and that is an expression problem. The following statement works but produces will not produce any data if there is a price missing in either of the price fields. ApparelTotal: (([XS]+[SM]+[M]+[LG])*[RetailPrice])+([XL]+[2XL]+[3XL]+[4XL])*[RetailXLPrice] After reading I know I have to use the Nz function but cant seem to make it work properly. My attempt: ApparelTotal: Nz(([XS]+[SM]+[M]+[LG])*Nz[RetailPrice])+([XL]+[2XL]+[3XL]+[4XL])*Nz[RetailXLPrice]

Any help you can give me would be appreciated. Thank so much for your last help. Sharon

Huh? One table?

I don't know what version of access you are using but you can make 3 tables - it's relational. It's the relationship between the tables. One large table means you can't have more than 1 per customer per order unless you renters the same data each time.

1 customer
Many orders
Many products

3 tables.

You make a customer, that customer I'd goes into the order and then for each order you select however many products you want to add per order.

This way you can retain one customer to have many orders - if you get the same customer return to purchase again then you can place an order or see their history of orders (which you can make a query to see their history of products)