A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
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 Command28_Click() DoCmd.RunCommand acCmdSaveRecord Forms!InvoiceNoEmail.SetFocus Dim oApp As Object Dim oEmail As Outlook.MailItem Dim fileName As String Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("SELECT [Account], [InvoiceNum], [EmailAddress], [Company], [Printed] FROM [ContactTotalsNoEmail] WHERE (((Contracts.SelectedPrint)=True)) ORDER BY [Account];", dbOpenDynaset) Do While Not rst.EOF strRptFilter = "[InvoiceNum] = " & Chr(34) & rst![InvoiceNum] & Chr(34) DoCmd.PrintOut fileName = "C:\Scripts\NoEmail" & "\" & rst![Account] & " - " & rst![InvoiceNum] & ".pdf" DoCmd.OutputTo acOutputReport, "InvTotalNoEmail", acFormatPDF, fileName rst.Edit rst![Printed] = "Yes" rst.Update DoEvents rst.MoveNext Loop rst.Close Set rst = Nothing Forms!InvoiceNoEmail.Requery End Sub
|Get Started with Digital Signatures||4||26|
|macro to compare 2 Excel columns.||14||30|
|In Excel 2007, how do I modify this formula so that the total number of question marks are printed out in a cell?||2||14|
|docmd has stopped working||3||13|