5,053 Topics
![]() | |
string location = Environment.CurrentDirectory; string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + location + "\\harita.accdb"; // get records from the Shippers table string commandString = "Select x from map"; //create the data set command object and the DataSet OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString); DataSet ds = new DataSet(); // fill … | |
Hello, Here is the scenario : I have the follwoing sales return from in my software:  In the from I have tow listview control, the left is Listview and the right is Listview1. I have the following code in procedure : Dim xsprice As String Dim xsprice1 As … | |
I have found the following post re this issue does any body have any idea which is correct [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Comdlg32] "NoFileMru"=dword:00000001 2.HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Value Name: NoRecentDocsMenu Value Type: REG_DWORD Value Data: 0 or 1 0 = Yes, allow recent docs 1 = No, do not allow recent docs Value Name: ClearRecentDocsOnExit Value … | |
i am tyring to create new project nemmed as car parking system please help to get the password and check the name in database and display the already gathered displays ........please help me ...........<snip> | |
I am trying to retrieve all the names of the mp3 files from my hard drive, heres the full code, what i am facing is "Access to the path 'D:\System Volume Information' is denied." error, but i have changed the manifest file as below [ICODE]<?xml version="1.0" encoding="utf-8"?> <asmv1:assembly manifestVersion="1.0" xmlns="urn:schemas-microsoft-com:asm.v1" … | |
Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there … | |
![]() | Hi, Here is the code I’m trying to execute using MS Access database to return a dataset. And i get the error "No value given for one or more required parameters". Public Class Main_Form Dim conn As New OleDb.OleDbConnection Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … |
Hello! I am currently developing a web interface that has access to an MS ACCESS database. However, I am unable to key in more than 6 Values into the database using the INSERT INTO sql code. Here are the codes that I am using: protected void bnAddPart_Click(object sender, EventArgs e) … | |
Good evening! I'm trying to figure out how to retrieve and display data from MS Access to my project's DataGridView. So far I have the codes to make the options for the CheckedListBox appear. SAMPLE: (Codes for other categories are not included since they're all basically the same) 'view client … | |
I've got 2 flex grids in one VB form and I wanna connect both of these Flex Grids to 2 different tables in MS Access. This is how my form looks like: http://i213.photobucket.com/albums/cc228/rose_408/form_zps100c290c.png Here's the code for the service flex grid (FlexService): Private Sub Form_Load() Set conn = New ADODB.Connection … | |
Once I have logged in, the "loggedIn.aspx" page is to display: IP Address: Contact: Date: I am able to get the IP address to display, but really have no clue on how to show both the username and current date. This was a conversion from .asp to c#.net Here is … ![]() | |
Ok, so my form displays an error saying "run time error. could not find installable ISAM." everytime i run it. And its pointing at "conn.Open" part of the code when i run it. heres my code: Dim conn As ADODB.Connection Dim rec As ADODB.Recordset Dim rec1 As ADODB.Recordset Dim rec2 … | |
I have found the following post re this issue does any body have any idea which is correct 1. [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Comdlg32] "NoFileMru"=dword:00000001 2.HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Value Name: NoRecentDocsMenu Value Type: REG_DWORD Value Data: 0 or 1 0 = Yes, allow recent docs 1 = No, do not allow recent docs Value Name: ClearRecentDocsOnExit … | |
connecting access 2003 database from remote computer .I have a vb2005 application which uses access2003 database. I want to connect to this database via remote computer connected via internet. | |
Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions … | |
Hi guys, I am building a program which has 5 forms, 1 mainmenuform with 4 buttons and each of them buttons have a form corrisponding to that button and this program is connected to my access database. The problem I have is I've put all my code into my first … | |
Hi Guys, Right... I've managed to run select statements with associated Joins to show the data I want in DGV's which is great. Seems to be working fine. I'm not to the point where I need to be able to Insert, Update & Delete Rows in my Database. I am … | |
I want to access some data in an Access MDB but I want to make sure that nothing can be accidentally altered. I have tried: conn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB;Mode=adModeRead;") I've also used conn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB;Mode=Read;") I then run a quick UPDATE WHERE query and it still alters … | |
Hi guys i have this code which insert the data in the textbox Dim FilePath As String = "C:\Users\ezekiels\Desktop\New Folder\EBU 6.mdb" Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FilePath & "") conn.Open() Dim myadapter As New OleDbDataAdapter("SELECT * FROM Table_EBU6", conn) Dim dtset As New DataSet myadapter.Fill(dtset) myadapter.Dispose() Dim table … | |
OK, I've exhausted my searching, so if someone can point me to a link with a good example, that would be super. I'm simply trying populate a combobox with data from an Access table (it's a simple contact list with Name and Number). Every example I find and try, I … | |
I have just tried to access http://blog.seorevolution.com/2013/01/24/5133/ and get the following: Forbidden You don't have permission to access /2013/01/24/5133/ on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.5 Perl/v5.8.8 Server at … | |
Hi people, I would like to learn how to create database applications which store the data entered by multiple users, process the data, and provide the data as requested by the user. Is it possible to write such an application by using Microsoft SQL Server and Microsoft Visual C#? I'm … | |
<?php //session_start(); include("connection.php") ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Hedgeis-market</title> <link href="market css.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="jquery-ui.css"> <script src="jquery-1.8.3.js"></script> <script src="jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css" /> <!-- <link href="marnet_internal_css.css" rel="stylesheet" type="text/css" /> --> <script> $(function() { $( … ![]() | |
As title show. I still not able to connect my ms.access login database . Please help me ~ Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\leong\Documents\Visual Studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.accdb") ' Dim cmd As OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username ='" & Usernametxt.Text & "' AND Password ='" & Passwordtxt.Text & … | |
Hello Community, I was wondering if there is a way to access SkyDrive using php i have looked at so many forums and i could not find anything and what i did find was too complicated to understand, what i want is a way to create files or folders, get … | |
I'm trying to search on how to store the image in a local folder and save its path and filename in ms access using vb.net but a lot of topic makes it more confusing for me. I'm just a student and working on my baby thesis. I'm currently building an … | |
I'm trying to be clear about registry, and would hope someone might confirm, or not, that my interpretation is correct. I read [here](http://msdn.microsoft.com/en-gb/library/windows/desktop/ms724072(v=vs.85).aspx) > The parent of each 64-bit registry node is the Image-Specific Node or ISN. The registry redirector transparently directs an application's registry access to the appropriate ISN … | |
Hello Community, I was wondering if i can get some help with the 4shared php api. [Here](http://www.4shared.com/developer/docs/samples/#PHP) is a sample on how to upload a file. But now i need to know how to delete a file, by the way i have never used an api. Please Help... | |
Please help me solve these errors that I usually receive. I've created an application that reads, updates, and inserts a record into an Access database. But every time I press the **Update** button to update a record, I usually receive this error message "**Syntax error in UPDATE statement**". On the … | |
How can i link database from microsoft access 2003 with VB.NET? can i use anything from eg. Form1 and display them on Form2? thx u very much. | |
Hey guys, I just got a HP Pavilion dv6000 a few weeks ago with Vista Home Premium already installed on it. Im having some trouble getting my wireless connection to work. It worked once for a few hours but then just decided to stop. When I plug in my ethernet … | |
Hello everyone. I am trying to build a inventory and pos software with vb 6.0 and MS-Access as database. In one of my form I have the following code to call my inventory of a certain invoice number to print tag for my products. I am using a MSHFlexgrid with … | |
Hello experts i am using following code in order to truncate a ms access table Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" Dim query As String query = "truncate table tbl" rec.Open query, con, 2, 3 con.close but its producing … | |
Remember when you had to use a whole host of 'utility downloads' just to keep your PC running smoothly? Windows has had optimization tools built in for ages now, so surely the days of PC optimization suites are long over? Not so according to iolo, which has just released System … | |
My project compiles fine, but when running a push_back on a vector, I'm getting an access violation when the vector attempts to resize itself. I have lots of code, but hopefully I can boil it down to just relevant classes. I am sorry about the HUGE amount of code, but … | |
I have a volunteer database and having trouble with genuine password protections. I have a "delete" button with this current code under Build Event: Private Sub delete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Delete this VounteerRecord. Are you sure?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand … | |
Hi, Could anyone solve this for me. I'm using VB 2010 and Access Database file. The database consists of a table called 'usertbl' with 'username', 'type' and 'level' fields. The records are as follows: Record 1 - Username: admin Type: admin Level:1 Record 2 - Username: user1 Type: user Level:2 … | |
Hi I once went for an interview before my previous job it was a practical interview and I was asked to determine and fix a number of problems and I cant for the life of me remember what was the fixes so was wondering if you guys could help: **the … | |
Microsoft Office VBA is a language many of us love to hate. I am no exception, but I know better than to kick the cash cow that feeds me. As it is, the grand and spacious realm that is DaniWeb lacks a VBA forum. There's VB.NET, VB4,5,6 and Legacy Languages. … ![]() | |
I have a calculated field that takes the ID field of a table and pads it with leading zeroes. So far, I've gotten this to work: `String$(4-Len(Trim$(Str$([ID]))),"0") & Trim$(Str$([ID]))` Broken down, it takes the ID field, and string-ifies it. For some reason, this pads it with a space, hence the … | |
hi I have an access database, which I connect it to the form I have text boxes which displays info from the fields in the database. I have created a "Next", and "Previous" button, which the user can move between the database info but i don't know the code for … | |
I'm creating a password protected Volunteer Database and everything is going well. I have created a 'password protected' form before entering the hidden database(seperate form). How though am I able to prevent a 'user' to find out the password by going through "Build Event" in Access? | |
hi friends. i want to add a picture a picture in crystal report from database at runtime and show in crystal report using VB.VET . i'm using Microsoft access database, visual stodio 2010 and SAP crystal report 2010. please help me i m so abset. | |
Hi, I have a database (OLEDB) on which i perform operations like insert, delete and update. When i carry out these operations, the changes are reflected in the database during runtime but when i close the form everything goes back to normal. How can i get these modifications to relfect … | |
hi. my name is Marvin, from Australia. i am totally blind. i use a screen reader called Job Access With speech (jaws), right! a picture of a shark. from http://www.freedomscientific.com. okay here's my review of jaws 14. some of the new features i use include, when you can not read … | |
I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a … | |
Hello everyone. I am developing a inventory and pos software myself with vb 6.0 and ms-access as database. In my sales invoice I want to generate the sales invoice number serially. I mean when I load the sales invoice form the txtsinvno text box will automatically generate the sales invoice … | |
Hello, I have been struggling a little bit with an issue in a relational database that supports queries. Originally I was going to use an OleDB data adapter and connect to an Microsoft Access database (created with Access 2000). The problem is that when I use a connection string like: … | |
Good day Geniuses! I am a beginner and would like to ask for your assistance regarding my Javascript not working ONLY in IE :( I dont know where to start debugging since I only use Chrome and Firefox for testing. Hope someone can help me on this. Javascript <script type='text/javascript'> … | |
Are you a freelancer or programmer for hire? Join, post & bid for projects free. Thousands of skilled programmers, skilled freelancers to choose from. Ultracoder is a developer oriented outsourcing site. Skilled programmers will bid to complete your project right now. Computer Based programs, Training, Web Services, Language Specific programs, … ![]() |
The End.