10,991 Topics

Member Avatar for
Member Avatar for memory100

have pivot table set up in report format with various fields from a CRM database. I want to clear blank data in the cells when the user click in the pivot table cell to open a certain cell to view the data that is whtiin the pivot table. it creates …

Member Avatar for memory100
0
154
Member Avatar for xuexue

could you give me a syntax for insert into using db2 as the database and vb6 as it's front end? i am trying to insert a numeric value to my table coming from a host variable in vb6, however, i do not get the proper syntax for it..could you help …

Member Avatar for AndreRet
0
121
Member Avatar for xuexue

front end: Visual Basic 6.0 [CODE] Dim intAmount as integer intamount = val(txtamount.text) [/CODE] Back end: AS/400 db2 library: CPALLIB field: amount type: Numeric Len: 9 Decimal: 2 value: 100000 The problem is that when i insert new record to my database for this field: (amount), the value is 100000. …

Member Avatar for debasisdas
0
218
Member Avatar for Khliboy_2796

Is there a possibility of one to write the program code and do not design the form? If its possible kindly assist in helpin with the procedure.

Member Avatar for WaltP
0
95
Member Avatar for Jaseem Ahmed

i have one form, with 2 picture boxes, one Vscroll, and so many textboxes in pictureboxes.. when i m clicking the VScroll, it works... now i want that when i press enter button in textbox the scroll should go down, as it goes on click.please help me.

Member Avatar for Vineeth K
0
224
Member Avatar for pmark019

How can I use SQL Statements in VB 6 with DataEnvironment. I have a DataEnvironment called Table(DataEnvironment2.Dsr) and a report named rptStudMastOne(rptStudMastOne.Dsr). I am planning to use the SQL Statement " SELECT * FROM Student WHERE StdSSN = txtStdSSN " and it will show in the report the record that …

Member Avatar for abu taher
0
103
Member Avatar for Heartis24K

I am taking my first class (online) in Visual Basic and we are using VB 2010. The assignment is to create a football calculator(see attached). I have attached the instructions that the teacher gave us and I think that I created the user interface okay but I don't understand about …

Member Avatar for codeorder
0
116
Member Avatar for abelingaw

How do I add all time values in a database table to get its total, get the total tardiness then sum up to know how many days an employee is absent or present in a monthly basis?

Member Avatar for abelingaw
0
112
Member Avatar for abelingaw

I want to compute the difference of time values. The values are loaded from my database (which are captured via biometrics) into labels. Here's a screen shot: [ATTACH]19115[/ATTACH] And I would like also to separate the hour value and minutes then the computation. Any idea where I will start.? :) …

Member Avatar for WaltP
0
80
Member Avatar for francis_sum41

visual basic 6.0 code! "15 Minutes allowance" -LogIN time is 7:00-7:30 -Beyond 7:30 is Late -beyond 7:45 is absent code for making a condition in attendence If it is: *Absent *Late *Present please help!!!

Member Avatar for WaltP
0
72
Member Avatar for shakunthala.mk

[B]Hello..I am working on project based on Human resource Management system using vb6 as front end!..I want to know how to design a timesheet?..will it be possible using datagrid? :X

Member Avatar for shakunthala.mk
0
53
Member Avatar for Khliboy_2796

Can I write a program code without designing the form.I have tried,the login form works but how do I insert a form which adds form number, name, sex,occupation etc

Member Avatar for Khliboy_2796
0
92
Member Avatar for Jaseem Ahmed

is there any way to select multiple textbox in one click... for example... we have 4 textboxs in an each row.. and 4 textboxes in an each columns.. just like this - - - - - - - - - - - - - - - - now when we …

Member Avatar for AndreRet
-1
90
Member Avatar for lance7tour

Have the following code but can only get it to work when I enter nothing into the answer box then it says sorry..... but if i enter any# or a letter it doesnt do anything.. wordpad will not accept all the end if's and else statements either. only one it …

Member Avatar for WaltP
0
194
Member Avatar for Shodow
Member Avatar for azzu khan

i m using two list box one(check style list box) is for food item another(simple list box) is for cost.when i selects any fooditem then a input will occour for entry of food quantity.and after selecting all items and entry of their quantity they will store in ms access databse. …

Member Avatar for AndreRet
0
772
Member Avatar for maheshsayani
Member Avatar for AndreRet
0
977
Member Avatar for prajana

hello! I am designing an attendance system and i have a problem regarding marking the attendance. I don't want to use datagrid as i cant mark the attendance there ie i want to use checkboxes to mark the attendance. I'll provide a screenshot of how the form should look like. …

Member Avatar for AndreRet
0
836
Member Avatar for Jaseem Ahmed

i m here to ask u a importnt question... is there any way to scroll down or up the text boxes on frames... i mean to say, i have one form, and a frame, and so many text boxes on frame, that all can not b shown at a time, …

Member Avatar for AndreRet
0
213
Member Avatar for abu taher

A text box show current date(like 24-03-2009). I write in other textbox 3. I want when I write 3 then the textbox (24-03-2009) automatically increase month like 24-06-2009. how it possible?

Member Avatar for abu taher
0
107
Member Avatar for Jollyyy100

I have a form on my vb 6.0, i need to change the appearance. In the sense that, i can change its transparency or opacity of the way how the form looks. Is there any way possible i can do that ?

Member Avatar for Jollyyy100
0
354
Member Avatar for abelingaw

I want to load values from a lstview column to a combobox in another form. The problem is that, my combobox style is 2 - Dropdown List and the values in it are from my database field. That's where the error occurs. Saying [ICODE]Text property is read only.[/ICODE] I could …

Member Avatar for AndreRet
0
800
Member Avatar for Shodow

can u help me about this . . . when i click the column header of datagrid it will sort automatically

Member Avatar for AndreRet
0
1K
Member Avatar for memory100

here is the current code i have : [code] Sub Remove_Blank_From_PivotTable1() ' The purpose of this macro is to remove the word (blank) from apprearing ' on any pivot table report.' Dim counter As Integer ' setting up a counter to loop through the worksheet Dim lastRow As Integer, lastColumn …

Member Avatar for AndreRet
1
115
Member Avatar for xXEJEarlXx

please help me. i need codes. How to Convert Dotted Decimal to Binary and Vice Versa in VB6. and a short explanation for the code.. please...

Member Avatar for AndreRet
0
372
Member Avatar for princess_ann

Hi, i'm ann from philippines:p and i just want to ask how to install the program i made in visual basic 6?:?: do i need to make an installer?:rolleyes: can anyone teach me how? :sad: Pleaszzzzzzzzzzeeee...:cheesy: thanks...:lol: Note: please be specific.:!:

Member Avatar for azizmuda
0
246
Member Avatar for xXEJEarlXx
Member Avatar for Unhnd_Exception
0
193
Member Avatar for robergto

Hi there! And Thanks for your help.- I've installed VB 5 Enterprise edition, and amn trying to begin self-guided studies of this language. When trying to use "Microsoft Common Dialog Control 5.0", as told in a book, cannot find it -> CTRL + T and Componets. Instead, have a "Microsoft …

Member Avatar for robergto
0
137
Member Avatar for lance7tour

Am trying to get this code to work where the user enters n rock,paper,or scissors and the computer randomly picks as well, it then states what each choose, once u click ok it tells who won the match but my code once it shows the 1st winner result have to …

Member Avatar for Ezzaral
0
329
Member Avatar for JD69

i am creating a program that will log into a copier's web interface and automatically enter information without the user seeing. I found a code that will log into yahoo mail and click the submit button WebBrowser1.Navigate(TextBox1.Text) WebBrowser1.Document.GetElementById("Admin").SetAttribute("value", TextBox3.Text) WebBrowser1.Document.GetElementById("PASS").SetAttribute("value", TextBox4.Text) WebBrowser1.Document.GetElementById(".submit").InvokeMember("click") this code does not work on the copiers …

0
64

The End.