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

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

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

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

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

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

I am having issues how my code is working. What I am looking to do is on click of Received Request to auto the date into Received Date (Works Fine) after that email a text message with my updates (layout works fine). Sends first one with no issue. The email box closes and I am again back to...

Is it possible to create a automatic email to not have a object to send. I am using Docmd.SendObject is there a command that if you only want to send To; Subject; and MessageText Current code Dim stDocName As String stDocName = "xxx" DoCmd.SendObject objecttype:=acSendReport...

Any help will appreciated. Table tblAll Country City Cost Cost2 Inside Form have pull down. cboCountry cboCity Then automate Cost into field txtItemDesc and Cost2 into Field txtItemDesc Code: Private Sub cboCity_AfterUpdate() Me.txtItemDesc = DLookup("[Cost]", "tblAll", "[City] ='" & _...

Any help will appreciated. Table tblAll Country City Cost Cost2 Inside Form have pull down. cboCountry cboCity Then automate Cost into field txtItemDesc and Cost2 txtItemDesc Code: Private Sub cboCity_AfterUpdate() Me.txtItemDesc = DLookup("[Cost]", "tblAll", "[City] ='" & _...

and not able to get it to work. Attached is the form I want to give the group a easy way to paste circuit IDs from Excel into a subform that will tie to the ticket as listed above. I have the releationship of ticket number assigned to the above ticket. Problem.... When i paste the numbers...

Between circuits in the same region. Here is what I need to do, if anyone has any direction or even links to samples that would be great. I have been searching and not coming up with what I am looking for. Basically I need to find the data circuits that are within a 10 mile radius of the...

2 weeks ago I lock down the Access back screen (This is not the Switchboard or the Database) so that it could not be Min or Max or Closed. So the top bar is locked down. Does anyone know where I might have found the changes to make this completed. I need to reverse the MIN and MAX to be...

Hello, I have done some research and unable to find my answer. But here is what I want to do. All I am asking for is direction. Any help would be appreciated. My database starts up with a switchboard. Nice looking. I have it lock down that the size cannot be changed and it is centered...