 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / May 2005Checkboxes from a database?
I am fairly new to InfoPath and was given the task of designing a form. In creating this form, I have come to a point where I want to be able to change a user's access to certain areas, but I have to read in the values from the database. I set up the text fields to query the database using a connection, but I do not see this functionality within the checkbox items. I tried to write my own function, and it reads the values from the database but will not check the checkbox. I have a routine called SetFormValue, but it will not check the checkboxes. I have used CInt, CBool, CString, and even If statements to try to get the values to show up correctly. If I do something like strValue = rsData("CheckBoxValue") and do a MsgBox strValue, it will show the True or False value. Any ideas? Thank you in advance! -Dallas Double-click the check box control and see what it's On Value and Off Value is. You must match those values exactly for the check box to function properly.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I am fairly new to InfoPath and was given the task of designing a form. In creating this form, I have come to a point where I want to be able to change a user's access to certain areas, but I have to read in the values from the database. I set up the text fields to query the database using a connection, but I do not see this functionality within the checkbox items. I tried to write my own function, and it reads the values from the database but will not check the checkbox. I have a routine called SetFormValue, but it will not check the checkboxes. I have used CInt, CBool, CString, and even If statements to try to get the values to show up correctly. If I do something like strValue = rsData("CheckBoxValue") and do a MsgBox strValue, it will show the True or False value. Any ideas? Thank you in advance! -Dallas It says that the values are "True/False (boolean)." I have set it to those values and casted the return values to booleans. One thing that I did notice was that whenever I set the value to true or false, you cannot click it or change it. It is like it has the value, but it does not display the check. Any ideas? -Dallas "True/False (boolean)" is the data type, not the values. If you look in the properties dialog box for the check box you will see two separate fields, one for the on value and one for the off value. Those are what you need to use. Under certain conditions you can change those values, and others (like working with a database) you cannot. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com It says that the values are "True/False (boolean)." I have set it to those values and casted the return values to booleans. One thing that I did notice was that whenever I set the value to true or false, you cannot click it or change it. It is like it has the value, but it does not display the check. Any ideas? -Dallas |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.