Recent content by StaceyG

Sidanshu is correct. Here's an example: deDVS is my data environment, rsBattererListQuery is my recordset within the data environment that acquires the data and DRBatterer is my report. Load deDVS With deDVS If .rsBattererListQuery_Grouping.State <> 0 Then...

Picture1.Picture = LoadPicture(Text1.Text)

I know microsoft has told me you can only use one datasource in a report. I'm not very familiar with this, but some others have told me to use Data Shaping.

I had to accomplish a similar task. This worked for me: deDVS is my data environment rsbattererlistquery_grouping is my recordset DRBatterer is my data report Load deDVS With deDVS If .rsBattererListQuery_Grouping.State <> 0 Then .rsBattererListQuery_Grouping.Close...

It could be a lot of things, what is your error message and error number?

Looks like you are not specifying the cursor type or locktype of your recordset. If you check out what microsoft says below, it would seem that your recordset is being opened for read only which is probably why you can't delete CursorType Optional. A CursorTypeEnum value that determines the...

I've created an ActiveX EXE with several data reports. This is to be a remote component for ease of updating reports without having to reinstall on all the client machines. The problem is when I tell the report to display it is showing on the server machine instead of the local machine. Am I...

StuartP, I'm with you on the data control. It just seems to constricting to me, but other people love it. Here is an example (below) of a form where the user can select a customer name or ID number from a combo box. After selecting the name (or ID) I use the find method to locate that record and...

Go to the keypress event of your masked edit and type KeyAscii=0 Then the user can press the keyboard till the cows come home and nothing will happen.

App.Path will do the trick. Try this: Add a command button to your project and type Msgbox App.Path Run your program and click the button You'll get a message box that tells you the location of your application. Hope that helps Stacey

Here is a sample where I am looking up specific information on a claim number that the user selects: 'requery using the selected claim number DataEnv.cmddisputebyclaimnum (strClaimNum) 'change the data report title to display the selected 'control number...

Yeah, you probably have an example where someone was duplicating stuff. You can declare a variable Dim strName$ and that is the same as saying Dim strName as string Currency datatype is the @ symbol Dim curtotal@ Integer datatype is the % symbol Dim intNum% VB Help lists them all

Sure, My client would like to update data in a grid form. So I was going to use a datagrid control. The datagrid control has a button property which allows a combobox type arrow to appear when you click into that particular cell. Then when you click that button it fires the ButtonClick event...

Microsoft says (see below) that you can drop down a VB control. Anyone know how?? The built-in button is enabled for a column when its Button property is set to True. Typically, you enable the column button when you want to drop down a Visual Basic control (such as the built-in combo box, a...

rnpIII, How do you know what your identifier numbers will be? You said they'd be 1, 3, and 23 or whatever other numbers. Do these numbers come from a textbox, listbox??? If they did come from a listbox type control you could just change around my first code above and pass the identifier as the...