|
That's a nice idea but System Modal dialogs died with Windows 9x.
|
|
|
|
|
Hmm, good to know... Hadn't made any since the 90s, so guess I'm a bit behind on this.
|
|
|
|
|
There's no such thing as a System Modal dialog anymore. Why? Because you're taking away the users ability to switch to other tasks if required.
How I've seen something like that done in the (recent) past is the app created a new Desktop, switched to it, showed a normal window in that desktop, then proceed as normal. When the dialog was dismissed, the new Desktop was removed, switching back to the original user desktop.
BTW, this is actually how the UAC nag dialog works in Vista and 7. The darkened desktop image that you see is merely a screenshot of the user desktop copied to the new desktop.
Since you're using a seperate desktop, there's nothing else for the user to click on, effectively making your form "modal".
You can find a nice example of creating Desktops here[^].
|
|
|
|
|
I don't have a use for this information (at this time), but that alternate desktop thing is something I neither knew, nor even had a clue about.
That's getting filed away for future use, and you get a "Good Answer" for it. Thanks!
|
|
|
|
|
how to convert vb code into c#?
|
|
|
|
|
VB6? Manually. No tool can turn a "program" into a decent program.
VB.NET? there are convertors around, some are free. Search[^].
And Reflector can show pseudo-source in the .NET language you choose, so you could build a VB.NET app and look at its C# equivalent (no comments, no meaningful names for local identifiers, ...).
|
|
|
|
|
There are many VB - c# converters available, but you will still need to go through the converted code as they are not 100% reliable.
Complex code in VB gives rise to 'interesting' results in c#, so if it is a smallish program it may be worth rewriting it yourself rather than converting.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Hello
How can i filter information saved in ms.acess between 2 datepicker that i have installed in my form?
|
|
|
|
|
You need to have a WHERE clause in your SQL statement that filters between the dates, something like this:-
WHERE datefield > ?StartDate AND datefield < ?EndDate
Then you add the parameters to your command object like this:-
cmd.Parameters.AddWithValue("?StartDate", yourStartDate)
cmd.Parameters.AddWithValue("?EndDate", yourEndDate)
Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
Can you post a demo project?
|
|
|
|
|
Sorry, this is a forum for asking specific questions. You should be able to find plenty of examples on the internet, if you just google VB.Net ADO demo .
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
In addition to the standard Where operation already provided above, I think you can also use the BETWEEN operator with Access;
Select something From theTable Where theDate Between date1 And date2
|
|
|
|
|
With this code i can filter all the data depending from the supplier.
but i can't filter data between 2 dt pickers
Set ac = New ADODB.Connection
Set ar = New ADODB.Recordset
Call DB
ac.Open strConek
lvSupply.ListItems.Clear
With ar
criteria = "Select *From tblSupply"
.Open criteria, strConek, adOpenStatic, adLockOptimistic
.MoveFirst
Do While Not .EOF
If Mid(!Supplyer, 1, Len(cboSupplyer)) = cboSupplyer Then
Set intitem = lvFurnizimet.ListItems.Add(, , !ID, , 1)
lvSupply.ListItems(lvSupply.ListItems.Count).SubItems(1) = !Date
lvSupply.ListItems(lvSupply.ListItems.Count).SubItems(2) = !Time
lvSupply.ListItems(lvSupply.ListItems.Count).SubItems(3) = !Supplyer
lvSupply.ListItems(lvSupply.ListItems.Count).SubItems(4) = !VTotal
lvSupply.ListItems(lvSupply.ListItems.Count).SubItems(5) = !UserName
End If
.MoveNext
lvSupply.SetFocus
Loop
.Close
End With
Label4.Visible = True
Label5.Visible = True
Label4.Caption = lvSupply.ListItems.Count
Label5.Caption = "Total number of supplyes :"
End Sub
|
|
|
|
|
If you had included this code in your original question you would have received some more usefull answers. Now, why can't you do a select that's limited with two dates?
Are you getting an error, or are you unsure how to adapt the code you already have?
..and why are you using VB6?
Bastard Programmer from Hell
|
|
|
|
|
I'm not getting errors but i can filter only the data from supplier,not by date pickers.
I use VB6 because i find it very easy in use.
thank you for your help.
|
|
|
|
|
BETWEEN probably works fine, however it is unclear to me whether it is including/excluding the boundary values; so I tend not to use it, for clarity's sake.
|
|
|
|
|
It appears to include the opening value and excludes the closing, so i always add a day to the end e.g. if i wanted everything from the 12th to the 15th Jan, i would do;
Between '12/Jan/2011 00:00' And '16/Jan/2011 00:00'
edit: and i always use 3 letter month to avoid confusion with the day
|
|
|
|
|
i want to thank you all for your willing to help me.
i'm confused now what can i do now for filter the dates.
Still i can filter only by supplier.
i appreciate your help and god bless you all.
|
|
|
|
|
All the information has been provided.
Simply append the datepicker date values to the query as per what has been shown above, e.g.
criteria = "Select *From tblSupply Where dateColumnName Between " + datePicker1.value + " AND " + datapicker2.value
You will need to change the dateColumnName and the controlsnames for datepickers and check the datepicker property name for the returned date value, i can't remember for sure of the top of my head if it is called value or not, but i'm sure you can look this up seeing as it is your project!
If you find that the second date value does not catch all the expected results, you might want to add 1 day to this value using DateAdd
|
|
|
|
|
I found this code searching in the net.but even this can't work.i have inserted this code under
txtData1_Click
<pre lang="vb"> Set ac = New ADODB.Connection
Set ar = New ADODB.Recordset
Call DB
ac.Open strConek
With ar
criteria = "Select *From saledetails Where ((Data >= '" & txtData1.Value & "') And (Data <= '" & txtData2.Value & "' ))"
.Open criteria, strConek, adOpenStatic, adLockOptimistic
If .RecordCount > 1 Then
|
|
|
|
|
I don't know what your table column names for the date are? are you sure its Data and not Date?
|
|
|
|
|
|
The other thing I noticed is the source table name has changed from tblSupply in your original question to salesDetails above, are you working with the correct source, your query syntax format is basically correct.
|
|
|
|
|
is tblSupply.this is not the problem...
when i click the dtpicker 1
nothing displays in listview
|
|
|
|
|
Well i don't know where your running code from, are you looking at the change events for the data picker, which should then fire off a query update using the info.
I get hte feeling you are just copy and pasting code without really thinking about what you are trying to achieve. As a result you are getting yourself tied up in knots and confusing the hell out of yourself and me!
|
|
|
|