Search Result

I am new to mySQL and am working on making a replacement database for out current access database.

I am trying to plan for the yes/no datatype in access. From what I understand, the mySQL equivelent is the TINYINT datatype.

Using the TINYINT datatype, what value would be considered "true/yes"? Would it be "1 for yes/true" and "2 No/False"?

Is it truly down to what I make it?...

Hi,

I have to run a query based on check boxes that are checked. Only those records with a specific check box (or boxes) should come up.

I created a form off of that query using those check boxes. If I check a box (or boxes) and run the query all records show up instead of just the records with the check box(es) checked.

How do I make that query run only based on the check boxes checked on the form?

I am trying to link a static table ( and use the yes/no check box feature for those fields) into a form that provides info to another table. Is this possible or even realistic? I know that access doesn't particularly like the checkbox features, but they are really needed in this form. Thanks for all help!

Hey,

I'm currently using Access 2007. I've created a form that shows a list of search results in a subform. I want the user to be able to select specific people from the list and press a button to input all the selected addresses into the "To..." box in a new outlook email.

The database has email addresses in a column already. I was curious if it was possible to create an new "yes/no" column...

Hello! (MS Access 2007 form)

I have three yes/no (check box) fields for registration:
1. Full year (Sept-May)
2. 1st term (Sept-Dec)
3. 2nd term (Jan-May)

Of course, if they register and pay for the full year, I would like the 1st term and second term check boxes to automatically check themselves off. If they don't, I want to be able to check one or the other or both.

I've tried...