InfoPath

InfoPath – Add Sequential Dates

In the past, I needed to add a date sequentially on insert of a repeating table. I found a post by S.Y.M Wong-A-Ton that helped me achieve this.  Here is a link to that post: http://www.bizsupportonline.net/infopath2007/automatically-populate-repeating-table-infopath-sequential-dates.htm If you are working on anything InfoPath, this site is a GREAT resource.  I highly suggest that you check… Continue reading InfoPath – Add Sequential Dates

InfoPath

InfoPath 2007 – Contact Selector Shows Red X

On rare occasions, I have ran into this and I always seem to forget what to do then this happens.  It’s actually quite simple.  All that you need to do is run office diagnostics.  First things first, close InfoPath.  Then, follow the directions for your version of Windows. Windows 7 Windows Control Panel Programs and… Continue reading InfoPath 2007 – Contact Selector Shows Red X

InfoPath

InfoPath 2007 – Populating from data/dropdown info from SharePoint lists using XML form data

This article applies to InfoPath 2007 only as 2010 and 2013 no longer have this limitation. At some point during your career, you will need to connect to a SharePoint list to retrieve information for a drop down list.  This process has changed since 2007 but I thought that I would go ahead and share… Continue reading InfoPath 2007 – Populating from data/dropdown info from SharePoint lists using XML form data

InfoPath

InfoPath – Difference between days

I had a request for a form to count the number of days between two date pickers as one of it’s functions.  All that you need to make this happen is add two date picker controls and one text field to display the count.  I have included an InfoPath sample form that explains this in… Continue reading InfoPath – Difference between days

SharePoint

SharePoint – Dropdown Menu/Navigation Does Not Work

Have you ever logged on to your SharePoint site and the drop down navigation does not work?  After days of clicking around, I decided to fix the issue, which really was not much of fix. Turns out, this is an issue with my MS Office installation.  All that you have to do is run a repair… Continue reading SharePoint – Dropdown Menu/Navigation Does Not Work

Windows

Editing a Windows 7 Hosts File

I know that this may be common knowledge to most people in the IT world, but sometimes I forget even the simplest of tasks.  I haven’t edited a hosts file in 7 years so it took me a minute or two to remember where I was supposed to do this.  Now that I am running… Continue reading Editing a Windows 7 Hosts File

SharePoint

Synchronize SharePoint list using Access 2007

If you need to make changes outside of SharePoint to a list, you always have the option to use Access.  Follow these steps and you will be well on your way to using this feature. 1. Open your SharePoint list 2. Click Actions  –> Open with Access 3. A dialog box will pop up on… Continue reading Synchronize SharePoint list using Access 2007

SharePoint

A No-No for having Multiple SPD Workflows for Lists/Libraries

Word of warning: If you need to have more than one workflow for a particular list/library, DO NOT copy a SPD workflow and paste back into the same library. What happens is that even if you change all of the properties of the files (names, etc.), there is still a hidden property that SharePoint likes… Continue reading A No-No for having Multiple SPD Workflows for Lists/Libraries

InfoPath

Retrieve Active Directory Information from the User Profile Service – part 1

Very often in InfoPath, I need to query Active Directory for certain pieces of information just so that I can have some type of functionality within my forms.  One of the most used and easiest forms of this is the user profile service.  I use this to my advantage to query e-mail addresses, user account… Continue reading Retrieve Active Directory Information from the User Profile Service – part 1