[visual-basic] Forum Topics

hi! how to get the field value in VBA with the help of SQL statement and assign this value to a Variable.... and then use that in the code...? thank you 4ukh

Hello Again, Again being a novice at MS Acces 2003 this is definitely outside my ability. I was told that using visual basic it is possible to show a month calender in a form instead of just entering the date in a field. The user should be able to have …

please tell me how to format text in a SINGLE cell of a table. Once the following text is added. i want to format it in followinfg way. ---------------X_------------------------ Title : ball cat dog ---------X_------------------------ Title : in BOLD and Underline rest of the data in BULLETS.

I want to fully justify text in rtb. I am designing an urdu editor. The rdu language is written from right to left. So the text is right justified initially. Waiting for reply

Hi every one I need help: How I can make hilpe files with (hlp)extension to My APP.

Hi, How to open a excel file from word macro by getting the file name from word. [B]this is my code[/B] OrgFileName = Selection.Text + ".xls" 'OpenExcel Macro Shell ("C:\Program Files\Microsoft Office\OFFICE11\excel ""C:\My Documents\File - CopyBook\""" + OrgFileName) OrgFileName is the workbook name which i have to get from word …

I've got two ms access tables within one .mdb file, the tables are mrproduction & fglotnum. From mrproduction I need records from fields mrStkNum, mrLotNum, and mrQty. From fglotnum I need records from field mrCost. The common field between the two tables is lotNum (i.e. mrproduction.mrLotNum & fglotnum.mrLotNum). I guess …

i'm fairly new to visual basic and i'm working on a simple space shooter game. i need to make an array to hold the bullets and then set the location to the center of the ship. my question is, would it be a good idea to use individual picture boxes …

Hi Guys, I have a problem.... I'm developing a tool in VB6, which gets value of a cell from a DOC File....I'm assigning the cell value to a string.but, in the string i found this junk character "".....can anybody please tell me how to remove "" this character.... I tried …

hi how to show the data in data grid. is the following one correct [CODE]set db.recordsource=recset[/CODE] thank u

hi how to view the entire table present in the DB in datagrid view thank u

hi i'm receiving anerror message while executing this statement. dr.Execute ("alter table results12 add (Total number,Percentage number,Status char(5))") error message run-time error:3292 syntax error in field definition

hi, I would like to generate ppt where data from my back end MS ACCESS dynamicall changes with record.I coded for connectin to back end. I want the code to generate Power point using VB 6.0 where i can dynamically change data.Please help me developing the code. Regards, Dinil

hi i have an error here could somebody know or expirence this before plss help.. this error enclude dll and i have the site now. this is the link [url]http://support.microsoft.com/kb/248055[/url] i already put the dll in the said folder and already installed mdac. plss any has expirence this .plss help

hi guys i have fairly good knowledge of vb6 but cant for some reason get my head around this i want to develop program where you can add multiple names (text string) then press generate and a name is randomly selected for quiz purpose , the name or string dos'nt …

hi guys! | -----------------------|---------------------|------------------------------| | validation_period |-----sys_date-----|-------exp_date-----------| |------------------------|---------------------|------------------------------| |-----------6-----------|---26/11/2008---|-(add validation_period-| |------------------------|---------------------|field value into------------| |------------------------|---------------------|sys_date)...?--------------| |-----------------------------------------------------------------------------| using ms access 2003 i got the system date by using date() function but the real job is to pass the validation_period (which is basically a number of month(s)) field value as a parameter into …

Hello I just started vb about three months ago and i got an assignment that i'm stuck on. It's a program that takes a text file and displays it on screen and i can scroll through it by clicking on a btn next. there are functions on the form that …

Iam developing a tool in VB. I need to access my database for few fields and print them as a table. How would i get a create a table in visual Basic. The question may appear bit odd but iam a beginner .. Please help. Thanks in advance

i require a code in VB for converting the anolog signal to digital so that i could process it .so please extend your help regarding this....

Thank God i found this site. my first day in VB and i was given an assignment to simulate how a lift runs in VB with 4 floors. pls can any one help me so fa i have been able to design the interface. please i need help in writing …

Is it possible to display in image in a listView box? I'm working on a link checker all the links on a webpage are put in a listView box. Right now I just have the words "Good" and "Bad" by each link and would like to put an image next …

i have a project of Call Management System with database SQL SERVER,now i want to limit the connected users in my database in 55 unit only,where in this 55users can only use the system and if there is 1 user trying to connect on my database the system will not …

hi to all again, I want to know how to disable the Maximize option of a window using a VB code. I believe one way to have a fixed window size is to disable the Maximize option?? Can anyone here please help..... Thanks a lot again in advance. Have a …

Hi, Are there any software that I can get back from VB executable file to VB source code? Please help me.

Private Sub Command1_Click() If Combo1.Text = "" Then MsgBox "Please Choose Supplier Code", vbInformation Combo1.SetFocus Exit Sub End If If Combo2.Text = "" Then MsgBox "Please Choose Product Code", vbInformation Combo2.SetFocus Exit Sub End If If Text1.Text = "" Then MsgBox "Please Input the Quantity", vbInformation Text1.SetFocus Exit Sub End …

I wnt to know about a code for hide a folder for windows xp.but i know to hide a folder with set attributes.if i hide a folder with using a attribute it will show in folder option.if someone changes folder option as show system folders and files then user can …

Hi All, I have a small application written in VB6 that outputs a list of words, one per line, to a Word document. By default the font size I use is 60 points, which is fine, as I don't mind the text takes up as many pages as needed, as …

Have made DSN, Now i want to make connect to database.. want a vb script for this. have to fetch data from data base Somebody help please.

I am working on microsoft MS SQL 2005, want to connect with vb script. Want a connect string for this.

I am work with sybase Adaptive Server Enterprise (ASE) 12.5 I wanna connect sybase from visual basic 6 I found this connection string: Provider=Sybase.ASEOLEDBProvider.2;Server Name=myASEserver;Server Port Address=5000;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; but i don not have the provider Sybase.ASEOLEDBProvider.2 I want this sostware driver and know how to connect sybase please help …

Private Sub Command1_Click() Set rs1 = DB.OpenRecordset("Table1", dbOpenDynaset) If rs1.EOF = True Then MsgBox "Record is Empty" Else MsgBox "Got IT" rs1.MoveLast If Not rs1.EOF Then rs1.MoveFirst Do While Not rs1.EOF If rs1!Name <> "" And rs1!age <> "" Then Set rs2 = DB.OpenRecordset("SELECT Name FROM Table2 WHERE Name like …

Functionality of the tool To take the screen shots and save it in a file with description of the screen shot which is entered by the user. Problem Now the text box is accepting only the normal text.This text box should be replaced by rich text box(i.e it should allow …

gud day, this is my new code of my counter using vb-DAO. if i were going use this code, this will happen (refer to my attachment). the quantity of the first product will added to its proceeding product. That is a very big mistake. My only problem right now is …

can anyone help me?

Hi All, i am using MSFlexGrid in my project , i have added the click event for the Grid. Basic operation of grid is when ever any one clicks on any of the cell i will create a combo box below the grid or display the current time or etc.... …

Hi All, I need help in passing data from a datagridview control to textboxes control. When the user doubleclick a value from a datagridview control in form1, I want the record to be displayed in the texboxes of form2. How do I go about coding this? Any help would be …

Hi All, Can anyone upload a multilingual (English & Chinese) vb6 application? I've tried but in resource file it shows '???' for chinese strings. Regards, Shrini

Hi, hope everyone here is dong fine. Can anyone please help me with my coding. This is the code to fetch the book name from INPUT box and display it in a TextBox(which is limited). But I want the records to be displayed on a ListView with several others having …

Hi Friends, how can i change the columns width in MSflexgrid by code from 1.jpg to 2.Jpg I have copied this code in my Module: [I][CODE]Public Function Grid_AutoSize(oGrid As MSFlexGrid, oLabel As Label) Dim nRow As Long Dim nCol As Long Dim nWidth As Long Dim nMaxWidth As Long ' …

Hello agian, i have a computer on a lan (local area network) it connect to the internet via a server( a computer on the lan that allow us to connect to the internet) now i use this code to see how many datas(KB) that i sent & recived [url]http://www.planet-source-code.com/vb...42532&lngWId=1[/url] but …

hey i'm ais94 i am currently a student with dubai in school we take computer science and we were handed a project to do that's how i got introduced to visual basic 6. you could do it whatever programming language you wanted to do it in anyway enough about that …

I've been trying over and over with multiple tutorials including those here and others and including provided f1 help to try and read/create/write/find-line commands (button pressing) from a Notepad file using VB 2008. Granted all these tutorials are VB 6 and lower, but I didn't think that would be this …

Hi Guys, I'm new to the site and just joined. I am currently doing a project for college and would like your advice on what technologies I could use that is effective but simple. Really simple!! What I intend to do is from a Web page on a server I …

Hallo Friends, I need some help from you. i am hereby attaching some files of my project. in 1.jpeg after clicking add button the data will be automatically written in access table shown in 2.jpeg. this is the code for add button. ----------------------------------------------------------------------------------------- [I]Private Sub cmdadd_Click() Dim db As New …

I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in the already existing PPT as extra slides. Please …

Hello I have a code which works perfectly with Word 2000, but causes an error with Word 2003. The error is **"Word is unable to create a link to the object you specified. Please insert the object directly into your file without creating a link."** This code attempts to create …

Another problem I am looking into is the following: How does one use a command button to run private sub's (again) or (at all)? For instance if a website isn't available at the exact moment that it is being checked for certain information on it. I have it set to …

Hi friends, I am Ramesh. I am a B.E. Graduate. Currently i am doing "ATTENDANCE AUTOMATION SYSTEM ", mini project in VB. I am supposed to generate a new access sheet(i am using MS ACCESS as my back end tool). I tried my level best, but i can't. FRIEND IF …

Hello, I want to create my own script like [URL="www.anonym.to"]www.anonym.to[/URL] but with few additional features i want to use database, i believe its very easy to make but the problem i don't know php, i can write in visual basic and c++ but not php, What do i want?? to …

Hey! I'm currently studying Visual Basic and I thought it would help me to register on a site like this so I can gain better insight into how programming and coding works. I hope that maybe you can answer my potential many questions.. This site seems to have a pretty …