Search results for query: *

wow...that easy. Thanks!! Lisa

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

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

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

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

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

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

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

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.

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!

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

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

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

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

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