Search results

I think I understand what you're saying. Strip out the item list query and put those items on the AA Table Query? Thanks for the assist on this, much appreciated.

The item list query is there because items are limited to 25 items per week per customer. If I put all of this info on the main table, I won't be able to break the information into a weekly basis. I made some adjustments based on your suggestion for the button. A new problem has emerged...

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

Are you digitally signing a database that is in .mdb? If you are, you should just be able to go to [Database tools] --> [Visual Basic] --> [Tools] --> [Digital Signature]. Once you sign it, close & reopen the database. You'll still see the "Enable content" popup, but this time you should have...

I was missing something too. I have a test database that's I use before I try it on the live database. When I tried it on my test database everything worked 100%. When I tried it on the live database, it only partially worked. There wasn't anything wrong with the expression Pbaldy posted, it...

Okay I spoke too soon. It works 3/4 of the time. The filter works when both combo boxes have a value, it works when The status has a value but not the unit, but it still does not work when the unit has a value but not the status. when I put [Forms]![Main].[Cmbfltunit] OR...

Okay I tried it again the first way you told me to. When I closed & reopened, the query shuffled itself around...and it works...somehow. I'm not somewhere that I can upload a pic to a sharing site & show you exactly what i'm talking about.

Sure doesn't. When I go to my query & put in [Forms]![Main].[Cmbfltstatus] OR [Forms]![Main].[Cmbfltstatus] Is Null, when I close & save the query & reopen it, it moves the expression & the Is null to a new column. I also tried putting the second part of the expression in the "or" block...

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

Figured it out. I had the text box set to number as it should be, the formatting was also correct. The problem (as expected) was user error. Of all things I forgot to bind the box. :banghead:

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

Okay problem solved. Pr2-Eugin, thanks for the code it worked perfectly. The problem was I was putting the formula into my unbound text box in the after update. What I NEEDED to do was put that same formula into my after update of my A/O Date box. /facepalm Reading the code you gave me...

Boblarson - I thought the same thing, but it doesn't work like that. Nothing pops up in the datediff box until I close the form then reopen it. It has the correct info, it just doesn't update once the initial date box is filled in. Pr2-eugin: 1: I'm not sure what you mean. The unbound text...

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

I've tried it with outlook open & closed, the result is the same. It will display the email completely ready to go, but it just won't send it. I don't get any errors from Outlook at all. Just the db error 427 saying .Send doesn't work. I cannot post the db. Maybe change Dim Outmail as string...

The email is completely filled out when the button is pressed and also has a valid email address. The email will display, but the error still comes up with .Send highlighted & the error 427. It wouldn't kill us to have to push the send button, but i'm just really curious why out of...

.Display works just fine. The email will display even if I have just .Send

Hah, had a "EUREKA!" moment and Filter on load makes sense now. Next question, why isn't .Send working in the code? I get an error 424 Object Required. I also tried OutlookMessage.Send and same thing happens.