Search results

Let me try to explain this better. Lets say that I have 20 buttons. The caption on each button will be put as a filter in a query. Each of these buttons opens up the same form based on a query. I want to have one macro that I can assign to each buttons on click event, and have it take that...

I ended up not doing this in the database I wanted it for, but I am trying to figure it out for future uses. I am confused on how to reference the button that the current macro is being called from. How exactly do I have it put its own .Caption into the variable. Thanks.

I have a macro that opens a form. The macro then sets a value in that form. I would like for that value to be the caption value of the button pressed. Forms![frm_Menu]![button].Caption I want to know what I need to put in that button field to have it reference the button that the macro is...

Is there some code that would validate all required fields that I can use for multiple forms without changing the code to validate each individual field?

I have macros that will close the current form and open another, but when there are required fields not filled in then problems arise. Is there anyway to first have the macro check to see that all required fields have a value, and if they do then continue on with the current process. If there...

Sorry to keep asking stupid questions, but is therea anyway you could give me some more details on what code or macros to use for appending and deleting the closed records from one table to another? Also I really like MrGrumpy's idea, is there any way to make the line of an overdue record in a...

It still seems like a decent possibility. As it is currently we have a computer hooked up to a plasma, so I am thinking I can have a form that displays the open tickets on that TV and just have the form on the TV flash until updated. Currently I have this set up: tbl_PWO (master table of...

Is there a way that I could have my all closed priority tickets be moved to a seperate table after a week of closure, in order to keep the table with open priorities in it relatively small?

Both of those are interesting resolutions. namliam, what is the requerying method? Could I make it update every 5-10 minutes? There should never really be more than a handful of priorities at any one time, would it really be that tought to have it only update open priorities? DCrake, is...

This is what I am trying to implement: I have a form for priority work orders, it has fields that automatically update the time when modified. On priority 1 work orders I want to make it so that if the time modified is 1 hour past the current time(and priority 2 is 2 hours past), then either...

Kiwiman, thank you for the quick help, works perfectly!

I have a query where the criteria is entered in a form through the user. Lets say that I have the fields of Money, Honey, Pickles, Phone. I would like the user to be able to type in a string such as "one" and have it return money, honey and phone. (since they all contain that string) Or if the...

I am trying to use the SendObject macro to send a record out using Outlook 2007. Eventually I would like to make it alot more complex, but for now I would be happy with it just sending the email. So when I click the button that has the SendObject macro I get this message: My Outlook client...

Well I could not find the right place to put the Forms!frm_ASI.FilterOn = False But I changed it up so I went with the frm_ASI closing when you choose to search, this way it reopens it everytime with the selected record. Plus this makes sense if I want to put the search option directly on...

Sweet, OK so that works now, but the only problem is if I hit search again from frm_ASI it will only pull up the record that was clicked the first time, I need a way to wipe that value after it has been opened, so it will open the newly selected record. Thanks again!

When I use this instead I still get the box popping up to enter the parameter. It seems that it does not recognize which record is selected within the subform frm_qry_ASI. No matter how I try it I cannot get it to recognize the selected record, I always get that prompt. Thanks for anymore ideas...

It should be fine that the Record Source for all of the forms is tbl_ASI, correct? That would satisfy them both having the same unique ID. I tried the code that you put up, but it always opens the form with the lowest ID number, not which one is currently selected. And shouldn't the stFilter...

I'll be looking forward to your insight!

Ive got the default autonumber ID field in the table. This makes more sense. I have a form where you enter the data. On that form is a search button(frm_ASI), when you click this button another form pops up (frm_ASISearch) and contains the subform with all of the records in datasheet form...

Let me use the names of my forms and what not to make it easier all around. There is: tbl_ASI (table that contains all the data) frm_ASI (this is the form that people enter the info in, also the one I would like to pop up when a record is selected from the search) qry_ASI (a query for the...