|
Hello,
i am creating my report table in word doc using VBA. When my application hangs and trying to open the word doc again, it says, document is locked by user or some time popup comes asking want to open as ready only. How can i close the word doc before opening it again.
Thanks and regards
Jishith
|
|
|
|
|
write the below code in closing event
wrdDoc.Close(False)
wrdDoc = Nothing
wrdApp = Nothing
or
kill the application from the process
|
|
|
|
|
jishbalan wrote: When my application hangs
If your application hangs, you don't get the opportunity to close the file properly. That's why you can't open it on the next run. The system still thinks you have the file open. Your code cannot correct this situation, unless you manage to stop hanging in the first place.
|
|
|
|
|
|
hi guys, Am trying to write a program that uses multiple threads to transfer large files over the internet. I also want to limit each chunk transferred to 1024 bytes to prevent timeouts and make it scalable. The transfer speed should depend on the number of threads used and not the size of the buffer/chunk. Any suggestions would be appreciated. Thanks in advance.
|
|
|
|
|
You haven't asked a question or described a problem...
|
|
|
|
|
Can anyone suggest me how to develop a translation software?
what are the basic requirements?
|
|
|
|
|
|
language
eg:
english to spanish
french to english
|
|
|
|
|
This is going to be a very difficult project. You have to be able to parse a sentence, approximate it's meaning, and lookup a similar concept in a dictionary to return the proper word or phrase in the new language, then string the piece together in a manner that makes sense in the new language.
You're not going to get a course in doing this in a forum environment. There is no one book that is going to cover doing this and there are entire university course sets that just scratch the surface of this topic.
Google results for "writing your own language translation software[^]".
|
|
|
|
|
I have an application which uses a SQL connection and brings data into a datagridview. The app allows the user to take this data, make changes on it and then save these changes.
This is fine when the user only brings back and manipulates around 100 - 1000 records, when the recordset is higher than this, all records that have been manipulated get inserted into the database apart from 1 record.
The error message within the application says 'Cannot insert NULL value into column 'QuoteID', column does not insert NULL's. Insert failed.
The app always brings back this error when using a large recordset, when i look in the db to see how many had been imported, every record is saved except one.
Just wondering if anyone had come across something like this before.
|
|
|
|
|
Shrimpersfan wrote: The error message within the application says 'Cannot insert NULL value into column 'QuoteID', column does not insert NULL's. Insert failed.
from above message, it is clear that column 'QuoteID' does not allow null value. whether you debug your code for record which have null value for column 'QuoteID'. Check for the last row of datagridview which may be contain null value for column 'QuoteID' (or for all fields)
|
|
|
|
|
Hi Rupesh.
I have looked at the databases and looked for any NULL's in QuoteID but none appear. In my datagrid view, there is a white space below the last field (space to enter another record) but i shouldn't think the app will be trying to import a record from this.
It's also strange how the import works with a smaller dataset but not with a large one.
I have commandtimeout's in my code too.
David
|
|
|
|
|
Shrimpersfan wrote: I have commandtimeout's in my code too.
whether you try to increase CommandTimeOut?
|
|
|
|
|
Yes i tried different intervals, in the end i used 0 so the app should never time out.
David
|
|
|
|
|
can you post the code snippet so i review it for some clue?
|
|
|
|
|
Well my app uses stored procedures to call up data, will be a lot of code
|
|
|
|
|
Hmmm.
i want to show only the code that how can you update the data from datagridview to database.Most probability is that you can not supply value of column 'QuoteId'( or all field for last record)
|
|
|
|
|
Hi Rupesh.
I seem to have sorted the problem. It seems as though a client had info missing in a completely seperate table.
Thanks again.
David
|
|
|
|
|
Hi,
I am pretty new at this programming stuff but I am using VB 2008 express to create a Terminal application that can save data received from serialport to a txt file. I have problems figuring out the right code to save it to text file. So far, I have gotten to the point of activating the datareceived handler but I am lost on how to get it to save to file. I have no idea how data received works as well. Could someone please enlighten me on how this works?
|
|
|
|
|
Quin Nee wrote: I have no idea how data received works as well. Could someone please enlighten me on how this works?
You write code that handles the DataReceived event where you check the BytesToRead property to see if there is any data that came in on the serial port. If there is, well, you read the data using the appropriate Read method of the SerialPort class.
Quin Nee wrote: but I am lost on how to get it to save to file
There's plenty of How-To examples for manipulating files here[^].
|
|
|
|
|
Dear Dave,
Thanks for the hints. I have the program up and running but it's still rough around the edges for my project. Is it possible to recognise the type of data cming in? For example, the device connected to the computer is a wireless node which receives transmissions from other wireless nodes. I want to read the data from each node and save it into different files like the MAC add of each node. Is it possible to do so in VB.NET. So far most of what I read about serial comms is just reading character or data. A colleague suggested using a look-up table to classify the data received. I'm not too sure how it works though. Btw, please take a look at my codes and inform me if there are any better methods of doing it.
Imports System.Text
Imports System.IO.Ports
Public Class Form1
Dim WithEvents serialPort As New IO.Ports.SerialPort
Dim mystringbuilder As New StringBuilder
Private Sub Form1_Load( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles MyBase.Load
For i As Integer = 0 To _
My.Computer.Ports.SerialPortNames.Count - 1
ComboBox3.Items.Add( _
My.Computer.Ports.SerialPortNames(i))
Next
Button2.Enabled = False
End Sub
'-------------------------------------------
' Event handler for the Connect button
'-------------------------------------------
Private Sub Button1_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
If serialPort.IsOpen Then
serialPort.Close()
End If
Try
With serialPort
.PortName = ComboBox3.Text()
.BaudRate = 9600
.Parity = IO.Ports.Parity.None
.DataBits = 8
.StopBits = IO.Ports.StopBits.One
End With
serialPort.Open()
TextBox2.Text = ComboBox3.Text & " connected."
Button1.Enabled = False
Button2.Enabled = True
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
'-------------------------------------------
' Event handler for the Disconnect button
'-------------------------------------------
Private Sub Button2_click( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button2.Click
Try
serialPort.Close()
TextBox2.Text = serialPort.PortName & " disconnected."
Button1.Enabled = True
Button2.Enabled = False
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
'-------------------------------------------
' Event handler for the DataReceived
'-------------------------------------------
Private Sub Serialport_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles serialPort.DataReceived
'This happens on another thread
mystringbuilder.Append(serialPort.ReadExisting())
Me.Invoke(New EventHandler(AddressOf UpdateControls))
End Sub
Private Sub UpdateControls(ByVal sender As Object, ByVal e As EventArgs)
'Do any UI code here on the main thread
My.Computer.FileSystem.WriteAllText("J:\Test\test.txt", mystringbuilder.ToString(), True)
End Sub
End Class
Most of it was copy and paste but I do get the general understanding of the program. I still feel that the data received section can be improved. I hope to hear from anyone soon about this.
|
|
|
|
|
Quin Nee wrote: Is it possible to recognise the type of data cming in?
Only if you write something to parse the data you've received.
Quin Nee wrote: I want to read the data from each node and save it into different files like the MAC add of each node.
This is only possible if the data you're getting contains that information. If not, there's no way to tell where it came from.
Quin Nee wrote: So far most of what I read about serial comms is just reading character or data
And that's all serial comm is, reading and writing character data.
Quin Nee wrote: Btw, please take a look at my codes and inform me if there are any better methods of doing it.
I can't tell you that because it depends on your requirements, situation, hardware, data your getting and if you want two way communication. What you have now just writes everything to a file, but doesn't have anything to parse the data you're getting nor handle cases where you haven't received enough data yet to parse a command.
|
|
|
|
|
Thanks for the quick reply,
Then how do I parse data? Btw, the data received through the serialport is expected to have MAC address and other information in the form of bits. I believe the data will be in integer forms. How do I change it from ASCII form to readable data?
|
|
|
|
|
Hi,
Looking for a bit of help. I have a program that draws a graph and plots some values. What I want to do is when I hover my mouse over one of the values, up pops a box which shows a bit more information. Is this possible or is there a control to do this?
Thanks for your help
|
|
|
|