Search results

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....

James, Firstly, I really want you to know I do appreciate the help you are giving me. If not for this forum, I would still be at square one!! When I click the button icon to add to my form it gives me a bunch of options. I am using the form operations selection,but i have to be honest in...

And as usual in my case, I am getting errors... I am assuming (Please correct me if I am wrong) that I needed to replace parts of your code with my field names...So this is what I typed in: docmd.runsql "UPDATE Productused SET [quantity field]=[qtyused]-" & me.[qty_used] & " WHERE...

I have to be honest in that I don't know what you're talking about....

Okay. I have a table we use when we receive in inventory. (Table is "InventoryReceivingList") It is all tracked by a 3 letter trace code (which the product is marked with). I have another table where the guys simply type in the 3 letter trace code and the qty they are using (Table is...

Brian, Bossman = Happy man. However, he has brought me more confusion. I did add a form that allows for the guys on the floor to log what they take out by simply typing in the trace code and the qty. He wants me to be able to run a report that states how many are left of the said product...