Recent content by DonBerry

Thanks, Don

harmmeijer, Thanks your code works for me. I'm not sure I totally understand it but as long as it works!! For some reason I was under the impression the name property and the id property were totally different but that seems not to be the case. When I get some time, I guess I'll have...

<script type=&quot;text/javascript&quot;> <!--Javascript to Handle OnChange Event of Select Box function getprintid() { option=document.forms.artcart.printstyle.options[document.forms.artcart.printstyle.selectedIndex].value namehidden=option //price=document.artcart.[namehidden].value...

Well let me try one more time its really late here! I am having trouble with a javascript function to get the value of a text-type input in a form. The problem I'm having is the &quot;name&quot; of the text input is in a variable this same function retreived from another eliment of the form and...

Thanks for the reply it may help but thats for tomarrow! but I posted my question incorrectly what I really ment and didn't type is this: I'm new to javascript and I am having trouble with a function to get the value of a text-type input in a form. The problem I'm having is the name of the text...

Hi, I'm new to javascript and I am having trouble with a function to set the value of a text type input in a form. The problem I'm having is the name of the text input is in a variable and I don't know how to use that variable correctly in the access sting ie document.myform.mytext(this is...

Kevsim you prpbably need to go into references and check &quot;microsoft DAO 3.6 object library&quot; also move it up in priorty in the list closer to the top. I believe Access 2000 defaults to ADO. Don

I have used a form of SVO4Turbo's last suggestion and now have that portion of my application running. It seems to be working quite well. To clarify, I needed to select on the ability to play a specific group of instruments not just a specific number. Thanks to all who replied. Don

Thanks SVO4Turbo I'll give this a try. It's a lot cleaner than using nested queries as I originally came up with. Don

SVO4Turbo your suggested query returns both Joe and Doug unless I'm doing something wrong. There apparently is nothing that requires them to meet all criteria of the &quot;In&quot; clause just any of the criteria. Don

Thanks SVO4Turbo I think this will work for me! Don

Thanks for the replys. Here is, hopefully, a better explanation. The one side table is a list of musicians, the many side table is the instruments they each play. I want to search for all musicians who play clarinet AND bass Clarinet And tenor sax for example. Don

I want to do a query on linked tables in a one to many relationship. I want to return items from the one side that match two or more items on the many side in an &quot;And&quot; form of the &quot;Where&quot; clause, i.e. each item returned must contain all the criteria in the many table. I...

A Bookmark does not work for a new record nor if you have an empty recordset and are making the first entry. You get an invalid bookmark error. You cannot get the Bookmark property of a record until after it is saved and inserted into the recordset. By then, in my case, it has moved and...

In an application I have a form that must be requeryed after a new record is added to update info on the form. My question is how can I get back to the last entered record and make it current? Its position in the recordset may change from the last record after the requery due to the sort.