Recent content by CINQUEFOIL22

Might I add.... You are all Geniuses in my book!!! You were right, I was able to change it. And now it works when I tab over... No worries of the High Jacking, someday maybe someone will learn from it! Again, my deepest Thanks in helping me with this!!

Ok, at first I was gonna respond (whiny voice of course) "brian it isn't working", but then I saw you posted again and when I tried that, as you already knew it would, it worked!! Brian, I thank you for stepping in. I see now what vba was trying to tell me to do. These modules get me very...

Ready to throw my flippin' pc through the wall, even though I know it isn't the dumb one...It's me... I think I did what you told me to do. I created a class module. The left drop down box said general and the right said declarations. This is what I put in. Option Compare Database Public...

Pretty much, yup. I have never done that before so it is pretty new to me.

I am so sorry, but I don't understand what you are saying... I am trying but I am confused...

I think I see...But I am still lost on where I put the variable. Is it a formula? And do I need to put it in each time I open the form?

I am sorry to be a pain, but I am self taught and questions asked when I can't figure something out in Access. I am not sure where this "variable" spot is that you are talking about. But if I am understanding you correctly it is going to put 712 there all the time. But each time I open the...

I have to be honest I am not sure what you are meaning by saving it into a variable. Could you explain?

I love this forum and how quickly everyone answers. I did what you said and sure enough it did load the way I wanted. Now here is my next question. Lets say I fill in the first line's product and it populates 712 for my purchase order number, is it possible to now make my second line for that...

Here is my question, I hope I can explain it so you understand. I have a table in my database "TblPurchaseOrder". From that I created a form "FrmPurchaseOrder" that opens in datasheet view in add only mode for people to enter in the product to be ordered on that purchase order. I currently...

Please disregard my last post...Although it would be nice to have the original entered, I did try what Brian said. I can simply run my report off of the Inventory Receiving List and roll with it that way....It is doing exactly what I need it to do as far as total inventory available...So, either...

Again, thank you for your input, both of you. Maybe I am confusing you? Which, given my nature, I don't think that statement it toooo far from the truth!! :) We want to keep the total quantity received in the receiving list as it was when it came in. Simply for reference. I have the form...

yes, it is....I am so confused....I don't understand...Even though I add the button, where is the data supposed to even show up at that shows the available quantity?

Okay...kinda found a way around my issue....I had the report give me a sum total on the trace code footer....I then inserted a text box with a code that subracts the tracecode total from the tracecode total qty/length received.... A bizzare way around it I guess, but it will work...Do you forsee...

This is the error I am receiving: "Microsoft Office Access can't find the field "I" referred to in your expression." It really isn't an I, it's a line like an I without the top or bottom... I am so confused....