Search results for query: *

There are three radio buttons to hold 3 different values (1,0,-1) and the selection goes into the table with one of those values. I need to count the number of instances of each of those values and then run a formula which counts all of the 1's and divides that number by the number of 1's and...

I am trying to use the .addItem and .removeItem procedures that were in the Access 10.0 Object library. I am doing this because I had to switch from Access 2000 to Access XP and this has left me with some rather large holes in my code. Currently I have the following libraries checked: Visual...

I just found out that I have to do my development in Access 2000 instead of XP and that has changed my Microsoft Access library from 9.0 to 10.0 which takes out the .addItem and .removeItem function from my listboxes....Is there a way to get these back with the 9.0 object library?

I am having a problem with the line of code: Set rs = CurrentDb.OpenRecordset("tblShopper", dbOpenDynaset) In my previous database, that line of code worked perfectly but since creating a new database, I can not get this line of code to work (it states type mismatch) Is there a...

I am currently working with a new Access 2000 format database. In the previous database I worked on the following line of code worked perfectedly: Set rs = CurrentDb.OpenRecordset("tblShopper", dbOpenDynaset) In my new database, this line is not working. Is there an option that needs...

Yes, in fact that is what I would prefer to do BUT in order to do this, Access tells me I have to set the focus on each of my controls before I grab their values which seems odd to me. Is there a better way to do get the contents of my textboxes? Thanks, Will

Unfortunately, neither of your suggestions worked. When I unload the form, close it, or press the quit button (which is where I placed the acSaveNo code in) they all sent the data to the table anyway. And yes, the data entry option was turned on and that also had no effect when I turned it off.

I have a data entry form where its controls are tied to a table. The only time I want a record to be added to the table is when the Add record button is pushed. When I close out my form, if the correct information is in the form, the record will be added. Is there a way to prevent this? Thanks...

Is there a way to reset all of the values on a form without setting the focus on each of the controls? Along a similiar line, is there a way to check all of the controls to make sure data is in them w/o setting the focus? Thanks in advance, Will