Search results

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

in my query I am trying to show all items that are null and items that the date is from today and back 7 days (April 21- april 14) In the Criteria Feild I have: Criteria: Is Null or : =Now()<7 Not working

Thank you ... I found out at work they are using Office SP1. You are right it works great at home. If I build this on Office 2000 SP3 or 2003 and save the program. If the users use 2000 SP1 to run the form will it work. Thanks RoyVidar - Thanks that article is what I was looking forward...

Thanks again for the testing. The heads starts to crash into my desk harder and harder. It does not make sense. No matter what it dies after the first email....

What.... pbaldy.. Thanks for the response. But I dont see how that is possible.. 1.)Did you select one item under Recieved Request 2.)the outlook box appear to send a email... 3.)Cancel or send doesnt matter ... 4.)Try to select another box below to generate another email and that is...

Attached is a sample of test database in the form you will notice that I want to notify when Request is Recevied. The email format will work for the first one. Go to the next line item and select recieved request and nothing happens same happens for when I cancel the email. I have been...