Search results for query: *

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

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

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

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

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

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

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

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!

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

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

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

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