Search results for query: *

Is there any way I can determine at runtime if the form that is currently active has been opened modal or non-modal? I couldn't find a form property for this. I could, I suppose, use a boolean variable blnModal which is updated by the routines in which I open the form (false for non-modal, true...

I've been having a discussion with a co-worker who feels that relationships between tables on a varchar type column should be avoided, as in his opinion they'll be much slower in query execution than on int type columns. In the database we're working on, we've currently got a varchar relation...

I'm stumped by a sorting order my customer needs on a field containing a multipart numeric code. Code consists of a country code, a letter, a two-digit year code and then an increment, for instance 31S03008 would be a record in the Netherlands (country code 31), and number 008 there in the...

At a certain point in my VB6 program, I want to check if another form is currently open (and refresh an ADO control there if it is). However, if it's not open, I want nothing to happen. I've tried doing this with the .Visible property as follows: If Form1.Visible = True then...

In VB6, one of my forms has an ADODC control that accesses a table in my SQL Server database and fills a couple of fields with it. Nothing special, I've got dozens of these throughout my application. For some reason, on *one* client computer (it does not occur on my system or for any of the...

I've got a puzzler here. In a VB6 database application running on SQL Server, one of my forms has a bunch of textboxes (as well as datacombos and checkboxes) bound to an ADO control, each populated with a different field from the current record. Many of these fields are optional and often empty...

If I print a form's contents using: Me.PrintForm Is there any way I can make it print as landscape rather than the default portrait? "Much that I bound, I could not free. Much that I freed returned to me." (Lee Wilson Dodd)

At user request, most of the forms in my VB6 application have a "print screen" command button that simply executes: Me.PrintForm to print the form's contents. Works well except for one little problem: somehow the font for labels is larger than on screen, often causing label captions...

In Access, I'm able to enforce that every value in a column is unique even if said column isn't the primary key. Am I able to do the same in SQL Server 7? I'll be able to solve this problem in my application too with a little recordset searching, but if it's as simple as setting a flag...

In my database, a simple one-column table containing unique company names has a ghost record. It shows a value there, but attempting to use it as a foreign key gives a key constraint, and when I try to remove it directly from the table view, I get an error stating the record appears to have been...

The SQL Server documentation informs me that: - When a field has the char datatype, every value saved takes up as many bytes as the maximum length defined; - When a field has the varchar datatype, every value saved takes up as many bytes as the value uses, and no more. It then goes on to tell...

I must be overlooking something obvious here, but I can't seem to use the Pi constant in VB6. What few MSDN references I can find to it aren't for VB, and several guess attempts (Pi, Pi(), Math.Pi, VbPi) all failed. So how do I use Pi in a VB calculation? "Much that I bound, I could not...

One of the routines in my VB6 application opens an Excel worksheet, and fills it with some data from SQL Server. In a recent addition, it sets the data format for one of the columns to financial data formatted as Dutch euros. The command for this is, in my case: xlsApp.Cells(row...

Every so often I do a major cleanup of my data partition, throwing out folders, sometimes big ones. The thing is that if I delete more than just a few files - say, if I do a couple of folders with several hundred files each - my explorer tends to hang. It deletes the files properly, then it...

Friends have been telling me that my computer, with its specifications, will perform better under XP than under my current OS, 98 SE. I've heard things about better memory management but I'd really rather know from somebody with the experience if, on the following setup, I should expect XP to...

In an SQL Server 7.0 database, I'm trying to concatenate a couple of fields into one string. The problem is that one of them is often Null, and doing so causes the entire string to default to Null; which makes sense but is not what I want. Rather, I want it to be treated like an empty value in...

Maybe I'm missing something obvious here, but how do I call a click event (on a command button or a menu item) from another form? When I'm on the form myself, using the line cmdMyButton_click works just fine, but when I try MyForm.cmdMyButton_click from another form, I get a "Method or...

In a VB6 database application, I have several options for outputting information to an Excel worksheet. I've got it to the point where it neatly outputs column headers (and bolds them), pastes all the records under them and puts a report title on the first row. There's two more things I want to...

I've recently installed a free version of ZoneAlarm after a few hacking threats from displeased individuals (probably boasts but better safe than sorry). It's working out fine for me with only few nuisances, but one of them is that I don't seem to be able to send files through mIRC anymore by...

It's been steaming hot the last few weeks and I'm noticing a sharp increase in spontaneous reboots and fatal exceptions on my Windows 98 machine. Was like this last summer too. Somebody suggested to me that my processor may be overheating and that I should check this, and add more cooling if...