Recent content by eholtman

A old nemish as resurfaced that I found a work around in the past but I dont want to go thru that again. So looking for any help on: In the same query (CMEC.Ticket) I have 3 tables named: NME_IMPLMT NME_SBT NME_RQSTR I want to see all records if the name of "JohnDoe" matches one of the...

I am running a Crosstab Query by the months for different Types of Products. If there was not products within that month the value is on the crosstab is coming up "blank". I dont like the look of that so is there a way to force the crosstab to show "0" for the count. My VSB knowledge is...

Alright I have invested time and still not any farther so I created a sample database any help will be appreciated. Banging the head against the wall. I am going to try to explain because I am not finding any easy way to get this accomplished. You will see two tables one with Employees (tbl...

D, Thanks for the response. I feel like a idot now you give me a answer and now I have to ask for more understanding. When you say In("Submitter", "Requester","Implementor") Are you in design view or SQL view. If in Design view where do I have input the string. Right now I have in my...

I am trying to build a query that if "Name" matches either "Submitter", "Requester", or "Implementor" then it shows. For some reason I am only getting if it equals all 3. I am looking if it equals at least one then show. Not sure if I have to show my properties differently or command in my...

Thanks - That seems to be closer to what I need the only down side is that is requiring Me.Contact1 not to be null. I cant say that is always true. Ohh I feel like I am almost there.

Ok all done with all the enhancements for now and coming to one issue that I need to come to the great wizard... Tables: Open Text fields: Contact1 Contact2 Contact3. Issues: Generating email, I am recieving error 2295 (Unknown message recipient(s). When Contact1, Contact2, Contact3 is null...

Much appreciation ... work great. Not a simple when you look at for an hour.

I am having issues with a multiple option on my If Statement. I do not want to create and If statement for each if I can combine what I want it to do. If [cboType] = "Class II with 16K / 16K" Or "Class III with 16K / 16K" Or "Class III with 32K / 16K" Or "Class III with 32K / 32K" Or "Class...

Thanks works great.

Good Morning. Have a quick question for the gifted. First let me say I have inside my table Target Install, Received Date, and Type of Circuit In the Query, I have created a column with the following statement. Due Date: [Target Install]-30 which works great to give me 30 days from the...

Good Morning. Have a quick question for the gifted. First let me say I have inside my table Target Install, Received Date, and Type of Circuit In the Query, I have created a column with the following statement. Due Date: [Target Install]-30 which works great to give me 30 days from the...

Good Morning. Have a quick question for the gifted. First let me say I have inside my table Target Install, Received Date, and Type of Circuit In the Query, I have created a column with the following statement. Due Date: [Target Install]-30 which works great to give me 30 days from the...

Private Sub Billing_Reconciled_Click() If [Billing_Reconciled] = True Then [Billing_Date] = Date End If If [Billing_Reconciled] = False Then [Billing_Date] = Null End If End Sub Simple code but I am having issue with other users that are being rejected when access this code. Can this be...

I have this below code working but I need to add a "IF" statement and it does not work/ CURRENT CODE Private Sub Order_Request_Click() [Current Status] = "Ordered" If [Order_Request] = True Then [Order_Date] = Date [Guaranteed Date] = [Order_Date] + 56 Else [Order_Date] = Null [Current...