|
I don't know much SQL but if your code is an exact copy...
"...SION_PK is not null) AND" & strConditionDates)"
put a space between the AND and the quote, or add a space to the front of strConditionDates.
|
|
|
|
|
I can see that the sql statement is malformed.
Currently reads:
"select distinct FK_Mission_PK from [sql_équipage des missions] where ((FK_MISSION_PK is not null) AND((Mission_Date >= #" & txtDate1 & "#) AND (Mission_Date <= #" & txtDate2 & "#) AND (Mission_Code = '" & Me.ListBoxMission_Code & "'))"
Should read:
"select distinct FK_Mission_PK from [sql_équipage des missions] where (FK_MISSION_PK is not null) AND (Mission_Date >= #" & txtDate1 & "#) AND (Mission_Date <= #" & txtDate2 & "#) AND (Mission_Code = '" & Me.ListBoxMission_Code & "')"
|
|
|
|
|
How to find no of pages printed this job
How to find no of copies Make in CD Writter
-- modified at 12:58 Wednesday 5th October, 2005
|
|
|
|
|
I have a button on a form that calls an instance of another form, but when this form is closed by the user it need to clear a textbox on original form.
I am having a problem clearing textbox?
The code I use to call instance of form is:
Private Sub btnDrift2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDrift2.Click
Dim Drift2 As frmDrift2
Drift2 = New frmDrift2
Drift2.Show()
End Sub
The code on the second form to clear textbox is:
Private Sub frmMap_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
Dim Snow As frmSnow
Snow = New frmSnow
Snow.tbxMapStatus.Text = ""
End Sub
Any Help?
|
|
|
|
|
Replace all the code in the sub of the second form with this:
frmSnow.tbxMapStatus.Text = ""
|
|
|
|
|
I get the blue line
States:
Reference to a Non-Shared Member Requires a Object Reference.
|
|
|
|
|
You can have a try using module to give name for both forms as:
public drift2 as new frmDrift2
public snow as new frmSnow
then in the those two program you donot need NEW again!
you can just directly to use drift2.show() and snow.tbxMapstatus.text ="" it works fine!
I am Entry level person
|
|
|
|
|
hi
how to display the combobox items in ascending order. if combo box containing "name" feild, how to display in alphabatical order.
please help me.
|
|
|
|
|
Just set the Sorted property of the combobox to TRUE.
|
|
|
|
|
hi
i am using date-time-picker for "date of birth" field. another column called "age" has to fill automaticaly after entering date of birth column. how to do this?
please inform.
|
|
|
|
|
Dim intAge as Integer
intAge = DateDiff("yyyy",DateofBirth,Date)
Hint: Replace DateofBirth with the value of whatever variable name you are using for the DateofBirth field.
|
|
|
|
|
Good morning everybody,
I have a Question concerning the Types that can be used in Functioncalls. (It's about usability...)
Let's say I got this Function:
function Foo (byval chooseTime as INTERVALL )
TIMEVALUES is an enum like this:
Public Enum INTERVALL As Integer
D_EFAULT = 0
SEC_5 = 5000
SEC_10 = 10000
SEC_30 = 30000
MIN_1 = 60000
MIN_5 = 300000
MIN_10 = 600000
End Enum
When someone is calling the Function Foo he will see a dropdownlist where he can choose one of the values in the enum.
My Problem now is that I only want a dropdown with the Values (e.g. D_EFAULT,SEC_10 etc.) instead of the whole path that is presented (e.g. INTERVALL.D_EFAULT....). Is that possible in any way ?
Thank you very much
cu
immes
|
|
|
|
|
Dear ,
My application is client- server application and one module is used for send file to server application for mail sending purpose.
If the user type the mail text than click send button it will save to the database,than it will convert to XML(from Dataset) ,than the file will be
zipped than it will pass accros the Dial-up Network.The server will recieve the file and Unzip it ,than the XML file convert to dataset and saved
and save to the database .this will work fine but when i want to see the mail .,I opened that mail,that time the appliaction crash and give this error
and sometime when i click the mail delete button ,the application crash. can u help me in my case.
if u need more info about scenerio,please mail me
Error Ocuured In Form : frmMail
Error Ocuured In Module : Button10_Click
Error Ocuured At Time : 10/4/2005 2:29:24 PM
Exception Occured In ITICSMS Server :
Message : Object reference not set to an instance of an object.
Source : System.Windows.Forms
StackTrace : at System.Windows.Forms.SafeNativeMethods.MessageBox(HandleRef hWnd, String text, String caption, Int32 type)
at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options)
at System.Windows.Forms.MessageBox.Show(String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton)
at CSMSServer.frmMail.Button10_Click(Object sender, EventArgs e)
Explanation : System.NullReferenceException: Object reference not set to an instance of an object.
at System.Windows.Forms.SafeNativeMethods.MessageBox(HandleRef hWnd, String text, String caption, Int32 type)
at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options)
at System.Windows.Forms.MessageBox.Show(String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton)
at CSMSServer.frmMail.Button10_Click(Object sender, EventArgs e)
================================================================================
Error Ocuured In Form : MdlStart
Error Ocuured In Module : Main
Error Ocuured At Time : 10/4/2005 2:29:39 PM
Exception Occured In ITICSMS Server :
Message : Object reference not set to an instance of an object.
Source : System.Windows.Forms
StackTrace : at System.Windows.Forms.UnsafeNativeMethods.PeekMessage(MSG& msg, HandleRef hwnd, Int32 msgMin, Int32 msgMax, Int32 remove)
at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at CSMSServer.mdlConnect.main()
Explanation : System.NullReferenceException: Object reference not set to an instance of an object.
at System.Windows.Forms.UnsafeNativeMethods.PeekMessage(MSG& msg, HandleRef hwnd, Int32 msgMin, Int32 msgMax, Int32 remove)
at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.ThreadContext.RunMessageLoopIn ner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at CSMSServer.mdlConnect.main()
Ishak
|
|
|
|
|
Hello everybody
I'm doing a programming using VB6.0.
My question is..
How am I going to code the coding for combo box.. For smart card reader..
How the combox will detect there are a new card reader installed to the computer.
yani
|
|
|
|
|
The combobox doesn't do this at all. It won't detect anything because it's not designed for this.
Your application has to detect and use the SmartCard reader through whatever SDK you can find for it. Check the manufacturer's website to see if there is any developer information for it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Damn what a useless comboBox, what were they thinking
|
|
|
|
|
Hi all,
I am a VB.net programmer recently doing a project to interface with digital camera or web cam. I understand that there is a WIA driver which can be program in VB.net but only on Window XP. Is there any similiar for Window 2000 ?
Tx and best regard
|
|
|
|
|
WIA comes standard built into Windows 2000, XP, 2003 and Vista.
Everything else must download and install it seperately.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave,
Tx for the info. But when I try to add in the reference in the VB.net, I can't locate WIA ? Do u have any info about this files under window 2000 ?
Tx and best regard
|
|
|
|
|
It's the System.Management.dll. There's no difference between 2000 and XP and 2003. Once you add a reference to that, you can import the System.Management namespace[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
do you know how to paste clipboard to grid??
its giving me tedious time,kindly help me.
thanks
|
|
|
|
|
hi there,
just simply read data from clipboard and then paste it into the grid
this link might give u a hint on this:
Clipboard
<< >>
|
|
|
|
|
I have two forms, Form1 and Form2. Form2 is opened when a button in Form1 is clicked. What I try to implement is when Form2 is closed, Form1 is also closed.
Thanks.
|
|
|
|
|
Lets say form1 is the form you want to close
Dim Form As form1
Form = New form1
Form.Close()
|
|
|
|
|
In form2 Unload event write the foll.
Unload form1
|
|
|
|