Calculating OD from weight and/or metres in VBA
Hi there, Have a problem trying to convert weight and/or metres to OD, I work in the flexible packaging industry coordinating all the trials for the UK & Europe. I can calculate from an exsisting OD to weight & Metres using the following VBA statement; RNEW = (PI * ((((NEWI(1) / 1000) / 2) ^ [...]

Answer Question   |  December 4, 2009  10:41 AM
VBA, VBA macro, Visual Basic

CONNECTION VB WITH ACCESS
how to connect visual basic 6 and msaccess 2003 by using connection string

Answer Question   |  August 9, 2010  7:56 AM
Access 2003, VB 6.0, Visual Basic, Visual Studio 2005

COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT NB : THIS [...]

Answer Question   |  January 23, 2010  7:24 AM
Microsoft Access, VB, Visual Basic

How do you get data from visual basic to a html form automatically
Hi People again, I’ve got a program I did in Visual Basic 4 that I’ve recently modified parts of, the parts modified were like so, a person would click a certain button and a form.html would come through the internet and pop up on the screen as well  another VB form as well popped up with some [...]

Answer Question   |  October 31, 2009  6:45 PM
VB4, Visual Basic, Visual Basic 4

Unknown Publisher warning by ie.
When you have a file and your the creator of this file.exe and put it on a server, others can down load, but they get a msg. saying Unknown Publisher, is there a way you can let ie. know who the publisher is, so they don’t get this warning?

Answer Question   |  January 23, 2010  11:51 PM
VB4, Visual Basic, Visual Basic 4, Visual Basic Error Messages

store image to sql server
would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

Answer Question   |  January 23, 2010  8:28 AM
SQL Server 2000, SQL Server Image Store, VB 6.0, Visual Basic, Visual Basic 6.0

VB
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form’s Combo — when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 [...]

Answer Question   |  October 21, 2009  4:26 AM
Microsoft Access, VB, VB 6.0, Visual Basic

Attaching a Default Icon to .exe file
Ok, I know how to change an icon, through the properties tag, but my question is this. How does one attach an icon to a program coded in Visual Basic with a default icon, instead of the one that is always there? Like if I make my own Icon.ico file, how do I make that [...]

Answer Question   |  October 21, 2009  11:52 PM
VB4, Visual Basic, Visual Basic 4

Print to file and getting Un-Readable data.
I’m trying to print out my Visual Basic 4 code to a file, and get un-read-a-ble code, but if I print it out to my Printer it’s very readable, why can’t I get readable data when printing to file?

Answer Question   |  October 23, 2009  8:59 PM
VB4, Visual Basic, Visual Basic 4, Visual Basic developers

Tree View Control
i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide [...]

Answer Question   |  October 15, 2009  8:55 AM
Crystal Reports, SQL Server 2000, Tree View control, VB 6, Visual Basic

How do you get Visual Basic 4 to play sound.wav files
Hi everone, I thought I saw this answer on this site earlier, but now can’t find, at the time, I clicked the button e-mail myself, but now realized it didn’t send me anything, here’s my problem. I wrote a program using vb4, I also have vb 2005 but don’t like the way it compiles, so [...]

Answer Question   |  October 14, 2009  11:58 PM
Visual Basic, Visual Basic 4

Customize page size of data report in vb 6.0
hi guys… My problem is….. Default size of data report is A4. but i want to change it 12×18 inch. or any other. how can it possible? plz tell me soon lakahmikant_prince@yahoo.co.in

Answer Question   |  September 30, 2009  9:42 AM
VB 6.0, Visual Basic, Visual Basic 6.0

Forms in Access 2007
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How [...]

Answer Question   |  June 30, 2010  7:55 PM
Access 2007, Access forms, Microsoft Access, SQL, Visual Basic

Not Supported Error in Crystal 8
I have a report designed in Crystal 8 that is ment to display the data from the stored procedure that has 1 parameter passed. SELECT BS.Box_Set_ID,   (int) BS.Date_Stored,  (datetime) BS.Shelf_Location, (varchar (255)) BS.NumOfBoxes,   (int) LTrim(BS.[Description])as Description ,  (varchar (255) LTrim(BS.Comment) as Comment,  (varchar (6500)) BS.Content        (varchar(MAX) FROM Box_Set BS WHERE ((BS.Description LIKE ‘%’ + @KeyWord + [...]

Answer Question   |  October 19, 2010  2:23 PM
Crystal Reports 8, Visual Basic

How do I set decimal places with VB Access
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number of decimal places displayed in the [...]

Answer Question   |  September 21, 2009  11:55 AM
Access 2000, Microsoft Access, VB, Visual Basic

VB script to copy valid data to another file
I am new to Scripting (Vb).  I need to do the following thru VB script. Is this possible? There are few VB scripts which is currently performing the file transfer function (transferring these files from the network drive to the application). Some times, this text file contain some junk data in the first few lines.Script which [...]

Answer Question   |  September 21, 2009  5:59 PM
Visual Basic, Visual Basic Script

how to print on second page in datareport in vb6
i want to print multi page without connecting back end database table in data reports in visual basic6.0 how to implement this. i want to sample coding

Answer Question   |  September 8, 2009  7:29 AM
VB 6, VB 6.0, Visual Basic, Visual Basic 6.0, Visual Basic printing

Vlookup Formual in VB
I have the following code that keeps being displayed as “run time error 1004 for application or object defined error. Sub formula() Sheets(“Depletions”).Activate Range(“G8:G156″).formula = “=IF(IF(ISERROR(VLOOKUP(B8,’Banfi DA ‘!$D$5:$P$266,7,FALSE)),”",VLOOKUP(B8,’Banfi DA ‘!$D$5:$P$266,7,FALSE))=0,”",IF(ISERROR(VLOOKUP(B8,’Banfi DA ‘!$D$5:$P$266,7,FALSE)),”",VLOOKUP(B8,’Banfi DA ‘!$D$5:$P$266,7,FALSE)))” End Sub When I replace the formula with something more simple it works. I have also pasted this formula in excel [...]

Answer Question   |  September 4, 2009  6:04 PM
Programming, Visual Basic, VLOOKUP

Write Recordset to MSAccess(mdb) using VB6.0
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance.

Answer Question   |  August 28, 2009  2:51 PM
Microsoft Access, Visual Basic, Visual Basic 6

how i do save picture in data base vb.net
iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

Answer Question   |  January 23, 2010  7:58 PM
Access Database Attachments, SQL Express, Visual Basic