Visual Basic

can i programatically enable the macro of word2003...

2-Jun-07 9:19

You'd have to either move the button like I show'd you before, you you would have to dynamically create an entirely new button and place it on Panel2. A control cannot be a member of two different controls collections at the same time. In other words, a control cannot show up in two different places at the same time.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

koolprasad20032-Jun-07 2:24

koolprasad2003

2-Jun-07 2:24

Hello my good frnds,

can any one tell me, how can i programatically ENABLE the macro in word 2003, IS IT POSSIBLE ?????

if yes..then please tell me how can i ??? any code ???

i am using vb.net 2.0

Thankx in advance,
koolprasad2003 Smile | :)

Be A Good S/W Eng... Life is swing with you..Enjoy..

Re: can i programatically enable the macro of word2003...

Dave Kreskowiak2-Jun-07 9:16

Automating Database connection

2-Jun-07 9:16

You can't. In order to enable the macro code to run, the macros would already have to be enabled!

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

ips_sun2-Jun-07 0:13

ips_sun

2-Jun-07 0:13

Hi experts!
my query is.. can we create a dynamic conncation string at run time... no matter to which database we r connecting to.. it may be SQL server, Oracle, MYSQl, ACCESS... etc.
when ever i execute my appplication... the user shud be able to choose from the available drivers.... to which database they want to make connection ... like a wizard. i am using VB 6.0.
Or is it possible that ... the wizard which Microsoft provides for connection string...cud be called directly into the application.. from which connection shud be made automatically depending upon which database does the user has selected... is there any aPI to handle this!!! the reason.. i m askin this.. is to avoid the massive chunk of code to be written! which is surely gonna hang me up in the office for next couple of weeks!
Any suggestions please...!!
thanx in advance..!

Re: Automating Database connection

Dave Kreskowiak2-Jun-07 9:15

displaying mesage [modified]

2-Jun-07 9:15

A connection string is nothing but a normal string of text. You need to have template strings for all the database engines you're going to support. You can find examples at http://www.connectionstrings.com[^].

After that, you'd have to write a data layer for each database engine you're supporting too. Access doesn't support the same SQL syntax that SQL Server does and Orcale has it's own flavor too. Each version of this data layer would implement an Interface that you write to provide all the functions you need.

To support all this, you wouldnt be saving yourself frmo writing a "massive chunk" of code, you'd be guaranteeing it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

trialnerror1-Jun-07 23:42

1-Jun-07 23:42

hello there good programmers... a little help here about vb code that can display a message while in 3d environment. any idea?

to explain further. am now coding a server/client program. and my problem is when i send a message to the client program the user cant see it while in 3d environment. how do i solve this problem? is there any other solution?

thank you very much...
jigs

-- modified at 7:01 Saturday 2nd June, 2007

Re: displaying mesage

Christian Graus2-Jun-07 1:21

2-Jun-07 1:21

How are you sending this message ? If a 3D game is running, I'm not sure what you can hope to do, Windows will not be processing any drawing messages.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: displaying mesage

trialnerror2-Jun-07 1:44

2-Jun-07 1:44

the server program sending a message in the client in normal way. recving a string then displaying it using normal window.

the problem is, its not displaying the message in the time its arrive but instead its in the back or behind of the 3d program when the user in the workstation which have a client program is in 3d environment. the scenario should like this

server
|
|
workstation (client running in 3d environment e.g. 3d games)

>> actually the workstation with client program receiving the message and displaying it but its in the back of the 3d program. i want to make a vb program that can display message wether its in 3d program or in normal mode. its possible?

Re: displaying mesage

Christian Graus2-Jun-07 1:54

Re: displaying mesage [modified]

2-Jun-07 1:54

If it is, it would involve detecting that DirectX was being used, finding the directX surface in use and rendering to it.

trialnerror2-Jun-07 2:08

Re: displaying mesage [modified]

2-Jun-07 2:08

nice idea thnx, but is it possible to display a message in windowless environment? if the client program detected dx8, is it possible to dislay message in the top of the 3d program? do i need a hooking technique or it is just simple detection and display in 3d way..?

>>> ok i'll make a experiment if its possible
-- modified at 8:28 Saturday 2nd June, 2007

trialnerror2-Jun-07 3:35

2-Jun-07 3:35

i have no idea how to detect if directX is loaded or not... o boy having troubled with this program.

-- modified at 9:40 Saturday 2nd June, 2007

Serialization....

Sonia Gupta1-Jun-07 23:33

Sonia Gupta

1-Jun-07 23:33

Serialization is the process of writing the data in a class, i.e. the values of its properties - into a string that can be written to disk, or sent to an object in a client program. It's approximately the equivalent of putting data into a DBF. So what's the big deal?

Re: Serialization....

Dave Kreskowiak2-Jun-07 9:06

Create a login username & password

2-Jun-07 9:06

You may want to read up on Serialization[^]. You've generalized it way too much.

Serialization converts an objects data into a trasmittable or saveable form, be it binary or text based.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Serialization....

Navneet Hegde3-Jun-07 21:02

Navneet Hegde

3-Jun-07 21:02

yes , Serialization is Process of packing data , but added it encode the data pack's it so that it can be sent over wire.
Main advantage of serialization is that it ca be used to access object between different Processes over different machines.

Thanks & Wishes
Navneet Hegde
Nashik(City Of Pilgrimage)

Develop2Program & Program2Develop

ravenathan1-Jun-07 23:02

1-Jun-07 23:02

Can Somebody please show me an example code on how to make a user login and password that will look to a database table with fields username & password for verification.

I would greatly appreciate your help.

Thanks & more power to the group....
neal

Christian Graus1-Jun-07 23:22

1-Jun-07 23:22

Is this a windows app or a web app ? Which bits are you stuck on ? Do you know any SQL ? Do you know how to access a database ? What is the database you're using ?

ravenathan1-Jun-07 23:40

1-Jun-07 23:40

yes sir its in MS VB6.0 and the database is in ms access and it is in windows app.

Thank you very much for your interest on helping me...

Regards,
Neal

Christian Graus2-Jun-07 0:33

2-Jun-07 0:33

OK - VB6 is a dead language. You need to specify if you're using VB6, as people will assume .NET otherwise.

ravenathan2-Jun-07 1:02

Re: Create a login username and password

2-Jun-07 1:02

Sir christian,Its not in .Net. Sory I'm not specific in details. But once again. Thank you very much for your concern on helping me.

May you contionue your support to all people in-need of help. God Bless!

Best regards,
Neal

Rupesh Kumar Swami2-Jun-07 0:19

Rupesh Kumar Swami

2-Jun-07 0:19

hi neal,

takes two text box(TextBoxlogin,TextBoxpassword) and on click event of button use following code
Dim q As String
Dim oleadapter As OleDbDataAdapter
Dim mdataset As New DataSet

If TextBoxlogin.Text = "" or TextBoxpassword.Text = "" Then
MsgBox("Enter Login ID & Password ", MsgBoxStyle.Information, mdGlobal.myMessage)
TextBoxlogin.Focus()
TextBoxlogin.Text = ""
TextBoxpassword.Text = ""
Exit Sub
End If

try
q = "select * from login where username='" & TextBoxlogin.Text.Trim & "' and password='" & TextBoxpassword.Text.Trim & "';"
oleadapter = New OleDbDataAdapter(q, mdGlobal.conn)
'where mdglobal is module and conn is oledb connection object
oleadapter.Fill(mdataset) ' mdataset is dataset

If mdataset.Tables(0).Rows.Count > 0 Then

loginok = True
Me.Close()
mainform.show
Else
MsgBox("Wrong Login ID / Password ", MsgBoxStyle.Information, mdGlobal.myMessage)
TextBoxlogin.Focus()
TextBoxlogin.Text = ""
TextBoxpassword.Text = ""
End If
Catch ex as exception
msgbox (ex.message.tostring)
End Try

hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

Re: Create a login username and password

ravenathan2-Jun-07 0:55