Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. katiekat

    Mystery Function!!!

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

    Mystery Function!!!

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

    Update subform after entry

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

    Update subform after entry

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

    Verify entry before save using double entry

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

    Verify entry before save using double entry

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

    Verify entry before save using double entry

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

    counting related records

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

    counting related records

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

    counting related records

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

    counting related records

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

    tab out of subform

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

    tab out of subform

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

    tab out of subform

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

    tab out of subform

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

    Force Update

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

    Force Update

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

    Force Update

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

    Force Update

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

    Force Update

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

Part and Inventory Search

Back
Top