12,425 Topics

Member Avatar for
Member Avatar for savedlema

Hi friends, I'm developing an application for HR. I have two tables so far.One is tblDetails and the other is Academic. I have created a relationship (ID to AcademicID), I have been able to pull data to a form by this SELECT statement: sqlSearch = "SELECT tblDetails.ID, tblDetails.FirstName, tblDetails.Surname, Academic.AcademicID, …

Member Avatar for savedlema
0
209
Member Avatar for honeybee2090

http://www.warriors-rules.com/socks.txt i want to creat login application for this application have 2 textbox 1 webbrowser 1 button login text1.text username text2.text password i am useing htaccess for this AuthUserFile /.htpasswds/.htpasswd AuthName "Sockz-5 Login" AuthType Basic require valid-user

Member Avatar for honeybee2090
0
84
Member Avatar for honeybee2090

my text box have multi lines i want to count those lines and show it in form caption. spoz i have 12 lines in text1.text i want show it like this Sockz-12

Member Avatar for honeybee2090
0
536
Member Avatar for ms061210

Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = …

Member Avatar for mikeybware
0
326
Member Avatar for Divinedar

The attached excel worksheet can explain better of what I need. I need to calculate the attached based on fiscal year starting with August and ending in July for the next 5 years. If you have any other questions for better understanding please let me know.

Member Avatar for peter_budo
0
261
Member Avatar for ponnu

vb6 code to check if record doesnt exist,then insert new record.server is ms access 2010.So when i used the Dlookup function If IsNull(DLookup("[empid]", "[employee]", "[empid]= & txtemplid.text")) Then I got error like "function or subfunction not defined .is it due to issues with referencs .how can i fix this error …

Member Avatar for ponnu
0
2K
Member Avatar for lianpiau

my record got OrderFormNo and CashBillNo.(one to one insert) if 1st record OrderFormNo is 123 and CashBillNo is ABC, if 2nd record also same OrderFormNo, the CashBill must be same. As a result, I want detect if got same OrderFormNo in database but different CashBillNo, will not insert to database.

Member Avatar for debasisdas
0
225
Member Avatar for myliene

roll no. name 2/12/2012 14/12/2012 23/12/2012 12 james 56 90 88 23 philip n/a 99 76 45 rosy 55 n/a 85 6 peter 59 74 45 13 sam 69 73 n/a this data i have in excel sheet,i want to write a vba code that depicts individual student's performance in …

Member Avatar for ChrisPadgham
0
113
Member Avatar for ms061210

**PLEASE HELP ME. THIS CODE WILL RETRIEVE THE SEQUENCE YOU MADE. AND WILL OUTPUT IN THE TEXBOX IN THE NEXT FORM. BUT MY PROBLEM IS THAT IT DOES NOT RETRIEVE/GIVE THE GENERATED SEQUENCE. FOR SHORT NO OUTPUT T__T . PLEASE HELP.** Public Sub getJO() Dim oradb As String = "Provider=OraOLEDB.Oracle; …

Member Avatar for Begginnerdev
0
183
Member Avatar for Navu_1

as i declare the first one field is combobox and another one is text box. then if click the combobox value then corresponding text value to be displayed on text box.how to proceed to coding in ms access.

Member Avatar for debasisdas
0
89
Member Avatar for amitash

Hi, I want to store today value in a string in VBA Word, e.g. today is Oct 04 2012, the string will be = "04102012". Any simple code can achieve that? Thanks!

Member Avatar for AndreRet
0
296
Member Avatar for jontennyeah

i was adding a windows form namely form3. but when i set it in the startup form there was an error "The custom tool ' MyApplication.generator' failed" what can i do to fix it? i cannot debug my program with that error. can you help me ? thank you

0
84
Member Avatar for myliene

i have data in excel file from which i want to generate report card for students based on their performances in test held on certain dates.for it i need to write a vba program to depict it in a chart and the dates on which students did not aapear for …

Member Avatar for BitBlt
0
90
Member Avatar for angel06

Guys kindly check this code of mine. Supposed to be Text3.text once inserted into Table1 should give the total work hours but instead, it gives a date, not time. Private Sub Command1_Click() Dim Str1$, Str2$, Str3$, Str4$ Text2.Text = DateTime.DateDiff("n", Text1.Text, Label1.Text) Str1 = Text2.Text \ 60 Str2 = Text2.Text …

Member Avatar for BitBlt
0
123
Member Avatar for compulove

I am writing a program that is a multi-form inventory program for a bookstore with data saved in a textbox. Here is what I need to do: * Write a menu-driven multiform inventory program for a bookstore with data saved in a text file. 1. Each record of the text …

Member Avatar for AndreRet
0
208
Member Avatar for Poojaaa

I am working in sql2000 database as backend and Vb6 as frontend. Its for bank scenario I am trying to display the balance corresponding to particular account number. Do try to help. Following is my code. ************************************* Private Sub Command1_Click() Dim con1 As New ADODB.Connection Dim cmd1 As New ADODB.Command …

Member Avatar for AndreRet
0
106
Member Avatar for angel06

Hello! I'm currently working with my monitoring system now, is there a code to append records from table 1 to table 2? Please help me guys! Thanks.

Member Avatar for BitBlt
0
237
Member Avatar for guru_iyer

I've a DataGrid Control in my application and a button. When i click a button it should display the contents of the Logins table in the DataGrid. For this I've coded the following, but its giving me an error "Rowset is not bookmarkable.". I've searched a lot, many suggestions include …

Member Avatar for AndreRet
0
1K
Member Avatar for mahela

I have a vb programme.there I link it to a access database.In the database I have a table with 3 fields code,description,amount.I used primary indexing for code field.so codes are as 1,2,3,4,...when I enter the code number in vb program I can extract related description and amount.but what I want …

Member Avatar for mahela
0
106
Member Avatar for HibaPro

the procedure entry part 1stractI could not be located in the dynamic link library MSDART.dll ??? how i can fix this ??

Member Avatar for AndreRet
0
147
Member Avatar for HibaPro

after i add all the reference on my vb6 project and everything loaded successfully when i press on report button to view the report i face this error msg: Logon failed Details: ADO error code ox80004005 Source: Microsoft OLEDB Provider for SQL Server Description: [DBNETLIB][Connectionopen] sql server doesnt exist or …

Member Avatar for AndreRet
0
135
Member Avatar for charuwaka

in my college we are runnig c++ by creating a directory from cmd and this commands goes like this cd\ cd rollno set path=c:\tc\bin tc this created dir in c folder and also saves our pgms with our roll no so what i want is iwant to implement it in …

0
62
Member Avatar for silversurf

Hello everyone, I am trying to build a inventory and pos system with Ms-Access as database and VB 6.0 programming. I got stuck in one place again. What I want to do is trying to print out the codes and price of the products. In this form, I have a …

Member Avatar for AndreRet
0
458
Member Avatar for HibaPro

Private Sub Cmd9_Click() 'On Error GoTo Error_Handler Dim Report As New Blank_rShopDrawing 4 Set Report = New Blank_rShopDrawing Report.RecordSelectionFormula = "false" Form1.CRViewer1.ReportSource = Report Form1.CRViewer1.ViewReport Form1.Show 1 Exit_Error_Handler: Set rs = Nothing Exit Sub Error_Handler: MsgBox Err.Number & " : " & Err.Description Resume Exit_Error_Handler End Sub the error in …

Member Avatar for AndreRet
0
317
Member Avatar for maverick420

**While executing the following code and when clicking the clear button it gives me error "Error Input String in not correct" line --> workedHour = Decimal.Parse(HourWorkedTextBox.Text) Any help will be highly appreciated** Public Class Payroll Dim fullName As String Dim pay_Rate, workedHour, grossPay, netPay, taxRate As Decimal Dim taxAmount As …

Member Avatar for AndreRet
0
241
Member Avatar for jamescv7

Hi its my first time to join on this community, could anyone help me out to figure out? Actually I want to figure out how this picture would work http://i49.tinypic.com/5bd1tt.png using loop. Basically its like this on a elaborated details: > Write a program like the one to the right. …

Member Avatar for AndreRet
0
459
Member Avatar for HibaPro

when i want to add a component or Referrence to vb6 Project it give me this error msg : error accessing the system registry how i can fix that ??? sry again

Member Avatar for AndreRet
0
5K
Member Avatar for Doogledude123

Whats wrong with this, doesnt make sense that it wont create the folder or files. If PathRead() = 0 Then MsgBox("Error Reading Path Info: One or more Paths do not exist.", MsgBoxStyle.Critical, "Path Read Error") MsgBox("Would you like to create these files?", MsgBoxStyle.YesNo, "Create?") If MsgBoxResult.Yes Then MkDir("/Paths/") System.IO.File.Create("/Paths/aPath.txt") System.IO.File.Create("/Paths/mPath.txt") …

Member Avatar for TnTinMN
0
189
Member Avatar for jd2369

i'm creating an application that will automatically launch a website and click a button on that website. div class="levelwrap level1" style="display: block;"> <ul> <li class="first"> <li> <li> <a id="ctl00_ContentPlaceHolder_TabStrip_Tab3" href="javascript:__doPostBack('ctl00$ContentPlaceHolder$TabStrip','ctl00$ContentPlaceHolder$TabStrip$Tab3')" style="z-index: 8;"> <span class="wrap"> <span class="innerWrap">Network</span> can anyone assist? I'm trying to click the button above. screens a screeshot of …

Member Avatar for geniusvishal
0
131
Member Avatar for joshuaramirez

I need to update my Microsoft Access database 2003 from my server automatically. but i don't have any idea how to do it. Please help i really need this for my thesis. Thanks!

Member Avatar for debasisdas
0
202
Member Avatar for Dr.Lipe
Member Avatar for debasisdas
0
33
Member Avatar for sanjayd503
Member Avatar for debasisdas
0
68
Member Avatar for ms061210

**PLEASE HELP ME, MY CODE IS FOR SEARCHING. YOU WILL FIN THE NAME IN THE COMBO BOX, THEN WHEN YOU PRESS SEARCH ALL THE DATA ABOUT THE TENANT WILL BE RETRIEVED. BUT MY PROBLEM IS, EVEN THOUGH THE TENANT IS IN THE LIST, THE CODE ALWAYS RETURN NOT FOUND. PLEASE …

Member Avatar for ms061210
0
158
Member Avatar for HibaPro

Private Sub Cmd_Print_Click() 'On Error GoTo Error_Handler If newflag <> 0 Then MsgBox "Inserting New Record Mode, Press EXIT Button To Return To Normal Mode", vbCritical, "Attention" Exit Sub End If If RepNo.Text = "" Then Exit Sub Dim Report As New rstoreinmaterial Report.RecordSelectionFormula = "{DetailsStore_InOut_Material.RepNo}= " & Val(RepNo.Text) & …

Member Avatar for AndreRet
0
516
Member Avatar for ralph.s.bernardo.1

hey guys i need help for adding values of two or more fiels using ms access, adodc, and datagrid in vb6.0 . example of these is book quantity field with book title field with different titles. i need help ASAP for my library system project. help me please. help for …

Member Avatar for AndreRet
0
184
Member Avatar for jayrbete

Hello Everyone, Can you help me about importing Maya 2011 in visual basic? or converting maya binary to exe files..? thanks a lot for helping me.

Member Avatar for Begginnerdev
0
136
Member Avatar for Tintso
Member Avatar for webseller

Hi All,, I want to add new leave type which its respective purple color to the already existing template by microsoft office available at "http://office.microsoft.com/en-us/templates/results.aspx?qu=employee%20attendance&queryid=194963f8-3883-4599-b317-3dbd92b705c5#ai:TC102780235". Anyone could help me how to add new add new leave type and its color to the year column. Thanks in advance Jos

Member Avatar for ChrisPadgham
0
193
Member Avatar for ss123456

i have a table employee. it has various attributes.(e_id,e_name,e_addr..) i have a data grid that displays all d values of employee..i need to now select multiple rows from the datagrid of employee such that only e_id gets inserted into another table. is there an sql or vb code that can …

Member Avatar for ChrisPadgham
0
869
Member Avatar for HibaPro
Member Avatar for AndreRet
0
423
Member Avatar for steadi

Hello All, Recently I have been working on a level editor in Visual Studio 2010 so that I can make levels for games and upload them into my game engine. My problem, however, lies within the "saving" part. 1) I start off with an empty panel with thousands of controls …

0
92
Member Avatar for tokipot

hi, im new here, ahhm can u help me abt my project, its a library system that have database and u need to login first to borrow a book, first u need to register, after register you will have ur profile, that profile consist of searching and borrowing books, and …

Member Avatar for AndreRet
0
958
Member Avatar for ss123456

i have a database consisting of a table PROJECT(p_id,p_name,P_manager) i am using oracle 9i as my backend and auto increment is possible only through triggers and sequence. instead i would like to retreive the data p_id onto a combo box. simply put- when i add data into my table PROJECT …

Member Avatar for AndreRet
0
2K
Member Avatar for HibaPro

hey everybody , i need the help plzz,,, i have an application that developed using vb6 and i have its database that design by sql server , but i dont know how to make it run , when i run the application its give me the following error : Dim …

Member Avatar for HibaPro
0
706
Member Avatar for dinzky0307

i have 2 forms.. the first one is for displaying students record while the other one is for searching student record (in datagrid) i want to display the searched record of a student from form2 to textboxes in form1..how is this possible? If DataGrid1.Col = 0 Then If Text1.Text = …

Member Avatar for ChrisPadgham
0
1K
Member Avatar for abelingaw

I've done programs to save values to a dbase from a certain control, but done one by one. Scenario: * There are 7 textboxes where values are entered. * There are also 7 rows (but in one column only) for each values when save button is clicked. Problem: * How …

Member Avatar for ChrisPadgham
0
138
Member Avatar for utsav91292

I want to make student management system in which student will enter his data and we can save it in any other program such as word, excel. And when he will open again he can get his data back..

Member Avatar for ChrisPadgham
0
80
Member Avatar for llian21

ive been trying to connect visual basic 6 to a database using only codes and i cant make it work. please help

Member Avatar for ChrisPadgham
0
78
Member Avatar for compulove

Help writing inventory program in vb! I am writing a program that is a multi-form inventory program for a bookstore with data saved in a textbox. Here is what I need to do: Write a menu-driven multiform inventory program for a bookstore with data saved in a text file. Help …

Member Avatar for ChrisPadgham
0
159
Member Avatar for dstoltz

If I use WRITE to a text file, it uses quotes " surrounding the lines... If I use PRINT, it does not include quotes - which is what I want... BUT - if the line has a comma in it, like "FIELD1 FIELD2, FIELD 3" then PRINT wraps to a …

Member Avatar for dstoltz
0
62

The End.