Search results

JHB...after months of banging my head again Access I finally figured out what was going on...I have the customer form/query working well and the Order form&query working well but I was trying to use TWO different tables to store the details of each other in and THAT was not working. Once I...

If you look at my database it will be visable...I have developed the process to first open the frmCustomer...then button to the frmOrders The frmOrders has fields established from the customer form...CustomerID, Organization name. After that the operator will button over to the detail form of...

I have a similar situation....I have a query that has several tables associated with it. It basically is a monthly form of sales. CurrentMonthOrders I want to be able to enter a date that the apparel is ordered and when the order is complete to be able to check the order complete. Most of the...

I have developed a database for my son's small business but am having a problem with one of my forms/query. I am having problems with my form frmApparelOrderDetail. I know the problems is the query qryApparelOrderDetail but cannot figure out what is happening. When I join the orders table...

JDraw: My son has a small decorated apparel business in Michigan. His customers are mainly schools and sport teams. His customer come to the shop and order very specific items. He does not stock any products. The order process system I am trying to create starts with the customer, the order...

I am only working with the trophy part of the table right now...My sons business has lots of products that they make, Trophies, Transfers, Engraving. I am using one large table but using several forms that feed the table. I also have ApparelOrderDetails that is entirely different aspect to...

I just checked and I really didn't. The query in question is the qryTrophiesDetails. I have attached my database for your inspection. Just when I think I understand a LITTLe of whats going on Access dumbs me up...ugh. S

Why does my query return the PK results instead of the field data? Any suggestions? Really new at this but all my other queries work properly... Appreciate any suggestions. Sharon:confused:

I believe it is...not really sure if I understand yet but will try and apply your response. I will be saying the data as it makes up the order fields. thanks so much for your quick response. I REALLY appreciate help from this forum. S

I am fairly new to Access and I have a complicated query that I am using for order processing. Basically I have a field [BaseStyle] and each basestyle has a prices associated with it. What I want to do is when a person selects from the drop down table the next field [BasePrice] and the...

OH thanks so much....I never thought of it that way. I definitely will do research on google. I use google first before I use this forum as I really do want to learn how to use If statements. Again thanks so much for ALL your help. S

JD....thanks so much...there is only two criteria either "wide" or Round. So would I then have to make another statement that says If wide then .15 or If round then .11? Or something like that? S THANK YOU THANK YOU THANK YOU FOR HELPING ME. I have several other area that this logic will be...

I also have a similar problem with expressions. I am developing a order entry system for my sons business. He makes trophies. What I need is help with part of the pricing. How do I put in to my query that If [ColumnStyle] is Wide then [ColumnPrice] = .11 per inch. There are only two...

In this situation would these all have the same Order Number?

Again I must not be stating my question correctly. I just placed an order for shirts apparel and filled out all the fields and I fill out all the field but I want to do it again with another new item say pants. Same order many items....Access only process the given fields once what trigers...

WOW thanks for all your work. But I still have one unresolved question. I think maybe I am loosing it but I still can't see how I enter multiple items per order....Once you start order on the order form and want to order another item when does the second group of fields present themselves???? s

I am having trouble describing what my problem is. On my form frmOrders I want to be able to order more than one item per order...I want access to create a second line of control fields and then a third etc...It is probably something I am looking right at but can't see. One orderID but many...

I did modify me subform but it won't let me use the continuous form on the main form it says that it has a subform and can't be used. I studied yours and you have done it but not sure why i can't. Also my form does not look like your example. Bummer. ssssssssss

thanks for the help...yes there are three different types of orders...yes and know on the separate orders. I have tried to include the form so that trophies and engraving are handled separately but on the same form. Customer can purchase a plaque and have it engraved or bring there own...

Jump the gun on my first response....you suggested using continuous form but I have a subform and access says you can use continuous with a subform. My order detail field are considerable and I have split them into two forms. Any suggestions? I have attached my database for you to look at...