Search results for query: *

DUH. THANKS ROY-VIDAR! That's the one. I don't know why I didn't bother checking that one, and of course, that's what I was looking for. Thank you so much! Holy tek-tips batman!:-0

Hi All, I know I can do something with Excel, I don't remember how, or what it's called, so I can't even search the help files. Somehow, you can have excel place a scrolling drop down type box at the top of the columns, so you can look through one column all at once, and not have to scroll...

All the action is happening in the subforms though. Would this work in the afterupdate of [A]? forms![A)![B].form.requery Holy tek-tips batman!:-0

Hi All, quick question! I've got a form with 2 subforms: one data entry(A), one displaying records(B) that may or may not have just been added using the data entry subform. How can I make the records show up in B as they are entered in A? Something in the afterupdate event telling B to...

Gracias Ace!! Works like a charm. Karma, I agree that though two seperate entries would assure accuracy, it would involve a lot more manpower than we have to give it. The copy/paste issue is a good thing to think about as well, I'll caution folks to resist the urge. :) Thanks again all...

Thanks guys! I'm out for the day, but I'll look into it on Monday! Thanks again for the help! Holy tek-tips batman!:-0

I'm entering keycodes for software into a database. We have such a huge volume that when a key gets entered incorrectly, it's a super time consuming job to find the error. I need to verify the keycode, and the easiest way is to have the person entering the key do it twice. Here's what I was...

Thank you so much. Sorry for being such a pain about something so simple. Thanks again! Kate Holy tek-tips batman!:-0

Am I supposed to put something in the () in the 'count (*)' bit? And I assume this is an entirely new query I'm making here, right? Holy tek-tips batman!:-0

Thanks guys, Both of these look fairly easy, but where's the best place for them? I'm sure this should be obvious too.... Thanks so much for your help! K Holy tek-tips batman!:-0

Hi All, I KNOW there's a way to do this, but I can't remember how, or where would be the best place for it. One to many relationship between Tbl A(one) & Tbl B(many). I want to be able to count how many records there are in B related to record 1 in A, etc. It must have something to do...

YES YES YES! That is EXACTLY what I was looking for!!!!! THANKS! You have no idea. This may seem trivial to you, but it will same me so much time! THANKS AGAIN!!! Kate Holy tek-tips batman!:-0

Fantastic! Thanks a bunch! Kate Holy tek-tips batman!:-0

That would work, but I may be entering more than one record in the subform, so I wouldn't necesarily want to be kicked out after the last field. I was kind of looking for a keystroke that would move me on to the next tab stop in the main form. Thanks though! Kate Holy tek-tips batman!:-0

Is there a way, when you're tabbing through a form, to get out of a subform with a keystroke instead of having to use the mouse? Just wondering. Thanks! Kate Holy tek-tips batman!:-0

I have tried saving the form, then using the button to print the other form, but that doesn't work either. Holy tek-tips batman!:-0

thread702-529182 Here's my orignal thread. Basically, what I need to know is: What happens to a form and it's contents when you move to the next record, and how can re-create that action so when I use my print button, the calculation feilds will update? THANKS!!! Holy tek-tips batman!:-0

Ok. The button works, but the info is still not printing until I create a new record. This is mighty frustrating. Holy tek-tips batman!:-0

Brackets solved the compile error, but it still says that it can't find the form. Should I try this requery action in some other place? Holy tek-tips batman!:-0

Dim strdocname As String Dim strWhere As String strdocname = "Work order" strWhere = "[ID]=" & Me!ID Forms!Work order.Requery DoCmd.OpenForm strdocname, acNormal, , strWhere DoCmd.PrintOut DoCmd.Close This is the code that I have on my button at...