Search results

Great! Glad you got it working! (I'm a bit slow with my responses - late night, I suppose :D) Best wishes on your project Michele :)

And again - I'm afraid you've switched my formula to be opposite of what I was suggesting. For the calculated field ("NullSorter"), assign the value of 1 to your *Null* values. The value of 0 is for *Is Not Null* (please ignore - per above post, you already got it running correctly)

Ok - and just for the sake of clarification: Sort fields should be arranged in this order in your query design grid: [Status Code] NullSorter DUE_DATE And you needn't display the "NullSorter" field (check box un-checked) in your results - it just needs to be inserted between your other 2...

Welcome Michele! :) Considering your dual requirement (ASC order on values, but remaining Nulls tacked onto the end), you've essentially asked Access to contradict itself since Nulls are sorted to the top in Ascending order. In order to coerce your intended result, we'll need to contrive...

Hi there, If it's not feasible to include the benchmark data into your query, you could always build a separate report for just the benchmarking, then nest it as a subreport within your main report footer. I'm a bit rusty with reports, but that would be my first thought . . . Hope this helps...

Apologies if I'm missing something, but isn't the Outlook appointment object (what you're calling "mobjAPPT", or the "mobjFLDR" object) capable of returning the Subject string? If so, assign it to a string variable, then test that variable to see if "*" is in there. Make sense? granted, this...

I agree you probably need to introduce a variable that you can apply a conditional to. I'm not familiar with Outlook object properties, but I'd try to put a control structure around it -- in order to run through all the appointments in code and test for your "contains" condition : For i = 0 to...

I would think you should modify your search string to accommodate both criteria by referencing the listbox 'Column' property: rs.FindFirst "[FirstNametxt] = '" & Me!List93.Column(0) & "' AND [LastNametxt] = '" & Me!List93.Column(1) & "'" I'm just guessing for the Column indexes that your first...

Hello there - perhaps the following article will be of assistance: http://support.microsoft.com/kb/209536 Hope that helps . . . John

Thanks - I definitely needed a sanity check. This darn mysterious Me.Dirty is throwing me for a loop!

Ah, yes - my sentiments exactly. But now if I may further indulge your patience, I'm running into a problem which may or may not be related to this setup of unlinked main and child forms - I'm getting a main form Me.Dirty=True for no apparent reason when I simply navigate through the records...

Whew - it's been forever since I've posted here! I'm setting up a form to enable adds/updates to the recordset - your basic single record view -- but I ALSO want a listview of the records for display purposes on the same form. 1) My first thought was to use a listbox to load the 'Display'...

Unfortunately, the success I had with this method was because I was actually linking to a web page (a pseudo-FTP site). Using this method for the FTP site I access at work hasn't been successful. You'll have to use the Shell function to get the data and store it on your local server or drive...

DeV, FYI, without some more detail about how your tables are setup or what a Top 10 is meant to represent I'm at a loss as to how to help. Maybe someone else has a better grasp of what your scenario is, but just a suggestion . . . Regards, John

Did you try a totals query? SELECT Column1, Sum([Column2] FROM 2004Assessment GROUP BY Column1 HAVING Column1 = '011-999' (or if '011-999' represents a range of possible field values, the last part would be "HAVING Column1 Between '011' And '999'") HTH, John

Try

Howdy Folks, Simple circumstance: in a table of values (tblData), I want to be able to generate a recordset that associates each of those values with a tier or grade level (i.e. - 93% = A, so any value >= 93% should be an A, etc). I'm using a reference table (tblRef) to store [ThresholdValue]...

In the criteria row of the design grid for field [ROW A] put: <> [row B]

In the design grid, I'm using a reference to a value in a form's combo box as criteria. Short of using code, is it possible to have the preceding comparison operator for the criteria be user-defined at run-time? In other words, is there a way to let the user choose between criteria "=...

FoFa, OK, did some research and investigating into Adjacency Lists, Nested Sets, Materialized Path, and Binary Fractions. Right now I'm debating as to which solution to go with. I'm curious as to what your table structure is and whether you've run into any drawbacks with your approach. Are you...