Recent content by escoyne

Thanks for the guidance John. Got everything works like I want it..

Thanks John. Got the first part working. I understand the reasoning on why not to store the value because of the variables. How do I calculate the taxes and have them print on my invoice? Keep in mind that not all customers pay taxes on their transactions.

I'm a newbie to Access and I need some quick help. I'm trying to figure out if these two things can be done.. 1) I have a check box labeled "Payment Received?". The color of the font is red. What I would like to happen is when the check box is checked, the font color changes to red to...

Thats kinda what I was looking for initially. Here's what I done so far. Can you help me out with the SQL Append query?

Ok, i changed that into a different table. But still the same thing FYI-- I'm a newbie with Access so I'm going on the fly with all this

Thanks Bob Just a quick question, why doesnt the product name stay on the first line, when you change the category on the second line?

I'm having trouble with my cascading boxes. I cant get the second combo box to pull the info based on the first combo box. Here's the dB.

FIRST OFF, I do want to help my!!.. Go back to my orginal post and reread what I'm asking help with. I've got the cascading combo boxes already. I'm trying to figure out how to add my products into my subform. The VBA code that i'm using isn't work. thanks anyways

Hmmm? The Northwind DB that I have doesnt have casading combos..

Yeah, I looked at it. Not quiet what I was looking for. In the sample DB, there is only 77 products. I have over 770 products! divided into 5 categories.

OK, i need some really quick help... I'm trying to create an sales receipt / invoice form. On the form, I choose a catergory, then product (both combo boxes). I have a command button that I would like to be able to click and add the product to my subform. I've searched here and seen some...

WOW, that makes for alot of products...

Ok, I'm trying to see what woud be the best way to do this. I have products that have two different prices based on the color. Would it be best to have the two prices in a table? or would it be easier to use a multiplication type function to get the pricing based on the standard price? Keep...

Yeah, the risks were what I was working on when the error message came up.

Tables look good. I guess there was too much in that one table. Now I just got to put it all back together..lol:D