3,459 Topics
Hi guys well what I want to do is that when a button is pressed it increases the value in one of my database cells. So my question is how do I do this? As I cannot get this to work. My code so far: Any help would be appreciated …
I want to create an Android application where a user can create an account which basically stores their username and password, and photos. I want to use a Microsoft Access Database, a user once logged in can take a photo using the android device and the photo is automatically sent …
hi friends, i m very newbie to vb.net. i'm using opendialog control to select the database file. this works for me. [COde] Private Sub btnbrowse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnbrowse.Click opendatabase.ShowDialog() txtfilename.Text = opendatabase.FileName End Sub[/COde] Then i need to connect with the actual code. i'm …
Hi, I'm using an MS Access database which has password (database password, not a workgroup or smth). I'm using 13 characters - with no special signs- only letters. When I try to open the DB from access it works fine, but when I try to run my Windows Form application …
Hi guys well what I'm trying to do is produce a query that only produces the results which will match my director input. I have looked for the correct syntax and cannot seem to find it. Any help would be appreciated Code of my syntax below: [CODE] ResultSet results = …
i have created program below ,but it does not run successfully why [CODE]import java.sql.*; public class Bank { public static void main(String[] args) throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // TODO code application logic here try{ Connection cn=DriverManager.getConnection("jdbc:odbc:rushiDSN"); System.out.println("Connected Successfully"); Statement stmt=cn.createStatement(); stmt.executeUpdate("CREATE TABLE Author(AuID Number(3), AuName Char(15), AuAddr Char(30))"); System.out.println("Table created …
Haven't been around here in a long time but have returned to hear your thoughts and suggestions regarding my problem. I had been dev'ing projects in VB6 until around 2006 when I stopped all my development. Mainly it was a change in responsibilities but it was also because I had …
Hello! Is there a way to hide the password of your database inside the source code? [CODE=vb.net]"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Database.accdb; Jet OLEDB:Database Password = [B]MyPassword[/B]"[/CODE] As you can see the password is exposed, increasing the risk for the database to be compromise. Is there anything you can suggest …
Hi guys I am able to drop my tables that I want but however when I come to trying to drop rows the rows do not delete. I have tried the following which have all produced the same error duplicate key TABLENAME : Any help you can give for a …
Hello Friends, I need an urgent help on the below topic.... I have created a project which takes the database dyanamically.... Means when the application starts it will ask for the database path....the database will already be created in some or the other folder.... The path for database is stored …
Hello, I am a beginner trying to make a networked game called Guess Who. I have 2 combo boxes I am trying to read a access database. Whatever is selected in the 1st combo box will be the column to 'lookup' the values in the database. These values should go …
Hi guys I have successfully set up my database which through my GUI I am able to create my tables that i wish and insert data into the table. My problem is through that I can only insert one row of data into a table so what would I need …
Hi there well title says it all really. Is it possible instead of creating tables within my database to create the tables within a form in java? . If it is possible how would I go about doing this?. Before you ask yes my database is fully connected to my …
i wanted to know how to deploy a simple program that is coonected to a access database.I have tried it many times but when I try to install it says that some file is mising. How can I do it so that I dont have to copy the database from …
Hi i have the following code. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection Dim da As New OleDbDataAdapter Dim ds As New DataSet Dim dsnewrow As DataRow Dim cb As New OleDbCommandBuilder(da) Dim a As String con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB.mdb;Jet …
Hi Guys, Can you have any idea about randomly shuffle the questions in database without affecting questions id. Let i will explain little bit more ...... read carefully 1) I have a table containing 5 questions like this que_id que 1 abc 2 bcd 3 efg 4 hij 5 klm …
Hi and Greetings, I am new to these forums, so if I submitted this to the wrong forum, my apologies. Before I get to my question, a little backstory. I was running an application on my laptop that was using Microsoft Vista, with Microsoft Office 32 bit and JRE 1.5. …
hello im working with vb 2010 and ms access as data base, just newbie.im trying to save the loged out date and time to my access table by selecting from tblloghist wherein my column SystemUserID is equal to my textbox SysID(located at my form) then it will save the timelogedout …
Hello i am developing a web app in JSP as front end and ms-access as back end..i hv login.jsp which contains username & password which will be validated in access database upon success user.jsp will be shown..i hv been done with jsp page design..but don't know abt database connectivity..can any1 …
Good Morning Lladies and Gentlemen: . I need some help in my app... I am using Access 2007 (from MS Office 2007 Pro). I have an attachment field in my customer table that holds multiple attachments. I need to preserve this data so transferring to from a spreadsheet DOES NOT …
how to JOIN three tables in MS ACCESS 2007. the tables are: *student (Primary key: StudentNumber) *event (Primary key: Event_num) *Transaction (Primary key: Transaction_num) the MS ACCESS gives me this code, but nothing appears in the Datasheet view. [CODE] SELECT Student.StudentNumber, Student.Lastname, Student.Firstname, Student.Initial, Event.Event, Event.EventDate, Event.EventFee, Transaction.Status FROM Student …
Dear All. I have developed College management system ,and using VB6 tools as front and MS Access as database ,I want to generate autoID of students according to their technologies,for example for Electrical....... 01ELE,For Computer ....... 02Comp ,for Civil.... 03CL etc or Pls Give me suggestion t o create new …
Friends i want to submit project in my college on employee management system.... front end should be c# and back end sql server 2008... i got one project on net but its backend is microsoft access I want to change this to sql server 2008.... what changes i have to …
guys hello i have database with table name tblAgent with a column agent_id and a vb6.0 form add-agent i want to generate id everytime i open form and everytime i added new data it refreshes the ado recordsource and fetch the max(agent_id) and +1 to increment the agent_id now i …
i need help in adding image in my current payroll project i need a more simple way or easier to understand codes in adding image in my database tnx in advance
I got the following error in my code today: Syntax error in INSERT INTO statement. [code=c]OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText="Insert into Cursanti([ID],[Nume],[Prenume],[Sex],[Varsta],[Ziua-1],[Ziua-2],[Ora-1],[Ora2],[E-mail],[Telefon],[Referal],[Partic/Grup],[Adult/Copil)] Values ('"+id_b.Text+"','"+name_t.Text+"','"+surname_t.Text+"','"+sex+"',"+age_t.Text+"','"+ziua1.Text+"','"+ziua2.Text+"','"+ora1.Text+"','"+ora2.Text+"','"+email_b.Text+"','"+phone_b.Text+"','"+from_t.Text+"','"+ore+"','"+categorie+"')"; cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close();[/code] The error points at "cmd.ExecuteNonQuery();" Searched the other topics, saw that people had similar problems, but …
I have made a database file in MS Access 2007, Now I made a basic blank form in VB2008. I have connected it already in the form. Now the problem is, how would I know if I have connected it successfully? I run the program > added a new entry …
Hi, I have a 2 text boxes tbox1 and tbox2 now i want to populate tbox2 when a value is entered in tbox1...how this can be done? note: Supplier Table tbox1: SuppilerID tbox2: SupplierName..Should populate when supplierID is entered. How this can be done. As I am using MSAccess db... …
Hello guys, i am new to PHP and finding it interesting difficult at the same time. I need to connect to an access database depending on the selected menus in the drop down box and printing the selected field in a table. Here is my code [code=php]<?php $ch1 = 'unchecked'; …
I have a storedProcedure in SQL-Server that I am using to delete duplicates from one of the tables. This storedprocedure makes use of a cursor. I tried to create the same storedprocedure in microsoft access by just replacing the 'CREATE PROCEDURE' with 'CREATE PROC' but it didn't seem to work. …
I have an Invoice.accdb database (in MS Access) that I am pulling into a MicrosoftReportViewer. I am having trouble subcategorizing the data, and was wondering if anyone could offer a little insight please. I would like to display the data as follows: Invoice Date [INDENT]ID Patient Name Pt ID Status …
hello, I got the below exception while trying to update the datagridview after adding a record into microsoft access database: [COLOR="Red"]c# rows cannot be programmatically added to the datagridview's rows collection when control is data -bound[/COLOR] using below code: [CODE] private void btnAddOne_Click(object sender, EventArgs e) { string name = …
Hi i'm unable to do multiple update (using Ms Acess because of restrictions). I try to do through ADO method (also because of restriction , x ODBC). The operation will break when reaching the script to update on the second page. Can you guys point where did i went wrong? …
Hello experts , Now this may seem a silly question but i do have to ask . Its a similar question to ones people have posted but not that similar . i would like to connect VB 6 to ACCESS 2007 using ODBC . I have no idea how to …
Dear all, I want to create a page on which I want to display the Number of kits issued, total women visited monthly wise, How much cases are registered total, how much are close due to delivery/migration/miscarriage/abortion/Fake Data. Can any one help me???
uhm. im coding a simple log in program in vb 6 and im using access as the database. i already coded the username and password verification part successfully. but our instructor requires us to include a "Privilege" whereas, all registered usernames in the database have corresponding privilege or rights to …
hi. can you please help me out with this program im writing. its a simple log in system written in vb6 . ms access is my database. i have a problem with connecting vb to access. heres the code: [CODE] /codes for module Public db As ADODB.Connection Public rec As …
How to set case sensitivity in ms access database? I need it for password column.
Hey y'all. I'm making a database using MS access 2007. I have a login form from a table which consists of admin and user. I want it admin to enter a different form from the user. Any ideas?
Hi. Can you help on my project. My code in search button doesn't run. I am making a Directory System and the following information must appear when you click search button..Remarks,Telephone Number, First Name, Last Name,Address. Email me the code at <<Snipped>..im hoping for your help on my project..Im creating …
[COLOR="Green"]yo evryone. class 11 kids submit a comp project as olevels paper 2. im a few years away from 11 but iwud love to make a project write noe n get an idea n so make an awsum one in 11 after this experience. buti dont hav any idea. i …
how to connect combobox to ms access database item ..............i need please say step by step and the database item are id name itemno 1 motherboard 5 2 keyboard 8
Hello friends, I am new to Jsp Here am facing a problem while trying to retrieve the data from ms access db using student no(number) form.jps ========= [CODE]<html><head> <BODY style="background-color:SteelBlue"> <center> <p> </p> <p> </p> <p> </p> <p> </p> <form method="post" action="search.jsp"><h3> Enter Ur Number: </h3><input type="text" size="3" name="no"><br /> <p><input type="submit" value="Submit"> </form> …
Hi all, Can anybody help me...How to create insert store procedure in access db with c# windows application.
how can i save image with other fields into ms access and retrieve it
Hi Looking for some general advice: I have taken over support of a large and complex web site, which uses multiple Access databases. At present it makes use of the MS Jet database engine (Provider=Microsoft.Jet.OLEDB.4.0). (as well as MySQL, used in a Snitz forum). After solving many specific problems I …
hi I have successfuly created an access database with vb.net accept it is not password protected. Can someone help me to password protect this DB. Here is the code I use. Thank you [CODE] Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click Try Dim cat As New ADOX.Catalog …
Hello, Guys i am working on a little project using C# & Ms Access, where i need to print some reports,there are few things i need to ask:- 1) is there any way to print reports other than Crystal Reports 2) i tried using crystal reports all things are kind …
How to convert MS access database to MS SQL express 2005?
I have all my customer information in a database program called Maximizer CRM 11. I inherited this info from another worker. I would rather use Microsoft Access. I am thinking that I can export the Maximizer database to a csv file. Will that include all the fields and can I …
The End.