Your right. There is so much garbage in the database from all the users with half a brain that entered customers.
I tried the Levenstein and it came close to extracting but it takes too long to test and adjust the integer.
Now I'm just going to try and manually change the names first based on a static list and then run the function.
Surely the static list would be better used as a Company table content and linking ot to the customer table. It will require a change to the UI to support the Company. Not trivial but will make your life a lot simpler down the track.
Never underestimate the power of human stupidity
Try to find out on which line the error occured and check the (array) indexes used on that line.
We can't really help because we don't kow where the error occurs. Even then we would probably not know the allowed ranges for indexes used on that line because your code snippet is incomplete (EndIf without matching If, labels that are never targeted, and loop variable increments without the loop start and stop statements).
And another tip:
Instead of posting new messages to fix errors in previous ones or add more information, you should edit your existing one like I have done here. There is an 'Edit' link on the bottom of each of your messages.
I'm new to this forum, just started working in VB .Net and I'm now starting my first project.
I ran into a little snag today, spent quiet a bit of time trying to fix it but you can't fix something if you don't understand what's going on, right?
So two things - can someone explain why I'm getting the error In the attached screen shot and how do I fix it?
Intellisense is suggesting that I generate a constructor sub in frm_reportviewer1 but when I do I get some more errors saying "reference to a non-shared member requires an object reference" (I get this when I say frm_reportviewer.show()
Data source configuration wizard, choose database objects, click tables, click finish to configure the dataset - get this message "Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information". I have a split access database and am pointing to the back end where the tables are and in the correct folder. VS configuration wizard finds the Access database back end and the table names which it has.
I am SO STUCK. When I put code inside the form to open the connection all I am able to know is that the table itself is where the bounded area is on the form but no information details from the access table. The VS form does show the correct number of records that the main table has, which strikes me as odd to know how many records are in the table but not be able to grab the individual fields in the table.
1) DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.
2) It doesn't quite work like that.
We do not do your work for you.
If you want someone to write your code, you have to pay - I suggest you go to Freelancer.com and ask there.
But be aware: you get what you pay for. Pay peanuts, get monkeys.
The idea of "development" is as the word suggests: "The systematic use of scientific and technical knowledge to meet specific objectives or requirements." BusinessDictionary.com[^]
That's not the same thing as "have a quick google and give up if I can't find exactly the right code".
So either pay someone to do it, or learn how to write it yourself. We aren't here to do it for you.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
Hi there. Simple question or so I hope. I have two forms. Form1 is showing a directshow video stream. The second, form2, overlaid, is basically a splashscreen, adobe photoshop style, with transparency. Both forms work fine. HOWEVER, the transparency is only rendered for the first frame as form2 is displayed. Then, as the video changes behind it, the form2 region is not updated (ie the transparent bits remain what was on the screen when it was first drawn, almost as if it was a screen grab)
I am assuming it is because the OnPaintBackground sub which paints the transparent form is only called once, as the form loads. So how can I keep it updating so that the actual live video shows thru the transparent bits? This is what I have :
ProtectedOverridesSub OnPaintBackground(ByVal pevent As System.Windows.Forms.PaintEventArgs)
Dim gfx As dra.Graphics = pevent.Graphics
Dim IMA As Image
IMA = Image.FromFile("D:\WORK\myfile.png", True)
gfx.DrawImage(IMA, New dra.Rectangle(0, 0, Me.Width, Me.Height))
You can't do it using a transparent form. The form overlaying the video is a control that is never repainted, which has to be done ON EVERY FRAME OF VIDEO.
You have no way of getting that notification and, frankly, in Windows Forms, the performance hit is ridiculous and won't be able to keep up with the video.
The proper way to do this would be a filter that draws the overlay in the graph that is loading, decoding, mixing, and rendering the video/audio. There may be libraries out there that make this easier, like possibly Overlay.NET.
I've never used any of them, so don't ask.
System.ItDidntWorkException: Something didn't work as expected.
How exactly do you think changing the extension on a file name will affect the content? Follow the link I provided and see what you need to do to read a cursor file and interpret (and display) its content. .NET even contains a class to do most of the work for you: Cursor Class (System.Windows.Forms)[^].
Thank you I'll refer to it! But I tried to load a cursor file using these methods, it didn't give any errors but at runtime it says that the cursor file is damaged. I even tried system cursor files! I just want to give a preview of the cursor to the user, changing the mouse pointer is enough, don't need to view a preview on a picture box.