Code Newsgroups: Visual Basic General Discussion

new to this group need help from u

goodboy - 31 Mar 2007 8:39 PM - 3 messages

i need a coding to take a " print out from the datagrid in current working form"........so what type of code i should use...... ...

IMG File?

Kevin Provance - 31 Mar 2007 6:44 PM - 4 messages

I just downloaded the latest Windows SDK for Vista. Turns out it's an IMG file? No file association on XP, so how exactly do I open this thing? Sorry for the stupid question, but apparently I've not dealt with this file ...

Loading DLL's from a different path

David DB - 31 Mar 2007 4:39 PM - 5 messages

Hi, Our our VB6 program we are using a DLL that we have written in VB6. Until now we have just added this DLL in the References in the project. But now we need to specify where this DLL is. ...

Can this be written better?

Ron - 31 Mar 2007 9:12 AM - 32 messages

Hi A string from my program includes a file ext which I want to exclude, so I have written this code, can this be done better? Private Function myLooseEXT() Dim myStop As String, xCount As Integer Example string:- xPart2 = "Here we are again.jpg" ...

Insert Listview Items into Table in Sql Server database

Sandy - 31 Mar 2007 1:00 AM - 10 messages

Hello - I am developing an application that lends itself to using several listviews. I do, however, have to put the contents of those listviews into relational tables in a Sql Server database. Is this possible? I tried to make it simple by using one listview and inserting the contents ...

Best way to compare dates in ListBox

Norm - 31 Mar 2007 12:08 AM - 3 messages

Hi, I have a listbox setup with vbTabs and four pieces of information and I want to keep the 5 newest records and delete the rest. Here is the information in the listbox: 72 66.1 103 3/22/07 ...

Basic Class Design - How to use Properties with Methods?

Bill - 30 Mar 2007 8:50 PM - 2 messages

I am struggling with the concept of using Properties to input viariables for processing by the Class vs inputting them as Method Arguments. With Public Properties I can manipulate the data coming in to my Private variables and I would like to "call" a Public Property in a function to use ...

Question On Clipboard

John Lane - 30 Mar 2007 7:16 PM - 12 messages

I copied the line of code from Mictosoft: MsgBox (My.Computer.Clipboard.GetText()) and of course it doesn't work becasue the is no object (error message). I made a reference to MyComput 1.0 Type Library, but that didn't work. Does ...

Robust code?

Saga - 30 Mar 2007 4:57 PM - 8 messages

Hi all, There is an application that checks every 30 seconds to determine whether any new files have been copied to a folder and is interested in two types of files: TXT and GZ. When it finds these it copies them to a work folder and after that it moves them to a ...

SerialPort Class - Need a way to stop and wait for datareceived

Richard - 30 Mar 2007 4:38 PM - 3 messages

Hello, I have any VB.Net 2005 application that is using the SerialPort class to communicate with a Mettler-Toledo PS60 Shipping Scales through COM1. Below is my current code. My problem is that the shipping weight is returned long after I need the shipping weight. I need to make the application stop ...

Future of VB6 application.

Mike Riley - 30 Mar 2007 4:26 PM - 28 messages

Where can I get info to determine which (if any) future versions of Windows will run my VB6 application? Thanks, Mike ...

VB One Dimensional Array assign to Two Dimensional Array

bejingaf - 30 Mar 2007 12:28 PM - 17 messages

Hello! I'd like to now how is possible to assign one dimesional array to two dimensional array with exactly same structure. dim arr1(0 to100) dim arr2(0 to 50, 0 to 100) arr1=arr2 Please, any info is wellcome. ...

StackOverFlowException inside thread.

Bubba - 30 Mar 2007 11:00 AM - 3 messages

I've written code that uses a thread to read a 70K line CSV file one line at a time, however, after about 9 to 10 thousand lines into the file I get a StackOverflowException while the thread tries to update a counter. ...

Form Sizing ... Again ... FFS

Love-Drunk Gump - 30 Mar 2007 8:33 AM - 3 messages

Greetings, I cannot figure out how size my form correctly, under any Windows Border / Caption Bar / Menu Bar configuration. By my understanding, ScaleHeight / -Width is the client area from the "inner" top-left corner below the Caption and Menu Bars, to the bottom-right corner inside the ...

User-defined type not defined errors going from VB5 to VB6

jim evans - 30 Mar 2007 3:30 AM - 3 messages

I've been using VB5 every since it came out. I picked up a copy of VB6 on eBay. When I loaded my first program into it, it was riddled with "User-defined type not defined" errors. The errors seemed to all ...

OT: Vista Can Be Taken Down by an Animated Cursor

Kevin Provance - 30 Mar 2007 2:37 AM - 14 messages

Thought you chaps might enjoy this...and the irony it invokes. [link] Vista Can Be Taken Down by an Animated Cursor By Scott M. Fulton, III, BetaNews March 29, 2007, 5:16 PM ...

PageBreak property in VB

Nitin Pai - 29 Mar 2007 8:39 PM - 2 messages

Hi Everybody, Here is my problem. I am not able to set a manual pagebreak property in excel using VB. I have Excel 2003 and VB 6.0 with 11.0 excel object library. I have reduced the columnwidth to 2.5 ...

Open Excel file

phreak008 - 29 Mar 2007 4:06 PM - 7 messages

Here is my problem. From my code, i want to open an excel file.I don't want to use an Excel object to do that. My problem is that when I use the API function ShellExecute, it starts the excel with the file but ...

Slow Control Manipulation in IDE with Vista

Rick Raisley - 29 Mar 2007 3:10 PM - 8 messages

I just installed VB6 SP6 on my new Vista machine last night, and am just starting to play with it. One thing I noticed right away is that some operations are /really/ slow and, uh, flashy (that is, they flash). Moving a ...

Vista Installations

Rick Raisley - 29 Mar 2007 1:33 PM - 15 messages

I finally got a Vista machine, and have been testing my installs on it. My programs normally install to the Program Files folder, and keep an INI in the program's directory, and data files in subdirectories of the program's ...

Prevent a Form from Losing Focus [Maybe]?

Love-Drunk Gump - 29 Mar 2007 10:51 AM - 7 messages

G'day folks, I have a small ToolWindow form aside my main form, displaying Chr(0 - 255) (a character map). When a user clicks on a character, I want it pasted to the field with the active focus on the main form. ...

International MsgBox button captions

Peter T - 29 Mar 2007 9:45 AM - 10 messages

Is there an API to return msgbox button captions that will be displayed according to user's language settings. I'm not looking to change the captions but to be able to do something like this - sCancel = "Cancel" ' in user's language ...

VB6 DB Export to text file problem

anonymousfromhk - 29 Mar 2007 4:01 AM - 4 messages

I want to export the db recordset to a text file like the following format, --------col1--------- ------col2----- -----col3------ 9999999999999aaaaaaaaaaa33333333 11111111 bbbbbbbbbb 6666666666 3333333333333cccccccc 7777777 The table have 3 column and i want to export the text file have fixed ...

Line Manipulation on frame in VB6

albertleng - 29 Mar 2007 3:29 AM - 8 messages

Dear all, I need to create a program in which there will be some movable TEXTBOXes on a FRAME. Those TEXTBOXes are dragged from a toolbar onto the frame and their text can be changed. We can also delete the ...

microsoft.NET framework Causes VB 6.0 Compile Failure

drjoeross - 28 Mar 2007 11:46 PM - 3 messages

Greetings, My VB 6.0 Professional STOPED compiling after I installed the .Net Framework required by a program I had just downloaded and installed. I now get an error message from "Microsoft (R) ...

PrintOut Run Time Error 2585

cronse - 28 Mar 2007 6:05 PM - 2 messages

Hello, I am a newbie to access vb so bear with me. I am trying go the last record and then print it out when the form loads. I have tried to change it to acSelection and acPages and I keep getting error runtime ...

Text To Speech Sample Program

Brian - 28 Mar 2007 4:08 PM - 7 messages

Does anyone have a link to the sample VB6 Microsoft TTSApp that is idenetified on their website.... The links for downloading are no longer available as many of the VB6 download items have been removed. Here is the link to what I'm interested in: ...

Fomat function?

anon - 28 Mar 2007 3:50 PM - 15 messages

Hello, I want to use the Format or FormatNumber function to format a Single in this way: show only 2 digits after decimal point, but total number of digits must not be more than 4. So for example 1.23 ...

InteropForms

vovan - 28 Mar 2007 3:48 PM - 5 messages

I downloaded and installed MS Interop Forms Toolkit. The documentation says that this package is intended to be used to convert an existing VB 6 project to VB 2005. I spent some time on reading and analyzing samples. So far I couldn't understand what is going to happen when all VB 6 forms are ...

How to show progress bar during the files or folders deletion

Riky - 28 Mar 2007 2:36 PM - 3 messages

hi i have a windows application. I am select the folder or file name from the folderbrowserdialog box and to delete the folder or file i am calling the following code. Public Function DeleteFile(ByVal path As String) As Boolean ...

Hex 0D 0A and serial question

Rhonda - 28 Mar 2007 2:28 PM - 8 messages

Using code like: TxtString = Chr(2) & Out1$ & Chr(13) & Out2$ & Chr(13) & ChkSum & Chr(4) I thought I could place the 0D 0A AFTER each of my variable values, not in the center. The values are only 5 to 7 digits, the checksum is 4-digit. I'm ...

MS Office Excel VB

mike - 28 Mar 2007 2:23 PM - 4 messages

Hello, ( MS Office Excel 2003 ) I'm getting a runtime 1004 error with for any/each of the following. I don't want to employ the standard Range("A1") object since the the A1 is literal string, and I need more progamatic control hence the Cells method. ...

VB6 on Vista some references doesnt work

VB6 on Vista references doesn't work - 28 Mar 2007 2:12 PM - 5 messages

Is there a solution for this? /Regards Anders MCSD VS6, MCAD VB.Net ...

new calendar window "always on top"

patric - 28 Mar 2007 1:24 PM - 2 messages

Hello VBA Community, I am looking for a long time already for a VBA code that opens a new calendar window in outlook after outlook start in a particular size and position with property "always on top". Unfortunately, I was not ...

Printer Problem in Vista

Mike Williams - 28 Mar 2007 12:48 PM - 6 messages

I'm having a little problem printing underlined text using the Printer Object in VB6 running under Vista. The same code using the same printer on the same machine works fine if I boot into XP (tested separately with no ...

Maximize running app

Anderson - 28 Mar 2007 12:39 PM - 10 messages

I made a program that stay as a icon in the System Tray, and I want to maximize it when someone try to execute a new instance of the program. Is it possible? Thanks Anderson ...

Microsoft SQL Server 2005 Express

Omar Abid - 28 Mar 2007 10:42 AM - 10 messages

Hi, I'm Trying to make a program with vb2005express that connect to any Microsft SQL data base and show it's table. I'm having some problems can anyone help me? Omar Abid ...

spaces in arguments

J Jager - 28 Mar 2007 10:36 AM - 4 messages

I read several questions and answers about this subject but can not figure it out. I use the following code: System.Diagnostics.Process.Start(AppName, FileName) AppName and FileName can contain spaces. Can someone give me the exact code that will work with the AppName and ...

Where Do You Want To Go Today?

Stefan Berglund - 28 Mar 2007 2:36 AM - 7 messages

In spite of the fact that Microsoft abandoned this ad campaign on December 13, 1996 I thought it was especially appropriate when considering the following: [link] ...

Internet Explorer settings

KT1972 - 28 Mar 2007 1:57 AM - 2 messages

Hi, I have a few qustions: * How can I catch the IE when just started? * Is it possible to access internet explorer settings by VB? I'm trying to access and change proxy server address and port if possible Thanks ...

updating number value data in database

baked potato - 28 Mar 2007 1:51 AM - 8 messages

Hi there, I'm not sure at all how to do this so assistance will be much appreciated! I need to add a quantity amount (txtQuantity) to the field "Quantity" in my "CurrentStock" database. But it has to add to the value that is already in ...

VB6 on Vista - error writting to the registry.

Paul Lambert - 28 Mar 2007 1:41 AM - 9 messages

I am experiencing an intermittent problem on Vista with one of my VB6 projects, occasionally - but not every time - when I open the project VB6 refuses to open saying it cannot get to the required registry keys (exact error message eludes me as at this point in time it is working) ...

Problem building dll

Andy - 28 Mar 2007 1:14 AM - 4 messages

I have to make some changes to an ActiveX DLL built in VB. I've opened the project, made some changes, but the 'Make [ProjectName].dll...' item on my File menu is greyed out. There is a major change made to my system since I ...

Office 2007 enterprise product key. i NEED one, but cant find one.

Seb - 28 Mar 2007 1:06 AM - 9 messages

When downloading office enterprise 2007 for my PC, i was not given a product key to activate my version. and i cant find out where to get one, someone please help. Thankyou. ...

sort a 2d array

chimeria - 28 Mar 2007 12:55 AM - 7 messages

how do you go about performing a simple sort on a 2-dimensional array ...

Loading files in an array

George Berotti - 28 Mar 2007 12:09 AM - 4 messages

How do I load a dynamic string array with jpg files ordered on "Date Picture Taken"? The target folder is so ordered in Windows Explorer. or How do I capture the "Date Picture Taken" metadata? for each file? ...

Need an API...

m0a - 27 Mar 2007 11:54 PM - 5 messages

Hello, i need a API which can block incoming and outgoing packets in VB 6.0 Any of such api's are defined in Kernel32.dll , netapi32.dll ? Please let me know. even if such API's are defined in VC++ that would help too. With a little ...

Urgent help using MS Chart in VB6

EasySite - 27 Mar 2007 11:03 PM - 2 messages

I have a line graph. Probability (0-100%) displayed vertical axis, and Time along the horizontal axis. I also have two text boxes (probability and time). When user enters info into these text boxes, I want these values to plot on the graph. ...

Force logout of app after time period

EdwardH - 27 Mar 2007 10:58 PM - 3 messages

I would be grateful of a general approach. The app is receiving an integer from a stored proc representing a time interval before system forces a logout. So if keyboard is not accessed for that period of time, app runs a ...

Setting Printer Page Order at Run-time

ferror - 27 Mar 2007 10:57 PM - 5 messages

Please is there a way i can set the printer's page order at run time in visual basic 6.0? I will be glad if this request could be responded as soon as possible. ...

Manifest for Setting XP Compatibility Mode in Vista

Rick Raisley - 27 Mar 2007 3:56 PM - 6 messages

I KNOW it's here somewhere, and thought I'd saved all such articles, but have spent the last 1.5 hours looking without success, so apologies for the repetition. I'm looking for the Manifest file that sets the Windows XP SP2 compatibility ...

Converting a PDF document image to text

Greg - 27 Mar 2007 3:25 PM - 6 messages

I prgramatically save a PDF document as text using automation. I then process the document in VB. However, my client now has one of his clients sending an image of a document in a PDF file. What is the best way to convert the PDF image file to text using VB? ...

SP5 or SP6

Rick Raisley - 27 Mar 2007 2:24 PM - 19 messages

I've been using SP6 of VB6 pretty much since it was available, without any problems. I am now at the point of installing VB6 on a new Vista machine, for testing and development, and am thinking back of some comments here ...

Trouble with writing SQL queries in VB - understanding the tick mark placement

jonny - 27 Mar 2007 1:45 PM - 7 messages

mrsScrapData.Open "Select * FROM [Raw Data Scrap Subform] WHERE IDrawdata = '" & mrsRawData!autoidrawdata & _ "' ORDER BY AutoIDrawdatasubform", mconAP, adOpenStatic, adLockOptimistic, adCmdText I have the most trouble determining where to put the small tick marks on the query and if I dont get it right I get a error message - usally ...

Recordset.Sort

vovan - 27 Mar 2007 1:23 PM - 6 messages

I have a stored procedure with Order By as: CASE WHEN CAST((Left(dbo.[Partial].PartialNumber, 2)) AS int)<50 then CAST(1 AS varchar)+(dbo.[Partial].PartialNumber) ...

How to Change Colour of Cell in datagrid More options

satish - 27 Mar 2007 12:18 PM - 2 messages

I have a table with two columns field1 int,Field2 and added a column to datagrid on runtime sum (field1+field2) ,upon changing the data in either of the fileds the sum field or column too changes . Intially there will be data in the fields ..and ii try to change the ...

Show desktop

James - 27 Mar 2007 12:16 PM - 4 messages

Is there a way to duplicate programatically the "show desktop" shortcut on the quick launch toolbar ...

Formless Timer

EnVeeTee - 27 Mar 2007 8:51 AM - 11 messages

I have a class module (process1.cls) which required a timer. I've found some code and it works well. Now I have another class module (process2.cls), which also requires a timer and needs to run with process1.cls, however the two timers do not co-exist, ...

Finding the location of systray (taskbar)

Jack - 27 Mar 2007 4:35 AM - 26 messages

It is possible to anchor the main taskbar (taskbar which includes systray) at the different locations on desktop. How programmatically find where the taskbar is? Jack ...

Reading Path VB 6.0

Sharrukin Amiri - 26 Mar 2007 10:54 PM - 2 messages

In VB6.0, how do you read what version of Windows a user is using? and how do you retrieve the Windows path programmatically? Warm Regards, Sharrukin ...

Combobox sorted property

Lou - 26 Mar 2007 10:22 PM - 2 messages

How can I get numbers to sort correctly using the "Sorted" property. I set it to true but when there are numbers involved it does the sort incorrectly it goes 1, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 21, 22... ...

Toggle a checkbox in a subroutine

Mel - 26 Mar 2007 9:36 PM - 17 messages

Hi, I have an array of checkboxes on a form. The code for all of the checkboxes is very similar so I thought I would just make a subroutine and pass the data I need to it for each checkbox. However, how can I pass the checkbox object to the subroutine to retrieve the state of the correct checkbox? ...

Convert Time to a Number

cronse - 26 Mar 2007 8:46 PM - 16 messages

My problem is that I am making a user form where the user adds in two time a start time and and end time and then, it needs to calculate the time inbetween that. I get the right anwser but since the user enters ...

Beginner's question: Set

Aalaan - 26 Mar 2007 8:31 PM - 9 messages

Hi all Would anyone like to have crack at this very elementary question? I now have several apps up and running, one quite complex. Nowhere have I ever used Set to assign values to variables, yet everything works. For example I have said bGross = Text1.Text, and not used set. Can anyone ...

Finding the height of the taskbar

Jack - 26 Mar 2007 5:41 PM - 7 messages

Hello, How to calculate the height of the current (screen bottom ) taskbar? Thanks, Jack ...

Vista problem accessing HKEY_LOCAL_MACHINE in registry

Hansin - 26 Mar 2007 4:41 PM - 9 messages

Hi everyone. I have a VB6 compiled program that installs and runs ok on all versions of from Windows Vista all the way back to Windows 95. It seems to run ok on Vista as well except for one curious thing. My program ...

SQL Server Express/VB6 Backup

lee - 26 Mar 2007 4:32 PM - 6 messages

Hi, I'm looking for a way to automate SQL Server Express backups through VB6. I thought I could use SQLDMO but it won't even connect to the database - I get an error saying I need to use SQL Management Objects ...

Public Const REG_DWORD = 4

Aaron - 26 Mar 2007 4:15 PM - 11 messages

A VB student question... I'm trying to make a basic script to send a string out a serial port. Like: 02 0D 0A 31 32 33 34 35 36 0D 0A But my scrip sends: 02 0D 0A 32 32 33 34 0D 0A 35 36 ...... (4 bytes?) ...

shelling to Microsoft excel

Ellie - 26 Mar 2007 3:57 PM - 3 messages

I would like to open excel from my VB6 app but I might not always know the path. Is there a way to extract this information from the registry? Thanks, Ellie ...

Detecting the mouse click anywhere on desktop

Jack - 26 Mar 2007 3:22 PM - 4 messages

Hello, I am looking for Windows notification of the mouse click anywhere on desktop, outside of my own app GUI. What message it will be? Jack ...

Mortgage Calculations

YYZ - 26 Mar 2007 3:03 PM - 2 messages

Hi Folks. I am stuck on working on something that I'm doing in VB, but it relatively UNrelated to VB. Yes VB Classic. Given a Loan Term (in months), interest rate, and intial loan amount, I can calculate the monthly payment via this formula: ...

Is there a way to put a Global Error Handler on VB application?

jonny - 26 Mar 2007 11:27 AM - 2 messages

Currently I am using a error handler on each procedure. Is there a way I can put on a global error handler? ...

Global mouse cursor position

Jack - 26 Mar 2007 3:13 AM - 2 messages

How to find mouse cursor position on the desktop (in relation to the screen borders)? Jack ...

How to find the location of the icon in systray?

Jack - 25 Mar 2007 10:27 PM - 7 messages

Hello, When the speaker systray icon is clicked on there is a form containing volume slider poping up with the bottom corner touching the speaker's systray icon. How that is done: ...

Vista UAC doc

mayayana - 25 Mar 2007 10:04 PM - 4 messages

I just came across this link to a UAC developer requirements white paper updated in Feb. 2007... Probably of interest to many: [link] 8f46d/WindowsVistaUACDevReqs.doc ...

Simple code to turn on/off microphone plugged into soundcard.

Jack - 25 Mar 2007 8:36 PM - 2 messages

Hello, I think I need to access the mixer settings to be able to turn on/off microphone (mute). Any samples I can have a look at? Jack ...

CVTRES.EXE Causes VB 6.0 Compiler failure

drjoeross - 25 Mar 2007 3:34 PM - 4 messages

Greetings, If anyone with vb 6.0 pro has seen and fixed this error I would very much appreciate your help! I have searched for over a month and found no solution. I get this error at the Very End of the compilation ...

TitleBar Height

Ringo - 25 Mar 2007 3:23 PM - 3 messages

Is there a way to determine the height of the titlebar of a window if you know its hwnd ...

Needs help in funciton

Anna - 25 Mar 2007 11:27 AM - 3 messages

Hi: There are three functions in my program. One is loading data from text file and fetch rows from the site and it pulling correct information, second is loading data from a query and pulling no information from the site, third is loading data from an array and ...