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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hunterlpr

  1. hunterlpr

    Help with a loop

    wow...that easy. Thanks!! Lisa
  2. hunterlpr

    Help with a loop

    Thanks for your reply Rolliee. I've almost got it. I used some VB and then invoked an update query. But what I'd now like to do is skip the query and write it into my VB. Below is my Vb and following is the SQL which Im not sure how to change into VB Dim rst As Object Dim vartemp As Variant...
  3. hunterlpr

    Help with a loop

    I need it to repeat that 2nd if statement until no more matches. something like dowhile until no match.
  4. hunterlpr

    Help with a loop

    Dim rs As DAO.Recordset Dim vartemp As Variant Hi, I need help making the 2nd part of my if statement to loop. I'm getting the results I wanted but used the goto next record to check the next one however I need to check all records. How would I create a loop to do this. Thanks. vartemp =...
  5. hunterlpr

    Select All Checkboxes

    Okay I think I'm a lot closer ..the following code does what i want however i need to get it to loop until no match can anyone please help...thanks! Dim rs As DAO.Recordset Dim vartemp As Variant vartemp = DLookup("[category]", "table1&quot...
  6. hunterlpr

    Select All Checkboxes

    Thanks for your reply. I actually guess I want to update. What I have is a continuous form with many different categories and subcategories, such as: Basic Skills Repair Wiring The student can.... Basic Skills Repair Wiring The student can Basic Skills Repair Wiring The...
  7. hunterlpr

    Problems with Access Security on Network

    I have a similar problem - I think - my problem is that everyone joins the workgroup located on the network and it works fine. The problem is I need a station set up that is not on the network just on the hard drive. However, when I copy the workgroup and program to a disk and then copy them...
  8. hunterlpr

    Select All Checkboxes

    Hi, I'm looking for help on how to select all the checkboxes on a continuous form if the checkbox the user checks has a goal value of null. The problem is my form is set up dependent on grouping. It is grouped first by category, then by subcategory. So if the user selects say the record with...
  9. hunterlpr

    Filter in datasheet view

    Thanks again. Fortunately I got busy on another project and other coding dilemas so I didn't start the other coding. That looks like it will work....I'll give it try.
  10. hunterlpr

    Filter in datasheet view

    Thanks for taking the time to look it up for me and I appreciate the code. Nothing is ever as easy as one simple line. I was hoping just to put a domenuitem command in. I'll try the subform and code. Thanks for your help!
  11. hunterlpr

    Filter in datasheet view

    I'm hoping someone can help me with this problem. I have a form that on an after update event filters the form and returns the records. I have coded this in visual basic and it works fine except that I want it to return the filtered records in datasheet view not in form view so that it will be...
  12. hunterlpr

    retrieving groups of records/filter?

    Thank you so much for your reply. I originally had it set up with a form and subform, the problem with this was they had to scroll through the main form instead of selecting from a list(combo box) to see the records and I want them to be able to pick. Is there a way to do this. Also I went...
  13. hunterlpr

    retrieving groups of records/filter?

    Hoping someone can help because I'm confusing myself as to how to go about accomplishing this task, there may be a better/easier way to do this. I have created a query from two tables that uses say the following fields Classes tble, field Course Name Enrollment tble, fields, course, last name...
  14. hunterlpr

    count on report while grouping

    my data is broken down and grouped as follows in my report Class white hispanic black disabled disadvantaged Female 10 0 3 2 8 Male 9 0 1 1 6 My query is written to sum all the fields above except it...
  15. hunterlpr

    Remove filter goes to first record

    Hoping someone can help. I have created a toggle button to apply a simple filter, which works fine. The problem is that is when I turn it off the filter is removed however it places me at the first record on the form. Im thinking I may just need a bookmark but am limited in my VB knowledge...
See more

Part and Inventory Search

Back
Top