Search results

I have searched for this, but can't find a solution that works. I have 3 combo's all of which were created the same way, the 3 were added at a later time. When I added them I used the format painter to copy over the same "Look" of all the colors... well only the first of the 3 keeps the color...

grr I always do this to myself.. I was referring to the wrong control cobQID... should have been txtQHeadID so don't mind me :) Thanks if you started looking

Hi, thanks in advance... I have a main form with a subform, on the sub I have a button to bring up another form to make some selections which enter the data to the subform in one action... so this works perfectly... My issue is I also add Modify options so after the user makes their initial...

Thanks for setting me straight, I just assumed it was all inclusive in the package.

Hi, Hope you don't mind me waking up this old Post, but I am having a hard time finding an answer to what appears to be an identical issue for me.. I have Access 2007 on W7 Pro, I downloaded the Run time, and installed it etc etc.. I don't see the Developer Option, and I don't see the Addin...

ok John, I'll test out the logic tomorrow. vbainet... the way I set it up is there is a table with one field, and one record... a serial number.... in the code I loop through the recordset, and I use the qty field to control a loop that will repeat the current record, at the same time i read...

thanks John, just looking at it ( at a glance) I don't see where it would take an entire row and copy to another table, it just lookes like it is updating values based on criteria. What I have done for now is stripped down the table I want to create and only used key fields... only 5 fields...

I need to read each record and loop it based on the quantity field, so if a record has a quantity of 3 then the record needs to be duplicated 3 times. The reason I am doing this is because I need to add a serial number to each line. this is an order file and I am creating a label file with a...

not a chance, I've been using it for a year ( Access for 10+), it is a lousy design, I have no trouble using it or organizing it... I just don't like the "fixed" position" and the loss of object descriptions in ( I know it is in properties still). I'm stuck with 2007 because my company will not...

ok so that was really annoying, I kept unhiding and rehiding and finally I was able the use the option to "UNHide in this group" by Right clicking on the table... that option would not show up previously... very annoying. I still hate Access 2007

I hid this table previously, then went to Navigation options to add the check back beside the table, but it won't show... I checked the whole list in case it popped up in another group, so then I went back to navigation options to show hidden objects, and there it is, but still grayed out.... so...

Thanks for everyone's Help!

Excellent BOB, I hate solutions like this that make sense but you wouldn't think you need to do. So I removed the set focus from the subs, and instead of adding another control I just moved focus to the other control and then immediately back, and this seems to work? Private Sub...

I know, that's why I thought having it in the sub would do it? At the very least in the same place where I was clearing the control? Makes no sense to me.

thanks Bob, cleans things up, but still not getting the focus working. I was not expecting this to be a problem. I guess I'll just use the Tab Stop Property set to NO on the other controls as that seemed to work.

the rs is used all through out, but go ahead

you're correct, but that is a typo, if you look at the original post, I had it right in there, and just changed it again and still does not bring me back

lets Regroup, because we’re all over the place let me clarify..... frmRF is the form name... there are 2 unbound controls... txtMB & txtUPC, then the subform which is bound to tblRFpick the primary function is I start with cursor in txtUPC, then Scan a UPC and it updates tblRFpick ( through...

gives me a type mismatch ( I fixed the RE ref you had) # 2 I'll look at later, but thanks Not sure how this helps me? The Me.txtUPC = "" is working, but I am not getting the focus after that where the cursor is in the field... you suggestion does the same.

actually I don't go to any other controls, I use code to update the table and clear the field for the next scan... it just ends up at the first control of the subform... what you suggest does not make sense because that sub form control will never be empty or null? here is my code if it helps...