Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (9 items) Re: Displaying unique values in dropdown Hi Matt, Thanks for your quick response, but unfortunately it didn't work... When I use the filters you define, I get the same result as I do without the Preceding expression - a list of multiple instances of the three Technical Products. I'm not sure what you mean by using pseudo-code to simplify the filter. The filter is set up using the ... Posted to SQL Database Integration (Forum) by pcapsey on 09-01-2006 Displaying unique values in dropdown Hi there, I have a problem regarding a filter on cascading dropdown boxes. The data to be displayed in the dropdown boxes are held on tables in an Access database. The relationship between the three dropdown boxes looks like this: Project --> Subproject --> Technical Product The Project and associated Subprojects are held on one table. ... Posted to SQL Database Integration (Forum) by pcapsey on 08-31-2006 Re: Problem using "matches pattern" as a filter Hi, I think I've found out why I'm getting the above error message. When I set up the filter, I use the pattern \p{L}, which translates as any letter. This gives the filter shown in my original message, namely: Document_Revision does not match pattern Custom Pattern A When I preview the form I get the error message. When I look at the filter, ... Posted to General (Forum) by pcapsey on 05-24-2006 Problem using "matches pattern" as a filter Hi all, I've come across a problem with using the condition ''does not match pattern'' or ''matches pattern'' in a filter on a repeating table when switching views. I have an initial view, from which the user selects the criteria to query the database. In this case it is a document number, selected from a dropdown list. Once the user has ... Posted to General (Forum) by pcapsey on 05-23-2006 Clicking disabled button crashes InfoPath Hi folks, I came across this by accident, trying to replicate all of the things that users might do... To recreate the bug: 1 - Create new form with 2 text field controls and a button control. 2 - Set Conditional Formatting on the button so that it is disabled when the first text field is blank. 3 - Preview form. Enter text in first text field, ... Posted to General (Forum) by pcapsey on 03-30-2006 Using hyperlinks in text fields Hi folks, I'm currently working on a form that is linked to an Access database. The users need to be able to enter hyperlinks in fields in the form, and to be able to click on the link to open the referenced document or page. The problem is that hyperlinks are treated as plain text when entered in a text field. I can't use rich text fields ... Posted to General (Forum) by pcapsey on 03-14-2006 Re: Switching views with a repeating table Hi Adam, I think you might have cracked it! I had the table keyed on a number of fields, which are also the query fields used to select records on the Select view. I've changed the table to use the autonumber as the key, and I use that field to move from the Summary to Detail view. When moving back from the Detail to Summary, I set the autonumber ... Posted to SQL Database Integration (Forum) by pcapsey on 02-16-2006 Re: Switching views with a repeating table Hi there, Many thanks for the replies. However, I couldn't get my form to work following Matt's example, which I worked through, and I couldn't work out what to do from Agni's reply, as I'm not a coder! Maybe I should give more detail about what I'm trying to do. The first view of my form, Select, has a maximum of 7 hierarchical fields that can ... Posted to SQL Database Integration (Forum) by pcapsey on 02-16-2006 Switching views with a repeating table Hi there, I'm currently developing an InfoPath form that uses three views. These are: Select view - the user enters criteria that are used to select records from an Access database. Summary view - this view shows summary information for all records that meet the criteria entered by the user in the Select view. The information is displayed in a ... Posted to SQL Database Integration (Forum) by pcapsey on 02-15-2006 Page 1 of 1 (9 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.