Search results

To be honest, even with the watch, I'm not sure what to do with what I see. I did compare the newer code with the older code and found a couple things I missed and was able to get rid of the type mismatch. I ran breakpoints and compared the two to see if there was a any difference. The only...

pbaldy- I'm not really sure if I used the immediate right, but I put in me.subjchoiceID and it came up with "variable not yet created in this context" I finally got something to come up on the hovering bit too. On "For x=0 to me.subjchoiceid" i got a pop window saying that subjchoiceid=15 at...

Thanks mdlueck. I am guessing that anything that the breakpoint doesn't stop at is what is important or not working? if so it skipped the purpled lines.... If Me.SubjChoiceID.Selected(X) = True And Nz(Len(Me.SubjChoiceID.Column(0, X)), 0) > 0 Then strIDs = strIDs & Me.SubjChoiceID(0, X) &...

What I mean by that it isn't working, is that the code isn't save the selection code for the item in the list box. (I hope I made some sort of sense) I'll defnitely look at the link you suggested. Thanks

I have a db that I wasn't the one who wrote. I'm actually pretty much a noob at this. Up until recently one of the forms had a bound list box. When I changed it to an unbound list box, the selections stopped being recorded. I know its possible to record those selections still because there is...

I forgot to mention there is a form with a button that called up the survey. I added a combo box and on the main query for the survey form a statement that would direct it to look at the combo box. Now, it kinda work. Save for the fact that when i added in more surveys and other info into the...

Since the last time i posted, I've decided to try something with the database work. I downloaded a survey database that someone posted for use and I'm trying to adapt it the work i have. So far the biggest hurdle is the form. It is based on a query, i think which set up the basic controls. A...

While working on ways to try simplify the tables of the database that I've been working on i found that I kept getting errors on this code Private Sub Form_Load() If Not Form.Recordset.EOF Then txtStudentName.Value = DLookup("[firstname]", "tblTeacherpreSurvey", "[ID]= " +...

I could use some help with VBA. To be honest, I don't know it and didn't write what I am about to post. I keep getting an error message that says 'invalid use of null" Private Sub Form_BeforeUpdate(cancel As Integer) Dim varW, varX, varY As Variant If...

Yes, Simon- that is pretty much it spot on. I know the design is sloppy, but again- it wasn't something I had designed. At the time I came onto the project, I didn't even realize that it was not organized. Now, i do know- I just don't have the knowledge necessary to fix it. *I did try...

This database is not something I designed. Someone else started it and then just quit. I cobbled together something, but I know that it isn't that good because to make it work I had to split the database into 6. Probably too many reports, but that is because I don't know how to code. If...

That's kind of why I am asking for help. The most I know about access is how to open it and enter data. How do you take names out?

I hope that I don't get into trouble for posting this in more than one access forum, but I really do need help. First I want to say that I am a complete N00b when it comes to access. For all I know the answer is already here- I just don't know what I am looking for. I started volunteering for...