Recent content by meierswa

Does anyone know a quick and easy way to send a change of address notice to all vendors in Dynamics SL using a canned report (or a report that would require minimal Crystal modifications)?

EndOfMonth coupled with NetworkDays and an If statement did the trick. Thanks for the help.

I am trying to determine the number of business days between two dates; however I need to make the start date the first day of the following month. I am using the following formula to determine the number of business days: =NETWORKDAYS(C10,Q10)-1 How can I make the start date (cell C10) the...

I have a list of numbers in excel. Is there any code or an automated way to determine which combination of numbers, when summed, will give a specified value?

I want to be able to run a macro which searches for duplicate records in a column and, if found, deletes the entire row. I have the following code, but it only deletes the duplicate cell, not the entire row. Any help is appreciated. Sub DeleteDuplicates() Dim iListCount As Integer Dim iCtr As...

This is what I ended up with: Expr 1: DateDiff("d",[tblActivity]![dtReceived],[Forms]![frm15days]![txtDate]) with >15 in the criteria. It seems to be working.

I am trying to create a report that will list all documents that have been received but have not been processed with 15 days. Right now I have 2 dates (dtReceived and dtCompleted, Is Null) in the SQL statement in the report. I also have a form with a text box (txtDate). The date input on...

The dates are entered using text boxes and the processors are selected in a list box.

I have created an input form that allows a user to specify the criteria for a report. Here is the current code: Private Sub preview_Click() On Error GoTo Err_preview_Click Dim stDocName As String stDocName = "rptActivityReport" DoCmd.OpenReport stDocName, acPreview, ...

I am code illiterate. Where do I put this?

I have the Multi Select set to extended for both list boxes. The user needs to be able to select multiple items.

The query works with the new date criteria you recommended and the processor criteria (i.e. Forms![frmActivity]![lstProcessor]). However, everytime I try to specify criteria for the third field (i.e. Forms![frmActivity]![lstDocument]) I get the following error when I try and run the query...

Between &quot;#&quot; & [Forms]![frmActivity]![txtStartdate] & &quot;# And #&quot; & [Forms]![frmActivity]![txtEnddate] & &quot;#&quot; generates the following error: <b>You did not enter the keyword And in the Between...And operator. </b> The correct syntax is as follows: expression [Not]...

The following expression has an invalid date value. Between #&quot; & [Forms]![frmActivity]![txtStartdate] & &quot;# And #&quot; & [Forms]![frmActivity]![txtEnddate] & &quot;#

I think it has to do with my form. Both my list boxes generate their values from queries. I have the row source type set to table/query and the row source set to the respective query. Do I need to put a command before my criteria expression (i.e. Somecommand [Forms]![frmActivity]![lstProcessor])?