Search results

Team, I'm trying to get a combo box & button to work together and i'm failing miserably. On the main form of the attached database, I just want the button to go to the associated record based off my selection (or entry) in the combo box. I've tried the following: - Looked through the...

Team, I'm putting a form together that will have 2 unbound text boxes that show a weekly item total and an item total. I have a subform for user input. It has 5 columns for the user to input the number of each item given away, [Uniform Items], [Toys], [Household Items], [Clothing Items]...

Team, How do I get multiple reports to export & save as a pdf then attach to a single email? I'm using the code below, but I have no idea how to tailor it to handle more than 1 report. Private Sub Email_Decorations_Click() Dim strRep As String Dim strDPath As String Dim strFName As String...

Team, I have a report that is filtered by a selection in a combo box. What I need to do at this point is add another filter in another combo box to filter the report. The user should be able to use on or the other or both. Currently in the query, I have [Forms]![Main][CmbStatFilter] in the...

Team, I'm having an issue with conditional formatting when it comes to negative numbers. It should be pretty straightforward but it's giving me problems. I checked to make sure the text box is set to a number and it is. I have a text box with a calculated number in it. If the number is...

Team, I have an unbound text box that calculates how many days an item has been sitting with a reviewer. =DateDiff("d",[A/O Date],Date()) Right now I have the formula in the control source block and it works, but you have to close the form then reopen it for the number to pop up. What I...

Team, I'm trying to figure out how to get access to filter a report based off my selection in a combo box before emailing. So, when I pick "The boss" in my combo box then hit my email button, it would filter all my reports by whats with the boss then email it to him. I'm pretty sure I need...

Team, I'll try to explain this as best I can. I want to put a button on my form that sends an email that pulls data from the current record i'm on. Example: I'm on Mr. Smiths record. My button should send an email with Mr. Smiths name in the subject line. His name is the data I want my...

Team, I'm trying to use an unbound text box to calculate how many days have passed since another date in a form field. All I want the unbound box to show is a number like 12. For example if today is Aug 7 and the date in the form field is Aug 6, my calculation should show 1. I've tried...

Team, How do I add multiple criteria for a report filter? Right now i'm using the Criteria block in the query builder. I know I can type in "MSM" to have it show everything marked as MSM. I need to add 2 more values to the filter. I need the report to only show me only items MSM, BSM and...

Team, I have a button called "Run Report" that is supposed to open up a report that is filtered by a selection made in a combo-box. Only 1 selection can be made in the combo-box and there isn't a blank space. For example, if I pick "for signature" as my combo-box selection then hit my...