manoshailu

dear sir i have one check box and one button.when i open form above button is hide. if i tick check box and close the form and when i re open form i want to display above button please help me how to do it. thank you wansa Public Class …

hi, how to get the time difference in vb6 exp; dt1 = now() ' dt1=08/Aug/07 12:57 PM dt2=some date n time now i want to find the difference between these two in terms of time... can u plz tell me how to do that

I have a spreadsheet that has many columns. I want to search the titles of the columns and copy all the content in the column that satifies the search criterion and paste it in different worksheet. Copying these columns manually is very time consuming and I wanted to create Macro …

Im trying to display data in a datagrid then once a row is selected show a different column of the database in a text box. I use the unique primary key in the datagridview as not visible so once the row is selected, i can get that integer and populate …

Hi Guys, I have written a program in VB 6 wherein I want to delete a particular record from MS Access Database Table. I noticed that the record does not get deleted immediately. Only after I close the recordset it disappears. I have a Delete Command Button in a Form …

hi, I want to create a pdf from excel sheet using visual basic 6.0. Can you people help me describing or sending me a ready codes regarding the same. Thanks with regards, Sayyad H.A. India.

please guide me how to resize or stretch the picture with in a cell using vb 6.0

hi, I wanna to calculate the total in currency format $00.00. But the coding doesnt seems to work . Can u help me ? total = Cstr(total) + Request.Cookies("jumlah")

hello...im new in vb world.so please help me if someone can..my problem in details: 1.have created a ms access database file named Database2.mdb which has 5 columns as follows a,b,c,d and result.it has 5 row and a,b,c,d are filled with data but result column is empty. 2.have created a datagrid …

hi, tkx to welcome me in here! i have wrttien a program in vb6 that uses ms access. the program is a attendance monitoring system, that uses the time to calculates hrs late and early of employees. im having problem i dnt know how to make validations in vb6 ex: …

can you please help me how to insert a backrond picture in vb6.

hi!!! am palcy , am having problem in my listview with my save button whenever i try to edit something then press the command button for saving the update that ive' done it give's me the error "querry is too complex" then pointing my "rs.Update" code any solutions or proper …

hi all i am newbie in Excel VBA i created list in Excel and i wrote into ([B]a1[/B] cell-income, [B]b1[/B] cell-expence, [B]c1[/B] cell-kredit and [B]d1[/B] cell-debet) i enter a2 cell income (for ex:1000) and b2 cell expence (for ex: 100) and I give condition in VBA that if income greater …

Hello, when i input to database show error cannot convert type varchar to type numeric.. I' m using convert(numeric, quantity). Where my quantity is empty. Please help me. Thanks

Hi, All I am trying to do 2 level filter on datagrid. First I search the datagrid for same customer number. Than search again by date. The problem I encounter is the first search works just fine (it return me records of a particular customer no.). But when it comes …

hello to all, I am using MS SQL 2005. I have 3 tables, COLLAGE, USER, STUDENT I am providing username & password to collage as well as students. I wanted to assign Foreign Key to 'username' in both tables College & Student. i have done, 1. right click on username …

Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …

Hi all, I am getting exceptions while downloading Excel template. i think the problem is in one sheet if i remove that sheet i am able to download with some vb error messages like cannot read file etc., As per my knowledge in vb code for downloading i have changed …

Hi guys .. i wanted to open some of my files. like mswords that save in any of my folders. also wanted to open .txt, .jpg, html etc files. any code for this.. i have an idea using shell "location of exe" but it open exe files only. i wanted …

Private Sub cmdLogin_Click() Dim comSave As New ADODB.Command Dim sqlAdd As String Set RS = New ADODB.Recordset With comSave [COLOR="red"].ActiveConnection = ConnDB[/COLOR] .CommandType = adCmdText End With ConnDB.BeginTrans sqlAdd = "INSERT INTO UserName (FullName,IDCard,CustomerID,Office,Address,Telephone,UserId,UserPwd)" sqlAdd = sqlAdd & "VALUES('''& txtFullName.Text & ''', ''' & txtIDCard.Text & ''', ''' & txtCustomerID.Text …

OK, this might be a bit too difficult to explain on the forum but I thought I would give it a shot. I have an excel sheet which has 3 columns, The first and second columns contain different figures and the third column has a figure which could be a …

Goodday All. I have imported data from an MS excel spreadsheet into MS Access. All goes well unit I try to populate a MSFlexgrid with an open recordset. In my code it shows me that each and every field is found except when it gets to empty field it see's …

I made a cross tab query. please see the attach file. the sum of category show in textbox in my project. like: Stationary = 2000.00 Machinery = 5000.00 Salary = 2200.00 here I can write sql command like:[CODE]select sum(stationery) from table1 [/CODE] but here I know the category"stationery" so I …

Can anyone tell me .when in let property why we put parameter of property always value type .why not return type should be reference type.Additional can anyone explain me datasource class of vb6.How should i use this data source class using ADO 2.6 Means using recordset object in a datasource …

hi to all genius, i am making invoice form in vb6, i have to make grid like view so that user can add item details in row just by clicking on it and new Grid is open to select record from it. hope u r understanding.. example: this is the …

Do anyone know how to use the vb to retrieval data from MS SQL ? Do anyone have a good tutorial about it can post it??

how to make a validation like vb in asp.net? I want to make a text box should only accept numeric values.... samy

Hello Guys, I am new to VB6 & Oracle too. I have one got one Project from my friend. He gave me some VB6 files & 2 SQL files for Oracle database. Now i want to know that how can i connect my VB files to database?? I am also …

The program has a button named [B]INCREMENT [/B] . The label that starts with 0 will increment every time the button is being pressed and save it in a database then so on. . .those being saved in the database will appear in MSFlexGrid. Important part: in MSFlexGrid 1 2 …

im a beginner in vb. i really want some help in using vb. actually i want link my vb interface to data in access using adodb. then how to list data (access) through vb interface according to some criteria that had been set by user. Example: using customer id: 102,103,104,105,106,107,108,109,120 …