Recent content by GKChesterton

Thanks so much for the reply. I haven't got your solution working yet. Currently there's no response to mouse-clicks. Here's the contents of a typical table cell: <img src='presentation/red.gif' id='loc_4_1' onClick='SetValue("loc_4_1")'> <input type='hidden' value='-1' name='loc_4_1'> My...

I am making a chekerboard. The user can set the pieces on the board and submit her arrangement using an HTML form. This calls for a form that includes an 8x8 table. Each cell allows the user to indicate Red, Black or (default) Empty. Now I reach for JavaScript, because I'd like the...

(1) -- Take out 'On Error Resume Next' -- deadly for trouble shooting. (2) -- DistinctBehaviors.RowSource is not right, I believe. You want to use the value. You can use it in a recordset somehow, but not as presented. If we knew what it was we were doing, it would not be called...

I wonder how the whirl went? If we knew what it was we were doing, it would not be called research database development, would it? [tab]-- Albert Einstein

SkipVaught and joelflorendo have provided fine solutions. Which to use depends on whether you want the last file regardless of date, or want a file only if it is found with the last business-day date. If we knew what it was we were doing, it would not be called research database...

Thanks AceMan for the insight on recursion. I never understood it; very simple. (Not me. The insight.) If we knew what it was we were doing, it would not be called research database development, would it? [tab]-- Albert Einstein

Me.Filter = "(False)" Me.FilterOn = True I'm not familiar with the first line just above. I'd use Me.Filter = "" If you're trying to remove the filter, set .FilterOn to False (and it probably doesn't matter whether you change .Filter). If we knew what it was we were doing, it would...

I think we're talking about something else. Unfortunately the term "autocorrect" is so appealing, so marketable, that MS has used it in several contexts. In 2003, you go to Tools > Options > tab: General. Under "Name AutoCorrect," un-check "Perform name AutoCorrect." Most reports indicate...

TeamSelection_AfterUpdate() This doesn't make sense here. _Click would work for a button; _Load would work the new form.

Switch from OnLoad to OnCurrent. Watch out for over-using OnCurrent, as it can be a bit hard to control. But I think this is just the occasion. If we knew what it was we were doing, it would not be called research database development, would it? [tab]-- Albert Einstein

Is there any chance this is handled well by merely sorting each subform in descending chronological order?

If you switch the record source from a query to the table and the problem is fixed, then your query is formatting the number. It is generally good practice to base your form on a query instead of a table. So you may want to keep that query in place and adjust the formatting. In query design...

I have this issue when working on client-side app which is linked to a back-end on the network. If I link to a copy of the back-end on my hard drive, saves are fast. If we knew what it was we were doing, it would not be called research database development, would it? [tab]-- Albert Einstein

I knew it was p-code, but I was concerned about the Do-Loop!

Some edits below based on idea that missing value will be found as Null, not an empty string (""). Dim varAmount as Double 'will trip on Null varAmount=table.Amount table!Amount Do Until table.EoF If not IsNull(table.Amount) then varAmount=table.Amount ELSE Do Until table.Amount...