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!

Register Log in
  • Congratulations Rhinorhino 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. AccessHelp123

    Access 97 Shared Database

    Hi All, We have an Access 97 database that used by several people in the company. Access to this database is granted using a .mdw file. Users have been complaining lately that people are unable to simultaneously make changes to the database. I checked the Tools-->options--Advanced section. The...
  2. AccessHelp123

    Unable to compact Access 97 database

    Hi, We have an access 97 database that has reached 1,048,580 KB. I am unable to compact the database to reduce its size so users can enter data into it. Here is what I have tried so far. I created a new 97 database and imported all tables into this new db. As soon as I do that I get an error...
  3. AccessHelp123

    Project Serve Disable Emails on Certain Projects

    Hi, I have a few projects that I need to publish but I want to disable email notifications on these projects. Does anyone know how I can accomplish this? Thanks.
  4. AccessHelp123

    Getting Data from Enterpise MS Project Files from Excel

    Hi, I am trying to use excel macros to access enterprise MS project and get 'TimePhasedData'. I am not sure how to connect to the enterprise project on the server using VBA. Below is the code I have to opne a .mpp file residing on my local computer. Sub test() Dim oMP As...
  5. AccessHelp123

    Javascript in Content Editor Web Part

    Hi, I created a page using enterpise wiki template. I added a Content Editor Web Part to the page and entered a link to an html page that has javascript in it. The javascript is supposed to expand and collapse items associated with a few buttons. The scrip works in an html page correctly. When...
  6. AccessHelp123

    Enable email in Sharepoint Calendar

    Hi, I am trying to create a calendar list in sharepoint that accepts incoming mail. What I would like the calendar to do it get the information from the email and update the calendar on Sharepoint. I believe what I need is setup an e mail address that I can e mail to. How do I do this? When I...
  7. AccessHelp123

    Update Sharepoint List Using Excel VBA

    Hi, I have a sharepoint 2007 list which I am trying to update using Excel 2010. Users enter the row of data in Excel and I am trying to create a macro to take this row of data from excel and add it to an existing sharepoint list. Any ideas on how to do this? Thanks.
  8. AccessHelp123

    Mining Data From Sharepoint 2010 Wiki Page

    Hi, We are using Sharepoint 2010 Wiki Pages to enter requirements for our product. As you can guess the requirements are spread across multiple (hundreds) wiki pages. What is an effective way to loop through and mine data from these pages into an excel document? I am only looking to extract...
  9. AccessHelp123

    MS Access Database in Sharepoint?

    Hi, I have a MS Access 2007 database that has data relating to the menu items from a different application. There are several tables and queries which are used in forms to display the different menu options that will be available in an application that the team is working on. Team members can...
  10. AccessHelp123

    Web Application Using Microsoft Access 2007

    Hi, I have a MS Access 2007 database that has data relating to the menu items from a different application. There are several tables and queries which are used in forms to display the different menu options that will be available in an application that the team is working on. Team members can...
  11. AccessHelp123

    Auto Scrolling list in Web Part

    Hi All, I am trying to display text from a list in a web part. The list items in the web part need to autoscroll constantly in the sharepoint site. Has anyone implemented a solution for a similar task? It does not have to be list items, if any text can be displayed in the autoscroll that will...
  12. AccessHelp123

    Sharepoint Custom List 'People' drop down picker

    Hi, I am creating a custom list entry form in Sharepoint. One of the fields in the list needs to be populated with the names of people in Lightweight Directory Access Protocol (LDAP). I am fairly new to sharepoint, how do I go about creating a field that gets its drop down (people-names)...
  13. AccessHelp123

    Excel Pivot table issue

    Hi, I have an excel worksheet that contains the following data. ID Feature Planned_Delivery Actual_Delivery 1 F1 1 1 2 F1 1 1 3 F2 1 2 4 F2 1 2 5 F2 2 2 6 F3 3...
  14. AccessHelp123

    Run Macro in Excel twice a day?

    Hi, I am trying to run a macro in Excel(automatically twice a day) that connects to a MySQL database and retrieves data. The file will be located on a Sharepoint server. Is there a way to code in VBA so that the file automatically retrieves data twice a day saves the file and sends an e mail...
  15. AccessHelp123

    Not able to enable macros in excel 2007

    Hi, I have a few files uploaded in Sharepoint that people use from time to time to open and update the file and then check it back in. Lately on one of the files one of the users is not able to enable macros. Once the OPTIONS(by the security warning) button is clicked the message displayed is...
  16. AccessHelp123

    Excel Interview

    Hi Guys, I have been working with Excel VBA, sql server for while. But just wanted to see if anyone knew where I can find a list of commonly asked questions in an interview since I have one coming up. Any help is appreciated. Thanks.
  17. AccessHelp123

    Is this pivot based on another pivot?

    Hi, I have a worksheet which has 10 pivot tables. Five of the pivot tables as sourced through an external data source (Access). The rest of the pivots are based on the first 5 pivot tables. The problem is at this point I dont know which pivots are based on the other pivots and which ones are...
  18. AccessHelp123

    Pivot Table Sort Page Filters?

    Hi, I created a pivot table which has country name as one of the page filters. When I try to filter the data in the pivot table using country and click on the drop down icon I noticed that the country was not sorted in alphabetical order in the drop down list. Is there any way I can sort the...
  19. AccessHelp123

    Pivot table Issue when switching from Excel 2003 to 2007

    Hi, I have several pivot tables created in an excel sheet. These tables were created in excel 2003. These pivot tables were created so that they reference external data but cannot be refreshed. However, all other normal pivot table functions are possible. After switching to excel 2007 some of...
  20. AccessHelp123

    TransferSpreadsheet error

    Hi, I am trying to import several sheets from an excel file into an access table using the VBA code below in MS Access. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_Sheet1", strFile, True, "Sheet1!" DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_Sheet1"...

Part and Inventory Search

Back
Top