Re: Excel - Visual Basic Discussion Boards

Dave Kreskowiak31-Mar-04 5:33

31-Mar-04 5:33

sbeausol wrote:
long GetCreatorID(BSTR FAR* pbstrCreatorID);

Return Value

1 if successful; otherwise, see Error Codes.

Parameters

pbstrCreatorID A valid pointer to a BSTR. This variable must exist and be initialized to NULL.

Remarks

Returns the creator ID. The creator ID is the logon name of the user when the raw file was acquired.

VB 6 Example

// example for GetCreatorID
BSTR bstrCreatorID = NULL;
long nRet = XRawfileCtrl.GetCreatorID ( &bstrCreatorID );

We still need the code your using in VB.NET so we can see what your doing. How the string your passing is declared, what the function call looks like.
All I can tell you right now is that the string your passing in should be a StringBuilder object.

RageInTheMachine9532

Re: OCX Control VB .NET

sbeausol31-Mar-04 9:43

sbeausol

31-Mar-04 9:43

Here is what I have tried to call it:

Dim Creator as String
XRawfileCtrl.GetCreatorID(Creator)
This results in a type mismatch

Dim Creator as New StringBuilder()
XRawfileCtrl.GetCreatorID(Creator)
This gives me the error:
Value of type 'System.Text.StringBuilder' cannot be converted to 'String'.

Thoughts?

Re: OCX Control VB .NET

Dave Kreskowiak1-Apr-04 1:44

Dave Kreskowiak

1-Apr-04 1:44

The more I think about this, the more I think your going to have to modift the MISL code in order to generate the custom marshaler your going to need to get that pointer. It would have been much easier if the library wasn't an ActiveX control.

Basically, since your component is expecting a pointer to a BSTR and expecting to be able to return a pointer to another BSTR, you're going to have to allocate memory for the BSTR and pass the pointer to it to the GetCreatorID function.

The reason for this is because the function your calling will deallocate the BSTR you passed in and will allocate a new one, passing that pointer back to you.

Sorry, but how to do this is out of my realm of experience.
I would need the library your using to be able to play with this and get it to work.

RageInTheMachine9532

Re: OCX Control VB .NET

Anonymous1-Apr-04 4:02

Anonymous

1-Apr-04 4:02

any examples on how I might get started (I don't want to inconvenience you by sending the files)...

What exactly is a BSTR?

Also, would it make sense to use another language - Visual C# or Visual C++... or will I have the same problem...

Thanks for all the help

Re: OCX Control VB .NET

sbeausol1-Apr-04 4:04

sbeausol

1-Apr-04 4:04

sorry didn't login

any examples on how I might get started (I don't want to inconvenience you by sending the files)...

What exactly is a BSTR?

Also, would it make sense to use another language - Visual C# or Visual C++... or will I have the same problem...

Thanks for all the help

Re: OCX Control VB .NET

Dave Kreskowiak1-Apr-04 5:00

Dave Kreskowiak

1-Apr-04 5:00

A BSTR is a Unicode array a characters with a 4-byte length on the front of it.

Any of the managed languages would also have to same problem since strings are immutable and the .NET Framework doesn't marshal return pointers to strings back to managed code.

You might want to drop a note to Heath Stewert in the C# forum about marshaling a BSTR to an ActiveX control function and getting a BSTR back. He's really good with the Marshal topics. Be sure to include the code snippets your included here and specify that you are not using P/Invoke to call this method.

RageInTheMachine9532

Excel

Anand Chakravarthy30-Mar-04 18:06

Anand Chakravarthy

30-Mar-04 18:06

How to call an API and implement to travel bertween worksheets using VB 6.0

Anand Chakravarthy

Re: Excel

superwinsock30-Mar-04 18:28

superwinsock

30-Mar-04 18:28

Hey Anand Chakravarthy

You might want to give a little more specific detail on what you are trying to achieve...

Cliff

Newbi Question? Help with Menus VB.NET

Nickiler30-Mar-04 17:43

Nickiler

30-Mar-04 17:43

I have just started working with windows programming in VB.NET with Visual Studio .NET 2003. I have created a mainMenu control on a new form object in the visual creator.

When I go to compile the project my menu doesnt show up. Everything else works just fine though, and my compiler doesn't issue any warnings.

I tried the same project in a C# program and it worked just fine. I would just use C# but I have 8 AppDev study CD's in VB.NET.

I also checked that I left all the defaults alone in the properties for the menu.

This is beyond me why this is happening. I would hate to reinstall my VS.NET and hate more to spend hours trying to figure this out.

Can anyone offer solutions?

Nick WTF | :WTF:

Re: Newbi Question? Help with Menus VB.NET

Guerven30-Mar-04 19:49

Guerven

30-Mar-04 19:49

have you included menuitems with your mainMENU?

Marvin N. Guerrero
- Casting More!!

Re: Newbi Question? Help with Menus VB.NET

Nickiler30-Mar-04 20:38

Nickiler

30-Mar-04 20:38

How do you mean?

When I created the menu in C# - eveything was done automatically.
Also, under the AppDev tutor it was also created automatically. It seems as though VS.NET might be leaving some inportant info behind.

What do you mean by "include menuItems"?

=======================================================================
It takes "me" and two monkeys just to open the box to a light bulb!

Re: Newbi Question? Help with Menus VB.NET

Nickiler30-Mar-04 20:46

Nickiler

30-Mar-04 20:46

Wow, what do you know... I restarted my computer and all works fine now - I think I need to reinstall my VS.NET 2003 Wink | ;-)

Thanks anyway,

Nick

====================================================================
It takes "me" and two monkeys just to open the box to a light bulb!

How to solve error (Keycodev2.DLL not Found or Invalid Key Code Error)

Kashyap Vakharia30-Mar-04 16:34

Kashyap Vakharia

30-Mar-04 16:34

I have developed windows application and it has some crystal report in it, it is working fine on the PC on which i have developed it, but when i install the same application on other PC which has a .Net framework already installed. it shows the error message "keycodev2.dll not found or invalid key code" i have made the setup programm and include all the crystal report files in it but still the error is there. Can you please give me some solusion of these.
Thanks
Kashyap Vakharia
SPR
FIJI ISLAND

Creating a component in VB .NET

James Lancaster30-Mar-04 14:14

James Lancaster

30-Mar-04 14:14

I am creating a component in VB .NET. The component contains a private ArrayList as in the following example:

Private __ItemList As New ArrayList

I need to create a list of the strings contained in this array and expose them in a property drop-down editor in the Properties window when the component is at design-time.

I understand that I can use a custom Type Converter to display a list of strings in a property drop-down, but the values in my SelectedItemConverter class need to come from the main component that exposes the SelectedItemProperty and maintains the __ItemList array list. I am at a loss as to how to get the list of string values into the converter class so it can return the array of strings when the property is accessed.

Here is how far I have gotten:

Private __ItemList As New ArrayList
Dim __SelectedItem As String

RAS Connection Structure

MASOSi30-Mar-04 12:23

MASOSi

30-Mar-04 12:23

I am having trouble calling the MprAdminConnectionEnum. The call returns a zero error code, but the buffer structure is not complete with data.

Could someone please convert this to a VB.NET Structure.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rras/rras/ras_connection_0.asp

Information about MprAdminConnectionEnum is at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rras/rras/mpradminconnectionenum.asp

I would be overly greatful for a working example!

Thankyou to anyone!
MASOSi

How to send OledbDataReader ?

Member 36080530-Mar-04 11:43

Member 360805

30-Mar-04 11:43

plzz;

I have problem ?
how can send oledbdatareader from function like :

public function sss() as oledbdatareader
...
dim z as oledbdatareaedr=...
return z

end function

and how can i use it in other methods like:

dim x as oledbdatareader=sss()

.......

is this algorithm rigth , or no ?

and if it is wrong plzzz write small code to tech me .

thnks for allllllllll

Think Before Begin

Re: How to send OledbDataReader ?

John Kuhn30-Mar-04 15:36

John Kuhn

30-Mar-04 15:36

Your brief example, which I assume omits the implementation details, looks essentially correct.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

How the disable the resize function of a form

MJay30-Mar-04 6:36

MJay

30-Mar-04 6:36

as topic, i wan to disable to user from resize the form size.. anyway can do this? anyhelp is appreciated... VB.NET

Re: How the disable the resize function of a form

Guillermo Rivero30-Mar-04 7:24

Guillermo Rivero

30-Mar-04 7:24

1. Change the FormBorderStyle Property of the form to FixedSingle or FixedDialog

2. Override the OnResize method and set the size to be constant.

Free your mind...

Re: How the disable the resize function of a form

Anonymous30-Mar-04 18:51

Anonymous

30-Mar-04 18:51

In VB.Net form, under Properties of the form, you should set the Maximize button to "FALSE" and there is a Minimumzise & Maximumsize that you need to supply its values in order to disable the maximize button, e.g form size is 300X300, so set Minimumsize to 300 & maximumsize to 300...

Re: How the disable the resize function of a form

superwinsock30-Mar-04 21:56

superwinsock

30-Mar-04 21:56

If you haven't resolved this yet.....

'In the Resize event of your form set the size properties to be constant
Private Sub MDIForm_Resize()

On Error GoTo Handler

With Me
.Height = g_lngHeight + 1425
.Width = g_lngWidth + 180
.Top = 0

End With

Exit Sub

Cliff

How to save content of a picturebox to jpg and content of a richtextbox as a normal text file?

MJay30-Mar-04 6:25

MJay

30-Mar-04 6:25

as topic, i wish to create a normal save file function to save a content of a picturebox to jpg or bmp format, and content of a richtextbox as a normal text file.. in the reverse way... can anyone provide also the coding for open file command? load a jpg or bmp file to the picturebox and load a normal text file to richtextfile... any help is greatly appreciated... VB.NET

How to Unzip files using VB.Net

Anonymous30-Mar-04 5:11

Anonymous

30-Mar-04 5:11

Need to unzip some files that were zipped using WinZip in vb.net. Not sure if there is freeware addins out there to do this or if a purchase has to be made. Anyone know ?

Call MDI form procedure in Toolbar

LC Chan30-Mar-04 4:35

LC Chan

30-Mar-04 4:35

Hi All,

I created a Toolbar in the Main form and it has some buttons like Add,Change,Delete. Let's say there are 2 child forms A & B.
In each form, a public procedure - add_record() - is created.

Now, I'd like to call the child form - add_record() in the button.click() event. But it seems the compiler didn't accept it.

Here's the code in tool bar click event.

Protected Sub toolBar_Click(ByVal sender As Object, 
                             ByVal e As oolBarButtonClickEventArgs)

    Select Case tblMain.Buttons.IndexOf(e.Button)
    Case 1
        Call Me.ActiveMdiChild.add_recod()    /* build error occur */
    End Select
End Sub

I think i'm using a wrong approach with Toolbar.

Would anyone give me some advice.

Many thanks, Wilfred Smile | :)

Re: Call MDI form procedure in Toolbar

Charlie Williams30-Mar-04 5:25

Charlie Williams

30-Mar-04 5:25

Me.ActiveMdiChild returns an instance of type Form. You're getting the error because Form doesn't contain a method called add_Record.

You need to cast the return value of Me.ActiveMdiChild to the type of the child form the contains that method.

CType(Me.ActiveMdiChild, MyMdiChild).add_Record()

Charlie

if(!curlies){ return; }

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.