Recent content by Nathan87

Thanks a lot for all the great information. That definitely clears it up (at least this problem). :)

Thanks a lot CJ! You are right in that I was deciding it wasn't working based on the record count. I just tried the movelast as you suggested and that worked. So I guess the query has been working all this time and I was just thinking it was wrong because of the record count. I definitely...

Thanks for the suggestion. Tried below and still no luck. PARAMETERS IDFilter Long; SELECT AttachmentTable.ID, AttachmentTable.ItemID, AttachmentTable.AttachmentType, AttachmentTable.AttachmentName, AttachmentTable.Default, AttachmentTable.Deleted FROM AttachmentTable WHERE...

That gives the same results. I even tried using Yes/No and got the same results as well.

Just got it on Amazon for $5.50 including shipping! Hard to beat that if it's a good resource. Thanks a lot for pointing it out.

I have a query that works as expected when I just open it and type a number for the parameter field, but when it is called through VBA it seems to be functioning differently. Here is the query: SELECT AttachmentTable.ID, AttachmentTable.ItemID, AttachmentTable.Type...

With the picture change commented out it doesn't flicker at all. It looks like what is happening is the record is changing and loading with the old picture, then the picture changes and the whole form reloads. So the picture redraws twice, once with the old and then with the new picture. I...

It looks like the whole screen is flickering. I just noticed it's not just the picture that flashes. The text boxes with values also reload so it makes me think the record is changing and loading and then reloading the whole form when I change the image path with VBA. Is there a way to change...

It looks like I'm only calling Form_Current() once when switching records. I put a break point in the code at the Echo False line of the Form_Current() sub so that I could verify that.

For some reason the flicker is still there even with the echo set to false. Could I be activating the "on current" event more than once by switching records? I'm changing records using the arrows at the bottom of the form. I would think advance it one record would only trigger 1 on current...

Thanks a lot Mark. When you explain the empty string that makes a lot of sense. I'm not sure why that didn't occur to me. As for the flicker fix, that seems like it should clear it up. I'll give it shot now. Thanks!

Hello, I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws. Private Sub Form_Current() LoadDefaultPicture...

Makes sense. Thanks a lot for all the great info CJ.

Thanks a lot CJ for the answer and for the different options to work around. For my own curiosity's sake, what is the logic behind not being able to add the unrelated 1 record table to left joins? For my case it seems like that shouldn't cause any problems, but I'm suspecting that there is...

I think that is what I was trying, but it wasn't working. I wasn't sure how to take a snap shot of the query to post on here, but I was thinking in terms of the design view. I should have posted the SQL view as that is easy to copy and paste. Sorry about that. Here is my original query that...