1,597 Topics
 | |
 | Hi! This is my submission for code snippet contest. I also posted this code to help other members on how they can use compact & repair their MS Access Database within Visual Basic 6.0. You also need to add Microsoft Jet and Replication 2.6 in your project reference. To use, … |
| | How can i insert data from access file into listview in C#? Thanks |
| | i have a datagridview in my vb.net form displaying data from ms access file A , table A , is it possible for me to export the data in the data gridview to ms access file A table B?? i'm not using sql.  |
| | Hi, I'm a developer by trade but I've done some networking in the past (mostly buying and creating machine specifications but also a bit of firewall management and AD policies,) In a previous company I was even Manager of the Systems department (Developers and IT guys) Anyway I've recently joined … |
| | Hello - I'm looking for advice on the best way (or possible ways) to set up a project for work. I have access to our companies internal web server (for employees), and a MS access database that all users have access to, located on a shared network drive. I need …  |
| | Hi, I'm writing a database for a computer shop and need some examples to look at. (It's not for a real shop, just a little project of mine) Where Can I find some templates for Access Database templates for a business like this? |
| | hi, There is a a physical server (window server 2008 r2) which is running as main server and as domain controller. As administrator it automatically gives remote access to the server from out site of the network. Im using the Remote desktop to log in to the server. The static …  |
| | 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 … |
 | 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 |
| | How to link MS Access Database with an HTML Page...? If both data base and webserver are on same server. |
| | 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'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 … |
 | 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 …  |
 | 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! 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 …  |
The End.