Recent content by bobhilt

What the group allows you to do is interactively debug a system that inludes vb DLLs and such. If projectB is a dll, the debugger will drop into it when a call to it is made. It doesn't allow you to share forms between one app and another, however. To do something like that, forget about...

Version is 7.02.100. I'm just trying to display them normally. What I was able to do as a workaround, though I find this was just luck, is to reduce the width of the sub-report in the header, and move all of the report header's stuff that I needed to the right of the sub-report. So I...

I've got report header a, which contains a sub-report with headers a and b. The reason for this layout is that in the subreport, I do a sql lookup to find which header to suppress (a db lookup based on the main report's parameter). This part works great, and doesn't interfere with the main...

The main point is that Change is not the entry point to the list change, but click is. It sounds like you're doing this in jscript perhaps? Anyway, if it's VB, you could always use a form-level variable to compare the listindex (or a static local variable) to know when to go further (into...

The only difference is that you're unloading the form in the cancel case, which is causing you to lose the values. If you want to keep the values, .hide it in the cancel as well. Don't use form_activate, else every time your app gets focus it's going to fire and hose your values. (Form_Load...

put debug.print messages in the _click, _change, and other events of interest to examine the behavior. The _change event won't fire for dropdown list style, only for combo style. The "change" is the change of the text in the combo box. The event you're looking for is _click. -Bob

if the cancel button has the cancel property set to True, then this gives you an alternate way out of the form. It should behave as you mentioned, e.g., keeping the changes there unless you change them back. If you're unloading the form, then the properties will not be carried forward from...

you can either set the .filter property, and use that same recordset, or if you want it to be a different rs object, .filter, then .clone the recordset. This sounds like what you're after. -Bob

When set the property, you're doing so for the current record only. In order to do the same for each record,you'll have to loop: rs.Open "Select * From equipment", strcnn, , , adCmdText sEquipmentName = "'" & Text2.Text & "'" sLocation = "'" &...

What you want to do is work out your search patterns, find (and select) the text, then set the case property to your range: Selection.Range.Case = <your case type> Valid case types: wdLowerCase wdNextCase wdTitleSentence wdTitleWord wdToggleCase wdUpperCase I found this by recording a...

I was able to locate a .pdf on the crystal site that covers this topic ( http://support.crystaldecisions.com/communityCS/TechnicalPapers/compiled_reports.pdf) but I must be missing something! From the directions: Compiling a report Accessing the Compile Report dialog box 1. Open your report in...

This should do the trick: 1. Subtract the day date part minus one from the date to get you the first day of the month. (Mathematical equiv of adding 1 - day of month) 2. Add a month. 3. Subtract a day. You can probably make this look cleaner with intermediate steps, but this should get the...

Or you could consider using a recordset with batchupdate. (Create the recordset with a select with a where clause like 'WHERE 1 = 2'. With this empty recordset, you can then .add in vb, the .batchupdate. Bypasses the stored proc, so if you need to munge the data on the oracle side, this method...

Yeah, that last part about stepping through in code and not working in .exe is pretty strange! Is it possible for you to try a different ado provider? (OLE DB, ODBC, etc.?) It sounds like you're doing the right stuff (probably not what you needed to hear!) Sorry. Best of luck. :-p

Answered: From the main design tab, right-clicking on the sub-report gives a &quot;Change Subreport Links&quot; option, which does the trick (exposing the param field).