BitBlt

What's the datatype of the Date of Birth column? If it is text, you can just use some string manipulation functions (mid(), format(), etc.) to break the string apart and re-assemble it however you want. If it's date/time it becomes a little trickier, as you have to use the datepart() …

[URL="http://www.ibiblio.org/zen/gateless-gate/1.html"]Mu.[/URL]

Actually, that property is not exposed at design time. It's not even exposed at run-time unless you use direct WinAPI calls (good luck with that). That's the disadvantage of using some of the packaged controls...you get what you get. As an alternative, you might consider just using an unbordered picturebox …

How are you instantiating the form? Are you starting up from sub main() or from the form itself?

You forgot step zero: 0. Talk to a person who has a fuzzy idea of what they want the computer to do for them. 0a. And unrealistic expectations of how involved they have to be during development. 0b. And unrealistic expectations of how long it will take to finish. 0c. …

Cheating? Not at all. Anything you can do (except perhaps an outright lie) to get the prospective employer's attention is fair game. My dad is also in IT and I used him as a professional reference for years. Of course, I told him I was going to, and got his …

I have a solution (I think), but shouldn't your "Results" look like this? [CODE]right result ESN|Shipdate |returndate 123|2011-01-03|2011-02-20 123|2011-03-02|NULL 123|2011-04-10|2011-05-18[/CODE] Please confirm if this is the case, then I will post what I have. Also, in the spirit of "Help those who have at least have tried", please post what …

I know that to print graphical stuff (as opposed to pure text) you are generally better off coding to a library like OpenGL or wxWidgets. That way you only have to worry about a memory device context and not the actual driver-level stuff. The library and operating system will handle …

[QUOTE=Narue;1592321]Or you could just, you know, remember the folks who rub you the wrong way. [/QUOTE] I agree with that sentiment. Just going formulaically (is that a word?) based on post counts may give a hint, but every member has his good/bad points. A straight count doesn't tell you how …

Part of the problem I see is that you are trying to force semantic equivalence on non-mappable syntax. Ever heard of a book called "Godel, Escher, Bach: An Eternal Golden Braid" by Douglas Hofstadter? He has some interesting chapters on reductionism vs. holism. Your design attempt sits squarely on that …

Struct?

Unless you're willing to use Windows API calls, VB doesn't really do dynamic control creation very well. Partly this is because of the whole event procedure registration thing, callback function stuff and the like. As a workaround, you can create the necessary buttons at design time, but make them Visible …

I was poking around in the Control Panel and noticed the Event Reminders link down at the bottom. Being a nosy sort, I clicked on it and was unsurprised to discover I had no reminders. However, I then clicked on the Calendar link near the top of the page and …

Split returns an array, so you have to reference your variable as an array. So, for example, if you reference avarSplit(0) you will get the first element in the array, avarSplit(1) will get you the second, etc.

[QUOTE=Tellalca;1580033]... generally scripting means writing some commands run line by line, not compiled. Programming generally means writing some heavy weight code that is compiled into machine code.[/QUOTE] I beg to differ. What about JavaScript? VBScript? These are considered "scripting", but can be as intricate as any compiled program. What about …

If I was given that task, I'd probably write some Powershell scripts. It's pretty easy with Powershell to iterate through directory trees and look at file contents, and copy stuff around. Problem is, it takes some time to get familiar with Powershell (less than 180 weeks, though) so if you …

Common de-duping problem. Part of the issue is that you need to identify which records you want to KEEP, then delete everything else. To do that, you have to correlate your subselect so that the ID's of the records you want to keep are excluded from your outside select. One …

Could it possibly be a problem with MSAccess interpreting your dates incorrectly? I notice you're using DD/MM/YYYY rather than MM/DD/YYYY. You might want to force the format in your query.

The file you saved is a SQL backup. You have to RESTORE to get it into SQL Server. You can either do this through the Management Studio GUI or using a RESTORE DATABASE command (look in BOL for syntax). Keep in mind that the Management Studio GUI expects the file …

Just so you know, the idea of "right" is sort of amorphous. If your data structure stores your data the way you need it then it can be considered "right enough". If you want to know whether your data structure follows a specific set of rules, such as "normalization", that's …

That size is relatively small, but you'd have to change your table structure every time you added a new "achievement". Much better to have a normalized table structure, then you can dynamically add achievements without disrupting your existing data. Of course, adding a column in SQL Server is trivial itself, …

The only way I know of to do this is calling the Win32 API manually. First you get the process ID by iterating through the running processes, compare the process EXE file name until you find the one you want, then get the hWnd and send it a message asking …

What have you got already?

Not much to go on here. Here are some questions that might help you troubleshoot: What are the data types of the columns? Is there a mismatch between source/target? What is the format of the incoming data? Is it formatted the same way as last time you performed this task? …

The only way I know how to do something like that is with a macro, something like:[CODE]Sub AddPaid() For i = 2 To 4 If Excel.Cells(i, "M") = "Paid" Then myValue = myValue + Excel.Cells(i, "L").Value End If Next i Excel.Cells(5, "M").Value = myValue End Sub[/CODE]but I don't think that's …

You could always add another key column (fieldC) to TableA. If you're getting duplicates, then your normalization is incomplete and your TableA can't uniquely represent the data you need to store. Or you could cheat and create another column as primary key that is an identity column, and take fieldA …

I guess I'm just not quite understanding the question. Are you talking about a replication scenario? Or perhaps a partitioning scenario? Or a concurrent-user application? Parallel computing implies more than one thread performing the same work on different segments of a problem (such as updating ranges of data in a …

Okay, so this was a fun one. I had to do this using a fake table, plus I used Access2003 (hope you don't mind -- syntax should be the same). First, create these queries: qryDistinctCustNbr: [CODE]SELECT DISTINCT dbo_TransStuff.CUSTNBR FROM dbo_TransStuff;[/CODE] qryFor1231: [CODE]SELECT dbo_TransStuff.CUSTNBR, dbo_TransStuff.TRANSYTD, dbo_TransStuff.RPTDATE FROM dbo_TransStuff WHERE dbo_TransStuff.RPTDATE=#12/31/2010#;[/CODE] qryFor0528: …

My gym routine is: AVOID LIKE THE PLAGUE. I have never regularly used one. I don't "look down" on people that do, it's just not for me. Historically, I prefer to do activities that require one to move around a lot in more non-repetetive motions. Basketball, softball, hiking, volleyball. I …

I like to read Victorian and Edwardian-era romance novels. NOT the modern day "Gothic Romance" spew, mind you...I'm talking about Austen, and Bronte, and Eliot...Wilde and Forster and Burnett...Richardson, Trollope, James... Look on gutenberg.org (the greatest collection of free literature on-line!) But I also like he-man adventure or sci-fi stories …

Unfortunately, VB is very good at hiding the API calls needed to create a class dynamically. In VB when you create a form it becomes a referenceable class, so you have to instantiate it explicitly. As an alternative, you might consider using an array to hold instances of your forms, …

But...my hobby IS programming! Just in obscure languages like FreeBASIC, VB-DOS, QuickBasic, NASM, etc. Oh, and DaniWeb is my newest hobby. Wait, that's still programming, to some degree. Hmmm...Oh, yes...I play a guitar a bit. And harmonica. And baroque recorder.

[QUOTE=Kraai;1580599]Any legal idea that can create some income...[/QUOTE] ...will be taxed to death. </rant> I like the idea. And, competition is what makes us have to innovate to be noticed. Look at places like GoDaddy. Who'd have thought that domain registration was so sexy? Not me! That's why I still …

The Try/Catch construct wasn't implemented until VB.Net, so you'll have to use the "On Error Go To..." construct. Here's a sample: [CODE]Private Sub Form_Load() On Error GoTo form_load_error . . Your (error-prone) code goes here . form_load_resume: Exit Sub form_load_error: MsgBox "Error " + CStr(Err.Number) + ": " + Err.Description, …

Here's a snippet of code to update the appropriate column. My table name is a different than yours...but I think you can figure out what to do. [CODE]update b set b.dbUnique = a.id from dbo.mytablewithdups a inner join dbo.mytablewithdups b on a.col2 = b.col2 and a.col3 = b.col3 and a.col4 …

Company and Project should be parent/child entities. That way you can independently relate them to Results. Question should have a SectionNumber attribute so you can differentiate whether to relate it to a Company or a Project. You should not store an "overall" score. Frankly, you shouldn't even keep a "Section" …

I have found that the best place/time for Intern hunting is near the coffee machine, early in the morning. With the fog rising off the keyboard and the sun just coming through the window, you can sneak right up on them before they wake. They look so cute with their …

Delete the "BUILTIN/Administrators" group from your SQL Server.

display NOT(input)

Could be any number of things. Not much detail in your post. In no particular order: How big are the nvarchar and varchar columns? Nullable? Sparsely filled? How many rows in each table? Indexed? Clustered? Fragmentation? What does your server paging look like? Server memory utilization? Disk utilization? Cache Hit …

More detail needed. What help specifically are you looking for? What have you tried? What are you thinking of trying?

There is a parameter expected in your SQL statement (which we have not seen). Please show the SQL statement, and the surrounding VB used to construct it. My guess is that your statement is using ODBC syntax incorrectly, so your driver is trying to interpret your varchar as an int. …

SQL Server 2008 has all the necessary geospatial data types. For a little primer on how to use GIS, you should visit the ESRI site. They are the industry leader on that sort of thing.

Your post doesn't really have enough detail for anyone to help you. Are you asking how to code a menu "click" event procedure? Or do you need to know how to call a function from another module? Or are you looking to find out how to calculate some result?

Are you using SQL2008? You should check out the "geography" datatype. It's a CLR Assembly datatype with all kinds of .NET methods you can use (specifically the .STLength method to calculate the distance between two geo points). There's a good write-up in SQL2008 BOL. Helps you get away from all …

Use the "On Change" event in your first combo box, update the "filter" property on your second combo box and issue a refresh.

I'm a little past my teens as well (about 30 years past), but I started programming assembly on a Motorola Odyssey when I was 16 back in the 19mmffmmmms. It was before the days of PC's, so that was all I had. To all you teen programmers, I just say …

[QUOTE=Portgas D. Ace;1567936]Why can't we all just speak like Aussies mates! too bloody right we can![/QUOTE] Because, alas, not all of us were born in places that have cool accents. I'm going to go to my room and cry now.:icon_neutral:

Was gonna post some clever SQL, then suddenly remembered this wasn't the SQL Server forum <blush>.

For homework help requests, no work posted usually = no effort made by poster, which in turn = no help given. You should post what you HAVE tried and then more assistance should be forthcoming. However (at the risk of offending the purists) I will give one hint: load the …