Search results for query: *

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

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

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.

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

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

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

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.

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

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

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

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

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)...

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

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

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

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.

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

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

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

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