Search results for query: *

Currently have a report that shows current month sales, year to date sales, last year current month sales and last year year to date sales. Now the sales department wants it changed so they can select which quarter, 1, 2, 3, 4 and show that quarters sales instead of the current month sales...

I have a database that is the data source for some Crystal reports. One table holds data sent from a broker of invoices of my client's product sold to the broker's customers. A SQL Specific Pass Through query reads the invoice history files in the clients accounting system. There is a Union...

I have a Crystal report that uses SQL as the data source. I am going to use a business monitoring software to run and distribute the report. My problem is that I need a "silent" DSN so that when there is no log in prompt for SQL. How would I do that? The DSNs I have created don't see to hold the...

I have a Crystal report that uses SQL as the data source. I am going to use a business monitoring software to run and distribute the report. My problem is that I need a "silent" DSN so that when there is no log in prompt for SQL. How would I do that? The DSNs I have created don't see to hold the...

Have a formula question. I need to write a formula that says if {AR_InvoiceHistoryHeader.InvoiceDate} is between 11/01/2013 and 10/31/2014 then {AR_InvoiceHistoryHeader.TaxableSalesAmt}+{AR_InvoiceHistoryHeader.NonTaxableSalesAmt} else 0 but not sure how to do that. There will be three...

scanning information into an Excel file but I need to insert code so that after the last field is scanned there is a carriage return and then a home command so that the pointer is now at the first cell of the next row. The carriage return is easy <CR> but I cannot find anything for the Home...

Have the following selection formula: {MasterFile.Order In} = {?Order In Range} and{MasterFile.RepName} = {?Rep} and (NOT IsNull({MasterFile.SelectionsOwner}) and {MasterFile.SelectionsOwner} in{?Owner}) OR (NOT IsNull({MasterFile.SubmittalsOwner}) and {MasterFile.SubmittalsOwner} in {?Owner})...

Have a report that is running fine and now the client wants to change. The report has a cross tab displaying information by months based on date range selected. There is a sub report in the report footer that also has a cross tab that displays information by months based on date range selected...

In the report there is a time field which is displayed as 13.98062 and I want to display as hh:mm:ss. Every formula I use returns a Bad Time Format String. Any suggestions. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

In the data source there are seven (7) fields of different type of "owners". Selection Owner, Calculation Owner, Submittals Owners and so on. I need to write a formula that turns these fields into an array. In the report I will need for Crystal to determine if a selected owner is in the array...

Have a form in which a number of fields are summed in another field. Works fine. However if someone accidentally deletes the value from one of the fields the sum field also goes blank. I am trying to wrote code after update so that if the value of a field is deleted the field defaults to zero...

Have the following formula: if {@PrintExtItmDesc} = "Y" and {PO_PurchaseOrderWrk.ExtendedDescriptionKey} <> array("", "0000000000") then formula = {PO_PurchaseOrderWrk.ExtendedDescriptionText}+chr(10)+chr(13)& "MTR Required" I would like the part "MTR Required" to come out in red. Is it...

Have a field SelectionsYesNo which will a value of either Yes or No I want the following fields to be enabled if the value is Yes otherwise Disabled. SelectionsOwner SelectionsEstimatedTime SelectionsEDC SelectionsCompletedDate SelectionsStartDate I intend to put this statement on AfterUpdate...

Have a form where I have a field that is a drop down and list % of completion. 0, 25,50,75 and 100. However I do not want the 100 to show up unless another field, a check box for completion, is checked. Is that possible. Is it possible to show certain choices depending upon the value of another...

Have a table with two fields, initials and name, say JS and John Smith. I have a master file with the field Salesperon and I want to make the first table the data source. However I want both JS and John Smith to populate the field in the master file when the record is selected. Is that possible...

In an Access database in building a table with a query I have to take a time, say 2:00PM and convert it to 14.00 or 9:48AM to 9.80. How can I do that? Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

I have code to open any document based on what is entered in a field. Private Sub Command13_Click() Dim strInput As String On Error GoTo Error_GetMTR strInput = Attachment Application.FollowHyperlink strInput, , True Exit_GetMTR: Exit Sub Error_GetMTR: MsgBox...

Have a multi-column report which is a listing of parts and prices. My problem is that the heading, Catalog # and Sales Price only appear over the first set of columns. How can I have the headings appear on it's own over head column. Is there a way...

Is it possible to embed an Excel spreadsheet into an Outlook form? Have clients that own a number of different air craft. On the Outlook form we would like to have a spread sheet that list the air craft, number of, engine type. Some companies may own 1 while others may own 8 or 9...

In previous versions of Access I could create smaller forms but in 2007 it seems the only form size possible is full screen. Is there any to create a smaller form format as before? http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc