Search results for query: *

You might want to check out the Top N [Percent] clause for a select query; it lets you specify how many (either an absolute count or a percentage) records you want. If your sample records were anything like the real data, it looks like you could specify the top 1 for each SSN, if the data's...

Looks like your array is fixed-size, so Erase won't turn & bite. But, in the future, if you're using dynamic arrays & clear them with Erase, it also releases the allocated memory for the array itself; you'll have to do a ReDim to reset the dimensions before you can reload it.

I'm a long-time IT professional & have been working with Crystal Reports since it debuted (not to mention Access reports); I'm very comfortable working with it. We're in the initial stages of a project to switch 8 stand-alone systems (all from different vendors) over to a single-source...

If you're testing records/data against some defined criteria (e.g., HOURS > 40, YEARS <= 5, etc.), why not just write an INSERT query to copy the records that satisfy the criteria into another table?

If you need more flexibility, try loading the data value into a Variant-type variable & running it through the VarType() function. It'll return an integer value indicating the evaluated sub-type: 1 for null, 2 for integer, 8 for a string, etc.

VB has predefined constants for most every key on the keyboard; do a search in VB Help or the Microsoft site for "keycode constants". They're fairly mnemonic- the <CTRL> key is vbKeyControl, the "+" sign on the keypad is vbKeyPlus, etc. You'll want to check in the KeyPress event for the...

Or use DateAdd, like Format(DateAdd("h",1300,#11/06/04#), "mm/dd/yy") which will return 12/30/04. If you skip the Format(), it returns 12/30/04 04:00 (it assumed a 00:00 start time on 11/06). That what you had in mind?

I always took the brute force & ignorance approach & didn't allow apostrophes (in loaded data or user input). I'd check in a form or control's KeyPress event for Asc(39), set it to Null if it cropped up. I've seen various workarounds for the problem, but never found one that I was all-the-way...

It works here- maybe a config issue or the like, I don't know...but it's in probably 1/3 of the reports I've done here. Many are used in external reports or loaded to the hospital intranet, so suppressing (fields, sections, objects, subreports, whatever) is a big deal.

As a rule of thumb, ToText() is your answer for any sort of numeric or date formatting issue.

UpperCase (ToText (<value>,"dd-MMM-yyyy")) Today's date is returned as 18-JUN-2004

Au contraire- I use CR 8 & suppress sections and/or subreports all the time. The easiest way is to open the Report Options for the subreport & check "Suppress printing if no records"- no records, no subreport. Then, in the main report, open the Section Expert, select the section containing the...

Dammit...you get called in to the office at zero-dark-thirty & you start to make all kinds of doofus mistakes. Brain cramp...mea culpa [morning]

I've had some bad experiences with TerminateProcess (due to messaging, record locking, threads, whatever). Nowadays, I just declare: Const WM_CLOSE = &H10 & use that in a PostMessage statement: Result = PostMessage(hWnd, WM_CLOSE, Ø&, Ø&) Since it's the moral equivalent of the Close...

Check http://www.able-consulting.com/ADO_Conn.htm; EXCELLENT site for connectivity examples

Have you checked that the ADO library is enabled in the References list?

Do you have the textbox's MultiLine property set to True? That should allow the text to wrap around (to the limit of the MaxLength value, at any rate). You'll probably want to tweak the ScrollBar setting, too

Set the form's Pop-Up property to True; it will always stay on top of the other forms in the MDI

I'm nowhere near Liverpool (Indiana, damn the luck), but I'll be glad to offer what assistance or knowledge I can...

I was wondering about that, myself ;-)