|
hellow to all
i am trying to make insert statment into a access database ..
i write the folloing statment
MyOledbCommand.CommandText = "Insert Into Messages " _
& "(firstname,lastname,username,password,date) " _
& "Values (" & "'" & String2 & "', " & "'" & String3 & "', " & "'" & String4 & "', " & "'" & String5 & "')"
but i keep getting the msg Syntax error insert statment ..
the more odd thing is that i use the same statment in other form and it run's fine !
what could be the problem ..
i had tried million thing and possibilities nothing is working 
thxx a lot
|
|
|
|
|
maybe the problem isnt with your statment, but with your connection?
|
|
|
|
|
You may wnat to check the values of each string, If one of them contains a single quote mark, then your insert statement will fail.
|
|
|
|
|
"Date" is a VB reserved word, don't take it a habit of using reserved words, however u can still use it as a DB fieldm enclose it with "[]"
MyOledbCommand.CommandText = "Insert Into Messages " _
& "(firstname,lastname,username,password,[date]) " _
& "Values (" & "'" & String2 & "', " & "'" & String3 & "', " & "'" & String4 & "', " & "'" & String5 & "')"
good luck
|
|
|
|
|
hello everybody,
first off i wanna say thanks to everybody behind this website, its a great source of knowledge.
now im having trouble adding mouse events to the cards being drawn using the cards32.dll functions, ive looked around but cant find anything that would explain what im supposed to do.
what i need is to be able to click/drag (interact) with the cards drawn using cdtDrawExt function.
thanks in advance.
|
|
|
|
|
I'm attempting to tackle a problem I have no experience with. Does anyone know a good resource where that I can use to be able to interface with a barcode scanner in order to navigate a application. (The application I'm creating has mouse or keyboard input devices, only a barcode reader. It will ONLY allow a user to scan an object and progress/navigate throughout the application by means of a barcode reader.)
Any ideas?
shannon
|
|
|
|
|
If you are using scanner with keyboard interface, its just as simple as typing from a keyboard. Use notepad, scan a barcode, the data read will be displayed in the notepad.
Hope it helps
:->
|
|
|
|
|
There is no keyboard input. The user is using a industry barcode scanner to vehicle parts. The scanner is th only input device. Any ideas?
Shannon
|
|
|
|
|
How does it interface with PC? is it RS232? or does it have additional peripheral like PCI Interface cards? . . . . In that case, I think you should be contacting the "Barcode Scanner Vendor" regarding the drivers or commands you will use to communicate with the machine.
If it is via RS232, try it with "Microsoft Comm Control", but still u need to know the commands you will be sending to the machine.
Hope it helps.
|
|
|
|
|
Thank you for your suggestions! They did in fact point me in the right direction.
Shannon
|
|
|
|
|
I show/hide different forms by defining the forms in a module:
Public Class formLibrary
Public Shared frmMain As Form
Public Shared frmComponents As Form
Public Shared frmNewProject As Form
....
End Class
Then I use the following to close the current form and open another:
Dim newFrmMain As New frmMain
formLibrary.frmNewProject.Hide()
newFrmMain.ShowDialog()
This is working perfect for all forms in my project except one. When I attempt to open the frmNewProject, I get this error:
An unhandled exception of type 'System.NullReferenceException' occurred in Mule! Data Management Tool.exe
Additional information: Object reference not set to an instance of an object.
..on this line of code:
formLibrary.frmNewProject.Hide()
Has anybody ever experienced a problem like this?
Thanks
Brad
|
|
|
|
|
Your form declaration is this:
Public Shared frmNewProject As Form
And you recieve an unhandled exception here:
formLibrary.frmNewProject.Hide()
The reason is because .Hide is not a shared sub procedure of the Forms Class, therefore you are required to instantiate a Form object instance.
For instance:
Public frmNewProject As New Form
|
|
|
|
|
In other words, when you trying to hide a form that does not exist in memory 
|
|
|
|
|
Thanks. That works (anyway it gets me through the code with no exception). But now frmNewProject does not hide. I can't select it but it is still visible.
Any ideas?
Thanks
Brad
|
|
|
|
|
Do you have a code sample of what you have changed and how you are using .Hide? And what do you mean when you say
Brad Fackrell wrote:
I can't select it but it is still visible.
|
|
|
|
|
The class is where my forms are declared:
Public Class formLibrary
Public Shared frmOpenProject As New Form
Public Shared frmMain As Form
Public Shared frmScoringJustification As New Form
Public Shared frmProjectName As New Form
Public Shared frmDatesAndLocation As New Form
Public Shared frmPOC As New Form
Public Shared frmArticulation As New Form
Public Shared frmCollectorsAndNotes As New Form
Public Shared frmComponents As New Form
Public Shared frmPrint As New Form
Public Shared frmNewProject As New Form
End Class
The code that I use to Hide and Show:
Dim newFrmMain As New frmMain
formLibrary.frmNewProject.Hide()
newFrmMain.ShowDialog()
When I execute this, frmMain loads and is active. frmNewProject is still visible (behind frmMain, frmMain is a small form; about 30% of the screen) but I cannot select it or any of it's controls.
Thanks for your help.
|
|
|
|
|
I'm not quite sure why your frmNewProject would still be visible...but the reason why you cannot select it or any of it's controls is because you are showing your frmMain as modal.
Brad Fackrell wrote:
newFrmMain.ShowDialog()
When you use .ShowDialog, you are displaying your form modal, meaning you can not access any other form until you close your frmMain.
Going back to your frmNewProject, where are you showing the form in code? If .Hide is not used, is it possible to .Close the form? Just to make sure it is accessing that line of code.
I did a quick test with your class and placed a .Show and .Hide in two button events. It worked with no problems...so in theory, it should be working for you?
|
|
|
|
|
Anonymous wrote:
where are you showing the form in code?
I have a btnClick that calls:
Dim newFrmMain As New frmMain
formLibrary.frmNewProject.Hide()
newFrmMain.ShowDialog()
...nothing else in the btnClick sub.
Anonymous wrote:
If .Hide is not used, is it possible to .Close the form?
No. I think it goes back to what you said about newFrmMain.ShowDialog() only allowing newFrmMain to be accessable.
In fact, after removing formLibrary.frmNewProject.Hide(), it seems like that line of code is doing absolutely nothing.
I've gone through frmNewProject with a "fine tooth comb" to see if there is anything that could be making it 'hang'...no luck finding anything.
|
|
|
|
|
Try commenting out the newFrmMain.ShowDialog()...does your code execute the formLibrary.frmNewProject.Hide()? Give the debugger a try as well, and step into that line of code. It should be executing.
Also, where did you place the code to display the frmNewProject form? (formLibrary.frmNewProject.Show())? I am assuming you did show the frmNewProject...otherwise, the line formLibrary.frmNewProject.Hide() will execute, but you won't have a form to hide, therefore appearing like it did absolutely nothing.
|
|
|
|
|
Anonymous wrote:
Try commenting out the newFrmMain.ShowDialog()...does your code execute the formLibrary.frmNewProject.Hide()
No. It stays visible and active.
Anonymous wrote:
Give the debugger a try as well
It appears to execute just like any other .Hide that is working properly. The debugger doesn't do much at that line. Is there something specific that I can look for?
Anonymous wrote:
where did you place the code to display the frmNewProject form? (formLibrary.frmNewProject.Show())?
In the form that is displayed prior to frmNewProject I have a btnClick with this:
Dim newFrmNewProject As New frmNewProject
formLibrary.frmOpenProject.Hide()
newFrmNewProject.ShowDialog()
Strange thing that I have noticed, after executing the btnClick to hide frmNewProject and show frmMain, I can close frmMain using the 'X' in the upper right hand corner (frmMain_Closed) but the application stays running and frmNewProject is once again active.
|
|
|
|
|
Brad Fackrell wrote:
Dim newFrmNewProject As New frmNewProject formLibrary.frmOpenProject.Hide() newFrmNewProject.ShowDialog()
Does this code work in the form displayed prior to frmNewProject?? If that works, then you have a very strange situation as it is the exact same code when you are attempting to display your newFrmMain.
But...I think the problem is the following:
In your class code you have:
Public Class formLibrary<br />
Public Shared frmOpenProject As New Form<br />
Public Shared frmMain As Form<br />
Public Shared frmScoringJustification As New Form<br />
Public Shared frmProjectName As New Form<br />
Public Shared frmDatesAndLocation As New Form<br />
Public Shared frmPOC As New Form<br />
Public Shared frmArticulation As New Form<br />
Public Shared frmCollectorsAndNotes As New Form<br />
Public Shared frmComponents As New Form<br />
Public Shared frmPrint As New Form<br />
Public Shared frmNewProject As New Form<br />
End Class
Take note of the bold line in your class. Then in your btnClick event you placed:
Dim newFrmMain As New frmMain <br />
formLibrary.frmNewProject.Hide() <br />
newFrmMain.ShowDialog()
Again take note of the bold. Then in your previous form when you display your frmNewProject you had:
Dim newFrmNewProject As New frmNewProject formLibrary.frmOpenProject.Hide() <br />
newFrmNewProject.ShowDialog()
Now if I am correct, when you are attempting to hide your frmNewProject using this line of code (in your btnClick):
formLibrary.frmNewProject.Hide()
It is executing...BUT it is hiding the frmNewProject in your fromLibrary class...which hasn't actually been displayed to the user. Thus appearing to do abosulutely nothing.
How does that work? You are creating a new (local) instance of frmNewProject and then using the .ShowDialog to display it. So, you can test my theory by changing what you had in your previous code:
<br />
Dim newFrmNewProject As New frmNewProject<br />
formLibrary.frmOpenProject.Hide() <br />
newFrmNewProject.ShowDialog()
Try changing it to:
'Dim newFrmNewProject As New frmNewProject formLibrary.frmNewProject.ShowDialog()<br />
'newFrmNewProject.ShowDialog()
I know I jumped around alot...but the main idea is that in your code you are attempting to .Hide a form that hasn't actually been displayed to the user. This is because the formLibrary.frmNewProject and newFrmNewProject are two different instances.
I hope that makes sense?!?
|
|
|
|
|
Yes, that makes sense. I appreciate all of your help on this.
Brad
|
|
|
|
|
Hi, I currently faced a problem on inserting decimal value from vb .net into SQLCE which declared as money data type. ANyone know how to solve this??
Thanks in advance!
|
|
|
|
|
Hi all,
I'm working with the SoapFormatter class and I can serialize my TreeNode with no problems. But I get the following error when I try to deserialize my content.
System.Reflection.TargetInvocationException
Exception has been thrown by the target of an invocation.
The exception is thrown at the bolded line below:
<br />
Dim lSoapFormatter As New SoapFormatter<br />
Dim lReader As Stream = File.Open(asFilePath, FileMode.Open, fileAccess.Read)<br />
<br />
'deserialize the content<br />
Dim lTreeNode As TreeNode = CType(lSoapFormatter.Deserialize(lReader), TreeNode)<br />
<br />
'close reader<br />
lReader.Close()
The InnerException indicates that I have an InvalidCastException.
System.InvalidCastException: Specified cast is not valid.
at System.Windows.Forms.TreeNode..ctor(SerializationInfo si, StreamingContext context)
The thing that doesn't make any sense is that it is working fine on my machine (the one I developed my application on) but when I attempt to run it on another person's machine it throws this cast exception!? 
I transferred my source code to this machine which is how I found out it was throwing this InvalidCastException in debug mode, but I have no clue how to resolve this!
Any ideas?! Please help!
|
|
|
|
|
I have a dropdown list called ddlstat and I want to populate it with values from a database table called status. The value I want to get from Status table is Status name.
here is the code for ddlstat:
Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged
End Sub
Does anyone have the code to use to populate a ddl.
Thanks
macca
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
