Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
Private Sub cboReportingSet_BeforeUpdate(Cancel As Integer) 'verify that this group has same currency as others in this set Dim rs As Recordset Set rs = DB.OpenRecordset("Select * from [List_Of_Group/Division] where ReportingSet='" & Me.cboReportingSet & "'", dbOpenDynaset) If rs.RecordCount > 0 Then rs.MoveFirst If Nz(rs!ReportingCurrency, "") <> Nz(Me.txtReportingCurrency, "") Then MsgBox "You can't use this reporting set for this group. Another group in this set has a conflicting currency. All groups within a set must have same currency." Me.cboReportingSet.Undo End If End If rs.Close: Set rs = Nothing End Sub
|How to convert sql code to access query||8||55|
|How to format Query so resulting excel file is properly formatted.||2||27|
|putting an icon in a form||13||20|
|Access Delimiter for check box filter||3||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!