1,597 Topics

Member Avatar for
Member Avatar for johnnyboy123

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 …

Member Avatar for Reverend Jim
0
470
Member Avatar for deyb.dizon

.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 …

Member Avatar for deyb.dizon
0
255
Member Avatar for Gabriel_4

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. …

Member Avatar for cgeier
0
124
Member Avatar for amit7471

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

Member Avatar for Ezekiel_1
0
389
Member Avatar for vishal anand.s

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 …

Member Avatar for abelingaw
0
328
Member Avatar for azapovjednik

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

0
107
Member Avatar for noselbond

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 …

Member Avatar for noselbond
0
716
Member Avatar for Patrick_3

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 …

0
173
Member Avatar for XEN0

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.

Member Avatar for XEN0
0
290
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
357
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
211
Member Avatar for neha05
Member Avatar for YumnaZia

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;

Member Avatar for JamesCherrill
0
332
Member Avatar for pathum_1

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 …

Member Avatar for Ketsuekiame
0
188
Member Avatar for azapovjednik

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 …

Member Avatar for Shahbaz_2
0
351
Member Avatar for micca.jhai

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

Member Avatar for Ferdielux
0
200
Member Avatar for thannu07

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 …

Member Avatar for Reverend Jim
0
187
Member Avatar for Erika_2

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 …

Member Avatar for Deep Modi
2
431
Member Avatar for babbu

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

Member Avatar for Ketsuekiame
0
228
Member Avatar for Lee_2

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 …

Member Avatar for L7Sqr
0
304
Member Avatar for kipslem

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 …

Member Avatar for Reverend Jim
0
3K
Member Avatar for micca.jhai

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") …

Member Avatar for BitBlt
0
393
Member Avatar for racigan

**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 …

0
194
Member Avatar for lyndata

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. …

Member Avatar for ryanjayson
0
320
Member Avatar for spowel4

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?

Member Avatar for shdwmage
0
1K
Member Avatar for Yousha

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" …

Member Avatar for ryan.ally2
0
405
Member Avatar for Mr.M

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 …

Member Avatar for Mr.M
0
788
Member Avatar for narasimha9

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 …

Member Avatar for narasimha9
0
167
Member Avatar for CoolAtt

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 …

Member Avatar for CoolAtt
0
348
Member Avatar for Gobumanikandan

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.

Member Avatar for JamesCherrill
0
283
Member Avatar for edogg23
Member Avatar for edogg23
0
156
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
226
Member Avatar for mutago

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 …

Member Avatar for LastMitch
0
299
Member Avatar for Yousha

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 …

Member Avatar for BMXDad
0
377
Member Avatar for tomexlfc

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 …

Member Avatar for waseem.akhtar.3572
0
16K
Member Avatar for gmmorpheus

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 …

Member Avatar for ReyJEnriquez
0
179
Member Avatar for ange1991

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 …

Member Avatar for JOSheaIV
0
212
Member Avatar for vishal anand.s

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" …

Member Avatar for rishif2
0
1K
Member Avatar for Lisa_4

**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!!!!**

Member Avatar for CimmerianX
0
175
Member Avatar for gmmorpheus

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.,., …

Member Avatar for Begginnerdev
0
260
Member Avatar for mikkelseg

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

Member Avatar for JorgeM
0
159
Member Avatar for gmmorpheus

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 …

0
190
Member Avatar for gmmorpheus

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 …

Member Avatar for Myronz
0
284
Member Avatar for Anuanusha

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 …

Member Avatar for Reverend Jim
0
185
Member Avatar for fuhanspujisaputra

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 …

Member Avatar for ss125
0
171
Member Avatar for gmmorpheus

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 …

Member Avatar for Kishan Tilak
0
645
Member Avatar for GilbertB

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 …

Member Avatar for almostbob
0
86
Member Avatar for bejfake

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...

Member Avatar for [Prototype]
0
339
Member Avatar for fuhanspujisaputra

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 …

Member Avatar for fuhanspujisaputra
0
215
Member Avatar for DGULLIVER

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 …

Member Avatar for BitBlt
0
267

The End.