BitBlt

[QUOTE=Ancient Dragon;1574450]My PC is HP desktop computer and 19" monitor.[/QUOTE] You should look into a dual-monitor configuration. I switched to it about a year ago and I'm SOOOO glad I did. I have an HP with dual flatscreen 19's at work, a really old Dell desktop with a single flat …

Really? You can't take two seconds to google this? Here, let me help you: [URL="http://en.wikipedia.org/wiki/Database"]http://en.wikipedia.org/wiki/Database[/URL]

You could always call it "TLA Solutions"... [U]TLA[/U] = [U]T[/U]hree [U]L[/U]etter [U]A[/U]cronym

When you use GoTo to branch out of your logic, you have to define "Resend" as a location (a "paragraph", if you will) in your routine. Just put the word "Resend:" by itself on a line where you want your logic flow to branch to (don't forget the colon ":" …

Yes, it's possible. However, you don't give enough information to allow for suggestions. How are you accessing your table? Are you just writing a query in SSMS? Are you writing a program and using some sort of object library like ADO? Or a bound data control? Are you coding to …

[QUOTE=skatamatic;1651159]In VB (.Net I am assuming) - use a pointer. At all. Just use one. Oh snap you can't.[/QUOTE] Um...actually you can. It isn't pretty but read [URL="http://www.codeproject.com/KB/vbscript/how_to_do_pointers_in_visual_basic.aspx"]this[/URL]. Besides, why would I want to use pointers in VB? Didn't Microsoft (hallowed be it's name) specifically build VB so I wouldn't …

So what value is in Label15.Caption? If it's not a date, then you're going to have difficulties. Also, please use "CODE" tags when you post code.

Define a global constant (or variable) in a module and set the value to your string. Then when you set con.connectionstring, set it equal to your global constant (or variable).

Sometimes I'll fire up the GNU emacs Multiplication Puzzle and do a few rounds. Helps me focus.

There are arguments both ways. If you think you would ever have any kind of hierarchy in your dimension, or want to store pre-summarized data in your dimension table, keep it separate. Otherwise just put it in the fact table. You'll use up more storage, but you might get some …

If you're looking to have your stored procedure directly output Excel-formatted data, then no it can't be done. You could use CLR to do some object manipulation, but that's a real pain. If you execute your stored procedure in SSMS, you can output to a grid, then right-click any header …

[QUOTE=jwenting;1640993]yes, but then again some people think that irony means "made out of iron" :)[/QUOTE] Silly me, I never thought of that. I thought it was where I got my shirts pressed. :icon_cheesygrin:

No. If you look in the SQL Server Books On-Line (BOL) do a search for the term "[ ] (Wildcard - Character(s) to Match) (Transact-SQL)". It has an example almost exactly like your situation to help illustrate.

You could also just truncate the temp table, rather than drop/recreate. Since there are no schema differences, it should handle your requirement of an empty table.

The syntax you're using for your DCOUNT function is incorrect. If you use something like this: [CODE]DCount("Name", "MAIN", "Name = 'Expired'")[/CODE] ...then it should give you the count you're looking for. However, since you are actually looking for a simple count of rows that fit the criterion, you could (for …

"Geeks' Lounge Lizard" or... "Sometimes I get VB-jeebies"

You have not specified the return type for the function. Try: [CODE]Function Resistor(color1 As String, color2 As String, color3 As String) As Double[/CODE] You can then call your function like so: [CODE]Dim myResistor As Double myResistor = Resistor("black", "blue", "silver") [/CODE] Please note that you have several other problems with …

Or you could do a guessing game like "Higher/Lower". Randomly generate a number, then have the player input a number. Game responds with "higher" or "lower" until the player inputs the correct number. Or, if that's too simplistic, how about "Battleship"? Only put a 3d twist on it... Or, if …

Use this: [CODE]If DateDiff("d", Now, "9/29/2011") = 0 Then MsgBox "the software has been expired." Unload Me End If [/CODE]

You can't really just "exclude" the data in red the way you show by using a join between the tables. There's no way to join the tables that will result in that. You can sort of approximate it by using something like this: [CODE=SQL]select pDate as sortDate, pDate , pName …

Are you talking about DeMarco-style DFDs? I didn't even know anyone was even teaching that anymore.

Not much to go on here. There appears to be nothing wrong with your code per se. I can assume that you have already included the Excel Object Library in your project references (otherwise, you wouldn't have even got this error message). Try, just as a science experiment, to hard-code …

On your form, create a list box, make it multi-select. Make a datetime picker above. Make a "Save" button. On form load, fill the list box with student names from the database. When the datetime picker changes, check the database for student attendance rows. Selectively mark the listbox rows as …

Personally, I don't do it for the "pat on the back". I do it to pass along knowledge in the same spirit that assistance was passed to me back when I was a struggling noob. Sometimes you get a thank you. Sometimes you get "rep points". Sometimes (to quote a …

Use a File DSN, rather than a User DSN or System DSN. A File DSN can be stored in a shared directory. Then, in order to use it, you just have to have permissions to read the remote directory with the File DSN you are interested in. User DSNs and …

Reading from the file is not dependent on the index in your list box. So, to skip one row, you have to do an input from #1 and then DON'T WRITE to #2. So, after line 8, put in an Input #1, then start your next loop on line 9 …

Need more information. Can you post the code in question, and the connection string you're using to connect (suitably edited for sensitive parameters, of course), and maybe a little background about what you're trying to accomplish with your code when the error occurs?

An intravenous coffee feed?

Uh...we don't really do that sort of thing here. We're more about "If you're stuck, show us what you've done and we'll help you get un-stuck". If you're looking for sample code, you might try a google search first. Good luck to you anyway!

[QUOTE=OblibSystems;1651180]...so why are so many computer science courses (who are training the IT professionals of tomorrow) teaching it?[/QUOTE] For the same reason that professors in the '80s taught Pascal and C, and professors in the '90s taught C++, etc. etc...because those languages were available, and they were useful to present …

You could also just make these little modifications: [CODE]Option Explicit Private Sub cmdExit_Click() End End Sub Private Sub cmdRun_Click() Dim num(19) As Integer Dim i As Integer Dim sum As Integer sum = 0 ' <----------- BitBlt added this grd.Rows = 2 grd.Cols = 2 grd.Clear For i = 0 …

Not sure what you mean by "make a gif file work". Could you be a little more specific? Do you mean you want to display an existing GIF file on a form or in a control, do you want to be able to edit bitmaps and save them in GIF …

With the construct you are using, you appear to be thinking more like procedural programming. That is, where you get a record, decide what to do, do it, then get another record, decide what to do, et cetera, etc. Even though Transact-SQL can be used that way (with "cursors") your …

[QUOTE=adam_k;1646141]...PIVOT won't work in access...[/QUOTE] Actually, MSAccess has the "Crosstab Query" which serves the same purpose. Granted, it uses different syntax, but the result is the same. Interestingly, MSAccess supported this functionality before SQL Server did. Oh, the irony... :)

We generally give help to those who show at least SOME effort to do their own work first. What have you already got?

- More coffee, less beer - More manuals, fewer novels - Shorter days (I just started coding...how can it be dark already?) - I started using Acronyms in everyday conversation

The problem is that the picture box and image controls MUST have a file reference as the starting point. You can't "hopscotch" passing blocks of pixels from one control to the other. So, what happens if you pre-load your picture box picBoxSprite with a file is that it then has …

Without more of your source code it's a little difficult to know precisely what the problem is, but here are some things to check. Look at the error message. Count the number of parameters. Now look at your function call on line 6. Count the number of parameters. They are …

Simplest way is just to test for Label10.Visible = True inside the Form_MouseMove event, like this: [CODE]Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) If Label10.Visible = True Then MsgBox "Game Over!" End If End Sub [/CODE] However, that means that unless your button …

Not enough detail to go on. What have you tried? What does your database look like in terms of table structure? Do you mean delete all the data in one table? Do you mean all the data in all the tables? Do you mean drop the tables completely?

Not much information to go on here. What is the exact code you are executing? How are you setting the connection string for your ADO Connection? Please post so we have a better idea of where your problem might be. Also, in your VB6 project, are you using the ADO …

Yes, you should. Just out of curiosity, have you ever used the .dtsConfig file method for setting your variable values? In the BIDS menu, look under the SSIS menu, for "Package Configurations...". Enable them. You can then specify many different ways to have settings for your package variables load when …

As any good DBA will tell you, "It depends". Not knowing how your data is distributed (as in, table structure) is a big hindrance to giving good advice. There are advantages and disadvantages to each of the methods you list. You have other options too: Single instance, partitioned data High-Availability …

[QUOTE=mayurbonde;1645646]use CSocket object overide its onreceive method .use send method to send data and receive method to receive it...[/QUOTE] I'm sure your heart is in the right place, but you may wish to check the dates of the threads before you post.

Not a lot to go on here. At first glance, it appears that the construction of your mega-IF/ELSIF construct will never get the the ".MoveNext" on line 24 because it has to fail every condition before it goes to the next row. So, if you have "!Position" match any of …

Back in the day, "stand-alone" usually referred to any executable that didn't require any supporting, library or ancillary files to be distributed with it in order to run. So I could put my little ".exe" file on a 5 1/4 floppy and you could just run it on your own …

Step 1: Print out 10,000 copies of your program. Step 2: Take the printout to a recycling center and trade it for money. Step 3: Go down to the office supply store and buy a handheld calculator. All joking aside, the operative word here is "practical". A handheld calculator has …

Not enough detail to help. Is this MSAccess VBA? If so, what version of MSAccess are you using? Are you just trying to execute the statement assembled in variable 's'? Are you trying to change the data source for form3? What is the structure of your table 'appdetails'? What are …

You might try declaring your "rCell" variable as a "Cell" rather than as a "Range". It might help with reducing some unnecessary overhead.

The only thing I see that's a little odd is, down just below the "rsDiag.AddNew" statement, you have "rsDiag!ICD9raw = ICDraw". Did you mean to have that "9" in there? Also, I don't see any declaration for either of the "ICDraw" or "ICDDesc" variables. Finally, a bit of advice. You …