Search results for query: *

Anyone aware of applications developed with MS Access and designed to assist home owners with building maintenance for one only singe family home. There are many high-end applications designed for business, however these are to elaborate for a single home. Thanks KMD

Can anyone provide any feedback on how well CR performs as a report writer against Microsoft Active Directory (AD) ? For example, does CR have specific features to allow direct linking to AD ? Are there other features that are designed to interact with AD data ? Thanks, KMD

I just posted this question in the Access Forum as the data is within a MS Access database. It may be possible to get Access to perform this query however my thinking is that Crystal would be more suited for the job. Would designing this query in Crystal be less complex a task due the...

The 'Parts' Table contains a Date Field called [PURDATE] which contains the date the part was purchased. I need a query to display parts purchased as a function of year and month of the purchase : YEAR_MONTH COUNT OF RECORDS 2018-JAN 596 2018-FEB...

Some part numbers provided by different vendors are similar but may have a vendor specific prefix or suffix added for their unique purposes. I want to compare vendor specific part numbers against generic named stock numbers currently held in stock...looking for matched items. Would the...

CRXI using MSAccess Each Part record contains a text field {COMMENTS} which is used to store notes and comments about the Part. I am looking for a specific text sequence anywhere within {COMMENTS} as follows: “Charge12345678” The word “Charge” with 8 characters following. i.e...

CR XI I have a database that contains two tables and each table contains two only text fields. tbl_Vendor contains the fileds {tbl_V.Serial} and {tbl_V.Part} tbl_Inventory contains the fields {tbl_I.Serial} and {tbl_I.Part} The serial and part numbers within these tables should be an...

2103 Excel 32 Bit Win7 4 BG RAM Somewhat complex 2013 Excel file is drawing on all RAM in order to function....and once loaded the computer is slowed down to an extreme level. Cannot delete rows to reduce the file size as Excel crashes during this process. The file was created in MS Excel...

CR XI I have a large text field that CRXI displays in this fashion: 2015 : data... data 2016 : data... data 2017 : data... data (I show the data as beginning with the calendar year for illustration only... the data is not actually in this state. As staff enter new data, those new lines...

Any ideas on finding professionally designed actual MS Project MPP files (redacted where necessary) that could be used as examples of how to learn to design and use the program effectively. I have looked at some examples on line but most were simplistic and not related to actual real project...

I am plotting a large project and trying to force the Gantt chart to fit on one C size sheet (22”x17”). However, as I force the gantt to fit the sheet, the row height of the task area, to the left side of the gantt, will only reduce no less than about 1/4” even though the Task font is much...

Will CRXI (version 11.0.0.1282) function correctly with Windows10 (version 1703) ?

CR XI: Record Selection Editor Are there techniques or workarounds to comment within the Record Selection Editor in the same or similar way that is available with formula editing by utilizing "//" ? With ad-hoc reports I often have several different selection criteria in use that I interchange...

Are any of the current SAP offerings of CR stand alone products? If not can anyone tell me that last CR version that is designed for standalone use?

Characters 30 and 31 in the {tbl_alpha.address} field should only contain valid state abbreviations. In order to be able to check and flag any potential errors in state abbreviations within the “{tbl_alpha.address} field, I am considering using the formula below. //@State Abbreviation Check if...

MSP 2010 Is there a method to calculate the Span of Tasks within the project Gantt Chart View and display as a column ? By Span I mean the number of Calendar Days or Weeks or Months the Task covers. I thought this might be a selectable Column that I could insert and display in the same way...

I am trying select records where only the following condition exists: The second, third and fourth characters of the ‘ModelNo’ are not found anywhere within the ‘PartNo’. (Both ‘ModelNo’ and ‘PartNo’ are fields found within each record of the database table used by the report. There is one only...

I will soon be setting up for a project where the workforce for will work a 7 day week and 8hrs per day. What is the best method to configure MS Project for this condition? Thanks KMD

Anyone using SAP Lumira ? Can it do most of the tasks of CR ? Where would CR have an advantage ? (I would think that Lumira may be based on a CR 'Back-End'?)

I am trying to display data containing the "\" character. This text data is stored in one only database field as ' PN\abc123PN\def234PN\hij345 ' The PN\ is the identifier for each new instance of a PartNumber. Each PartNumber is always in the alph-numeric format of abc123 When the field is...