Search results for query: *

I've created a query that selects names from a table if the name ID is equel to another field. In those cases where the critera does not match I get a Null which then keeps my query from showing any data at all. What can I put in the "grid" under the "criteria" label that...

The Form uses a query for its Recordset. I'm using code in the &quot;On Click&quot; event that opens another dynaset off the same query. How do I keep the form records and this new Recordset in sync when I cycle through the new query. <p>BF<br><a...

I have a form based on a query. The query is based on two tables in a one to many relationship. I added some code to the &quot;On Delete&quot; event that looks up some criteria in the query and if it meets the criteria it allows a delete of the current record. My problem is when I go back to the...

I have a question about the &quot;Calender Control.&quot; Other programming languages give you the ability to click on a text box that is looking for a date and a calender pops up. You then can click on a date in the calender and the date you clicked on will fill the text box automatically. Is...

Thanks to Doug and Rochelle for the help on the Combo Box. Rochelle your iterpretation is what I was looking for. For the first column I assigned it through the property box and the second I basically just added another text box and bound it to another field in a table and assigned that column...

Access only lets you bound the first column of a Combo Box to a table/query. Is there a way through programming to grab the second column and also bound it to a table/query?<br> <br> <p>BF<br><a href=mailto:g43@tc3net.com>g43@tc3net.com</a><br><a href= > </a><br>

OK I'm starting to get depressed! I followed everyone's directions and I'm still not striking gold. Here is the new code. Maybe I'm doing something wrong with the Form/Subform. I simply added the control (subform)onto my mainform, canceled the wizard, named the subform &quot;RaterSubForm&quot...

After asking a few questions on this forum about different procedures it has become evident that one must have some knowledge about inserting SQL into code. Although I understand the concept, I'm having difficulty figuring out where to put all those d@mn quotes. Can someone point out a good...

I have a subform on my main form. I would like for an SQL statement to run each time I move to a new record on the main form. The SQL statement will update the subform from a table with each record change. Can someone give me a quick example on how to accomplish this?<br> <br> Thanks <p>BF<br><a...

I have a table with two fields. One field is named &quot;Rank&quot; and the other is &quot;LastName&quot;. Each Lastname is given a rank of 1 - 13. When I pull up a record on my form from this table, I would like to populate a combo box (same form) with all Lastnames greater than the rank given...