Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Private Sub List78_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Call_Ticket" stWhoCalled = "DirectAccess" stLinkCriteria = "Forms!Call_Ticket!Service_Tag_No = " & Me!List78 DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub
If stWhoCalled = "DirectAccess" Then Me.RecordSource = "OpenQuotes" Me.Caption = "You are Editing Open Quotes" End If
SELECT DISTINCTROW Main.CompanyName, Main.Real_Name, Main.Billable, Main.Distance, Main.Phone_Number, Main.Problem, Main.Call_Open_Time, Main.[Call_Close Time], Main.Installation_Date, Main.Service_Tag_Number_Auto, Main.Type_Support, Main.Address_1, Main.Address_2, Main.City, Main.State, Main.Zip_Code, Main.QBInvoiceNumber, Main.Billed, Main.Keep4Today, Main.Parts, Main.[Project Name], Main.Total, Main.EstHours FROM Main WHERE (((Main.[Call_Close Time]) Is Null) AND ((Main.Type_Support)="Proposal / Quote")) ORDER BY Main.CompanyName;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|linked sql server tables - should I or shouldn't I and why||4||63|
|MS Access How To Run a Macro From Task Manager...Not With AutoExec...I Need To Call A Public Sub||3||49|
|Is it possible to get data from a web-based interface and bring it over to an Access database?||4||37|
|Tabbed form question||5||20|
Join the community of 500,000 technology professionals and ask your questions.