5,053 Topics
 | |
 | Hello! 1st let me apologize if I have duplicated a post. I am a newbie to DaniWeb (and to Java and HTML) and have searched your forum for a few hours now and not found and answer to my problem. I was hoping someone could help. I have a simple … |
 | I don't work with ASPX or whatever it is now very much at all. I work with WinForms and DLLs most of the time, but I was asked by a client to make a portion of an application available online so that their clients can access certain information without calling … |
| | I am trying to program the last part of an application which needs to take data from an Excel sheet and add it to an Access table. I'm using Excel 2003 on XP. Any and ALL help is appreciated. The problem I'm running into seems to be on connecting to …  |
| | <html> <body> <%@page import="java.sql.*"%> <form method="post" action="csea.jsp"> <table border="1"> <tr><th>Reg No</th><th>Name</th><th>Present/Absent</th></tr> <% String pa = request.getParameter("pa"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:Student"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from student_details"); while (rs.next()) { %> <tr><th><%=rs.getString("reg_no")%></th><th><%=rs.getString("s_name")%></th> <th><input type="text" name="pa"/></th> </tr> <% } st.executeUpdate("update csea set pa='"+pa+"'"); con.close(); …  |
| | Hi All, I have a access database with these columns. USER_ID,COUNT,TIMES Let say the current record is this: USER_ID,COUNT,TIMES STEVE20,24,1.5 Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my … |
| | #**Can anyone please tell what are the differences between Microsoft Access and traditional DBMSes (i.e. SQL Server, Oracle, Postgres, and MySQL) in reference to how they handle record-locking, rollbacks, and database updates? **# |
| | I want to update my database but the problem is that the driver is not taking any values from the preparedStatement. I am getting an error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] You must enter a value in the 'ClassicRoom.Occupy' field. Press any key to continue... Here is the ActionPerformed … |
| | Hi Guys, I have created windows application project in framework 3.5, vs2008 with Access database when i changed target platform to x64 it will give me an error like 'The microsoft.jet.oledb.4.0 provider is not registered on the local machine'. How to solve this thread Thanks in advance. |
 | I HAVE MS ACCESS DATABASE OF 'STUDENTS' containing Their roll no's, names, min marks and max marks. As like schools publish results on their webistes, there is a text box in which roll no. is entered and the command button for searching the whole record of roll no. entered in …  |
| | I want to know how M/S ACCESS database can be connected to html page hosted on local host |
| | Hi there! So I was at the offices of a bank today doing some work to their webpage, and I needed Internet Connectivity, so the networking guy told me to simply run the following .bat file: REGEDIT4 ; @ECHO OFF ; CLS ; REGEDIT.EXE /S "%~f0" ; EXIT [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings] …  |
| | How to link MS Access Database with an HTML Page...? If both data base and webserver are on same server. |
| | I am trying to delete a record from a table by using dao recordset. Currently I am working with the code listed below. Unfortunately i've realised that this code only deletes the first record in my table, whereas I am looking to delete a record form the table with an …  |
| | Hi there, I am hoping that somebody here might be able to help me. My kids managed to get some virus on my computer while I wasn't at home. I twigged when I got a popup box at my online banking sites.. eek! I ran AVG and it found a … |
| | Ok so I have made ASP.NET website I have used Access database 2010 but I am having problems with one particular thing when I try and run the website I am getting this error which says OleDbException was unhandled by user code and Could not find file 'C:\Program Files\Common Files\Microsoft …  |
| | hello! i'm trying to implement an audit trail in my system and what i wanted is that when the user click the login button, infos like username, level of access, time in and date will be save in the database and fortunately i have done it and here is my … |
| | For a lack of words, I'm confused with my server at the moment. I moved an old site on ASP/Access over to ASP/SQL Server 2008 Express, and now some data appears, while other data does not. This one is an odd ball to me. I have data cells of the … |
| | Hey there i have a problem with a program that works on other pc's but not on my laptop. (it connects to access) When i try to run it it gives me the error "AAAjava.sql.SQLException:[Microsoft][ODBC Driver Manager] data source name not found and no default driver specified" I already reinstalled … |
| | hey guys! i just restricted my guest account from seeing my local drive E from properties. Now i want to give the access back but i cant see the guest account in Advance settings, where it was first present, in properties! Thanks  |
 | Hello, I got a bug from going on the keltec site - there's discussion but no solution that I've been able to find. I tried to post here before but I could not post or PM for some reason. Now posting is working so.... I've been working on this issue … |
| | Hello Helpers! My Compaq M2000 laptop has been a victim of a very silly mistake done by me. I've followed the steps given in the below link: http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/threads/134865/read-me-before-posting-a-request-for-assistance following are the logs for your persual: **GMER One.log:** GMER 1.0.15.15641 - http://www.gmer.net Rootkit quick scan 2012-03-20 22:48:27 Windows 5.1.2600 Service Pack … |
| | hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and … |
| | can anybody help me.i got an error while searching a rec from table error @ 2nd line after connecting with access [code] Dim src As Integer src = Val(InputBox("enter rno:", "rno")) Data1.Recordset.FindFirst "rno=" & src [/code]  |
| | Hello please can anyone help me with microsoft access. I work as a software support consultant for a medical software company and we have an sql server database with all the bugs etc but the website is awful. I have made myself a small access database with bugs that i … |
| | I am getting errors on installing Visual Studio 2008 on Windows 7 machine. On digging down deeper I found that "Microsoft Visual Studio Web Authoring Component" is not getting installed which is a pre-req for VS 2008. I further drilled down and searched different forums over the internet, they mostly … |
| | Hi everybody >> Thanks to this forum >> I need your help please .. My problem in the Combo Box and SQL query .. I have three comboboxes linked to an Access 2007 database first one "Department" second one "Year" third one "ClassRoom" in third combobox I need display the … |
| | Hello fellas :) I have a task to do, there are 10 questions and i obviously need 10 answers :) I have done (attempted) some of them /not every yet/ but i wonder if there are any errors or any correction or improvements that could be made :) Thank you … |
 | Dear Sir/Madam, I have created some ASP pages in my computer and stored those pages into the web site content directory (in my case C:\PanWeb) and IIS's Virtual Directory alias is "abcweb" created with the IIS V5.1 However, i can browse those pages in my computer by putting the 127.0.0.1/abcweb/ … |
| | Hi there I was wondering if their is anyone who can convert this statement from 'INSERT' to 'UPDATE' as I cannot seem to do is. Code can be seen below: [CODE]public static void COUNT2( ) { try { ResultSet res = stmt.executeQuery("INSERT INTO TABLE2 (VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT) SELECT VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT FROM TABLE1" ); … |
| | Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely … |
| | hello :) i'm developing an app in VS 2010 C#, linked with an MS Access Database. i want to use a table name as variable. i have tried: [CODE] string tblname = students; string query = "select * from '" + tblname + "' where rollno=123"; [/CODE] but it's not …  |
| | Ok, so, short version, my WoW account was hacked yesterday, and all my stuff was deleted. I uninstalled WoW, ran AVG virus scanner, and Advanced System Care scan, then I came here and ran the scans on the site, malewarebyte came up with 2, the rest negative, I just want … |
 | Any1 here i just need help regarding my System. In Log In Form. I need to be able to terminate/locked the account in vb.net if the user input wrong username/password in my Log In form like 3 attempts is good. and be able to enabled the account also as an … |
| | hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks |
| | My problem is for postItem.aspx and giveComment.aspx, users cannot access without login. Can i use the nested-if method? Then how to use it? Thank you... In Login.aspx.cs if (temp == 1) { string cmdStr2 = "Select Password from Reg where Username= '" + txtUN.Text + "'"; SqlCommand pass = new … |
| | how to create a short summary form in Access Database? I have created a database in which I have created 4 tables 1. Pregnant Women Data 2. Feedback of Pregnant Women Data 3. Traditional Birth Attendants Data 4. Villages Data I have registered 3397 pregnant women, and issued some women … |
| | I am creating a shared database to record requests entered by a team of 30. I need to record the Order Number, Reviewer Name, Date, Action Type(Order Type), Client Name, and a comments box for each order entered. When creating forms, Currently Reviewer Name and Date are auto-input so the …  |
| | Hi, I have a strange problem on a computer. I use a program that connects to a database that is located on the server. When I run the program, it can not always find the database and it returns an error. When I open windows explorer and go to the … |
| | If the class members declared public and the class itself is specified as default access ( Package access), then can the public members of that class be used in another package? I am asking this because .. as far i know class which is not specified as public cannot be … |
| | hi all.. i'm having a problem with my win7 desktop, its not showing up neither task bar but Task Manger is working properly .. even internet explorer and many other apps also working fine but when i start the window its only pop up MyDocument window automiatically and on searching …  |
| | Note: I'm very new to everything so please bare with me. Say I have a form on a website which asks for your first name, last name, and email address. Upon clicking submit, I want the data to be transferred and saved to a Microsoft Access Database. How do you … |
| | i have a dynamic table whose values came from the database. the user will select records from the table then save the result to another table. i have the following code: <?php echo "<form method='post' action='save_result.php'>"; $subjects="table1"; $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data.mdb").";"; $conn=odbc_connect($connstr,'','') or die("connect error: … |
| | hi! i'm having a project in school regarding vb.net and i badly need your help! it is about connecting vb.net to access. i need to be able to add, delete, edit, and save data to a table in access using a form in vb. i am also required to view …  |
| | Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\xampp\htdocs\xampp\display.php on line 5 Connection Failed: php is working fine, ran other simple php scripts... but this is the error when i connect to a ms … |
 | Hi all I need help with connecting to and manipulating a microsoft access 2007 database using code in visual basic 2008 express edition. It's for a project I'm doing for University that's due on the 12th of October:S. Please help me out in whatever way you can - links to … |
| | Hello, I am trying to populate a spreadsheet using Access data, however I am having trouble with the line noted below, which is giving a run-time error. I am not familiar with the Excel Object Model, so not sure how the "selection, range, etc" should be used. Any help and … |
| | Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in … |
| | I know this might be a very simple one, but yet I can't figure that one out! How do I get data from one table that are not in another? Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect. If ServerA has 20 rows and ServerB … |
| | Hello Before I start I'd like to show you this [URL="http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/threads/165724"]thread[/URL], which is basically the same problem as I had/have. What happens is the fans starts getting louder and louder, which means they're running faster... eventually my computer just starts slowing down and become unusable. I haven't gotten to that …  |
| | is it possible to access an access database without ms office or just using references or .dll  |
The End.