5,053 Topics
 | |
 | I have one access database and one windows form. I have some text field and one picture box. I want to Store some data and image into my database, i have written following code to do the task but it says "Syntax error in Insert into statement". I am pasting …  |
| | -- hello there!, here i am again asking for some help... i want to retrieve my data from my ms access database and i it gave me this error.. [COLOR="Green"]"Index was outside the bounds of the array."[/COLOR] ------ can someone help me about this?.. i put my code on my … |
 | Hey guys I'ld really appreciate if u can help me with this. I'm building an application that has an access database for storing codes for voters. my problem is that after i update my database with the usual vb codes, i'll have to exit the application before the datagrid view … |
| | I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database. |
| | Hi, I wrote a vb script in text file to send an automated email as a reminder to 36 recipients. I'm loading recipients from access database. I can send out email when i tried with test db, whereby there's only one recipient for each category (TO, CC, BCC). However, i … |
 | I just want to know about the new extension in Access 2010. I need to create a database with .mdb and I can't do it with Access 2010 'cause the new extension is .accdb or something like that (I don't remember :$) As you can see, I don't use it …  |
| | I did find another thread on this topic, but it didn't fully fit my issue. I would appreciate any help in resolving this issue, which is as follows: I have McAfee Virus Plus and I suddenly began to get notifications from the program that there was no virus protection. When …  |
| | Hi, I want to make a report of several fields - however, rather than showing each record for each field I just want to display totals. Given this I think it would read a lot better if I had the field headings in one column down the page, so it …  |
| | What is wrong with this code in IE, rest of the browsers its working fine, but when it comes to IE, it gives an error popup, Access is denied. Can some one help please. [CODE] var IE = false; if (navigator.appName == "Microsoft Internet Explorer"){IE = true} if (!IE){document.captureEvents(Event.MOUSEMOVE)} document.onmousemove …  |
| | I have 2 table [EMPLOYEE] Emp_ID Emp_Name [ATTENDANCE] Emp_ID Emp_Name Time_In Time_Out How do I display it like this. I hope I present this right [CODE] +--------++----------++---------++---------+ | Emp_ID || Emp_Name || Time_In ||Time_Out | <---- FROM ATTENDANCE +--------++----------++---------++---------+ | 1 || Josh || || | <---- FROM EMPLOYEE +--------++----------++---------++---------+ …  |
| | Hi I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it. Tanks in advance  |
| | Im trying to select data from a MS access database, i have done this for SQL server before with no problem, but now with a Access database i get a run time error for "No value given for one or more required parameters". Below is my code [CODE] Private Sub … |
| | guys can you please help me in displaying columns from my ms access table to a listview in vb.net.. i use oledb in connecting to ms access.. |
| | DATA TYPE MISMATCH ERROR CRITERIA [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text <> " " And TextBox2.Text <> " " And TextBox3.Text <> " " And TextBox4.Text <> " " And TextBox5.Text <> " " And TextBox6.Text <> " " And TextBox7.Text <> … |
| | Please tell me that in Html website what is the code in javascript to connect to a MS Access database that is hosted on NIC Server. If not so possible in javascript then any other option what can added in HTML website |
| | im tr table only 2 column exist , first1 time period of text type nd 2nd is rate ,i.e also text type,my code is [code] try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:DRIVER=Microsoft Access DRIVER (*.mdb);DBQ=trrelation.mdb"); String tp=(String)mTimePd.getElementAt(cTimePd.getSelectedIndex()); PreparedStatement ps=con.prepareStatement("select Rate from tr where TimePeriod=?"); ResultSet rs=ps.executeQuery(); ps.setString(1,tp); while(rs.next()){ tRate.setText(rs.getString(2)); } con.close(); } …  |
| | Please tell me how could i run .asp page on html website that is hosted on NIC's web server. Please reply at your earliest |
| | I receive this error in a c++ program after moving the program from Mac OS X to windows...I was using XCode, I am now using Visual C++...I looked up the error codfe but don't understand how to apply the solution. Here is the solution as stated by microsoft: A type … |
| | Hi Everyone, I am writing a program in VBA (within Access 2010) that grabs a specific .txt file, split up the fields as per given specification and imports the values in to an Access table. So far, I can open the file and see what the program is seeing and … |
| | I need to update a column in access where I should be removing the 7 leading characters in a field.Example: Column value before: AB34567213. Colum value after: 213 So, I tried using VB in Access and this is what I got so far: [CODE]Private Sub delete_leading_chars() Update table_name Set col_name … |
| | Right basically a form i have done is refusing to let more then one attachment be attached to the form and then emailed. This is happening on multiple sites within the server. I'm blaming our smtp server settings but don't really have anything to back up that assertion. Anyone give … |
| | [ATTACH=RIGHT]21290[/ATTACH]The HP ProBook 6560b at first glance is not distinguishable from other laptops. However, this business rugged machine was designed for the modern day businessman. It’s sleek, charcoal black aluminum case is smooth to the touch. Weighing in at a little less than six pounds, this laptop was made to … |
 | Hello to all java programmers I have a java database problem specifically the auto increment. In my MSAccess I have a table named "[B][COLOR="Red"]Confirm[/COLOR][/B]" and in that table I got two fields, the "[B][COLOR="Red"]confirm[/COLOR][/B]" which is set to text and the "[B][COLOR="Red"]id[/COLOR][/B]" which is set to auto number or auto … |
| | hi everyone i am 19 years old and have just finished ICT level 2 at college and have this great idea for a website but looking into it seems i need a database driven website and im nowhere near smart enough. ive played around with microsoft access and notepad and … |
| | I want to give users full access to certain folders in the ProgramData folder. Can this be done with Delphi code?  |
| | [CODE]import java.awt.*; import javax.swing.*; import java.sql.*; import javax.swing.text.MaskFormatter; import javax.swing.table.DefaultTableModel; import java.util.Vector; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseListener; import java.awt.event.MouseEvent; class MyFrame extends JFrame implements ActionListener,MouseListener{ Container c; JLabel lAccountNo,lAName,lDateofOpng,lAddress,lContactNo,lTotalBalance; JTextField tAName,tContactNo,tTotalBalance; JTextArea tAddress; JFormattedTextField tDateofOpng,tAccountNo; JButton bAdd,bNew,bDelete,bExit,bUpdate; DefaultTableModel mAccthld; JTable tAcctHld; MyFrame(){ c=getContentPane(); setSize(Toolkit.getDefaultToolkit().getScreenSize()); setTitle("Account Holder"); setLayout(null); lAccountNo=new JLabel("AccountNo."); … |
| | Problem - Main - Clicking any Google Search result, results in redirect to random sites - NOT the site of the search result - search function not usable Secondary - computer has slowed to less than a crawl plus - recently, on boot-up, Avast reports that Microsoft Realplayer.exe is suspect … Information Security android android-development apple audio chrome-os client-server data-protection digital-publishing dns flash http-protocol ide microsoft-access microsoft-office microsoft-windows multimedia office-suite os-x pdf peer-to-peer printer publishing seo storage tcp-udp user-interface virus-malware visual-basic web-browser webcam windows-virus |
 | I posted a while back ago on making directx work in classes. I'm having more issues now. On line 125 (system.cpp), when in debugging, it tells me that it has an access violation. I googled the issue, and someone had said something about initializing the pointer, but that is taken … |
| | hi there, can anyone please help me how to insert, search and delete a picture in vb.net and Microsoft access 2007? A picture that will be store in access is inserted in a form or a picture box. But it seems i have the wrong codes.. and when i click …  |
| | Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes … |
| | import java.awt.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.util.Vector; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.text.MaskFormatter; import java.sql.*; import java.awt.event.MouseListener; import java.awt.event.MouseEvent; class MyFrame extends JFrame implements ActionListener,MouseListener{ Container c; JLabel lRollNo,lName,lAge,lMarks; JTextField tRollNo,tSName,tMarks; JTextField tAge; DefaultTableModel mStud; JTable tStud; JButton bAdd,bNew,bRemove; MyFrame(){ c=getContentPane(); setLayout(null); setTitle("My Frame"); setSize(800,700); setLocation(10,10); lRollNo=new JLabel("Roll no"); …  |
| | showing illegal start of expression in defining functions of mouselistener interface import java.awt.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.util.Vector; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.text.MaskFormatter; import java.sql.*; import java.awt.event.MouseListener; import java.awt.event.MouseEvent; class MyFrame extends JFrame implements ActionListener,MouseListener{ Container c; JLabel lRollNo,lName,lAge,lMarks; JTextField tRollNo,tSName,tMarks; JTextField tAge; DefaultTableModel mStud; JTable tStud; JButton … |
| | My old laptop broke a while back and the hard drive was somewhat intact but just wouldn't boot. I now have a new desktop and bought a 2.5 IDE Hard Drive Enclosure so I could get all my info. However my old laptop user account was password protected, so now … |
| | Can anyone help on how to show a message box showing that existing record has been entered in database if i tried to enter the new record. However, if the input is new record (record added), the record is saved into the database. I'm using visual basic 2008 and Microsoft …  |
| | hi. i have a main form and log-in form. when i try to log-in and entered a wrong user or password it gives me error and i dont understand why the error is in the main form??? heres my code in my login form.. [CODE] private void Lgbtn_Click(object sender, EventArgs … |
| | Hello, A couple of days ago I was using Pandora and it suddenly said that my plugin had stopped working, Firefox froze, and my mouse (laptop) stopped working. I found that somehow the mouse had been turned off. The next day I tried using Pandora again, and once again the … |
| | I am trying to check for certain processes that is running and then inform the user of those processes via textbox like "The programs; -name of the processes running goes here- are running" The I am using is [CODE]Dim iIndex As Integer Dim isd As Integer = 0 iIndex = … |
| | I'm still pretty new to this and I need some help. Here's the situation. First the user opens a form to select which database (one of 3) they are working in. Then they will be using several forms. The same set of forms are always used no matter which database … |
| | Hello, I have a program that reads images from my access database. What I'm trying to do now is write the images out to a folder but I don't know where to begin. The "ms" variable holds the images. [CODE]Option Explicit On Public Class Form1 Private cn As ADODB.Connection Private … |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
| | The command FileSearch does not excits in ACCESS 2007, my code is as follow: How do I import this filein a different code? Public Sub Import_Labolink() Dim sourcefile, destinationfile, miscresults As String Dim i, N, m, o As Integer 'Dim mFileSearch As New myFileSearch ' New code for filesearch N … |
| | Hi I have an Access 2003 database and website that im trying to code using VB asp.net, it's basically a book and toy library website and what i want to do is have a webpage of items with pictures and when the user logs in to the site, they can … |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
| | I apologise if i have placed this query in the wrong forum - I'm new here. When i try to access the index or default pages of my website i get this error... [QUOTE] Server Error in '/' Application. -------------------------------------------------------------------------------- Could not load file or assembly 'FredCK.FCKeditorV2' or one of … |
| | Hello anybody I am trying to update table to access database in vb.net after changing password. But I have a problem in update error as following [CODE] Dim dbCommmand As New System.Data.OleDb.OleDbCommand Dim DBConnection As New System.Data.OleDb.OleDbConnection DBConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\thaeaye\Documents\Testing.mdb" dbCommmand.CommandType = CommandType.Text dbCommmand.Connection = DBConnection DBConnection.Open() dbCommmand.CommandText = … |
| | Experts, I'm new to VB and I'm trying developing a VBA application to send and receive data to an RFID reader and put the result into Microsoft Access. Project has: Mscomm command1 (command button) Text boxes (Text1, Text2) At this stage i have developed the following code. [CODE]Private Sub Command1_Click() …  |
| | I just noticed yesterday that I did not have McAfee Security Center installed any more. (beat myself up enough, thanks, but feel free to express shock and dismay.) When I looked on the pc yesterday morning, there was only a McAfee scan app in c:\program files\mcafee. I have had McAfee … |
| | hi dear i i have two columns in an access table, first column is of percentage and second is of result . i want that result should be automatically calculated as if the percentage is les than 33 then ruselt fail and if percentage is greater than 33 then result … |
| | Hello, Please I need an efficient algorithm for ranking records in a database. I know sorting and grouping can produce record ranks, but I want a means of inserting the ranks beside each record as arranged in the table. For example: [CODE=text]This figures will rank 10 - 3 5 5 … |
| | First time poster here... My VB.NET program compacts and repairs my DB, but somewhere in the process unsets the database password. No problem, just reset it through VB, right? Ummm... not sure how to go about that task. So I either need to know how to compact it without losing … |
The End.