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 Chriss Miller 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. Krykota

    Access 2007 will not exit

    I have no experience in ribbons, but am interested in them now that you ask your question. I found these links that might be helpful. Seems the focus is on how you exit the db. The most blunt and promising one is to use DoCmd.Quit in your exit routine found here...
  2. Krykota

    How to seperate a text box from it's label

    Why didn't I think of that?" isn't in the help files or any book!!! j/k ;) yer welcome!
  3. Krykota

    How to seperate a text box from it's label

    dhookom, just a minor correction. Ctrl-Z performs an "Undo" function. The correct function is Ctrl-X, which removes the item from the 'document' to the clipboard for pasting later (or can be forgotten and ends up in a delete). Pleasehelpalot, these are functions that can be used in nearly...
  4. Krykota

    requerying multiple tabs (and their subforms) on a main form

    ... and the finishing point!!! More complicated than I first envisioned but it does exactly what I needed. I went through about 25 articles listed on google on this question and none provided the solution. Sincerely and robustly, THANK YOU!!!!! p.s. just how many stars can I give you for...
  5. Krykota

    requerying multiple tabs (and their subforms) on a main form

    I think that is where I am stuck. The design of the whole form. frmWorkOrder TabCtl4 Page 5(Data Entry), Page 6 (Current Work Order), (etc) Page 6 (where my action takes place and repeatable for the other tabs on the form) frmWorkOrderMain frmWorkOrderList (a query based...
  6. Krykota

    requerying multiple tabs (and their subforms) on a main form

    PHV, thanks for the suggestion. I tried that and could not get Access to locate the control. Forms![WorkOrder]![TabCtl4].Form.Requery A google search yielded this suggestion. DoCmd.RunCommand acCmdSaveRecord Me.Requery Access did not like it (unless I have it in the wrong...
  7. Krykota

    requerying multiple tabs (and their subforms) on a main form

    My db is designed to track work orders. I have a data entry tab, a current tab, a past due tab, and a completed tab. What I hope to accomplish is to mark a work order complete and then have all the forms in all tabbed pages requery. Hence, the work order marked complete disappears from the...
  8. Krykota

    populate field based on if statement

    Yes I had noticed that when I was typing in the solution. I hate the simple copy and paste. I don't learn anything when I copy and paste. You are still cool with me Prattaratt!
  9. Krykota

    populate field based on if statement

    Prattaratt, Thank you. The first option was what I was after. I appreciate your time and effort in helping me. Quick, easy and did the trick. TheAceMan1, I liked your solution for its pointed limitations, something Prattaratt didn't have privy to when he provided his solution. To both...
  10. Krykota

    populate field based on if statement

    list box a is List17 and b is list 37. List 17 goes to a control source of CID. List 37 feeds NWID. On list 17, columns are id, brand, and name from a table called CID same columns on list 37 but from table NWID. As Prattaratt pointed out, it is important that the user can only select one...
  11. Krykota

    populate field based on if statement

    Thank you for the response, however I have a couple of issues. 1- I don't see an OnChange event for the list box control. But I think that After Update will work in its place. 2- Using After Update or even On Click events, I am unable to pull the data from either the table or the column with...
  12. Krykota

    populate field based on if statement

    Greetings. I have a form for data entry 'frmWOEntry' where the user selects from a list box "A" (has 3 columns, ID, Name, Brand) or from a seperate list box "B" (again 3 columns; ID, Name, Brand) as the item of focus for the entry form. The two list boxes contain two different catagories and...

Part and Inventory Search

Back
Top