Posts
 
Reputation
Joined
Last Seen
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
1 Commented Post
0 Endorsements
Ranked #4K
~15.8K People Reached
Interests
vb programming
PC Specs
windows 7
Favorite Forums
Favorite Tags
Member Avatar for mavtcr

I have developed a software in VB6. I want to give a menu option for back up. ie. to copy the database files to a pendrive I have given the below code Dim sourcefile,Destinationfile as string sourcefile = App.Path & "\HHA.mdb" Destinationfile = Textdrive.text & "\HHA.mdb" Filecopy sourcefile,Destinationfile When worked …

Member Avatar for rproffitt
0
29
Member Avatar for mavtcr

I developed a programme in VB for recording my income and expenditure on a daily basis.I started recording from 5th , September ,2019. On 31 March , 2020 I want to know how many months I have recorded the transactions.Here it is September,October,November,December,January,February,and March=7. How can I get this answer …

Member Avatar for rproffitt
0
31
Member Avatar for mavtcr
Member Avatar for mavtcr

Friends, I met with a small problem please help me I developed a small programme. When I exit from it I want to make a backup in another drive I coded like this FileCopy "I:\My Documents\New Folder\Pebble.mdb", "D:\Pebble\Pebble.mdb" Here the "Pebble.mdb" is my database in Drive "I". I want to …

Member Avatar for mavtcr
0
240
Member Avatar for mavtcr

Friends, I made a small calculator in a form.It works well. On the form there is an Exit Button to close the form. Now I want this task.If I keep the calculator on the form (Computer) idle for 60 seconds the form must be closed automatically / If I goes …

Member Avatar for mavtcr
0
253
Member Avatar for mavtcr

Friends , Is there any way for data alignment in the list box. My code is given below Private Sub TxtFdt_KeyPress(KeyAscii As Integer) Dim L, L1, L2, L3, L4, L5 As Integer Select Case KeyAscii Case vbKeyReturn If TRS.State = adStateOpen Then TRS.Close TRS.Open "SELECT * FROM Tran WHERE Ac …

Member Avatar for Aslam Mansoor
0
1K
Member Avatar for mavtcr

Friends I have a problem in totalling the variable .When I use my code I am not getting the answer as I expected. My code is as below Jsharbal = Format$(TRS("Sharbal"), "#,##0.00") Jworkbal = Format$(TRS("workbal"), "#,##0.00") Jsalabal = Format$(TRS("Salabal"), "#,##0.00") Jprofit = Format$(TRS("Prflbal"), "#,##0.00") CRTOTAL = (Val(Jsharbal.Caption) + Val(Jworkbal.Caption) + …

Member Avatar for mavtcr
0
246
Member Avatar for mavtcr

Friends , I have a database in sql server named "Deposit" with a table "Receipts" .I want to display the data in a list box.My code is given below Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim cnn As New SqlConnection("Data Source …

Member Avatar for cgeier
0
181
Member Avatar for mavtcr

I want to save data in to my ACCESS database from textboxes. My code is here. Private Sub BtnSubmit_Click(sender As Object, e As EventArgs) Handles BtnSubmit.Click Dim cb As New OleDb.OleDbCommandBuilder(DA) Dim dsNewRow As DataRow DA = New OleDb.OleDbDataAdapter(SQL, CN) DA.Fill(DS, "Deposit") dsNewRow = DS.Tables("Deposit").NewRow() dsNewRow.Item("Bank") = TxtBank.Text dsNewRow.Item("Acno") = …

Member Avatar for oussama_1
0
350
Member Avatar for mavtcr

Friends please help me... I have Three text boxes 1.Bank 2.Acno 3.Name I am selecting record from database where Bank and Acno are =(txtbank.text and txtacno.text) If any record found, the focus should go to the third textbox-'Name' else message "Record not found" should be displayed.I tried the following code …

Member Avatar for mavtcr
0
385
Member Avatar for mavtcr

Friends, In VB.net Form properties, There are Maximize Box and Minimize Box.If we make them false, those prperties will be disabled.Likewise there is a Close Box at the right top corner of the form.How can we disable this? Is there any way at design time to disable this? If not,Can …

Member Avatar for mavtcr
0
2K
Member Avatar for mavtcr

I have gone through the articles appeared in this forum on the above Area.But it didn't helped me much,As I am new to VB.net. In VB6 I have the following code and it works well. Private Sub CmbBank_GotFocus() CmbBank.BackColor = vbYellow LblMsg = "Select Bank" Dim A, B, C As …

Member Avatar for mavtcr
0
4K
Member Avatar for mavtcr

I am studying vb.net through the help received through this forum. While I was making a small programme Out of curiosity/error I created a module.later I thought it is not necesssary.So I wanted to remove it.I searched in the project Tab But I could not see the Delete command.So I …

Member Avatar for mavtcr
0
270
Member Avatar for mavtcr

Friends again problem with date function In my form there is a text field -txtDod- of Date type formated like "dd-MMM-yyyy" My input is also formated like "dd-MMM-yyyy" Now see my code Private Sub TxtDod_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case vbKeyReturn If Not IsDate(TxtDod) Then LblMsg = "Enter Date …

Member Avatar for Minimalist
0
273
Member Avatar for mavtcr

I was working with VB6. Now I am trying to study VB.NET. In vb6 There is Cancel property for command button eg. If we make the cancel property of exit command button 'True',then if we press Esc key ,we can exit from that form even without clicking the exit button. …

Member Avatar for Start4me
0
262
Member Avatar for mavtcr

Friends I am new to VB.Net Please help me I have two text boxes. When I press the 'Enter' key in the first text box the focus should go to the second textbox What will be the code?

Member Avatar for G_Waddell
0
747
Member Avatar for mavtcr

Earlier I raised a question in this forum regarding the sorting of database and Reverend Jim answered me as follows. It was Ok SELECT * FROM mytable ORDER BY fieldname But then I faced another problem As I mentioned in that I wanted to sort ORDER by 'Tdate' which is …

Member Avatar for pritaeas
0
282
Member Avatar for mavtcr

Friends I met with a problem...Please help I have a table 'Tran' in Access Database which has several fields of which one is 'Date' I added several records through programm on different dates.Everything OK. All the records appeared in a chronological way ie.Earlier to Later order . Later I deleted …

Member Avatar for mavtcr
0
339
Member Avatar for mavtcr

Friends...A small problem I have a combobox in which I want to add list from a field from a ACCESS databas Table.It works well My code is here ACRS.Open "SELECT * FROM Salary1", CN, adOpenStatic, adLockOptimistic Sfm = ACRS!Month Do Until ACRS.EOF CmbSfm.AddItem ACRS!Month ACRS.MoveNext Loop My problem is , …

Member Avatar for Minimalist
0
203
Member Avatar for mavtcr

Hello friends..please help me I have two identical Tables in my Database (Access) Table 1.Salup , Table 2.Salup1 . All the fields are identical My problem is:- I want to copy/append 1. All the records 2. selected Records agreeing certain criteria(eg."Sex=Male") From Table 1 to Table 2. through VB6 code.I …

Member Avatar for mavtcr
0
199
Member Avatar for mavtcr

Hello Dear All, I have a small problem ,though seems very simple,being a newb It is difficult for me. Please Help me I have a message box VbYesNoCancel My code is here If ACRS.RecordCount>0 Then MsgBox"SALARY ALREADY CALCULATED DO YOU WANT TO RECALCULATE ?",vbYesNoCancel,"Pebble" Else CmbNdm.SetFocus End If My problem …

Member Avatar for Stuugie
0
318
Member Avatar for mavtcr

Dear friends pl help me I want to select data from a data base table Tran with two selection criteria one is number and the other one is text When i use one criteria it works well But i am failed to use the two criteria my code is here …

Member Avatar for mavtcr
0
208
Member Avatar for guente

Please i have a problem i cant resolve. I was able to populate my combobox (Cus_ID) from TLB_Customer table sucessfully. Now, how ca i use the same populated combobox to populate a textbox (Cus_Name) all in the same TLB_Customer table. My Code Imports System.Data.OleDb Public Class frmTransaction Dim con As …

Member Avatar for ryanjayson
0
207
Member Avatar for mavtcr

Friends please help me in FORMATTING DATE I have a Form with three text boxes 1.txtNo- Data type-Number 2.txtName-Data type-Text 3.txtDob-Data type -Date format dd/MM/yyyy two buttons one for adding and the other for viewing Using visual data manager I have created a database-Members with table-List having the following Fields …

Member Avatar for mavtcr
0
291
Member Avatar for Saboor880
Member Avatar for mavtcr

Friends Please any body explain the difference between VISUAL BASIC and VB.net What are the advantages over the other Which is better?

Member Avatar for Deep Modi
0
269
Member Avatar for mavtcr

Friends, Please help me I have a form having 3 text boxes of data type number one text box for display- also number type one command button I want to add the figures of the three text boxes my code is as below Private Sub Command1_Click() Dim Total As Long …

Member Avatar for rishif2
0
208
Member Avatar for mavtcr
Member Avatar for G_Waddell
0
957
Member Avatar for mavtcr

Friends, I have a Database in Access, Table Name- Master . Structure is given below Mno=Membership no in digits Name=Member's Name Fno=Family number in digits Fname=name of the family Faddress=Address of family Fphone=Telephone of Family The database contains several records where some members come under the same family.In other words,Suppose …

Member Avatar for mavtcr
0
238
Member Avatar for mavtcr

Friends , I am new to VB.NET I know something about VisualBasics 6 Ther we have a DataManager to create new database and tables. In VB.NET Is ther any facility to create new database and tables,If so how to use it?If there is no such facility how can we make …

Member Avatar for Reverend Jim
0
253