Search results for query: *

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

I thought I'd figured this out for proof of concept, but if so, I can't remember just how to do this: I have one parameter for my main report {?PONumber}, which is used to get header info. I'd like to use that parameter in my subreport selection as well to get vendor info (3-table join)...

Is the class within the same project? (I'm wondering about the instancing) If this is a local class (not part of a .dll), then you're doing things properly. It might be that something has been corrupted even, so you could try copying things to a new form (or making the same call from a new...

(Your title is very generic, so you may get limited responses, but I'll give it a try.) Pass the word NULL in your parameter string for the stored procedure, e.g., &quot;exec MyProc 'Hello','World',27,NULL&quot; To find out if you need to do this, then check the value of the text box: If...

If you are using separate connections (or data-centric controls--What is oData?) for the two functions, they will not have visibility to one another when within a transaction. Using an ado connection (not a data control), pass the connection to getRef(), or make the scope such that it's...

Use the filesystem object (scripting runtime), and check the collection size. I've Pasted this code from MSDN. This would get you the list of files. (If the collection f.count in this example is zero, then your directory is empty): ------------------ Function ShowFolderList(folderspec) Dim...