Search results for query: *

I am fairly new to SharePoint and I am trying to create a registration system in SharePoint by combining two lists: 1. Class Calendar 2. Class Attendees This will be used to setup learning and development classes for the department. The administrator of the program will use List #1 to setup...

Hello All, Below is some code I have in MS Access 2007 VBA that uploads documents to our SharePoint site. It works perfectly with one exception. What I would like it to do once it is loaded to the site is to be placed in a master document library that is grouped by the report name. The report...

Good Morning,Was looking for some assistance with some VBA code to create a catalogue of items in a PowerPoint report. For example I have a list of customer numbers that I want to lookup in the report and list the page # they are on for quick reference. Please see attachment Thank you in...

Good afternoon All, I am trying to calculate the incremental increase (in months) at each change of the CURRENT_TARGET_DT for a given ISSUE_ID with multiple occurances on different rows. Can anyone give me an idea? Basically, looking at the data below I would need to calculate the difference...

Hello All, I am trying to do a year over year calculation based on month to month data which is represented in another cell for a dashboard. I have the YoY calculations working but because that % needs to be represented on a seperate worksheet in a dashboard I can only get the current month %...

Good Morning All, quick question! My system default printer is a Lexmark Black & White (Lexmark BW). I want to print out a report in color and have the following code that I use for another routine for Adobe which works fine. But using it for this routine, it still defaults to the BW printer...

Hello All, I have the below code and I basically want module 1 to run to generate a unique report number based on the item type, current year, and then a sequential number starting with 1 so it would look like this - IN12-0001 etc. That report # should also automatically populate in the...

Hello, I am trying to create a form that has a combo box with certain values for a given category and once a value is selected, a 2nd combo box gets populated with the sub-categories from the 1st combo box. Is this possible? Thanks in advance

sort of a tricky question. I have a bunch of due dates, that are monthly. I need to bump the due date on a monthly basis until greater than conversion date (2/7/2011) example: 6/1/09, with conversion date of 2/7/11, would need 3/1/11. example 2: 7/15/10 with conversion date of 2/7/11...

Good Morning, I am looking for a way to output my report to Excel or PDF using a radio button option. The report consists of several prompts in an HTML view. Once the iteration is correct I would like the user to click a radio button and have the report output go to either Excel or PDF. I am...

Good Morning, Is there a way in Cognos 8.4 Report Studio to create an exploding pie chart? I ahve checked all property settings and do not see a setting. Thanks!

Hello, I have a spreadsheet that uses links to others for calculations. On the main worksheet there is a calculation that compares Month-over-Month data. I am trying to find some code to automatically insert a column and redo the calc based on the new column and the previous column. Any help...

Hello ALl, Can anyone tell me an easy way to rename the tabs in an Excel spreadsheet when a report is output to Excel. I rename the pages in the report pages section (Summary,Detail & RM) but when they get output to Excel it reads "Detail_1", "Summary_2", "RM_3", "RM_4", "RM_5", etc). It...

Hello....I have a form that I am loading from importing an Excel spreadsheet to a table. One of the fields is setup as a hyperlink but when the field is populated on the form from the import the link does not work. However if you type the link in the text box, it does work. Any ideas on how I...

Hello All, Am trying to develop a POS system with an Access backend. I have a basic template setup that will have an inventory control, but am looking to set it up so that it can be used as a POS system also. So it will track inventory being sold and returned. Maybe have it hooked to a...

Can anyone tell me if there is a way to have a reminder pop up in Access? Sort of like when an appointment pops up in Outlook. I created a contact form and enter the contact's information, etc. I also enter a call back time and was wondering if there was a way I could build some code that...

Could anyone please tell me how to get rid of the smart tags in Excel 2003. I have gone to Tools-AutoCorrect Options-Smart Tags tab and unchecked all the appropriate boxes, but still get the darn things. Thanks in Advance!!

Hello, I'm trying to write a module that excludes weekdays and holidays from a date calculation....this is what I have for the weekdays and was wondering if something could be added to it for the holidays.... Function workdays(Begdate As Variant, enddate As Variant) As Integer Dim WholeWeeks...

Hi All, Was wondering if you can help. Trying to create an Access97 form where I can type a value into an unbound text box. I need some code in the AfterUpdate Event so that the other fields will populate with the record's related data. Any ideas?? I saw something similar on the sight a...

Hi All, Was wondering if you can help. Trying to create an Access97 form where I can type a value into an unbound text box. I need some code in the AfterUpdate Event so that the other fields will populate with the record's related data. Any ideas?? I saw something similar on the sight a...