5,053 Topics
 | |
| | I have searched and cannot find out why my code will not update the database. The program stops at the mDA.Update(mDS, "temp_data") line with the following error: System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message=No value given for one or more required parameters. Source=Microsoft Office Access Database Engine StackTrace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] …  |
| | i try to make the running sum of quantity using query with a expected output [CODE]ID | Date_in | Date_out | Quantity_in | Quantity_out | Quantity_Run_Sum in01 |17/2/2011| | 300 | 0 | 300 in02 |17/2/2011| | 400 | 0 | 700 Out01 | |20/2/2011 | 0 | 100 | … |
| | [code=text]jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Users/Kix/Desktop/IMPORTANT DOCS/oop/BANKSYSTEM/Accounts.mdb;DriverID=22;READONLY=false} Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at banksystem.BankDBDriver.retrieveData(BankDBDriver.java:200) at banksystem.BankSystem.actionPerformed(BankSystem.java:109) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:6267) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6032) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) … |
| | I made an windows application using c# express edition 2010 and i use the SQL database as mdf file inside my soultion and the connection string mad automaticaly in the app.config as the following: [CODE]<add name="MainForm.Properties.Settings.FamilyHistoryConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FamilyHistory.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />[/CODE] then when i am trying to publish the … |
| | Hi all. Not sure if this is the right forum, but it seemed the most appropriate from the list. I'm helping to develop a ghost-themed site. As it deals with an urban legend, we're pretty sure that kids will come across it, but don't want them to visit. There's really … |
| | This is my code. [CODE] <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Registration Page</title> </head> <body background= "bg8.jpg" width="1000" height="1000" alt="work1"> <form action="clientlogin.jsp"><table> <tr> <td> Company Name</td><td> <input type="text" name="cname" value="" /></td> </tr> <tr> <td> Password </td><td><input type="password" name="pwd" value="" /></td> </tr> <tr> <td>Location of company </td><td><input type="text" name="location" value="" /></td></tr> …  |
| | please help me.. I don't know ho to make that. Thanks |
 | Hi, I am experiencing some abnormal application behavior. I wrote an application in C# that does hourly database , as well as directory backups. Its constructed in a way that all settings are saved in XML file. and once the user allows the application to start doing the scheduled backups, … |
 | I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how … |
| | Hi all, I am not sure about method to publish my program. But basically when I publish it no errors at all... I have database name usurfdb.mdb. I have set it build action to content and copy to outputdirectory = copy if newer. Should I amend anything on my usurfdbdataset1.xsd … |
| | Hello all, I'm using MS Access as my DB for a very simple web site. Everything was running nicely till all of a sudden I can't inset rows into any table in my MS Access database. In my tests I even created a fresh and clean table1 with one number … |
| | ok. i am woking on a web browser for a friend of mine. everything works except for the favourites / history code, which is giving me an Unhandlded access violation. i have tryed using [CODE]Try[/CODE] but then it gives me a file not found error when attempting to append the … |
| | on Microsoft Access database i create tables named John , Philip and William. on Form1, i have datagridview1 which show those tables on database. when i click one of them,i pass it into a textbox1 on Form2. for example i pass John into textbox1 and here is my code (i … |
| | I want my Access form to return a result based on data entered in a text box and combo box. I have 4 queries: qryA, qryB, qryC, qry D I want the user to be able to select A, B, C, or D from a combo box and then enter … |
| | Can anybody advise on the way to set up an ODBC connector for a desktop MS Access MDB Front End to connect to an MS Access MDB Backend on a remote (internet) location? Thanks Max |
| | Hi, I have ms access as front end software to be used for employees in my company. Every user will have different access to the contents inside based on their role. For example, manager will have different access from the others. First attachment is the image for limiting user access … |
| | Hi, I run a Lenovo PC with Windows XP. Lately, it's been doing some funky things. It's hard to define, so I will give a couple of examples. When clicking on bookmarks, I usually have to click and hold the mouse to get it to get to the bookmark. Or …  |
 | After deploying my project, I tried to install it on other pc , it installs well but whenever i run the .exe application my database file which is MS Access cannot be found. Well obviously the path is the problem. How would i make my path flexible and so that … |
| | Good evening everyone! I am working on a documentary and I have 10 000 short videos to sort! I am looking for a database/software program which will help me. In brief I want to attribute several categories to files, in order to find later (when I will make the documentary) …  |
| | Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ? |
| | My sister has a problem with her laptop: whenever a menu/folder is opened there is mad scrolling through all the entries which you can't stop. This is driving her crazy because you can't run anything effectively without restarting the computer several times. Adaware, spybot, macafee and a few other malware …  |
| | Hi all, I've got a small problem with a database I'm working on, the project was given to me by college kids & their Teacher to complete. They created the database using Access 2007 and I'm left building a Windows App user interface in Visual Basic. Anyway I can't figure … |
| | Any ideas on this one.....? I cleaned down a virus infected pc (Windows XP Media Centre Edition SP3 with IE8). All the scans are now clean but iexplore.exe runs as a process in task manager. It throws an error every few minutes saying Internet Explorer has encountered a problem and … |
| | Hi Folks; This is my first post. I attempted to search through some of the threads hoping to find the specific problems i see on my desktop (running on XP), to no avail. Hope you can help. Thanks Symptoms: Virus or Malware downloaded? 1. Have to type "explorer.exe" on Task/Manager/File/new …  |
| | Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until … |
| | java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.[CODE] String id= t1.getText(); int c1=Integer.parseInt(rc1.getText()); /* rc1 is a radiobutton */ statementobj.executeUpdate("Update tablename(fieldvalue) values('"+c1+"')where ID='"+id+"'"); [/CODE] |
| | I think my girlfriends netbook has become infected with a rootkit virus thingy. I've tried several things the latest of which was reinstalling Windows XP. Unfortunately search results in Google still redirect to random shopping websites. Below the various log files as requested. Any help will be appreciated! mbam log: … |
| | Hi everyone, novice here. I'm having some major issues trying to figure out what's going wrong with my code. The general problem is that I can't get the foreign key in one of my child tables to populate the primary key from the parent table. I have a parent table … |
| | Hi I am using C# 2008 with Access 2007. I am using MDI on MDI a added a menu now that Menu have a Login MenuItem which is enable and other menu items are disabled at form load. Now I am try to implement this if login is successful then … |
| | Hi! In my direct 2d game i want to draw a big background picture entered by the user. Im currently trying to do this as described on [url]http://msdn.microsoft.com/en-us/library/ee719658%28v=vs.85%29.aspx[/url] . Altough it gives me read error at pos 0x0000. Heres the code: [CODE] RECT rc; GetClientRect(hWnd, &rc); using namespace D2D1; //Render … |
| | HI guys, I have finish my project in vb.net and publish it without errors. The problem is this: As my project finished installing in the pc, an error occurred saying that the path where should be my DB Access is not there. Although I manage this problem by manually copy … |
| | Hi Laptop caught a virus the other day so I have spent all day running virus scans but am now at a complete loss to why I still can't connect to the internet. I have tried pinging yahoo.com to test with no packets lost etc so there is an internet … |
| | I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my … |
| | [B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …  |
| | How to make or set this as autonumber in msaccess-vb database? from 00-00-00 up to 9999-9999-9999 how to make that code to become autonumber? and what code can i use in my database when the new entry is equal to existing ?(The same primary key) |
| | I am writing a video program, everything works fine except I am often (ie most times, but not [I]every [/I]time) getting the following error: Unhandled exception at 0x6076fde0 (msvcr90d.dll) in javaw.exe: 0xC0000005: Access violation reading location 0x0a450020. I have tracked it down to this function: [CODE]//fill the buffer from data … |
| | Why my code in my VB-access database is not working. my add code is not displaying the inputted data it only displays the gridline in datagridview. I already connect the database access file. What's wrong? Can anybody help me? thankz. |
 | Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: … |
| | Hey there, im stuck now with the datagridview not being able to discard the old headings in it and load another table in access. this is how the test program works i have 2 buttons. start the program, and press one button - the datatable loads close the program, and … |
| | guys How do you Create Database in MS Access Using Oledb in vb.net? |
| | I completed a form for my supervisor using VB via Microsoft Word. It worked beautifully on my end...I could fill it out, save it, etc. I password-protected the document and only allowed people access to fill-in the form, which consists of drop-down menurs and text boxes. However, when another user …  |
| | *THIS IS THE CODE WHERE I CLICK A BUTTON TO SIGN UP FOR AN ACCOUNT* Set db = New ADODB.Connection db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\useraccount.mdb" Set rs = New ADODB.Recordset rs.Open "Select*from useraccounts", db, adOpenStatic, adLockOptimistic rs.AddNew rs!Lastname = Text1.Text rs!Firstname = Text2.Text rs!Contact = Text3.Text rs!UserName … |
| | Hi, There is something wrong with my code. I can't seem to access the database anymore not can I add new data information. I am suppose to create a registration form with username and password. Then save it to a database on MS Access. Then login using the login form. … |
| | How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components. |
| | Hi, I have made simple database in MS access. I want the front end for that database which can be easy to use the database for 3rd person. Can anyone help me. Saroj |
| | Hello I am new to ASP and Access Databases really as well. I primarily use PHP and MySQL/Postgre.I work for my university in web admin department and due to rather sloppy coding in the past by workers have to rewrite an ASP form that writes to an Access DB. I … |
| | Hello, I have just started using databases, but I am totally stuck. I made a database and table using MS Access. The table has three columns. ID, Code, and Letter. Basically, the Code column stores a number for each letter (eg. 1 = A, 2 = B, 3 = C, …  |
| | well I followed the steps before posting and it seemed to solve the problem but here is the logs anyway: GMER 1.0.15.15530 - [url]http://www.gmer.net[/url] Rootkit quick scan 2011-01-15 13:46:00 Windows 6.0.6002 Service Pack 2 Harddisk0\DR0 -> \Device\Ide\IdeDeviceP2T0L0-4 TOSHIBA_MK1637GSX rev.DL032C Running: xrsodq7v.exe; Driver: C:\Users\Owner\AppData\Local\Temp\uwldrpob.sys ---- Devices - GMER 1.0.15 ---- AttachedDevice … |
 | I am having a problem installing the driver for Windows 7 from Mustek for my scanner. Hardware and Software I Use Mustek ScanExpress A3 USB 1200 Pro Large Format Scanner Windows 7 Pro 64bit HP Pavilion Elite e9280t PC i7 HP Photosmart Premium Fax AIO C309a - Wireless I downloaded … |
| | create a Report of Customers and my database are MicroSoft Access 2000 Coding are Following Plz somebody hlp me in my project [code=java]import javax.swing.*; import java.awt.*; import java.awt.event.*; public class FrmCustomerReport extends JDialog{ public static JTable JTExpTable; //Start create variables JButton JBSearch = new JButton("Print",new ImageIcon("images/print.png")); JLabel JLPic1 = new … |
The End.