Your videos are great, I am learning so much! Thank you for making them. Do we get a certificate if we become members and complete the courses? Just curious, it would be great and for sure you'll be my first choice!
at 15:10 by multipling column with -1 , column name changed to Exp1 , How we can keep the original column name while doing the same operation.....thanks
I have a table to track audits. The audit table has the header information. Who did the audit, when, etc. Then I have another table that has all the questions that need to be asked (along with an AutoNumber primary key). These are used in a combobox in the subform. A third table joins those to tables (effectively making a many to many relationship) and stores the yes/no value for each question. In the subform, I choose the question from a combobox and store the questionID in the join table, as well as the yes/no response to the question. The problem is that I can forget to select one of the questions as I'm adding them. Is there a way, when I start a new audit, to display all the questions in the subform and have a checkbox or option box for each question? Or have you already done a video on this?
Thank you, this is very good information. I have named my Tables like Customer_T will this be a problem when switching from Access to SQL? I have one of your Work Order Seminar in that you have programmed a Check Box which Filters a list box which shows Yes, No and all records. We run a Restaurant and want to keep track of our Menus for the Season.
How would you make only one yes/no selectable per row? For instance either Hardware OR Software but not both at the same time? Also, will doing this update the data in the table? Thanks!
Is it possible for you to prepare lesson on forms using C# Windows Forms. The tools and controls shipped with the Visual Studio can offer great flexibility and much more professional looking forms coupled with all capabilities one can possibly imagine.
@@599CD done, thanks a lot. I have another question plz, i disable shift key by pass but i forgot to create a button key to enable it, so now how can i enter to database if shift is disable?!
How do I add a checkbox to each record in a continuous form? And when I selected the checkbox How can I add value to each record by reference from only one textbox value?
Hi, I have almost 40 yes/no questions, so I have created the form using the table "data", each field in data table I selected"yes/No" data type. Now after completing the form creation, when I select first question or any of the question as yes/no , rest all of the questions getting no selected. Is this something can you help me with?
Sounds like your checkbox is unbound, OR all of the checkboxes are bound to the SAME field. I've actually got a video on a question almost exactly like this coming out soon. Stay tuned.
Irrespective what I select the first answer in anyone of the value list question, rest of all the questions the answer is showing as No and it is again allowing me to edit each answer
If you have a Yes/No drop down and you want to add an option to add info If you click "Yes" how do you add that; like an option for a date if you click Yes?
Thank you, your video help me resolve a problem for my homework.
Happy to help
Very nice. This is very useful info for my database. Thanks!
Glad it was helpful!
Your videos are great, I am learning so much! Thank you for making them.
Do we get a certificate if we become members and complete the courses? Just curious, it would be great and for sure you'll be my first choice!
Certificate of Completion: 599cd.com/Certificate
@@599CD Thank you!
at 15:10 by multipling column with -1 , column name changed to Exp1 , How we can keep the original column name while doing the same operation.....thanks
Just change Expr1 to whatever you want... anything BUT the original field name. It's called an Alias.
I have a table to track audits. The audit table has the header information. Who did the audit, when, etc. Then I have another table that has all the questions that need to be asked (along with an AutoNumber primary key). These are used in a combobox in the subform. A third table joins those to tables (effectively making a many to many relationship) and stores the yes/no value for each question. In the subform, I choose the question from a combobox and store the questionID in the join table, as well as the yes/no response to the question. The problem is that I can forget to select one of the questions as I'm adding them. Is there a way, when I start a new audit, to display all the questions in the subform and have a checkbox or option box for each question? Or have you already done a video on this?
And thank you for your videos, they are appreciated.
Thank you, this is very good information. I have named my Tables like Customer_T will this be a problem when switching from Access to SQL? I have one of your Work Order Seminar in that you have programmed a Check Box which Filters a list box which shows Yes, No and all records. We run a Restaurant and want to keep track of our Menus for the Season.
You should be OK.
How would you make only one yes/no selectable per row? For instance either Hardware OR Software but not both at the same time? Also, will doing this update the data in the table? Thanks!
Use an Option Group. 599cd.com/ACX4
Is it possible for you to prepare lesson on forms using C# Windows Forms. The tools and controls shipped with the Visual Studio can offer great flexibility and much more professional looking forms coupled with all capabilities one can possibly imagine.
I used to program in C/C++ years ago, but I haven't touched C#. Sorry.
How do you use Y/N/X fields? Yes/No/NotUsed
Hi, can i use check box and edit from report?! I mean if i insert check box in report, i want this check box modify in table
In a report? No. Reports are for printing. Use a form.
@@599CD done, thanks a lot.
I have another question plz, i disable shift key by pass but i forgot to create a button key to enable it, so now how can i enter to database if shift is disable?!
How do I add a checkbox to each record in a continuous form? And when I selected the checkbox How can I add value to each record by reference from only one textbox value?
Not following you. Post in the Forum: 599cd.com/AF
Thank you
You're welcome
Hi, I have almost 40 yes/no questions, so I have created the form using the table "data", each field in data table I selected"yes/No" data type. Now after completing the form creation, when I select first question or any of the question as yes/no , rest all of the questions getting no selected. Is this something can you help me with?
Sounds like your checkbox is unbound, OR all of the checkboxes are bound to the SAME field. I've actually got a video on a question almost exactly like this coming out soon. Stay tuned.
@@599CD I can see each checkbox is bounded to different field of table, for example when I select each check box each control source is different.
Irrespective what I select the first answer in anyone of the value list question, rest of all the questions the answer is showing as No and it is again allowing me to edit each answer
If you have a Yes/No drop down and you want to add an option to add info If you click "Yes" how do you add that; like an option for a date if you click Yes?
If you want the box to appear, then you need an AfterUpdate event and you can manipulate the text box's Visible property. See 599cd.com/AfterUpdate
Something like this is actually already on my TO DO list for a video, although I already cover it in my Developer classes.
How to insert the yes/no field from a different table into your form?
Depends on what you're trying to do
Yes/No boxes have a property called "TripleState" that takes a NULL value in addition to YES/No. Not really sure how it works but just an FYI.
Oh yes, I'm well aware of them. I cover them in several of my seminars. I've got a TechHelp video coming up on them soon.
599cd.com/search/?Q=triple
@@599CD That is awesome