1,597 Topics
![]() | |
Hi everyone, I am quite new to vb.net. Recently, I've been learning about Oledb commands and it's ability to save records in a form to a database. So, I started a project and now I am stuck. Here's the scenario: The form comprises of several comboboxes, a listview box and … | |
.i'm dave and i'm working with some receiving and m0nitoring system like.,i develop a system but it is a individual machine or a stand alone system,which means it w0rks only on a single pc,.my problem is i want to convert it to be a client server system which i can … | |
Hi, I have some deals with this. I can't make this run. It says that "Microsoft.ACE.OLEDB 12.0 is not registered on the local machine". I tried with diferent providers, but still not running. I tried installing the Access Database Engine Driver, and the application seems that don't want to run. … | |
i enterd static ip in modem and connect my 3 computers to that modem with automatically confic of system ip so now i want to access my one computer through any where via internet please let know how i do this | |
hi my name is vishal for past 10 days i have been going nuts on how to combine selected datas from 3 or more tables into single sql select query in vb6. i have 4 tables named table1 name: Inward column Name DataType mfr_ref_number text no_of_bundle integer supplier_id integer DC_date … | |
Hello, can anyone provide me with some sample code? VBA access. I need an insert into statement where form.control.value = some_column and another.form.control.combobox.value = some_column can anyone help? thanks | |
I have an old access 2.0 database, i converted it in access 2007 but the old code doesn't work.. i heard that it is about DAO and ADO anyone can help me to convert this DAO code to ADO coding.. thank you so much in advance.. Private Sub cmdSave_Click() Dim … | |
Hello, I am attempting to make a section in my application where a user can enter their own code which will be executed at runtime. I have looked up how to compile and run Visual Basic code while the program is running (Below). Dim VBP As New VBCodeProvider Dim CVB … | |
windows 7 home premimum x64 access denied for saving files to app_data folder and any other folder in the projects root directory. Code below is what im using to save and getting... doc.Save(Server.MapPath("~/App_Data/Logs")) I get a couple access to path denied msgboxes. Set a few permissions and no go. | |
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 … | |
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 … | |
How to access ftp via wordpress? | |
I have tried every possible way of connecting the database to the program, but its just not happening! Help me please :( final static String fileName ="Netlync.mdb"; static{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+fileName; con = DriverManager.getConnection(url,"",""); }catch(Exception exx){ exx.printStackTrace(); }} private static Connection con; | |
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace WindowsFormsApplication1 { public partial class Form2 : Form { OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='login.accdb'"); public Form2() { InitializeComponent(); } private void label3_Click(object sender, EventArgs e) { } private void button2_Click(object … | |
hello all, I want to make some simple database in access that would track student information, semesters etc... I have created basic tables like: students, professors, subjects.. now I am stuck with the most important part: semesters and subjects... here is the link [Click Here](http://prntscr.com/2jafl6)where you can see database relationship … | |
greetings everyone!. I'm making Clinic system for my project. I just want to ask how to get the total quantity of the medicine and display it on textbox. I'm using using vb6 and adodc. Any help will be greatly appreciated.Thank you... Table name inventory fields: Medicinename StockQuantity | |
hy i m trying to do a smal vb.net project using sql server 2008 in vs2012,and i dont know how to use those database in my project for eg : using select/insert/update/delete queriesfor my controls(textbox,combobox datagrids etc..) please help me with detail how to connect database and use it in … | |
PLEASE HELP - I have forgotten my Windows 8 Password for my new HP Laptop. I can not find a way to bypass. I changed my Microsoft Account password and tried using a new one, yet I continue to receive an error indicating - I do not have access,try again … | |
I have created an application in c#. Following are my concerns. 1) create setup file which includes the ms access db 2) identify the location where this db will be stored 3) use this location as the data source for the application | |
Hi basically I am creating a zombie survival game using Irrlicht. I have a base class Survival.cpp with my game loop in a method called `Survival::Run()` I am trying to call a `Shoot()` method from within the game loop from another class within Bullet.cpp I have included the `Shoot()` method … | |
Hello, My sincere apology, I have been posting almost 4 questions now where I have received 2 answers being solved. These are simple questions which any one familar with VB.Net can solve easily. Please understand, I'm a newbie to VB.Net. Now my next issue is; I have a a form … | |
Can someone help me I'm having some problem with this. I am supposed to make a sytem that will alert if the medicine was expired. here is my code. Private Sub DataGrid1_Click() On Error Resume Next Command2.Enabled = True With frmmed1 .Combo1 = Adodc1.Recordset.Fields("MedicineName") .Text3.Text = Adodc1.Recordset.Fields("StockQuantity") .Combo2 = Adodc1.Recordset.Fields("Expmonth") … | |
**this is my main file:** ExcelAppl = win32com.client.Dispatch('Excel.Application') Workbook = ExcelAppl.Workbooks.Open('excel file path') Sheet = Workbook.Worksheets.Item(1) Sheet1 = Workbook.Worksheets.Item(2) **this is the Python gui:** from Tkinter import * from tkMessageBox import * from tkColorChooser import askcolor import tkFileDialog import MainLibrary root = Tk() root.title("Chrysler Test Framework") root.geometry("800x500") def callback(): file_path … | |
i am using employee table to test if i am doing the whole program correct. I have 5 buttons. one is to add records and another to save(commit), to update, to delete and to clear. I am having trouble with the code to save the record to the data set. … | |
I need to disable cd-rom and usb drive access for certain users, via a batch file or something similar so that it can be scripted/automated. Any suggestions on how to do this? | |
Plz Help me I'm creating a form-View in asp.net 2010 and successfully upload all my data on the Form View but my problem arise when i edit the data in the form, it does not update the data. Following is my code. <%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" … | |
Hi Dw I'm working with permissions in my program I want it to protect the chosen file by permissions and now what I want is how can I make these permissions unchanged by a user? Or if not possible because I don't want even the administrator to change these permission … | |
Hi Everyone, I want to access the values from remote server. If I click search and advanced search I should retreive values from remote server. I have catergories like watches,perfumes,etc. Now based on the search I need to display the brands of x company y company for watches perfumes and … | |
Hi All, I need help with iptables to allow a specific IP to access a destination (FaceBook) The following rule blocks facebook access to everyone in the company(this rule works successfully): iptables -A FORWARD -p all -d $ip -j REJECT (The ip address is read from a text file.) Now … | |
Hi I have a three folders i have compressed all the folders using jar. I want to access one of the java file inside jar file that is actually inside one of the folders to start the application. | |
Hello. I have an old access data project. I need to convert it to sql and .net. How can I do that? | |
As the title says I'm having trouble in my Vehicle Maintenance routine where I will have a a monthly maintenance based on the last maintenance date. If the vehicle has reach 1 month since last maintenance it will show in a datagrid. Also it should select those vehicle that reach … | |
I need to prevent direct access of all the php files but allow only files pass.php how can i do that <Files ~ "\.php$"> Order allow,deny Deny from all Allow from 127.0.0.1 </Files> the code only allow access to localhost. now what if i want to allow access only to … ![]() | |
Im creating an application where some data should be populated in a gridview and then user should be able to update it and then same should be replicate to the database. So i have put a gridview and configure it to connect to my database which is base on access … | |
Hi all, I have already written a code to search for staff records from my staff database and it's working fine, but the problem is, if someone enters a wrong a wrong staff id or just any number or alphabets, it still displays the "Found Record" message, instead of "No … | |
studentrecords table.,.,contains IDNumber,LastName,Course,Firstname i will login through my system using IDNumber and once i go to the mainform iwant to display LASTname and course to the 2 textboxes in the mainform using the IDNumber as their Primary Key.,.My code errors Dim con As New OleDbConnection Dim cmd As New OleDbCommand … | |
HERE I WANTED TO FILL MY BLANK RECORD WITH ITS VALID DATA private void button5_Click(object sender, EventArgs e)//modify { comm.Connection = conn; comm.CommandText = " UPDATE Table1 SET total='" + textBox6.Text + "',result='" + label7.Text + "' WHERE Fname ='" + textBox1.Text + "'"; conn.Open(); comm.ExecuteNonQuery(); conn.Close(); dataGridView1.Update(); } I … | |
hi my name is vishal. i have been trying long to figure out to export data from vb6 using join queries in sql to ms word. here is my sample code i have tried: Option Explicit Dim dIsVisible As Boolean Dim inst As String Private Declare Function ShellExecute Lib "shell32.dll" … | |
**Please help me...I have a Dell InspironE1505...I have no problem getting internet access at home, but I am traveling for work and trying to use a Verizon MIFI card and keep getting LOCAL INTERNET ONLY...I have tried disabling, rebooting, taking off the IPV/6 in properties, still LOCAL ONLY!!!!** | |
good pm.,.,i have a next button Try lblcat.Text = ds.Tables("evaluation").Rows(cat)("QuestionCategory") txt1.Text = ds.Tables("evaluation").Rows(CurrentRow)("Question") txt2.Text = ds.Tables("evaluation").Rows(CurrentRow + 1)("Question") txt3.Text = ds.Tables("evaluation").Rows(CurrentRow + 2)("Question") txt4.Text = ds.Tables("evaluation").Rows(CurrentRow + 3)("Question") txt5.Text = ds.Tables("evaluation").Rows(CurrentRow + 4)("Question") Catch ex As Exception End Try every click to the next button my category and questions change.,., … | |
i have a a cooperative society website.i need to process the loan members ask for.how will i create a admin page where admin staff process and grants loans to members | |
Private Sub Load_Faculty() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim dr As OleDbDataReader Dim arrImage() As Byte Dim myMS As New IO.MemoryStream Dim sSQL As String = String.Empty Try sSQL = "SELECT b.FacultyFirstName, b.Image, b.Course, a.Course" sSQL = sSQL & " FROM studentsrecords as a left … | |
Private Sub Save_Record() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Dim arrImage() As Byte Dim myMs As New IO.MemoryStream Dim bSaveImage As Boolean = False Dim strImg As String = String.Empty If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else … | |
I have just a user form in access 2007 with a text box and a Save command. MY code: Private Sub Save_Click() If School.Value = "" Then MsgBox ("Text Box is empty") else Msgbox(" Not Empty") End If End Sub When the Save is clicked, and the text box is … | |
i have been doing like the code below, but why when i clicking the "delete" button, it is delete all records in the datagridview, but it does not updating to the database. And, how do i make only the selected row that has been selected by the user that gonna … | |
Private Sub Save_Record() Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Dim arrImage() As Byte Dim myMs As New IO.MemoryStream Dim bSaveImage As Boolean = False Dim strImg As String = String.Empty Try If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else arrImage = Nothing End … | |
Hi all , I am trying to build a function in Access Query database which gives results of a 1 month expire invoices from the current month.Therefore when I run the query, the results will be all the invoices which will expire next month. I have tried the Data Add … | |
Hi, I'm creating remote desktop application in qt 4.8. I have to implement some way to browse remote computer directory structure and possibility to download files on local machine. I'm wondering how can achieve this... | |
i have a problem here. Here is my case: I want to update the Quantity value from program based on the value given from program and minus it to the database. For example: i have 100 in Quantity in the database, once i run the program and update the Quantity … | |
Hi Everyone, Been a few years since I had to post anything here so I'm glad to be back. I've been asked to do a report to show vouchers that have been issued and presented for July (this year and last year). I have done this SQL: SELECT tblOutlet.OL_NAME, Format([VI_TRANSACTION_DATE_TIME],"mmmm … |
The End.