[visual-basic] Forum Topics

NEED HELP !! Is it possible to run a DTS package( which has been saved as VB file) on a remote computer which does not have the SQL server installed? If yes, could u pls tell me in detail? I have searched a lot of inofrmation on internet like registering …

Is it possible to rewrite the following VB.NET code in VB6? [CODE]Dim Names(,) As String = New String(,) {{"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, {"UserName", "RealName"}, …

I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" …

Hi, I am writing a program in Excel Macro, where I need to create an array and then have to check wheather an element exists or not in that array. I have created the array as follows - Dim tmpArr(1 to 10) as Integer tmpArr = Array(2,4,6,8,10) Now, i can't …

hi can you please help me with my project??? it is all about on making a map of the realty houses...and i dont have an idea to do it.. my teacher said..the concept is when you search the person his/her house will zoom in..please help me...

is there a way to take data from msflexgrid and put it into a ready made excel file(meaning some boxes in excel is already filled)? And it is put into some specific place in the Excel template. Data from MSFlexGrid-->Excel Template. Thank you.

Hiiiiii. this is asweta here . can you suggest me topic for my project on VB . i am 3rd sem IT engg student

at a current project I was ask to provide a native access using Visual Basic and the Btrieve API. Since there isnt any actual sample at the website availabel ([url]www.pervasive.com[/url]) I thought posting it might help some of you. You can find sample code but almost all of them using …

I am using a Data Environment to create a data report. The code is working fine in one app, but after I copy-pasted it to another app, it's giving problem. Both apps are similar and have same references and in same sequence This works fine (in App # 1) [code] …

You can found Source code, tips and trick vb6, tutorial vb6, control activex, library. Please visit to [url]http://vb6stuff.blogspot.com/[/url]

Hi, I was comparing the features visual Basic & visual studio at that time i found that in VB provide the facility of message box. But in VS we don’t have the facility of input box. The input box is really very helpful if we want to take some input …

So, I've been getting some help from the community on some issues (mainly G_Waddle, thanks again!). I'm a VB6 rookie, and it's been a while since I even did coding with that. So, basically here is my VB6 snippet. It's very straight forward and easy to code in VB6, but …

I'm trying to convert a simple program fron vb6. IT's only draggin several pictures with the mouse and drop them into anothet picture (trashbin). If the object picture dropped is a match then the trashbin.image changes to another image But: First, I don't know how to allow drag controls!!!

Hello, I need help in VB6 : Here is the requirements: a) Browse for new images. Minimum of JPG, BMP and GIF image files shall be supported b) Select images for a new group c) Assign name to a group and save a group in a file or database d) …

Help me! I just can't seem to get this right. I'm trying to open an Excel file(Template) and put data from msflexgrid into a specific place in the excel file but i just can't seem to get it right. Can anyone help me with this coding? Much appreciated. Thank you …

If I hard code search criteria i.e. adodc1.recordset.find "car Like 'corvete'" will work. But if i try to use an entered sting in text box on a form and assign it to a string variable with wildcards in the "find" it does not work. WORKS: Dim test As String test …

Anyone know how to implement a timer code? What do i have to do in order to implement a timer? And the timer is one minute and then the vb program continues. thank you so much.

Hi all, i have a trouble convert Text (have form of Hex already e.g 05 07 3F 04. ..) to Hex then i can calculate those number to draw graph with them. many thanks for any help or instructions!

How can i change my vb exe file in to a installable file. That contain the ms access database as back end. Anyone can help me.. Thank you for any help

anyone knows where i can DL it??...i just prefer video tutorials than ebooks..hehe

hi I am trying to add numeric text with [B]thousand seperater format [/B]in three textboxes. Problem is amount after thousand seperate get ignored i.e if text1.text is 1,250.00 text2.text is 3,500.00 and text3.text is 2,100.00 the result in text4.text is 6.00 instead of 6,850.00 Text4.Text = Text1.Text + Text2.Text + …

I am using the following function to convert ascii to hex, but it is not working properly. [CODE]Private Function HexString(EvalString As String) As String Dim intStrLen As Integer Dim intLoop As Integer Dim strHex As String EvalString = Trim(EvalString) intStrLen = Len(EvalString) For intLoop = 1 To intStrLen strHex = …

Hi, I'm a student from Malaysia and I am trying to do a program where the program will run and then when it reaches a certain part, it will show a message and pauses the program until the user clicks done/continue/yes button at the message. Flow: Programme running-->Message-->"Please close all …

Can u pls help me solve this problem iam using vb6.0 and sql 2000. when i insert the currnt date (as Now()) in the dbase with a colunm datatype date/time, it inserts the date 01/01/1900. In MSAccess it works by putting a # b4 and after the date e.g. #25/06/2010# …

How do I get the same result from this Python script in Visual Basic? [CODE=Python] import os username = os.getenv("USERNAME") desktop = "C:\\Documents and Settings\\%s\\Desktop\\" % username print desktop #Result = C:\Documents and Settings\<MY USERNAME>\Desktop\ [/CODE] I already have this, [CODE] Public Shared username As String = My.User.Name 'Gives computer …

Hello, i need function to Convert Hex numbers to Decimal.. My string is in this form 10,11 and i want to convert it in this 1A,1B.. Thanks

Hi, Can anyone please help me in this. i want to retrieve a view in VB.i was able to do with the below script when using tables,but not with view [code] Dim strSQL_revenue As String Set rs_revenue = New ADODB.Recordset strSQL_revenue = " select * from dbo.PLAN_PNL_INTERUNIT_REV" With rs_revenue .Source …

Can anyone teach me how to calculate a mouse click? I need to do a data insertion into MSFlexGrid. The flow is like this: 1:the data will read a text file and input all the data into column 0 2: when user wants to input again, it will be put …

Simple little exercise using the MonthView Date Picker. I'm trying to loop through print all dates from dateclicked to end of month. I'm getting stuck on the comparison value to define the end of the month. Keep getting the "argument not optional error" or and infinite loop. [code] Private Sub …

I am trying to incorporate MSFlexgrid to read all the data from a text file but i am currently having a problem with a line Below is the coding Private Sub Command1_Click() MSFlexGrid1.Cols = kiraCols + 1 Open App.Path & "\master_data.txt" For Input As #1 ' linecount = 1 Do …

i want a search command for searching a data in document or database which search any word in the document

I want to create an activation window to add onto clients pc so if they dont pay their account within a certain period the activation window will pop up and not allow them access to the pc until their account is paid and we will provide them with an activation …

[CODE]Private Sub Command1_Click() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "select *from Payroll", Cn, adOpenDynamic, adLockOptimistic rs.AddNew rs!Date = Text1.Text rs!Emp_ID = Combo1.Text rs!EmpName = Text2.Text rs!Father_Husband = Text3.Text rs!Designation = Text4.Text rs!PANNo = Text5.Text rs!PF_PENNo = Text6.Text rs!HRA = Text7.Text rs!Basic = Text8.Text rs!TA = Text9.Text …

Is there a good way to make vba code secure other than using a password, which I understand is quite easy to break?

I would like to design a programm in visual basic.net meet the following requirements: Fibonacci numbers Input limit is 15 Numbers are 0 1 1 2 3 5 8 13 The program must allow input limit Display all generated Fibonacci numbers The sum of all the Fibonnacci numbers Anyone who …

How To Click A Botton On Form1 From Form2 ?

Hi I'm new to Visual basic. I'm getting an runtime error 424:object not found,When i'm validating between dates in crystal reports.Please correct me where i did wrong.. [CODE]Private Sub Command1_Click() Dim f_date As Date Dim t_date As Date 'From_Date and To_Date Validation f_date = Trim(Format(DTPicker1.Day, "00")) + "/" + Trim(Format(DTPicker1.Month, …

Yoe guys, need your help.. I want to know on how to setup my client computers and the server so they can connect to sql server 2005 Developer Edition. Client computers are Windows XP. Server is Windows Xp installed with a SQL Server 2005. They are on the same Workgroup. …

I'm about to write a new program in Visual Basic. I have Visual Studio 6.0, but it's limitations are starting to become a problem and I'm wondering about trying Visual Studio 2008 Express (unfortunately purchasing the full version is not an option). I would hate to get halfway through and …

Hello, I am making a *.vbs file and I need help putting two codes in. The first code is to make a .txt file named "Hello World", with the text in the .txt file "Time ... (your time)-Test123" Code: [CODE]myfilename = "\Hello World.txt" MakeHelloWorldFile myfilename Sub MakeHelloWorldFile (FileName) 'Create a …

Hi.. How to control the gpedit from my vb6 application.. i want to control the GP edit from my vb application... plz help me with coding..

hi there, i am creating an application in visual studio 2008 standard edition. i have a form all frmMainMenu and a frmLogin and a frmAddNewProposal. i have a close button in frmMainMenu, i want to coed this so that when i click on the close button the frmLogin should appear. …

What is wrong in this code ? [code] rs.Open " update TblName set FldNum=" & text1.Text & " where ID_FldName=" & Text2.Text , db, adOpenDynamic, adLockOptimistic [/code] Knowing that FldNum ---> Data type (Number) ID_FldName ---> Data Type (AutoNumber) And What the correct code ?

Hi guys, just wondering, would someone give me some advise of what what kind of software should I develop...maybe just a simple software...or a small software...whatever you call that...a software that would not take a lot of time in the development process...maybe...more or less than 3 weeks...what do you think?.. …

Hello everyone, I am currently doing a treeview control in asp.net. I want to [B]load the database from MS Access into my treeivew[/B], but I don't know what should I type in my .apsx.vb file. [B]Please help me with the codes [/B]to make my treeview connect to the MS Access! …

I've been trying to find out the error returned from [iCODE]MkDir[/iCODE] to no avail. [iCODE]Err.Number[/iCODE] is 0 and I can't find any other error mechanisms available. [CODE] On Error GoTo mkError MkDir txtDir(Index).Text On Error GoTo 0 Exit Sub mkError: On Error GoTo 0 Text1.Text = Str(Err.LastDllError) + " " …

I am relatively new to visual basic. I have VB 6 professional complier. I am working to play .wav files in a program. I'm having a problem understanding APIs and functions can you direct me to a beginners tutorial that might help me? Thanks, Bill

I'm having problems loading an image from file. Im using a fingerprint SDK and it has a built in LoadImageFromFile() function. When I try to load my fingerprint image it returns, "A null parameter was supplied". I can load the same image from their sample program and my code is …

We are converting a Visual Basic 6.0 application to vb.net 2008 and are having an issue, while executing the code under “form activated event”. There is a difference in behavior between form.activate in Visual Basic 6.0 and form.activated in vb.net. In Visual Basic 6.0, the Activate event was raised only …

just want to design a software that called reminder sofrware. Its like resource project.And ı dont know even how to start. Its gonna be a software that is designed to alert the user of important events that they have input to the program and the program provide a calendar and/or …