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)?
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...
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, ...
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 "#" & [Forms]![frmActivity]![txtStartdate] & "# And #" & [Forms]![frmActivity]![txtEnddate] & "#"
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 #" & [Forms]![frmActivity]![txtStartdate] & "# And #" & [Forms]![frmActivity]![txtEnddate] & "#
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])?
Randy,
The form and report work if the data range is hardcoded.
I tried changing my criteria to the following:
Between "#" & [Forms]![frmActivity]![txtStartdate] & "#" And "#" & [Forms]![frmActivity]![txtEnddate] & "#"
However, it is still coming up...
Randy,
Thanks for the suggestion. Unfortunately, my report is coming up blank. I updadted the screen shots on the link in the first posting with my button code, qry, and frm. Any insight as to why my report is blank?
Thanks,
Andy
I am trying to get a form to control the criteria in a query and then view the corresponding report. Specifically, I would like to enter the dates, choose the processors, and choose the documents and then view the report.
Visit the link the see a screen shot of my query and form...
I am trying to build a form that will allow the user to alter the criteria of a query and then print a corresponding report.
I have two text boxes on the form with the following criteria in one QBE panel - Between [Forms].[frmActivity].[start date] And [Forms].[frmActivity].[end date]
This...
I am working in Office XP. I have developed a query and a report based on the query.
Any suggestions on how I can build a form that will allow the user to change parameters or criteria of the query using list boxes and input fields. Specifically, I would like to be able to enter the start...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.