Search results for query: *

Hi. I am trying to set up a shared workbook in Excel 2013 for an employee. We get the spreadsheet created, share the workbook, save it to SharePoint 2013. That all works fine. Someone else then creates a copy of the workbook in the same library (no folders) by opening it and doing a "Save As."...

Hi. We have 30-40 contact groups within Outlook. We just switched to O365. All of the people who were previously part of a contact group are listed in the name field as "Last, First" (the File As field). We noticed since we switched to O365, any time we add someone to a group (whether a new...

Hi. I am using Crystal 2013. I am linking 2 tables from an MS 2013 Access DB. They are linked by the below fields in a 1:M relationship. Table 1: Issue ID (string) Table 2: Ticket ID (string) I've linked these with a Left Outer Join and checked the data to make sure it was matching up exactly...

Hi there. A bit of background - We need to report on SharePoint lists and do not (and will not) have the ability to do so with SQL reporting services. Our backdoor way around this for the past two years is that we create an Access database and link all of our SharePoint lists as external data...

Hi. I am wondering if there is a way to limit which items from the quick launch are shown to each user. I understand that items will not show up if a user has no rights to the list - I cannot take away users rights. This is exactly what I'm trying to do: Employee A edits a newsletter library. I...

Hi. I am working in SharePoint Foundations 2010. I have a series of lists (and forms for each) that are related by "Asset ID": 1. Asset Info (1-1) 2. Computer Info (1-1) 3. Computer Updates (1-Many) 4. Phone Info (1-1) 5. Server Info (1-1) Based upon what is chosen as the "Asset Type" in the...

Hi. I have an Access 2007 database that holds information on computer hardware, software, and user info for our IT department. I have one form called frm_SoftwareInfoEntry based on tbl_Software. This form contains the following fields: SoftwareName, NumLicenses, SerialNumber. The IT department...

Hi. I have an Access Form (2007) that captures all of the user, hardware, and software information for a certain computer. This form has 4 tabs: (1)Manufacturer Information (2)Specifications (3)Software (4)Additional Information On the Software tab (which is part of the main form), there is...

Hi. I have a form with multiple pages and about a hundred or so fields. Based upon the selection of one combo box, I want to make different fields and pages visible or not visible. I got one of the pages (CurrentResources) to switch from visible to not visible using an onchange macro on the...

Hi. I have two tables: tbl_Solicitations and tbl_Comments. They are linked in a one-to-many relationship by the fied ID (autonumber;integer). The purpose of tbl_Comments is to hold multiple updates added about each solicitation listed in tbl_Solicitations. I then have a main form...

Hi - I am currently using the following formula to suppress "almost" duplicate records: {PJPROJ.user1}=previous({PJPROJ.user1}) or {PJPROJ.user1}="" or right({PJPROJ.user1},5) like right(previous ({PJPROJ.user1}),5)or left({PJPROJ.user1},5) like left(previous ({PJPROJ.user1}),5) or...

Hi. I have an 8 character text field with data that I want to use for a date in a format like this 'MM/DD - MM/DD' I have the formula {@dateformat}: StringVar DF := {tblMeetings.Date}; Val (DF [ 1 to 2 ])&"/"& Val (DF [ 3 to 4 ])&" - "& Val (DF [ 5 to 6 ])&"/"& Val (DF [ 7 to 8 ]) that...

Hi. I am using Crystal v10 I have the following running total which works great until I get to the end - I want to say: {@TrimName} like previous ?{@TrimName}? but I can't quite figure out the syntax that needs to be used with the like, previous and ? characters. I'd appreciate any help you can...

Hi. I am creating a report and I need to suppress records if another record is conditionally suppressed within it's group. For example, if I have: COMPANY ABC (group) Project 1 (details) Project 2 Project 3 Project 4 and I conditionally suppress any detail records that were started after...

Hi. I have a report that breaks down our marketing results and shows each of the ways our customers found us and how much money each source brought in. All of this information comes from tblRequestedInformation. Group #1 (How customers found us) Group #2 (Specific name of source) Details...

Hi. I am trying to create a report and am not sure if it is even possible to do what is necessary: I have table tblReplyCards from an Access database along with tables PJProj and SOAddress from a SQL database. tblReplyCards holds a list project numbers (PN) for which a customer sent in a...

Hi. I have a report that uses two tables: tblRequestedInformation tblNewCustomers My two tables are linked by a PN number: tblRequestedInformation.PN tblNewCustomers.PN The details section of my report breaks down the [/i]tblRequestedInformation[/i] by tblRequestedInformation.HowHeard and...

Hi. I am creating this report in CR10. I do not have anything grouped. I have two details sections: (a) includes info that will be supressed and (b) includes charts and graphs. I will be using the info from (a) in the report header. The statement in the header reads "There are a total of ##...

Hi. I have an Access database and one of the tables holds records for all of the quotations that have been requested. Fields include: Company, FirstName, LastName, QuoteDescription, etc. Is there any way that I can write a query to find records that would be requests from potential customers...

I am using javascript dropdown menus - they work great. I call them out using onMouseOver="MM_showMenu" - however, I'd like to make the basic word at the top of the menu link to something if someone clicks it instead of using the dropdown. Like if "Services" drops down and lists: Chemical...