No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
- PC Specs
- 2
|
hello every one i wont to select the data place in textbox in the form but the code does not work Sub backup() con.Open() Dim cmd As New SqlCommand("BACKUP DATABASE ['" & TextBox1.Text & "'] TO DISK = N'D:\5-2016\Backup.bak' WITH COPY_ONLY", con) cmd.ExecuteNonQuery() con.Close()
|
|
|
I was very tired of searching, but I did not find anything i have a from and its minted textbox and CheckedListBox the CheckedListBox have five choices and i want to insert the Items(more than 1) Checked from the CheckedListBox and the textbox into a table in the database like … 
|
|
|
this is the code of the from which i trying to open form the login form it is say invalid attempt to call read when reader is closed Imports System.Data.SqlClient Public Class Form40 Private Sub Form40_Load(sender As Object, e As EventArgs) Handles MyBase.Load Label1.Text = users Dim user_Name As String …
|
|
|
hello every one this my code to fill my combobox with the name of clients and i but the connection string in a module to let my prog workimg in any pc in the group But the problem here in the combobox says can not make the connection, I know … 
|
|
|
hello every one i made a Simple sales program by vb with tables sql I have worked and use the following to connect with data con.ConnectionString = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\hany_\Documents\Visual Studio 2015\Projects\hanysql\hanysql\Database5.mdf;Integrated Security=True" Now, after the completion of the program I want to know what is the way to run …
|
|
|
cmd = New SqlCommand("INSERT INTO temp_balance ( debit, credit, accname ) SELECT Sum(temp_sheet.debit) AS debit, Sum(temp_sheet.credit) AS credit, IIf (debit < credit ,'loss','profit') AS expr1 FROM temp_sheet group by temp_sheet.debit,temp_sheet.credit ;", con) there an error i dont know the error incorrect syntax near ' )
|
|
|
hello this code for add the auto number form the access table to the form vb but But it only works when the table contains data but when the table is empty does not work and the bill number appears a blank Sub New() InitializeComponent() Try Dim BillNo As New …
|
|
|
hi i have report in visaul basic 2015 in it the salary and i want to make a tetxbox and but the total in it i tried this Sum(Fields!salary.Value) but i get error 
|
|
|
good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not
|
|
|
I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get …
|
|
|
