If connection is possible then how to configure it?We have the database of Access in 1 network and front-end of VB to totally in another network? how to connect?
Simply put, if you have all administrative rights and permissions, you should probably use a tunnel to bridge the 2 networks and place the Access database on a shared drive.
Note that I absolutely don't recommend this as it will be slow as hell and Access is not a database server, so don't count on it to perform at all.
A real solution would be to convert your Access DB to a real DB server like Oracle, Informix, MySQL or other similar products and use ODBC from your VB program.We have the database of Access in 1 network and front-end of VB to totally in another network? how to connect?
you need NLD (serial technology) if both networks are within one country or ILD for multi national link to connect distant networks. Both have WAN network links required mid range routers of L3 switches to have such link. You are talking about point to point link beetween 2 distant networks, are mostly connect with serial technology.
Tuesday, November 16, 2010
Using VB, how can i prevent the results to be shown if the values inserted are wrong?
For example, if the user inserted in two text fields two values out of range and then he pressed OK, some unknown values such as (Nan) is shown in the result text, what codes shall i use to make warning box that to come out and ask the user to insert values within specific range and prevent the those unknown values to be shown in the Result text?Using VB, how can i prevent the results to be shown if the values inserted are wrong?
I don't know VB, but try this tactic. I know that in Java, there is something called a JFormattedTextField where you can say what data can be typed in, see if there's something like that in VB. Or, you could use a spinner (a text field with two arrows pointing up and down) to scroll through values. If this was in Java, I could have helped you a bit more.
I don't know VB, but try this tactic. I know that in Java, there is something called a JFormattedTextField where you can say what data can be typed in, see if there's something like that in VB. Or, you could use a spinner (a text field with two arrows pointing up and down) to scroll through values. If this was in Java, I could have helped you a bit more.
How to write one project exe open at the time same project exe cant open another time in vb.net?
example: SampleProject.exe open and working at the time same system without close sampleproject.exe. cant open sampleproject.exe.
now my exe open each time please help. only one time open exe.How to write one project exe open at the time same project exe cant open another time in vb.net?
One idea is to store a value in the Registry that tells your program if another instance of the program is running. In other words, you would use a key like ';IsRunning'; and set it to True (using SaveSetting) while your program is running, and set it to False when the program terminates. Have the program use GetSetting when it starts, and if IsRunning is True, pop up a message box to tell the user that another instance is running and then exit.
now my exe open each time please help. only one time open exe.How to write one project exe open at the time same project exe cant open another time in vb.net?
One idea is to store a value in the Registry that tells your program if another instance of the program is running. In other words, you would use a key like ';IsRunning'; and set it to True (using SaveSetting) while your program is running, and set it to False when the program terminates. Have the program use GetSetting when it starts, and if IsRunning is True, pop up a message box to tell the user that another instance is running and then exit.
What should I be aware of for a migration from VB.NET 2003 to VB.NET 2008?
Hey all,
I've been asked to take a very large program and migrate it to the lastest version of VB.NET. How big a project is this and are there any things I should look out for or plan for?
Any tips/tricks/ideas?
Thanks in advance!What should I be aware of for a migration from VB.NET 2003 to VB.NET 2008?
As stated above, the project converter will take care of this for you.
The only caveat I can think of offhand is if your 2008 application references a 2003 web service. In that case, you'll want to make sure your 2003 web service runs as a .NET 2.0 or 3.5 application (you can change this in IIS).What should I be aware of for a migration from VB.NET 2003 to VB.NET 2008?
any one idea about how to download .net 2008
You shouldn't have any problem migrating it. Visual Studio 2008 will have a wizard that will ask you a few questions before doing so.
The simple conversion will not be to bad. That being said there have been numerous things added that will make the program ';better';. Generics would be one aspect that you might look into adding in. Also you might consider replacing all of the manual dispose with using statements and let all of that be handled in a more efficient manner. Depending on the application you might benefit from some of the features added in 2008 as well such as LINQ etc. Also my experience has shown that there were people using direct sql statements in 2003. I would like to believe that they are all gone now but that is a different question. Make sure that all of your data calls are coming through procedures if that is not something already in place. Other than that bring good coding practices up and maybe change everyplace that you get a warning telling you there is a new way to do something and you should be fine.
I've been asked to take a very large program and migrate it to the lastest version of VB.NET. How big a project is this and are there any things I should look out for or plan for?
Any tips/tricks/ideas?
Thanks in advance!What should I be aware of for a migration from VB.NET 2003 to VB.NET 2008?
As stated above, the project converter will take care of this for you.
The only caveat I can think of offhand is if your 2008 application references a 2003 web service. In that case, you'll want to make sure your 2003 web service runs as a .NET 2.0 or 3.5 application (you can change this in IIS).What should I be aware of for a migration from VB.NET 2003 to VB.NET 2008?
any one idea about how to download .net 2008
Report Abuse
You shouldn't have any problem migrating it. Visual Studio 2008 will have a wizard that will ask you a few questions before doing so.
The simple conversion will not be to bad. That being said there have been numerous things added that will make the program ';better';. Generics would be one aspect that you might look into adding in. Also you might consider replacing all of the manual dispose with using statements and let all of that be handled in a more efficient manner. Depending on the application you might benefit from some of the features added in 2008 as well such as LINQ etc. Also my experience has shown that there were people using direct sql statements in 2003. I would like to believe that they are all gone now but that is a different question. Make sure that all of your data calls are coming through procedures if that is not something already in place. Other than that bring good coding practices up and maybe change everyplace that you get a warning telling you there is a new way to do something and you should be fine.
How can I shut down my PC using a VB Script?
Hi all,
I would like a VB script which, when opened, shuts down the PC. I will admit that I know nothing about VB and do not have the time to learn. I need this for an outside application... I don't think it should be difficult for an experienced programmer. Thanks!How can I shut down my PC using a VB Script?
The above answer is a good answer for doing it in VB Script (right out of XP).
But, if the script is going to be invoked from a command script, on XP, like a .bat or .cmd, check out the ';shutdown'; command line command.How can I shut down my PC using a VB Script?
hey you dont need that at all,just do the normal way
strComputer = ';.';
Set objWMIService = GetObject(';winmgmts:'; _
%26amp; ';{impersonationLevel=impersonate}!\\'; _
%26amp; strComputer %26amp; ';\root\cimv2';)
Set colOperatingSystems = objWMIService.ExecQuery _
(';Select * from Win32_OperatingSystem';)
For Each objOperatingSystem in colOperatingSystems
objOperatingSystem.Shutdown
Next
I would like a VB script which, when opened, shuts down the PC. I will admit that I know nothing about VB and do not have the time to learn. I need this for an outside application... I don't think it should be difficult for an experienced programmer. Thanks!How can I shut down my PC using a VB Script?
The above answer is a good answer for doing it in VB Script (right out of XP).
But, if the script is going to be invoked from a command script, on XP, like a .bat or .cmd, check out the ';shutdown'; command line command.How can I shut down my PC using a VB Script?
hey you dont need that at all,just do the normal way
strComputer = ';.';
Set objWMIService = GetObject(';winmgmts:'; _
%26amp; ';{impersonationLevel=impersonate}!\\'; _
%26amp; strComputer %26amp; ';\root\cimv2';)
Set colOperatingSystems = objWMIService.ExecQuery _
(';Select * from Win32_OperatingSystem';)
For Each objOperatingSystem in colOperatingSystems
objOperatingSystem.Shutdown
Next
Can you open a program with VB script?
I'd like to make a thing that opens a message box, then a program. I can't figure out how to open a program with VB script, though. Is there a way? If so, what is it?Can you open a program with VB script?
Robert, You can do anything with anything. click on link below...
Robert, You can do anything with anything. click on link below...
How to make a calculator project in Excel using vb?
Just +, - ,* ,%26amp; / these operations enough ,i am a beginner give full detailsHow to make a calculator project in Excel using vb?
1. 1st open a new workbook, Alt+F11 go to vba editor, on the left side, right click on a icon and choose insert userform, when click on this userform toolbox of controls appear, click the textbox button and click and drag a rectangle on the userform to create an entry box, create another textbox just underneath the 1st one.
2. click on the commandbutton on the toolbox, click and drag a rectangle to create a button on the userform, make another four for each of the calculation sign,
3. click on the label button on the toolbox, click and drag a rectangle to create a button on the userform, that would be for the displaying the result
4. click on each of the button, go to the properties window on button left(F4 to open if not already there), change the value right of caption to +, -, x, / respectively for 4 buttons
5. click on the label, go to properties and delete the value in right of caption, change the background color of this label(if like) by clicking on box right of Backcolor, palette,
6. right click on each of the calculation sign button,
for + put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value * 1 + TextBox2.Value * 1
for - put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value - TextBox2.Value
for x put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value * TextBox2.Value
for / put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value / TextBox2.Value
7. if you want to add feature to it like only calculate when both textbox have number add following line to each of the 4 sub
If TextBox1.Value = ';'; Or TextBox2.Value = ';'; Then Exit Sub
Here's a demo illustrate the above http://www.freewebs.com/swhtam/YA/myCalc鈥?/a> Alt+F11 and right click on the userform1, view code to see all the code listed above, view object to see the set up of userform1.
Please contact for more details
1. 1st open a new workbook, Alt+F11 go to vba editor, on the left side, right click on a icon and choose insert userform, when click on this userform toolbox of controls appear, click the textbox button and click and drag a rectangle on the userform to create an entry box, create another textbox just underneath the 1st one.
2. click on the commandbutton on the toolbox, click and drag a rectangle to create a button on the userform, make another four for each of the calculation sign,
3. click on the label button on the toolbox, click and drag a rectangle to create a button on the userform, that would be for the displaying the result
4. click on each of the button, go to the properties window on button left(F4 to open if not already there), change the value right of caption to +, -, x, / respectively for 4 buttons
5. click on the label, go to properties and delete the value in right of caption, change the background color of this label(if like) by clicking on box right of Backcolor, palette,
6. right click on each of the calculation sign button,
for + put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value * 1 + TextBox2.Value * 1
for - put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value - TextBox2.Value
for x put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value * TextBox2.Value
for / put the following into the ';Private sub CommandButton Click()'; and ';End Sub';
Label1.Caption = TextBox1.Value / TextBox2.Value
7. if you want to add feature to it like only calculate when both textbox have number add following line to each of the 4 sub
If TextBox1.Value = ';'; Or TextBox2.Value = ';'; Then Exit Sub
Here's a demo illustrate the above http://www.freewebs.com/swhtam/YA/myCalc鈥?/a> Alt+F11 and right click on the userform1, view code to see all the code listed above, view object to see the set up of userform1.
Please contact for more details
Subscribe to:
Posts (Atom)