Search results

ProductTypeID is for the shipping so I can assign the shipping rates depending on the type of product it is. So do you see anything else? I'm looking for any and all input... do you see anything else that could be split into another table?

Ok so I decided to start over because I really messed up :mad:. Thats ok I'm learning lots! So I have spent much time trying to make sure my tables are normalized as much as I possibly can have them. I did a ton of reading and research and I kept reading that Access Databases work best when...

ok I follow you....

This is in the form for the orders correct? So would this be like a split form in datasheet view? Would it be like cutomer info on top with all their addresses below? And this would also be in the form for the order? I think I understand that part

New customer. So could I have the recipient field work in combination with the addresses table? I'm working on it. Yes ok that is what I was thinking.

OH I was so close! Thanks for the help! Notes taken for future reference!

what I kept running into was I couldn't get the text to change and if i deleted all the text the text box obviously was removed also.

ok so now i'm playing with this for the form caption can you see what is wrong with it I can't figure it out. Private Sub Form_Current() Me.Caption = "Customer:& " " & IIF([FirstName] AND [LastName] Is Null, "New Customer", Me!FirstName.Value & " " & Me!LastName.Value) End Sub I'm sure it is...

Yeah buddy I figured something out on my own... I got the right titles to show in the form not the window caption still working on that one.... On the form I put two titles one "Edit Customer" and the other "Add Customer" I set the alignment exactly the same on both they are identical just...

ok and how about the title of the form? I have been playing with it and I can't figure it out

where do I put this?

Oh I just thought of something is there a way to change the title that is visible on the form depending on what action the form will be performing ie. adding, editing?

I combined my form that fills in tblOrderHeader and the form that fills in tblOrderDetails into one form. So now i'm thinking that I should have a contnious form that lists all orders and from there I have buttons for adding new orders, and editing existing orders (I'm using orders meaning an...

ok so just to make sure i understand because I think you are on the same lines as I am I have just a couple clarifying questions if that is ok... 1) When I enter a new customer would I enter Just the billing address and the current shipping address for that order? 2) How would you handle...

Ok so in working on this I got to wondering.... would it be better to create the data for tblOrderHeader and tblOrderDetails at the same time instead of two seperate forms.

Is there a way to have a checkbox determine if fields in a form auto populate? I usually keep billing and shipping addresses seperate but I was trying to think of a way to condense it down so I was thinking would it be possible to have a checkbox that is if shipping is same as billing it would...

thank you! Still working on it....

After much long hard thought I have decided to just change the current forms in my DB project and condense them into one form as recommended by some very helpful individuals on these forums. I currently have one form to add new orders which fills in my tblOrderHeaders with the orderid...

oh crud I haden't thought about that! :eek:

I'm kinda feeling like I am starting over... I know i'm not but with all the changes I feel I need to make It seems like I might as well....