Visual Basic

Re: nahelp me in this printing problem-- nidhi s

14-Jul-05 3:31

Without seeing your actual code, it's a bit difficult to determine what caused the error. But, it would seem that your code tried to retrieve the value of a cell in a datagrid and either the cell returned a null object or the specified cell didn't exist in the first place.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Member 211512814-Jul-05 3:53

Member 2115128

14-Jul-05 3:53

there is a main form,when button on mainform clicked another form with datagrid is called which contains the print button actually the instance of datagrid form is created in mainform is that a problem

Re: nahelp me in this printing problem-- nidhi s

Dave Kreskowiak14-Jul-05 4:24

Change SQL Server startup account to SA

14-Jul-05 4:24

Don't make me repeat myself. WITHOUT SEEING YOUR CODE, it's impossible to tell you what your doing wrong.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Toms Edison14-Jul-05 0:46

Toms Edison

14-Jul-05 0:46

Hi,
Anyone got source code to change SQl Server startup account to SA.
I need this to be run in my installation.

VB script will be very helpful.

Thanks,
Toms

Re: Change SQL Server startup account to SA

Dave Kreskowiak14-Jul-05 1:16

Selecting dropdown value automatically

14-Jul-05 1:16

SA?? What do you mean "startup account"? The SA account is only used internal to SQL Server.

By "startup account", I take it you mean the Windows service account that the SQL Server runs under. In this case, you'll have to create a Windows account called "SA" and change the service LogOn parameters.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

macca2414-Jul-05 0:44

macca24

14-Jul-05 0:44

I have a textbox which holds a date and I also have a dropdown box which has 3 values to select.
When the webform is loaded the date field is empty, the dropdown box has a value selected at load time which is Form A. What I want is that when I add a date to the date field then the value in the dropdown box will change to Form B which is in the dropdown list.

The code I have is as follows:

Private Sub dbxStatus_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dbxStatus.SelectedIndexChanged

End Sub

Private Sub tbxDateSigned_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tbxDateSigned.TextChanged
If tbxDateSigned.Text = True Then
'dbxStatus.SelectedValue = "Signed Off"
dbxStatus.SelectedValue = "Signed Off"
End If
End Sub

This code doesn't work.
Anyone any ideas?

macca

Gavin Jeffrey14-Jul-05 0:50

Gavin Jeffrey

14-Jul-05 0:50

do you get an error?

try using changing your if statement to be -

If tbxDateSigned.Text.length > 0 Then

Gavin Jeffrey14-Jul-05 0:53

Gavin Jeffrey

14-Jul-05 0:53

you may need to make the textbox autopostback equal true. Cause it will only get to that code once you have done a postback. You may want to consider doing this type of thing in javascript.

macca2414-Jul-05 0:56

macca24

14-Jul-05 0:56

Have you any javascript code that might o this type of thing or any resources to get me started on this.

Thanks,
macca

Re: Webbrowser navigation to a file included in .RES file

Gavin Jeffrey14-Jul-05 1:42

Gavin Jeffrey

14-Jul-05 1:42

You would have to do something like described below (havent tested it so you will have to play around a bit to get it working the way you want)
in page load put this line of code
tbxDateSigned.attributes.add("onblur","changeDropDown()")
Then create a javascript function like so -
function changeDropDown()
{
var element = document.getElementById("dbxStatus");
element.selectedIndex = 2;
}
as for resources you can try looking here or just google for javascript -
http://webdevelopment.developersnetwork.com/Search.asp?Category=6[^]

<help me>Access

vtalau13-Jul-05 23:44

vtalau

13-Jul-05 23:44

Help me
I have a trouble again with M.Access. I have a combo-box on a form, and this combo-box has the responsibility on showing the Query which creates the 4-column table, including Company,Name,Address and ClientID.

My purpose is that I want to show this Query in the combo-box in the order A-Z, before the blank company items.
My solution:
I create a query like below:
select .........
from nhanvien
where company is null
union
select .........
from nhanvien
where company is not null
However, the result isn't right like my hope. I think that the reason is because of the order of the ClientID which is the primary key...As a result, the destination query automatically sorts on the ClientID order.
Thinking of the solution :
I don't know how to do to archieve that result. I think so much about the SQL sentence of the above query. I believe that there's another SQL sentence helping me to solve this problem. I'm very happy whether you give me a SQL sentence to do that or another solution to obtain the same result ....

Thanks so much <vtalau>

Re: <help me>Access

SBendBuckeye14-Jul-05 13:01

SBendBuckeye

14-Jul-05 13:01

vtalau wrote:
select .........
from nhanvien
where company is null
union
select .........
from nhanvien
where company is not null

Try This

<br />
select 1, .........<br />
from nhanvien<br />
where company is null<br />
union<br />
select 0, .........<br />
from nhanvien<br />
where company is not null<br />
order by 1<br />

What I did was add a new column in front of your currently selected data and then sorted by column number 1. That should put all of your null items last.

Have a great day!

j2associates_NO_SPAM_@yahoo.com

Rudy Schramm13-Jul-05 20:01

Rudy Schramm

13-Jul-05 20:01

Can anyone tell me whether a webbrowser (MS Internet Control) can navigate to a file included in the vb6 resource file directly without transferring the file to a directory? Thanks.

Re: Webbrowser navigation to a file included in .RES file

Dave Kreskowiak14-Jul-05 1:13

Re: Webbrowser navigation to a file included in .RES file

14-Jul-05 1:13

Yes it can, using the res protocol (res://). The resource file must be built correctly though.

Storing and Showing HTML Resources in a VB Application[^]
Embedding HTML files in an EXE or DLL resource file[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Rudy Schramm15-Jul-05 2:22

Rudy Schramm

15-Jul-05 2:22

Thank's a lot, Dave.

Message Box new line?

phraser13-Jul-05 11:35

phraser

13-Jul-05 11:35

Hello im using MessageBox.Show() to display popup message boxes, i am trying to create a new line for some text im using. I have tryed /r/n and /n both dont work.

How can i create a new line?

Thanks
Oi

Christian Graus13-Jul-05 12:39

Christian Graus

13-Jul-05 12:39

Environment.NewLine

Christian Graus - Microsoft MVP - C++

phraser13-Jul-05 12:42

phraser

13-Jul-05 12:42

Thanks worked fine Smile | :)

Im also trying to hide a proccess when its run can you help with this

The code i am using is as follows

Dim startInfo As System.Diagnostics.ProcessStartInfo
Dim pStart As New System.Diagnostics.Process

startInfo = New System.Diagnostics.ProcessStartInfo("C:\test.bat")

pStart.StartInfo = startInfo
pStart.Start()
pStart.WaitForExit() 'Your code will halt until the exe file has executed.

The batch file is shown as it executes how can i hide this?

Thanks
Oli

Christian Graus13-Jul-05 12:44

Christian Graus

13-Jul-05 12:44

Unless you can get a handle on the console window and then hide it in code, I'm afraid I don't know.

Christian Graus - Microsoft MVP - C++