|
I'm glad I don't have to type that email out, I can't even say it never mind trying to remember how to spell it!
|
|
|
|
|
I need also a lot of things ....
I cannot remember: What did I before google?
|
|
|
|
|
I need to know the secret of eternal youth, but I won't ping you for it.
------------------------------------
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[ ^]
|
|
|
|
|
Hi there,
I have been searching the web for quite some time now, searching for a way to keep the mouse cursor under a forms control: Not letting the mouse leave the form. I found many answers using the SetCapture function in the user32 lib. However, I cannot get anything to work/the examples used deprecated materials(this was the case most of the time).
Does anybody know how to make a form keep control of the mouse? Examples would be great.
Thank You,
Shawn
PROJECT DESCRIPTION:
I am making a terms and conditions form which will run on start of every computer. I need to make the mouse stay inside the forms control. If the user clicks accept, the form should close; if the user clicks decline, the user should be logged out.
|
|
|
|
|
That's not exactly the most secure solution, considering how many different ways a person can interact with a PC... It'd be very easy to circumvent.
I would suggest instead making your window "system modal", which basically means the user can't interact with anything else until your window is closed.
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
