Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. staciann

    Merging Shared Workbooks in Excel 2013

    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."...
  2. staciann

    Outlook 2013: Sorting People in Contact Group

    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...
  3. staciann

    Crystal 2013, Matching records from 2 tables not linking

    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...
  4. staciann

    Building Connection to Access 2013 64 bit DB

    So I finally got this to work using an ADO connection on a 32 bit Windows install and a 32 bit Office install. Not my ideal solution since I have to use a separate machine, but it did work. Thanks guys! Staci Currently using Windows 7, Microsoft Office 2013, Crystal Reports 2013, Visual Studio...
  5. staciann

    Building Connection to Access 2013 64 bit DB

    I have SP 1 installed. Am I missing something else? Staci Currently using Windows 7, Microsoft Office 2013, Crystal Reports 2013, Visual Studio 2010 & 2008, SharePoint 2013 (on prem), MS Dynamics CRM 2013 (online), MS Dynamics SL Version 7.0, Adobe CS5
  6. staciann

    Building Connection to Access 2013 64 bit DB

    I've added the driver successfully and ran from the 32 bit ODBC, but my database still won't connect. I've also tried installing CR and Access 2013 32bit on another machine. I rebuilt the database and saved it in the 32bit version and CR won't read that either. Is it just an issue with Office...
  7. staciann

    Building Connection to Access 2013 64 bit DB

    Thank you. Can you tell me what I need to do (or should have added) once I'm in the ODBC Data Source Administrator? How do I add a 32-bit connection? As soon as it opens, under User DSN, is lists "MS Access Database." Staci Currently using Windows 7, Microsoft Office 2013, Crystal Reports...
  8. staciann

    Building Connection to Access 2013 64 bit DB

    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...
  9. staciann

    Show specific headers and lists under quick launch to certain users

    There is nothing called SharePoint Server Publishing. Again, we are using Foundations, not Server. Staci – Currently using Windows 7, Microsoft Office 2010, MS Dynamics SL (Solomon) Version 7.0, Salesforce 12, SharePoint Foundations 2010, Crystal Reports Version 10 & Adobe CS5
  10. staciann

    Show specific headers and lists under quick launch to certain users

    No, as far as I can tell that is not a Foundations feature. It's not listed as an option under features. Staci – Currently using Windows 7, Microsoft Office 2010, MS Dynamics SL (Solomon) Version 7.0, Salesforce 12, SharePoint Foundations 2010, Crystal Reports Version 10 & Adobe CS5
  11. staciann

    Show specific headers and lists under quick launch to certain users

    Actually, there is no "navigation" option at all. Staci – Currently using Windows 7, Microsoft Office 2010, MS Dynamics SL (Solomon) Version 7.0, Salesforce 12, SharePoint Foundations 2010, Crystal Reports Version 10 & Adobe CS5
  12. staciann

    Show specific headers and lists under quick launch to certain users

    I am using Foundations - no audience option. Is there a way to do it here? Staci – Currently using Windows 7, Microsoft Office 2010, MS Dynamics SL (Solomon) Version 7.0, Salesforce 12, SharePoint Foundations 2010, Crystal Reports Version 10 & Adobe CS5
  13. staciann

    Show specific headers and lists under quick launch to certain users

    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...
  14. staciann

    Conditional Form Event / Redirect?

    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...
  15. staciann

    Add Fields To Table With Data From Unrelated Table

    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...
  16. staciann

    Requeried Checkboxes Connected to Expressions Won't Stay Checked

    OK, so strangely enough, I just figured out that if I put the requery in as a macro instead of the VBA, it works just fine. I generally try not to use macros...can you think of any reason why the macro would work but the VBA wouldn't? Staci – Using Windows 7, Microsoft Office 2007 & Crystal...
  17. staciann

    Requeried Checkboxes Connected to Expressions Won't Stay Checked

    Thanks Duane. I'm not quite sure what you mean by "normalize". The requery works fine with the calculations, the checkboxes just don't stay checked. It subtracts one and then remains unchecked. Is there a VBA line I can put in to simply make the checkbox stay checked or unchecked? Staci –...
  18. staciann

    Requeried Checkboxes Connected to Expressions Won't Stay Checked

    ...HardDrive Text OfficeVer Text IE Text FF Text MonMan Text MonSize Text MonSpeaker Text FlashDrive Yes/No Access* Yes/No Excel* Yes/No Outlook* Yes/No PP* Yes/No Project* Yes/No Pub* Yes/No Word* Yes/No Visio* Yes/No Java*...
  19. staciann

    Requeried Checkboxes Connected to Expressions Won't Stay Checked

    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...
  20. staciann

    Multiple DoCmd to set properties not working

    I can't get it to debug. When I pull up the VBA and hit debug (or F5 or F8) it just makes a ding noise and won't do anything. It won't debug any of my other code (that is working) either. Am I doing something wrong or do you think my program is screwed up? Staci – Using Windows 7, Microsoft...

Part and Inventory Search

Back
Top