|
Go into Access and Design your database table. When you define the fields of your table, one of the field type options, the column after your field name, is AutoNumber.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
is it possible to set the data grid when user click on the column it will do ascending sort or descending sort?
|
|
|
|
|
Yes. How it's done depends greatly on the version of VB or VB.NET you're using.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i'm using VB6, but i didnt found the function on the properties...
|
|
|
|
|
It's been 6 years since I've used VB6...Let me see...IIRC, the VB6 DataGrid doesn't have any support built in for sorting. I think you had to sort the ADODB.RecordSet you bound the grid to. There was a Sort property on the Recordset object that you set something like this:
myRecordSet.Sort = "LastName ASC, FirstName ASC, Age DESC"
My VB6 is pretty rusty so don't take this as The Official Word...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello.
Basically I am trying to modify mouse events in a VB web browser. My first goal was to try and make a right click on the AxWebBrowser control to act as a left click. So both mouse buttons would act as left click. Yet when I was messing with some code it seems AxWebBrowser doesnt have MouseEvents ?
This is the code I am using to detect a mouse click on the control, but I get error!
Private Sub AxWebBrowser1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles AxWebBrowser1.MouseDown
If e.Button = MouseButtons.Right Then
'do something
End If
End Sub
Any information on trying to work with mouse events and a web control would be nice.
Thanks
|
|
|
|
|
This won't do what you want it to anyway. You can't change the mouse click inside the event handler. The mouse "event", message really, will still get passed to the Browser as a right-click.
The only place you can change buttons clicked on is using a global mouse hook. You have to change the mouse message BEFORE your application ever gets it.
-- modified at 23:17 Tuesday 15th August, 2006
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hey all
I'm confused here. I have an mdi application which will recognize keystroke that i hit. However, it seems to recognize the hit when it's first time loaded. After that, if I switch the focus to another window, it wont recognize the hit anymore. How can I make it recognize the hit everytime it's got focus?
Thanks
|
|
|
|
|
Try using event Got focus... on that other form...
|
|
|
|
|
I did, it doesn't work
|
|
|
|
|
What do you mean by "if I switch the focus to another window"?? If this means what it should, then the form won't see any keystrokes until it has the focus returned to it. Are you saying that the form won't see keystrokes when the form has focus again??
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Yes, you are correct.
Let's say you open the application, then, you open internet explorer (example). You go back to the application, then the keystrokes won't be recognized.
This happens if I open an mdi child too. After i closed the child, the the parent wont see the keystrokes anymore.
Did i mention this is MDI application. :P
Thank you
|
|
|
|
|
I haven't seen this problem myself and I can't find any information on it either. It could be caused by something you have installed on the machine.
When you close the child windows, does the MDI form show that it got the focus? The title bar of the window should turn Blue again.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
2 situations here.
First one, is when i have 2 mdi children.
I tried to test it by putting the following code on 1 mdi child form.
me.text = "deactive"
in my onDeactivated event.
and
me.text = "active"
in my onActivated event.
When I choose another mdi child, The Text changed to deactive, but when I switch back to the first mdi child, the text doesnt change back to active.
Second, With the MDI Container itself. I tried the same method, on the mdi container
I opened another application, and choose that application, the text on the mdi container is change to deactive, and when i switch back to the MDI application, the text changed to active again .
However, it still doesn't recognize the keystroke. I think it's not the focus that we're talking about here. I dunno what it is, but it sure is weird -_-
thanks
|
|
|
|
|
The first thing I'd look into is disabling everything I don't need on the machine. After you login to the machine, hold down one of the Shift keys to stop everything in the Startup folder from executing, then try your app again. I still can't find anything about anyone else ever seeing this kind of problem.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello.
A beginner programmer here.
I am trying to read a file. I am currently able to read the file in and write the file to a new file location. There are between 4,000-7000 records with each record 56 lines long. I need to read the invoice date located on line 7 of each record(or line 7,63,119,175 etc) & Column 45-53 . How do I loop thru to find the invoice date and then compare the date(datediff). If the posted date on the invoice is greater than 10 days from today() date, I want to append "old" next to the invoice date and write the appended line to a new file, example "08/02/06old". If the date diff is not more than 10 days then I want to ignore and write the line exactly as it is. I need to write the entire file to a new file while only appending any lines that are greater than 10 days. If someone can show me in code that would be so helpful. Thanks
I can attach a sample file if that would be helpful
mark
-- modified at 15:28 Tuesday 15th August, 2006
|
|
|
|
|
MrMarkH wrote: There are between 4,000-7000 records with each record 56 lines long.
That is ludicrous. At this point, you need a database.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Please define ludicrous. I am not an expert by any means but I feel you are way off the mark with your comment, if you could explain or better yet show an example then maybe I can better understand your position. I am recieving a flatfile and would like to change the file based on my stated criteria. If you can help, then it is appreciated.
|
|
|
|
|
4-7,000 records is WAY to many to store in XML, let alone plain text, even if they were all one line long, rather than 29.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
You may be right but I am recieving different info so I will proceed in another direction. Thanks
|
|
|
|
|
I am absolutely correct. What happens if a line break gets lost in the middle of your file ? How do you recover the records below it ? How do you search this data ? I'd love to know who is telling you that a 200,000 + line text file is a valid data store ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I am planning to Read the file using the file stream method and write out using the stream writer method. I then thought I would make an array and split on the crlf and then loop thru each Line 7 or either locate the first instance, and then loop thru every 56 lines(strNewline += (strNewline + 56))
|
|
|
|
|
If you're not written it yet, please don't. It is *insane* to do it this way, you can use SQL Server Express, VB.NET has wizards so you don't even need to know SQL ( although I don't recommend them generally, they offer a place to start ), and you'll get faster retrieval, individual record lookup, easy editing, and much safer data storage.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
200,000-400,000 lines??? You better pray that the file is absolutely perfect! If not, you and your data are screwed! Can I ask who on this earth told you this was a good idea?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I already asked that
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|