5,053 Topics
 | |
 | Hi I have access database with two tables With a Relationship i can insert records into the first table with no problems but when im trying to insert a record in the second table i got error message Error message : Syntax error in INSERT INTO statement. - Microsoft Office … |
 | Small groups of what are best described as cyber-mercenaries, willing and able to perform surgically precise hit and run hacking operations, are offering their services for hire out of China, Japan and South Korea. That's the conclusion of security researchers at [Kaspersky Lab](http://www.kaspersky.co.uk/) who have been following the progress of …  |
| | **Please help me...I have a Dell InspironE1505...I have no problem getting internet access at home, but I am traveling for work and trying to use a Verizon MIFI card and keep getting LOCAL INTERNET ONLY...I have tried disabling, rebooting, taking off the IPV/6 in properties, still LOCAL ONLY!!!!**  |
 | good pm.,.,i have a next button Try lblcat.Text = ds.Tables("evaluation").Rows(cat)("QuestionCategory") txt1.Text = ds.Tables("evaluation").Rows(CurrentRow)("Question") txt2.Text = ds.Tables("evaluation").Rows(CurrentRow + 1)("Question") txt3.Text = ds.Tables("evaluation").Rows(CurrentRow + 2)("Question") txt4.Text = ds.Tables("evaluation").Rows(CurrentRow + 3)("Question") txt5.Text = ds.Tables("evaluation").Rows(CurrentRow + 4)("Question") Catch ex As Exception End Try every click to the next button my category and questions change.,., …  |
| | Hello everyone, I have a problem, i am unsure how to read the data from my Access Database into my vb.net form. I did some searching but i didn't manage to find anything useful so i would appreciate any pointers. Here is the code from frmAddNewCandidate i am using that … |
| | i have a a cooperative society website.i need to process the loan members ask for.how will i create a admin page where admin staff process and grants loans to members  |
| | Private Sub Load_Faculty() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim dr As OleDbDataReader Dim arrImage() As Byte Dim myMS As New IO.MemoryStream Dim sSQL As String = String.Empty Try sSQL = "SELECT b.FacultyFirstName, b.Image, b.Course, a.Course" sSQL = sSQL & " FROM studentsrecords as a left … |
| | Private Sub Save_Record() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Dim arrImage() As Byte Dim myMs As New IO.MemoryStream Dim bSaveImage As Boolean = False Dim strImg As String = String.Empty If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else … |
| | hello i am using vb 2008 version and microsoft office access 2003.I have installed access 2007 also. while i work in vb,i get error -could not find installable ISAM ,at this code con.open("provider=microsoft.jet.oledb.4.0;datasourse="&application startup path&"vbnet.mdb") |
| | I have just a user form in access 2007 with a text box and a Save command. MY code: Private Sub Save_Click() If School.Value = "" Then MsgBox ("Text Box is empty") else Msgbox(" Not Empty") End If End Sub When the Save is clicked, and the text box is …  |
 | i have been doing like the code below, but why when i clicking the "delete" button, it is delete all records in the datagridview, but it does not updating to the database. And, how do i make only the selected row that has been selected by the user that gonna …  |
| | Hi, this is my first post, and I'm in need of some help making an application that saves the data from a textbox to an access database. This is my code, it gives no errors, but when I use it, ie, I input the text in the textbox and click … |
| | Private Sub Save_Record() Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Dim arrImage() As Byte Dim myMs As New IO.MemoryStream Dim bSaveImage As Boolean = False Dim strImg As String = String.Empty Try If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else arrImage = Nothing End … |
| | I am building an application that needs to access a database. I installed SQLite.net, made references to SQLite for Windows Runtime and Microsoft Visual C++ Runtime Packages. Now, how do I connect to the database? In other words, what are the Visual Basic codes? Note that I do not see … |
 | Hi all , I am trying to build a function in Access Query database which gives results of a 1 month expire invoices from the current month.Therefore when I run the query, the results will be all the invoices which will expire next month. I have tried the Data Add … |
 | I have two forms "Sales" and "PurCh". The datagridview in the Sales form is being populated by a stored procedure that is carried out when the form loads and it works perfectly. But the datagridview from the "PurCh" form has refused to populate when the form loads. I initially thought … |
| | Hi, I'm creating remote desktop application in qt 4.8. I have to implement some way to browse remote computer directory structure and possibility to download files on local machine. I'm wondering how can achieve this... ![Member Avatar for [Prototype]](https://static.daniweb.com/avatars/orig-avatars/avatar913340.gif){kind=avatar} |
 | In the new versions of server 2008+ MS have added an "Application and Services" folder to Event Viewer, I dont seem to be able to programaticaly access any logs in here, My Code: Dim strValue As String Dim objLogs() As EventLog Dim Logname As String = "Microsoft-Windows-Backup" Dim objEntry As … |
| | i have a problem here. Here is my case: I want to update the Quantity value from program based on the value given from program and minus it to the database. For example: i have 100 in Quantity in the database, once i run the program and update the Quantity … |
| | please how do i code a search button in visual basic. my database is microsoft access and i am using a binding source to connect to the database. |
| | Im doing an application n c# and using Ms Access 2003. i want to check whether a product id already exist in the database. Below is part of my code[code]string sql; OleDbCommand cmd; OleDbDataReader rdr; mDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Path.Combine(Application.StartupPath, "..\\..\\Company.mdb"); mDB.Open(); sql = "Select COUNT (*) ProductID … |
| | Hi Everyone, Been a few years since I had to post anything here so I'm glad to be back. I've been asked to do a report to show vouchers that have been issued and presented for July (this year and last year). I have done this SQL: SELECT tblOutlet.OL_NAME, Format([VI_TRANSACTION_DATE_TIME],"mmmm …  |
| | Dim connect As String connect = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & Application.StartupPath & "\segdata.accdb" Dim conn As New OleDbConnection(connect) Dim sr As System.IO.StreamReader Dim entirefile As String sr = File.OpenText(Application.StartupPath & "\SEG1.txt") entirefile = sr.ReadToEnd() ' Read the whole file Dim OriginalValue As String OriginalValue = vbTab Dim ReplaceValue As String …  |
| | I have created a Login form and coded as below (Before that.. I am very new to VB I have the knowledge only of the basic.) I got the code from this forum itself But it is not working properly Can anybody help me... My form contains two textboxes 'TextUserID' … |
| | Hi, I have some hijacking virus that I can't get rid of. I've tried Malwarebytes, tdsskiller, Skybot, AdAware and Superantispyware, cleaned some things, but it persists. Can anyone help? Below is the hijackthis log. Many thanks for any input. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 9:00:16 PM, …  |
| | Hi everyone, I have a list of an unknown number of Microsoft Access 2003 databases. All of my databases have the same tables but obviously different recordset data. I am able to open one table from one of the databases (select a table from one database) and edit one recordset. … |
| | Is there any way to show the highest value from a access db column in a textbox which you put in the load of a form? Found something by searching around, but did not get it to work at all. Maybe because i cannot open a connection in the load … |
 | Hello Community, I was wondering if there is a way to use some kind of local server such as Wamp, Xampp, easyPHP etc... something like that and set it up so everyone on the same network can access the database on the server. The server will be running on a … |
| | One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run … |
 | Good morning everyone, So I have come across an interesting request that I have never dealt with and was wondering what everyone kind of thought of where I should take it. A company I have been working with is updating their website. The company uses VPN internally already, what they … |
| | Hello all, I am having an issue with saving data entry from a vb6 form to a microsoft access 2003 form. Can anyone please help? I am getting the error "Operation is not allowed when the object is closed." I appreciate all your help! Option Explicit Dim cn As ADODB.Connection … |
| | I've written a script to alter images in a number of Excel workbooks. In order to properly access the image information, I need to iterate through all Sheet.Shapes on a particular worksheet. I'm having trouble with grouped worksheets. **How do I ungroup worksheets from VB.NET?** I've tried both activating and … |
 | EDIT: links fixed Hello guys ! Alot of people today want or actually have a website. But do they really understand the possible risks and dagers on the internet? You can never know when hackers or other institutions will target you, and people do not realize that your personal information … |
 | Imports System.Data.OleDb Public Class LoginForm1 Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Try Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\Documents\VodStore\VodStore\bin\Debug\VodStock.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = '" & UsernameTextBox.Text & "' AND password = '" & PasswordTextBox.Text & "' …  |
| | hi, i have a datagrid which looks like: subject students eg1001 182737H 29837B 29837C 19282W eg1002 192837C 32810H so on and so forth. how can i do a counter and put into a column between subject and students? like: subject numberofstudent students eg1001 4 182737H 29837B 29837C 192823W eg1002 2 … |
| | Hello everyone! I would like your help regarding this: I have a tuple vector which i must iterate through, and accessing the vector data to decide wether to erase or not the current vector element. My code : typedef tuple <int, CString, int, int> pc_data; vector <pc_data> pc_vec; //Assume that … |
| | Hi guys, I am confused on how can I access a same class reference object , that is created in class ReadInoiceFile, and be accessed in ReadErrorFile. To be more specific: I have a class called Transaction And then I have a class called ReadInvoiceFile. And finally I have a …  |
| | Further along in this code I'm trying to access processRow, which is of type DataRow, but I get a RowNotInTableException This row has been removed from a table and does not have any data. In an attempt to figure out when this data is getting deleted, I added a bunch … |
 | The problem started with getting redirected when we searched with Google. So we tried other search engines which worked for a little while but now it doesn't matter which search engine we use. If you go back to the original search after you are redirected a time or two you … |
| | i want to retrieve data from Access table but i don't know where i am going wrong.here i am going to show my work which return errors:- Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset Public Sub procedure1() con.Provider = "Microsoft.jet.oledb.4.0" con.Open(My.Application.Info.DirectoryPath & "\Database1.mdb") End Sub Private Sub … |
| | Hello Friends I have a software developed in vb6.0 the software has few textboxes and we have to type in it and the query is fetched and matching result is displayed It uses MS Access 2000 MDB format Somehow i have managed to open the access file but when i …  |
 | Hey guys Im doing some testing on a few database conversions from MDB format to accdb. I packged up my files so when the exe was ran it would install MS runtime as well as the databases needed for the app. I was trying to get it so that I … |
 | I am trying to connect to the Ms access database using PHP. The database, that I created has '.accdb' as an extension. I tried the following steps. but I get this error "The specified DSN contains an architecture mismatch between the Driver and Application". Any ideas?? 1. Go to your … |
 | **Bold Text Here** hey any one can help me sort out my problem.. when i enter the customer id then in tabular format i want its all detail. how to do.. like in textBox i enter customer id as 1 then pressed ok button then in new frame or in …  |
| | I've built an application that displays the contents of an access database in a datagrid and also a form which allows a user to add a new record to the database. When I tried to run the exe in the bin folder on another computer it displays an error when … |
| | Hey guys Im doing some Research on the artical title. Im wondering if it is possible to have an Access database set upfor a company, but instead of installing microsoft office on every client machine, can you create an .EXE excutable file that will access the database that will be … |
 | I have the code below in VS 2012. It dynamically allocates a DataGridView and an Update button, then it binds the grid to MS Access database table. That all works well. When I click the Update button btnUpdate_Click() is called, which calls the DataAdapter's Update() method. That produces the syntax … |
| | I'm using VS 2012 and coding a try/catch block in an MS Access database project, but VS says OleDbException is not defined (see line 3 in the code). Anyone know why? I got some of this code from [here](http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/c822d48c-fd90-44a1-a186-a15e16966233/), and according to MSDN OleDbException is valid in vb.net Try data_adapter.Update(CType(binding_source.DataSource, … |
| | I have no idea why the program isnt working, its practically the same code I used in the last project so why wont the database update? The code for the program is as follows: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; … |
 | Ok, so I have 3 computers in my house. 2 of them have complete internet access, the otherone doesn't and I don't know why. Let's call this computer A. Computer-A can't access web pages (using let's say chrome or IE). However my router has it's mac in the connected devices …  |
The End.