Search Result

Hi,

I just started using check boxes to send information to mySQL. What I want to do is to send id of the user and article to database when check box is clicked and when it is un-clicked remove that information from database.

Right now I am at this stage

...

I have a table with various information (company name, address, etc.) plus five check boxes. One or more of those check boxes may be ticked as it relays a type of status to the end user.

I have a query based on the table's five check boxes plus the Company Name and Record ID #. In the Criteria area I have the word True (no quotes) under each of the check boxes on seperate rows.

I have an unbound form (frmCheckboxes)...

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?

Hey, I'm quite rusty in VB so please be patient with me. I'm trying to make a query where the check box will be automatically clicked when the input date is after the 5th.

For example, for Oct, the input date is Oct 6th, 1999, the check box should be true.

For Nov, input date is Nov 3th, 1999, check box should be false.

Can anyone please help? Thanks so much.

Here is one I've been struggling with for a couple of weeks.

On a report I have a query that has records with both Check box fields and Test Fields.

I was able to get a sum of all the records in that query that had the text "GAMC" in the two text fields [Pl Ri Ki] & [Pl Lt Ki] by using

=Sum(IIf([Pl Rt Ki]="GAMC",1,0))+S um(IIf([Pl Lt Ki]="GAMC",1,0) )

Now...

Access 2003.

I have a query which pulls in a list if ID numbers with about 6 check box fields. In my report, I need to know how to count the number of ID numbers that have 2 or more of the fields checked.

Example:
There are (3) ID numbers listed that have Field A and Field B checked. How do I get the (3) to show in my report?

Thanks for you help.
J

Hi,
I am a dietitian. I created a form with two columns. The first column is a list of about 100 medications, and another column is the check boxes.
I put the check marks for, let's say 5 medications, and click on Print. I get the printout with the list of medications for a certain patient.

After that, I need to clear all selected boxes. I created a button "Clear check boxes". How do I make it to clear all check...

Hi

I am using the following code to programmaticall y fill my form

webbrowser.docu ment.getelement byid("txtbox"). setattribute("v alue", "hi")

I am stuck at a point where i need to set the values for select box, check box and radio buttons.

Any help is appreciated.

thanks in advance.