|
I believe your problem is that you are trying to compare two string dates as if they were date values, which of course you cannot do successfully. The only way you can successfully compare 'dates' as strings would be to arrange the dates in yyyymmdd format so that they have a 'numerical' value to which you can apply an operator.
I would suggest that the dates be stored in the database as either proper dates, or as the string representation of the date in yyyymmdd format. EIther of these would make it much easier to handle date comparisons.
If changing the database structure to a date is not possible at this stage you may have a problem unless you can change the string storage to a more usable format.
David Loring
!! Keep Music Live !!
|
|
|
|
|
I'll weigh in on this, I have had several projects where the client data was stored as a string. They always want to query by a from -> to date on these fields. Your best bet is to backup the data then change the field in the database to a date field then make sure the change took. Now you can change your code so that the search won't need to be converted to do what you want.
Just my 2 cents...
|
|
|
|
|
hi,
how can i query duplicate records
from a ms access table.
ram
|
|
|
|
|
How are you going to enter duplicate records
Develop2Program & Program2Develop
|
|
|
|
|
for example
tblA
col1 col2
101 AAA
102 BBB
101 AAA
103 CCC
103 CCC
select col1, col2 from tblA gorup by col1, col2 having count(*) > 1
returns all rows which are repeated
Regards
KP
|
|
|
|
|
I have two froms, one form has button called "Close",
when I clicks the "Close" button then two forms are closed.
I wants to close that "Close" button from not all the forms.how can I handle this????????
Thiwa
|
|
|
|
|
Maybe posting your code will help.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
try me.close in the close button code
|
|
|
|
|
me.close not worked.It cloased all the forms I open.
I want to close only one form.
THiwa
|
|
|
|
|
if u povide me the code u coded .
|
|
|
|
|
frmLoging.Close()<br />
MDIMain.Show()
when Im using this not showing the MDIMain form.
All the forms are closed.
Thiwa
|
|
|
|
|
problem is when u closing the fmlogging form .it destroys the object of all others.
so it will be fine if u hust hide the frmlogging
frmlogging.hide.
|
|
|
|
|
|
I guess you are closing MDI Form and all other forms seems to be its Child Form . Do take a look at it
Develop2Program & Program2Develop
|
|
|
|
|
NO.frmLogin form is not a MDI child.
Thiwa
|
|
|
|
|
Sir/Madam,
I am using the following code to display the button dynamically in vb.net 2005.
But the button is not appearing.
Dim b1 As New System.Windows.Forms.Button
b1.Name = "pankaj"
b1.Text = "1"
b1.Location = New Point(11, 111)
b1.Size = New System.Drawing.Size(100, 130)
b1.TabIndex = 2
b1.UseVisualStyleBackColor = True
b1.Show()
Please help.
Thanks and regards
Panakj
|
|
|
|
|
You also have to add it to the Controls collection on the form.
|
|
|
|
|
are you missing this ??
Me.Controls.Add(b1)
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
You forgot to add the button to the Form.Controls set. Use
Me.Controls.Add(b1)
inside the form.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
|
I hope you got the answer to your question, but also remember
Me.controls.Add() adds control to form
so you can also manipulate it to add like
groupbox1.controls.add
panel.controls.add
etc
Just take Note of Parent Control
Develop2Program & Program2Develop
|
|
|
|
|
|
hi all
i have VS2005 without crystal report
so i will use report
i want help for
How to creat report with parameter passing
(also don't know how to creat report)
|
|
|
|
|
where is the problem lying i parameter passing .
|
|
|
|
|
actully i don't know how reports generet
|
|
|
|