Recent content by spenzer

I have been reading about the performance between subqueries and domain functions when applied in a query although both are slow, I've always found that in the discussion it is the subquery that has an extra edge in terms of performance aspect. However, recently I've created a running sum on a...

This would be awesome feature; and I think it's long overdue, I've seen 2 or 3 access forums with indicators already. Now c'mon, the best access forum is still old school!:p

@sparks80 Thank you for the explanation and very informative link you pasted. I think that I haven't personally noticed the bloating because we perform compact and repair on a daily basis. But looking at it; I think that ideally, it is better to avoid bloating than getting it and then fixing...

@froggiebeckie Hi! I think your problem is related to using If Me.Dirty Then Me.Dirty = False in an Unbound form. Please try and close the form without testing for me.dirty and see if error goes away when you close the form or you can use a bound form and your me.dirty test will work.

You got my vote too. I wish you and your wife good luck. I will try and vote everyday i can.

Thank you for looking into it jon.

Hello! Thank you for your input, and with that, I now realize that there is also a place great for using a loop through recordset method though it is not as efficient as the other method. And so I think the rule of thumb is, use action queries as much as possible; as long as it can, and loop...

Thank YOu and well done! Wow I did not know I still have a method c until you came.:p You know what? I will try this for sure if it's as good as action query or better, then who knows i might stick to it. What I don't understand is the bloating part. You said that doing the other methods...

Hi! To test it as you suggested, I took out the criteria and tried to update a table with about 40k records. Viola! You were right looping through recordset took about 3-4seconds while doing it in action query gave the result almost instantly. This was a terrific finding as I am now thinking...

I have solved the problem by hiding my ip; and now i can get in and out smoothly again. What exactly happened, I'm not sure, I'm not totally blocked it's just that when i used my true ip; I automatically revert back to intermittent sort of connection to this site.

@jon You did really great work on this one. I still consider myself an access newbie and I like your presentation. It's very clear and you have a great voice. @boblarson I hate to say this but I'm afraid that you have stolen the thunder! Well, In a good way!:D That link you gave above is a...

I have these two sample snippets that practically accomplishes the same thing; I haven't noticed any difference in speed whatsoever. Both are fast enough and does the job really well. What does it do: Both snippets will perform a reset values to fields: TotalDays, Debit and PayDate on an...

Hi gemma, thanks for the tip. I have already changed my data type. But before that, I have read somewhere that memo data type field is prone or can cause database corruption. So with that reason along with we won't really benefit for the increased storage capacity. I decided to convert all of it...

It's been awfully hard to get in this website lately. It started a week ago, I had to try and attempt multiple times just to get in. And then if I try to post, i had to do it multiple times as well. This is not normal as I can surf and get in to every website so far. So maybe there's a...

I think that the automatic saving feature in access when using bound forms is still a great feature. It certainly saves time and helps beginner-intermediate programmer develop and see results fast which will inspire to do more and more until we get to the next level. Or at least, that's what I'm...