BitBlt

Depends on how you do the printing. You should look into the runtime capabilities of your Printer object, and look for the settings (and set them AT runtime) there.

Line 39 should probably look something like this: [CODE]con.Execute ("update table4 set Quantity = Quantity + " & qty & " where Item_code='" & Text3.Text & "'") [/CODE] Or, for consistency's sake, get rid of line 37 and change line 39 to: [CODE]con.Execute ("update table4 set Quantity = Quantity + …

Oops...needed to edit...see the next post...

Sounds fine. Is there a question here?

Yes, but you have to "downsave" it. When you go to save, use "Save As..." and select "Excel 97-2003 Workbook". That should do the trick.

You have several options, but a lot depends on what the data source is behind your ADODB object. What works in SQL Server might not work with some other generic ODBC data source. More details of your scenario would help determine what advice to offer.

More details, please?

Everyone is analytical to a greater or lesser degree. Ever ask a question when you didn't understand something? That's the essence of analysis. Or, as the old saying goes, "Inside every big problem are a bunch of little problems struggling to get out." Analysis is identifying all the little problems. …

You can test for the existence of columns in a specific table using the INFORMATION_SCHEMA.COLUMNS system view, and wrap it inside of an "exists" construct like so: [CODE]if not exists (select 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'members' and COLUMN_NAME = 'username') begin alter table dbo.members add username varchar(10) null …

Without seeing what you already have, it's hard to help. General guidance, though? Entity = a Noun...something in the scenario you are interested in keeping track of. Example: Studio...Customer...StaffMember Attribute = an Adjective...something that describes your Entity. Example: Equipment Portability Type. Relationship = if your Entity affects some other Entity, …

You can find all the Swift Codes [URL="http://www.theswiftcodes.com/"]here[/URL], but there are a lot of them, arranged by country. Are you sure you want to get into this? Keeping the list up-to-date would be a bit time-consuming.

Since this is an the MSSQL thread, I guess the first most obvious question is, have you run the query (with appropriate Turkish characters) in SSMS stand-alone? I built a little table with nvarchar(50) columns, populated it with some common Turkish phrases and did some selects, and it worked fine. …

This was a fun one, but I do have a couple of questions about your scenario. First, is this always to run for current month, or do you want to be able to set a date range? Next, were you looking for tabular data, or a pivot? And, did you …

Create a querydef that joins (or unions, as needed) your two tables, then reference that in Crystal.

This looks like a statement. Is there a question here? Please post to show what you've already tried. We aren't a code service, but if you're stuck we will be happy to point out where you should look to fix your problem.

How are you instantiating wbkFirst? If it is not a Workbook then you can't really get to the worksheets inside. One technique I've used is to create a variable and set it equal to Excel.ActiveWorkbook. Then you can do a for loop through it. Here's some sample code: [CODE]Dim book1 …

No real need to store it in an array...the ListBox control is, for all intents and purposes, an array. So, when the user clicks on the "Submit" button, just do this in the cmdSubmitButton_Click event procedure: [CODE]' Assumes some control names, so you'll have to change to match your project …

Generally speaking, you can't do indexed access methods on straight text files. You have to treat them sequentially, which means you have to operate on the entire file. So, one technique is to load the text file into a stand-alone ADODB.Recordset object (rather than bind it to a control), delete …

You need to initialize the variable "Flag" to False. If you look at how a Do...While works, it is looking for the entire "While" condition to evaluate to "True". Since Flag = True, then (Not Flag) = False. And we know that your initial values for variable "first" is less …

It is because you are assigning a scalar variable as output. If you want to get the whole set, just change your stored proc as follows: [CODE]alter PROCEDURE [dbo].[NISUS_GetEDIDocTypes] @pEntityType int, @pEntityID char(10) AS BEGIN SET NOCOUNT ON; SELECT EDXDOCTYPE FROM [dbo].[EDI_EntityDocCrossref] WHERE (EDXENTITYTYPE = @pEntityType) AND (EDXENTITYID = @pEntityID) …

You could use an "insert" trigger for that. Or, insert into both tables in one stored procedure, with appropriate existence testing to check if the data is used by the other table.

I would say no, because of the whole multiple Analyst thing. I would combine all the Analyst types into a single Analyst table and put three non-identifying relationships to Call (with appropriate role-names for the foreign key attribute names). That way you can have the same analyst be First-Line, Problem, …

You could take a (syntactically corrected ;) ) version of what @jcarbillon suggested. As mentioned before, you have to be careful about the international date formats. If you don't want to do that, then @adam_k's solution won't work if your selected dates cross over a year boundary. You need to …

Try this: [CODE]select a.product_code, a.productname, a.item_code, a.[date] from dbo.myTestProductTable a inner join ( select product_code, max(date) as maxDate from dbo.myTestProductTable group by product_code ) b on a.product_code = b.product_code and a.[Date] = b.maxDate [/CODE] Caveat: my test table defined the date column as a varchar...so if you need to do …

Create a table ("Options" or whatever) that contains a key, and a character column. Populate the table with the allowable values, including "Other". Create a table ("Users") that contains (in addition to keys and other columns of interest) a number (not nullable, foreign key to the "Options" table) and a …

The kind of generalized help you are looking for is not the sort of help we supply here. If you need assistance with such fundamental concepts of MSAccess as queries and forms, and how to use a form and how to link data to it, you should probably either buy …

I guess the immediate question is, how conversant are you with SSIS? If you're pretty good, you can use a ForEach Loop Container, iterate through a collection of variables and change the source server (or database name) with each iteration. Then inside the container, create a single DataFlow. Inside the …

I got reading #4: [QUOTE]Cats spend their days sleeping, washing, eating. They have no trouble asking for what they want. They'll use you for furniture if they feel like it, and if you get in their way, you'll get washed, too, with their remarkable tongues. Take care of yourself like …

Sounds like this could be handled with a TANK_STATE table (child of Tank table) that would have a unique id and foreign keys TankID, LocationID (the physical location), TankState ("used", "unused", "retired", etc.), FuelType ("jet", "rocket", etc.) and StateChangeDateTime. That way, if the Tank is taken out of service, a …

More information needed about your scenario. What are you using to do the value testing? If you just want to use SQL, then you have to do something clunky like using a CASE statement that tests each column against the desired value. If you are using some data access method …

Assuming for the moment that you have all the function declarations and constants included that you need for the Win32 function calls, you may want to check the actual contents of the return value (as in what datatype) from the Shell command and make sure it isn't conflicting with your …

Just make sure to convert the value in your text box to a numeric datatype using a conversion function. Since you are calculating prices, you might consider the CCur conversion function. Look in the VB help file for details on how to use it. You might have to test the …

I can just hear the trial now: Rep. Todd: "But, your honor, it wasn't in my posession at all! It was stuffed down beside the car seat!" Judge: <facepalm>

In my opinion, it is not actually necessary to be a programmer to be successful in Information Technology field. There are many different specialties within what is considered "IT". If you want to develop applications, then programming is usually required to a greater or lesser degree. If you want to …

Personally, I haven't ever run across a requirement to separate successive calls into discrete packets. However, other experience with the WinSock control leads me to offer this suggestion: after each SendData invocation, put in a "DoEvents" command like so: [CODE]Winsock1.SendData "String1" DoEvents Winsock1.SendData "String2" DoEvents[/CODE]In other instances of using WinSock …

John McCarthy, father of the LISP programming language and giant in the AI community, has passed away at the age of 84. Rest in Peace. [URL="http://www.slashgear.com/grandfather-of-artificial-intelligence-john-mccarthy-passes-away-25190622/"]http://www.slashgear.com/grandfather-of-artificial-intelligence-john-mccarthy-passes-away-25190622/[/URL]

The login you sign in with has to have appropriate administrator-level permissions before you can create a login. You need to log in with a username that has those permissions, or get one of the database administrators to grant your existing login that level of permission. Either that or get …

"Recordset.Delete" will only delete the active row. You either have to iterate through the recordset and advance the current row or do what @debasisdas says. Please don't post if you haven't tested your solution.

I believe you are trying to use @TestRunId in the wrong scope in line 17. You may have to do something like: [CODE]... AND TestRunID = ' & @TestRunId & ')') ...[/CODE] to include the variable from the proper scope. Not tested, just an observation. sorry about the formatting...not having …

Between lines 18 and 19, you might want to test the value of your string variable "s" and the value of your ComboBox to determine if there are valid values in both. If there aren't valid values in both, then raise an appropriate message box and exit the subroutine. I …

Personally, I don't recall ever using a cursor for inserting data. Could you give us a little more detail about the circumstance you have in mind? Maybe post an example? If we knew a bit more we might be able to come up with a rationale or an explanation (or …

Here's a handy little script I use when I "lose" tables. It will basically iterate through every database in the SQL instance and list all the tables/views. Feel free to tweak it to limit or increase the scope (as in, database_id > 4 or so to exclude system databases like …

What have you already tried? Also, you aren't being specific enough to allow any help. Here are some sample questions that might help you refine your request. Does it have to be truly random? Or can you just cross-join the two source tables and use results from that? Do the …

I can see why you have problems. To begin with, it appears that the rows are of several different formats. In order to be able to parse all that you need to read row by row, make some logic choices and grouping breaks, and decide where each of the data …

Interesting and subtle little problem. But your summary of the requirements doesn't quite match the result set you display. Let me see if I understand the requirements based on the result set displayed: 1. If there is a match in ID between t1 and t2 only, show the row. 2. …

I do it for the chicks. Oh, wait...that's playing guitar (oops)...

You should post some code to show what you've tried. That being said, can we assume you're using a "Line Input" type of construct to read each line of your file into a string? If so, you might want to try using "SPLIT" to break it into pieces. Just keep …

[URL="http://www.dbasupport.com/forums/archive/index.php"]http://www.dbasupport.com/forums/archive/index.php[/URL]

Is this going to be an ongoing periodic task, or a one-time load? It would make a difference in design. If it's one-time (and assuming you have MS-Access on a Windows client), you could do the table loads using the MS-Access Import wizard (once for each table, assuming they have …

You have several options. First and simplest is to have the database and the application in the same directory. Then the connection path is ".\db.mdb" and it will always look in current directory, no matter where you execute from. If that's not an option (as in you have to point …