Search results for query: *

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...

If a font is missing, it can't show. Unlike a text font (like Helvetica), Access can't fill in with a default substitute. You must install the font (at least that's the obvious solution!). If we knew what it was we were doing, it would not be called research database development, would it...

With the now more-limited scope, Duane's UNION query idea is more approachable. (My only objection has been complexity and learning for the newbie.) KJV1611's idea may be tenable. I'm not good at ganging up OUTER JOINs. (For some reason my attempts tend to result in a 'child' being 'left...

If the diagram adds clarity, hooray! But, this indicates you'll be learning more about DB design in order to serve the end-users. Back on the "Plus" side of things, maybe our "universal search function" is going to be on the simple side as proposed in my last posts. Your end-user puts in the...

I'm imagining the relationships ... hoping for a coherent data structure ... but you know, that massive database i cited (it was 700 tables, I had a typo error) is a total disaster in every structural aspect, which is why I needed a brute search method. Can you clarify relationships? Here's...

What is the data type? If it's Date: DateDiff("n",datTime1,datTime2) If we knew what it was we were doing, it would not be called research database development, would it? [tab]-- Albert Einstein