Search:

So then is there anyway to save the form as a bmp or jpeg if it's not on the screen?

I am currently attempting to screen capture the contents of a Form (with a PictureBox object in it) while the console is locked or turned off. This is necessary due to automated processing.

The...

you cannot use
var1 = NULL in SQL. You must use
var1 is NULL

hope that helps

I just upgraded to XP and I am using developing in VB6. I noticed when I started up my app, it told me that it couldn't find the 'Windows API' reference. Is this a problem with XP... or do I need...

Thanks Jim, but that didn't work. I tried an internetOpen without
an InternetConnect... but when I attempt to access due an
FtpSetCurrentDirectory, I don't get an error back... just a false ...

try this...

Private Declare Function TerminateProcess Lib "kernel32" (ByVal hProcess As Long, ByVal uExitCode As Long) As Long

hProcess is the PID, and uExitCode is 0.

newty25
ps you may...

I'm using the Inet API to write up a small FTP class to use in a
project of mine (I can't use winsock...) So, the problem is that
the connection is being dropped by the FTP server and causing ...

I had 20k lines of code. I guess I've been working to hard.

newty25

Is there any way to find this out in VB6?

newty25

I know this is easy, but I forgotten how to find the X, Y coordinates of the mouse on a form. I thought it was CurrentX, CurrentY... but that doesn't seem to be the case. I have a third party...

I wrote my own FTP ActiveX DLL by wrapping up the WinINET Control... but I'm having problems with it... and I think that they're related to WinINET. Does anyone know of a free/inexpensive FTP DLL...

I found some topics in the archives, but nothing that directly answers my question.

I am trying to test whether or not I've successfully released an object (that I've written). I think I'm...

Thanks! I queried the sysobjects table, and it worked like charm! Kewl!

Newty25

I'm using an ADODB connection to my MS SQL Server/Database
from VB, and I am wondering if there is anyway to return a list of
tables/views from a connection object/command object back to
VB from...

Maybe I should be more descript.

I am creating text files (2 of them), combining them, and then writing them to an Excel file. Sometimes, if my app is terminated prematurely while Excel is open...

When my program terminates prematurely (due to run-time errors, etc), sometimes I have left over instances of Excel left open. Is there a way to query to find out about left over objects to close...

I would do something like this... (assuming that you mean the names of the fields from a table in a database...)



dim cnn as adodb.connection
dim param as adodb.params
dim fld as adodb.field...

I'm new to VB (I program in JAVA, C, and C++, mostly, and have tutored the basics...) and this forum is the best!

see ya around...
newty25

geoff_xrx,

Sorry for the misunderstanding... but it seemed to me that you were putting down a fellow programmer in your response to his question. I would rather see a young mind flourish by...

You moron... you didn't spell it... that's why he asked. You put...



you meant to write I.D. ten T Error. I hate when nim-whitted idiots (or ID10Ts) like you try to make others look...

Does anyone know of a chart program for VB that does scatter plotting in 3D????

VB Menu > Project > References > Microsoft Excel 9.0 Object Library... check it, and click OKay.

newty25

Try this...



Private Sub Command1_Click()
Dim XLApp As Excel.Application
Dim wrkWorkbook As Excel.Workbook
Dim wrkSheet As Excel.Worksheet

Set XLApp =...

The undefined user-type error is because you haven't referenced
the Excel Library, yet. It's been in all of the other responses. Go
to the VB user menu > Project > References. Scroll down and...

I'm using vb6 and I have bolded dates on a MonthView. I want
to update the MonthView with a different set of bolded dates. I
have a command button setup to kickoff a refresh, but I don't see
how...

I would say 64k or 2 e 16. I don't think you can allocate memory to a textbox. Use the rtb.



You need to reference Microsoft Excel 9.0 Object Library, then
try this...



Dim XLApp...

Either I don't understand what you need done, or you're
working too hard to solve a simple problem... this does the
same thing as your previous code example.



Public Function...

if DateDiff("ww", Date1, Date2) > 0 then
DoEvents 'not in the same week
End If


This function counts the number of Sundays between the two dates. Date1 will not be counted if it falls on...

I am attempting to doing a bcp export from SQL Server table to a text file. So far I have...

[code]
bcp "SELECT * FROM table" out title.txt -c -Sservername -Uusername -Ppassword
[\code]

I am...

Even if you're not on a network computer... if you've set the computer as a standalone with an administrator you could set permissions on it. And, yes, Hack... you are right... anyone with half a...

you could set the attributes of the file to hidden and read-only. Otherwise you'd have to be an administrator to set up the OS permissions.

how about this...



Option Explicit

Private dtTime1 As Date
Private dtTime2 As Date
Private lngDiff As Long

oops... I meant hidden!

try this



Option Explicit
Public Const SW_HIDE = 0
Public Const STARTF_USESHOWWINDOW = &H1
Public Const SW_SHOWMINNOACTIVE = 7

Private Type STARTUPINFO

It won't clear the memory space... but it will overwrite it. I was gonna write in how it works... but trust me it works like this. If you ever get into real software development, ie C or C++ (more...

I tried your code, but it wouldn't let me use the 'selection.value'. Did you get it out of the macro editor? Oh well, it looks like I'm screwed on this one. I have to find some work around. ...

Sorry, I already tried turning the columns back into a "general" format. Here's what I currently have,



For intCount = 1 To wrkSheet.Columns.Count
wrkSheet.Cells(1,...

you said:



"Hello There" will still be in memory, but it will be inaccessible. You will write to the same memory space when you use the assignment operator. The variable will be destroyed,...

I'm working on converting a text document to Excel. When I initially open the Text file, I am number formatting all of the columns to be text instead of General (I have to do this because of a...

totally... when I execute it on the server... I can see the errors popup. The same execution seems to work fine in VB, but I know that it's not working correctly... ARGHHH!