Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VTbigwillie

    Counting Specific Criteria

    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...
  2. VTbigwillie

    .addItem

    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...
  3. VTbigwillie

    Open Recordset Problem

    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?
  4. VTbigwillie

    Open Recordset Problem

    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...
  5. VTbigwillie

    Open Recordset

    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...
  6. VTbigwillie

    On Exit

    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
  7. VTbigwillie

    On Exit

    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.
  8. VTbigwillie

    On Exit

    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...
  9. VTbigwillie

    Reset Controls on Form

    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

Part and Inventory Search

Back
Top