5,053 Topics
 | |
| | 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 … |
 | I am in the final stages of testing a text-based game I have been working on for several years but I am running into some major problems with my database access code and some very strange problems at that. What I am attempting to do is loop through a SQLite3 … |
 | 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 … |
 | So I put the database into the dubug folder in bin of my project, and in the data source configuration wizard i selected ms access and my file, then i copied my connection string, it was "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\bin\Debug\bookshop.mdb" and wrote some code for it to connect to it, to be … |
 | 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 …  |
| | @ by : O This is topic (http://www.codeproject.com/Articles/21351/Import-Data-to-SQL-Server-from-Excel-or-Access-usi) is reactivated again which was posted by : Oxiegen for further information: The code is corrected but the data is not getting exported from Access database to SQL. The code is as follows : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e …  |
| | Hi I am doing a project where i need to edit values in textboxes from database using jsp, here is my code, Please can anyone help me to solve this: retrieve.jsp [code] <%@ page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%> <HTML> <HEAD> <TITLE>Fetching Data From a Database</TITLE> </HEAD> <BODY> <H1>Fetching Data From …  |
 | 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 …  |
| | Live2Support is pleased to announce its integration with Microsoft Dynamics CRM providing customer service and business a multi channel platform to engage the website visitor proactively. **Features:** * Ability to store chat transcript * Callback requests can be sent to the Microsoft Dynamics CRM * Drive online sales * Enhances … |
| | Hi, I have a problem with changing the password from Microsoft Access Database. I get an Error "[B]No data exists for the row/column[/B]". The password in the database is encrypted and when I change the password it should be decrypting the password and new password should be updated with encryption … |
| | 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 |
| | My task bar in XP changed color to a pale green and the font size changed (I am paritally color blind, so color is a guess to a degree) from the normal blue. When that happens, the wireless internet won't work either. I have run all the programs that you … |
| | 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 … |
| | hi guys, I got another issue doin my project. Im using Microsoft access as Database. When i need to UPDATE it work and the msgbox displayed: "thank you", but when i looked into the database nothing happened. Anyone can help me to determine the problem? please Thanks in advance. con.Open() …  |
| | 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") …  |
| | 1)On receipt of the signed MSA back from the customer, the original should be sent to the legal representative and a controlled copy should be sent to the TM/Account Manager by ___________. B D M DM 2)Runtime Profiling is used by which category of users? Developers and System Administrators Configuration …  |
| | Hi I am new to using Microsoft Access as a database for Visual Studio (previously I used SQL Server) so I am unsure how to go about the usual tasks such as accessing the database. At the minute I am trying to write code to check if a username already …  |
| | **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 … |
| | This is a theoretical question but any specific technical knowledge that could help will also be appreciated. I am an IT Assistant with not much knowledge in programming (apart from EasyPattern and super-simple batch files) but have been given an opportunity to start getting into it by having been given … |
| | 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? |
| | Hi Guys, I am using access (.mdb) database in my windows application. When i am inserting values to db it gives me an error "syntax error in insert into statement" but it will work in SQL and access query analyzer. here is my code [CODE] string StrInsertToServer1 = "insert into … |
| | 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 … |
| | I want to sum the values of the 'countryamt' column and echo it out. The inputs are coming from the 'matconfirmation.php'. I stored all the inputs in an array, but i dont know how to sum the values up. The bold part of the code was what i tried doing, … |
| | 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. |
| | Hopefully I shouldn't need to explain what `gets` is or why it's easily one of the worst possible standard functions you could call in your code. In my personal opinion, the title for "holy shit, never use this function" is a tie between `gets` and `system`. I'll discuss the problem …  |
| | When I click on Button which fetch records from the database it works fine public void fetchrecords() throws SQLException { Statement stmt = null; String query = "select * from Employer where Fileno=1"; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(query); while (rs.next()) { firstNameTextField.setText(rs.getString(2)); lastNameTextField.setText(rs.getString(3)); addressTextField.setText(rs.getString(4)); //and more records. … |
| | 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 … |
 | my problem is i want to save a date from label in vb to field in ms access but i do not know that problem with my coding, the error appear is run-time error 91 object variable or with block variable not set, can anyone check my coding? Dim Con … |
 | ## Hey Guys ## , I've recently stopped doing some of the projects which I wanted to do and took a look at SQL and came across Microsoft SQL and i was pretty pleased with wha tit can do so i downloaded the program and watched some basic MSSQL tutorials …  |
 | Dear All, I have written some logic using MVVM pattern and tried to show a sub-datagrid in each row of a datagrid however there are some issues that I am currently facing and they are as follows (screenshot attached) :- 1. In each row I have an expander in which … |
| | I am currently trying to make a simple file uploader using http://msdn.microsoft.com/en-us/library/w3kksch7.aspx and its pretty straight forward except I keep getting the error Access To the path 'E:\Temporary' is denied I tried running visual studio 2012 as admin I already change the directory (It was at C: earlier) Help and … |
 | Well, I do not find solution, if any help me would be great, here the code and where the error log is visual c + + 2012 // ver1.1.cpp: define el punto de entrada de la aplicación de consola. // #include "stdafx.h" /* examples/standalone_example_docs1.cpp */ /* Standard C++ includes */ …  |
| | Im using Microsoft Visual Studio 2012 and Microsoft Access What code/sql will I add to check whether User is an admin or a regular user? so it can load to a Admin form or Regular user form. My professor told me to use a FieldName "LoginType" in my database.. but …  |
| | 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 …  |
 | ublic Class Login Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click If Password.Text = "" Or Username.Text = "" Then MessageBox.Show("Password v likh..", "Banday da puttar ban.. :D ", MessageBoxButtons.OK, MessageBoxIcon.Error) Else Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\CCIMS.mdb; Persist Security Info= False" Dim cmd As …  |
| | 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" … |
The End.