Recent content by tvsmvp

You're right! Thanks again -

Thanks for the help! I need to "store the calculation" only long enough to figure it and then export - otherwise, I wouldn't be storing, you are right about that. I'd begun thinking about using one of the other fields (like "city," as you suggest) but was having no luck until I got your post...

I think I've been trying to reinvent the wheel for about two days now. Using a query (as opposed to a macro I'd have to run to update my table) I need to count how many entries in my db live in a particular state - and break these entries down into groups of, let's say 15, placing a...

How would I pull information (into my form) from the next or previous record? I've tried this: Me!NextPartTitle.Value = DLookup("[PageTitle]", "Articles", "[ID] = " & [ID] + 1) which gets me into trouble when the id doesn't exist. Do I have to loop till it finds a higher-numbered ID? Or...

I got it to work - I'd made a mistake by using the .value property of the textbox instead .text. In the end, I was able to enter info into the text box, hit the enter key - and have the vba use the text from that tb, as I'd hoped. Simple now that I see it. Private Sub...

Thanks - that almoooost works. I follow your code - till it comes to passing the value of the text box (Me!tbKeyWordsLike.Value). I haven't been able to get that. Should I add an "after update" to the text box? Private Sub tbKeyWordsLike_KeyDown(KeyCode As Integer, Shift As Integer) If...

Okay -this answer's gotta be simple, but I can't find anything in access help. How do I tie an event to someone hitting the "enter" key after putting info into a particular text box?

Yes! Genius! The addition of "as integer" worked like a charm. Thanks!

Nope - still does it. I have noticed that what it's doing is sorting by the first digit: 8, 7, 4, 28, 27, 23, 2... etc. There's gotta be a fix for that just staring me in the face; I just don't see it.

No problem - Here's the SQL: SELECT Articles.ID, Articles.PageTitle, GetWordCount('horse',1,[Article]) AS CountArt2 FROM Articles ORDER BY GetWordCount('horse',1,[Article]) DESC; Here's the UDF: Function GetWordCount(strMyString, n, myField) On Error Resume Next StrippedWord =...

How do I get my query (which creates the row source for a list box) to sort correctly when the column I'm sorting on is a UDF? Apparently it's sorting before doing the calculations - not after. Rerunning the query in the list box's after change event simply reruns the query - which of course...

Thanks for the info - I'll use it and keep that bookmarked.

Okay - I stuck with it, burned a few more gray hairs and figured it out. The winning code looks like this: WHERE (((Articles.ID) = " & [ID] & ") And ((GetWordCount([KeyWord], 1, [Article])) > " & Me.KeyWord_1.Value & ")) ORDER BY KeyWords.RS DESC;" Apparently the two variables had to be...

Well, I've shot the last six hours or so trying to figure out where, how many and what type of quotes to use. I know this has got to be pretty simple - but I can't seem to see the rhyme and reason to how/when to use them. I'm loading up the row source for a list box with a query. Picking up...

Hey - I (actually we) got it to work. When you requested the SQL code, something caught my eye as I pasted it - and I noticed that I was (mistakenly) dealing with errors by alternating between IIf([Expr1]>0 ... and IIf([Expr3]<>"" ... Setting them all to the latter fixed the issue. Thanks...