This is a easy one (i think) I am using MS access 2003 and. I am having problems continuing SQL statments to another line. I have been trying &_ and that doesnt seem to work with my SQL statements. How do I do this. I have some long SQL statments and it would be easier to break to another line, but I can't seem to do this. The statment below gives an error.
sqlz = "SELECT [Crosstab AUS].* INTO [AUS REQ] &_
FROM [Crosstab AUS]"
When you are putting in a long string of code it doesn't all fit, so I want to know if there is a way to continue that string on the next line. I believe it's something like & _ if I'm correct in thinking. But I'm not perfectly sure, I guess the question I'm asking is if you can continue a string with & _ or if it is something else.
View 6 RepliesHow do you continue a select statement on additional line in vb
View 3 RepliesI have this do while loop that I am having trouble with. I need to know how to make the loop continue to the next line after it has looped around once. So far I have it outputting like this.
$*$*$*$*$*$*$*$*
But what I really need it to do is output like this
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
I'm writing a command-line application in .Net. The app itself is fairly simple, but it has to connect synchronously to a web-service, which in turn has to connect to a Oracle database, and those pieces are fond of taking their time.
Is there a straightforward way (without dividing my app exe in two) to continue executing but nonetheless yield execution to the command prompt?
It's Windows, so no "&". Also, I cannot use cmd.exe's "start" cmdlet.
what i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.
sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.
full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0
[code]....
how to read text from a listbox line by line and put current line in a label?
View 3 RepliesHow would i go about reading a file Line by Line that within that line The values are delimited by " Example of the data:
"bob" "cat" "1243"
"steve" dog" "6789"
I've started this with this code but not sure how to go about the next stage:
Using MyReader As New _
Microsoft.VisualBasic.FileIO.TextFieldParser(My.Application.Info.DirectoryPath & "Records28112011.jd")
MyReader.TextFieldType = FileIO.FieldType.Delimited
[code]....
I am trying to read in a TextBox line by line and take the first 7 characters of each line and output everything in another TextBox.This is what I have so far.
Dim line, lines() As String
lines = TextBox1.Text.Split(Environment.NewLine)
Dim i As Integer = 0
[code].....
Program that will log in to a site and only if its correct, it will continue.?
View 1 RepliesIs there a code or command that i put in my code for the press any key to continue command to activate in my console application. I already know about press Ctrl F5 i want to if there is any code that I could implement at the end of my program that would do the same as pressing Ctrl F5 if the ran the program by press the play button.
View 1 RepliesI was given a half-finished project to finish. It was written in C++ using Visual Studio 2005.
Is it possible to somehow continue the project in VB.Net?
I have a 'For Each...' loop in the VB.NET code for one of the pages on my website. There is also a Try/Catch block within this code that currently contains an 'Exit Sub' in the event of an error being trapped. However, what I would actually like to do is to merely exit the current loop value and recommence the loop at the next value in the sequence.
How can I do this?
Im making a application where you need to click in the webbrowser before the button will be enabled, how to do it?
View 3 RepliesI am making a Tetris program and I have a 2d array 10 by 20 for the grid.I want the Tetris blocks I have created to move down one block every second unless the user presses "a" or "d" (to move left or right) then the block should move left or right whilst moving down.The problem is that I have created a loop for it to delay a bit but then it waits for the user to press a key until it continues the program. So the block will stop moving down and just stay where it is until they press something.I have been told that you can do this in C with something like if keyboardhit or kybd() or something then it will read the key but otherwise it will just skip that bit and loop round. So how can I do this in VB?
View 2 Repliesi would like to know if there is a Way that when an exception is thrown to let the program continue aftare the exception was thronw for example
try
line 1
line 2
[code].....
I recently created a test VB.NET 2008 project with an Access database and it seems to work okay. It uses a dataset and table adapters. I'm aware that some people don't like table adapters. I'm willing to learn another way if it's better. Should I do this or continue using table adapters?
View 2 RepliesI'm writing in Visual Basic, using Visual Studio Standard 2008, targetting framework 3.5.When debugging, I pause code and edit it in my Startup Project, then continue running.Where the code moves into one of my non-startup projects, I am sure I used to be able to edit that code and continue running.Now, whenever I try and do that, I get a dialog stating that "Changes are not allowed when the debugger has been attached to an already running process", even though I can still edit code in the already-running startup project.All of my code is in VB, there's no weird language crossover thing going on. Why can't I edit-and-continue my non-startup projects?
View 6 RepliesFollowing is an example how I am trying to use continue. Do Until oRSOracle.EOF sSql = " ....." 'Executing sql Set oRSDB04 = oConnDB04.Execute(sSql) If Not oRSDB04.EOF
Then continue ??? (how to use continue) end if loop
64 bit is a wonderful thing, except that MS currently has no plans to make a 64-bit IDE. However, you CAN compile your program to be 64 bit using AnyCPU or x64 compile options. However, by using either of those options, you cannot edit-and-continue.To enable edit-and-continue on an x64 machine, you must set your compile option to x86 in the Platform property of 'Project Settings > Compile'. If you do not have that option available, be sure that you select 'Tools > Options > Projects and Solutions > General > Show Advanced Build Configurations'.
View 2 RepliesI want to know exactly how well I can depend upon the continued existence of VBScript. I am considering embedding VBScript in a computer system that I will be developing. Whatever scripting language that I choose must be interpreted, and it must have minimal object oriented support (it must have classes).
View 7 RepliesWhy can't I activate Edit And Continue? When I go into the Options, "Enable Edit And Continue" is checked but it's not allowing me to edit code at run time.
View 2 Repliesi need the app to preview the line in textbox in timeintervalof 1 s (can be change)nd when it will reach to the end it close the text file and andreread it after let say 1 m ..
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myStream As Stream = Nothing
[code].....
what if you created a pool of numbers: 1 - 21 and then chose a random selection from the pool? Something like the following:[code]This gets rid of those messy if statements and all of those loops.
View 1 RepliesI am using the MsgBox Function as a help on my program to notify users of unusable entries in my program. After the MsgBox pops up, and the user clicks on either 'OK' or 'Cancel', the program need to clear the box that the bad data was entered in, and continue with the program. What I am trying to do I guess is keep the program from returning unusable values by informing the user of entries that will return such values. But, where I am running into a problem is in when I click on OK or Cancel, the program continues as if nothing was called as a result of the MsgBox info being thrown.
Here is the code I have so far, mind you that I have used several of the other MsgBox codes to no avail.
I think what I need to do is have a line of code that calls my "textbox.clear" if certain criteria are met. but when I tried this, the program did not return to my GUI, it simply ran with a value of "0" in the "textbox.text" that the clear was called on.
The idea with System.IntPtr is to represent an integer whose width in bits correspond to the size of a pointer in the hardware and operating system that the CLR is running in, it's platform specific in other words. It supports 32-bit and 64-bit architectures only.This is a legacy from old-style C API's where pointers and ints were frequently treated as interchangeable. The Win32 API has many such parameters, where the width varies with the underlying architecture thus the mess with porting of code from 32-bit to 64-bit (we already did this once when going from 16-bit to 32-bit, funny how we never learn...).In practice, as is mentioned in other responses, it can be used to hold unmanaged resource handles and pointers etc that stem from the underlying Win32 functions. It can also be used to hold integers of the natural size for current platform. You can also use IntPtr.Size to dtermine the size of a pointer on the current platform.SO when you explain this to a child ;) this would be used to let program's flow at the same speed at diffrent kinds of operating systems?
View 1 RepliesI've written a testing program where my students write a test and the results are compiled in a text file. The text file is then emailed to me using SMTPServer.send(MyMailMessage). The program works, except that it takes a number of seconds for the email to be sent. The user clicks the next button, which should bring him/her back to my login screen for the next student, but instead it hangs while sending the email. How do I get it to do the emailing in the background, allowing the person to continue using the program?
View 3 RepliesI am making a test paper where counter is there. I have to continue it as user clicked on next button..
Code i used for timer on form 3 is:
Public Class Form3
Inherits System.Windows.Forms.Form
Private alarmTime As Date
[Code].....
I've been trying to write code below many time, but it still doesn't work.
Public Class Form1
Private Sub Form1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown
If e.KeyCode = Keys.LShiftKey Then
MsgBox("Left Shift")
End If
End Sub
End Class
So I don't how to do it continue to get Left Shift Key pressing.
I have the following problem:
I've got 3 lines
If I click the "next" button
Line 1 shall be highlighted
Then I I click ""next" again
[Code].....
a for i = 1 to 3 to loop within the Button1_click makes i directly 3 of course so line 1 and 2 will not be highlighted.
I am not allowed to use a msgbox in between cause then it would be easy, cause I would wait until "OK" would be pressed...
How can I make this for i = 1 to 3 loop work and highlight the lines 1, 2 and 3, one by one after pressing the "Next" button?