MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Private Sub btnGetQuote_Click() 'get the quote number Dim SQL As String Dim rs As ADODB.Recordset Dim quoteNo As Variant SQL = "SELECT quote_id FROM QUOTATION WHERE quote_date = #" & cboQuoteDate.Value & "#" Set rs = New ADODB.Recordset rs.Open SQL, CurrentProject.Connection, adOpenStatic, adLockReadOnly quoteNo = rs.GetRows rs.Close End Sub
|In Access, is there a command to go to a control in design view from a command button?||10||29|
|record saved form with no buttons or X||3||21|
|How to get query to return one row for each unique part #||2||14|
|add criteria to query in VB, Access 2003||2||10|