1,597 Topics
 | |
 | 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 …  |
| | 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 …  |
 | 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 … |
| | 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 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 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 …  |
| | hello, i am trying to save data in my listview item to access database.. i am new to programming and i am currently working on a project i need to submit very soon, this is really urgent and i will be much happy if i could get assisted as soon …  |
| | I am trying to create a form that allows the user to search (Access database) for a record by last name or customer number. It can be a partial last name or customer number. The SQL statement and code are below. This is the same method used successfully for a … |
| | Hi all, We use a .hta vbscript from a fileserver, but after office 2007 has been intalled, the script does not read/write from/to a .mdb file on that same fileserver. The script does work (with office 2007), if it is started from a desktop instead of the fileserver. (reading/writing the … |
 | I am moving from database from Microsoft Access to MS SQL and I have not worked with MSSQL before, can you recommend a good place to get some initial and then follow on training in SQL and MS SQL?  |
| | Hi, I am currently migrating access programs into vb.net with t-sql database backend. I am having 400000 rows of data that I have to pass into recordset and display it on the grid. In the good old access, the data appears almost immediately. Because access does not wait to load …  |
| | Hi, it's a very simple question, but I cant see how to solve it! I'm doing a web form, I have a button inside a table, the thing is, I can't access to the code of this button, Usually you just double click on the design view over a button, … |
| | Hi All, How can we set a value to iframe textbox element either in JS/Jquery <head> <script type="text/javascript"> function load() { alert("Frame is loaded"); myframe.document.getElementById("user_email").value = "<?php echo $var ?>"; } </script> </head> <body> <iframe onload="load()" id="myframe" name="myframe" src="http://www.gigpayrr.com/signup" width="700px" height="600px"> <p>Your browser does not support iframes.</p> </iframe> </body> |
| | hi friends! From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document. please give me … |
 | Please help me im new in making database i dont know what tables will i create and its content pls.. 1. Develop a database design for a Student Attendance Management System. Create an ER Diagram to illustrate the relationship between the entities in your database. Below are the suggested list … |
| | Hi, Have been using the same database for years without any trouble. Suddenly we are getting the Data Type Mismatch in Criteria Expression when we attempt to run a VB function. I am not familiar with VB so much, but have found where the error is happening: [CODE] Private Sub …  |
 | hi i m making a c# app which reads data from ms accesss & display it in textbox i have tried the following method but that didn't worked suggest me smthing or correct my code pls myconn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\nature bliss\Desktop\Stock\section1.accdb;Persist Security Info=False"); try { OleDbCommand cmd = new … |
| | I have an access database which I am using with .net, I can search tables and maker very specific searches no problem, trouble is that I can't work out how to make global searches. IE search entire databse for "fred" or search a single table for "fred". Anyone know what …  |
| | I have a problem with retrieving data from access databse. I make the connection and retrieve the data no problem. But when the data changes from another use of the database, I cannot get the new changed data without reloading the complete programme. Even repeating the load functions does not … |
| | Hello guys, I have a school assignment and I need to develop a site with Microsoft Access database, but I have no clue how to set up and use that database, I searched eveywhere on the internet and I haven't found anything concludent, all explications are foggy and I can't …  |
 | i am using "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\My PC\Desktop\MOMS 3\MOMS2\WindowsApplication2\MOMS.accdb" This is the path to connect with the database. can you one tell me any other way i can use instead of this. I want to use the program on other computers. I tried "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|Data Directory|\MOMS.accdb" and "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & application.startuppath & … |
| | I do not know if I am on the right track or not, but I have hit a dead end. I have read and reread my books chapters about super classes and inheritance and am still completely lost. in this assignment I have to: **Write a super class encapsulating a …  |
| | I have a warning that I can;t get rid of: Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated. I am pretty sure it is becasue I have not dimentioned the variable but how do you dimention an IO.memorystream. … |
| | Hi Guys... Putting together a Tiny little app which shows VPN Details for use 'In-House' but for some strange reason my DataSet won't fill? Can anyone spot the mistake? :S private void Form1_Load(object sender, EventArgs e) { //XML Load of Document. This loads the XML Document and the value of … |
| | I am developing a VB6 application which connects with an Access 2010 database. I want the application to execute queries stored in the database. Some of the queries include Access functions in field names. For example- FieldName: IIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName])" Is there a way in VB6 to execute the queries natively in …  |
 | I have a 3 columns in my MS access database namely ID, Name and Type. The Types are Driver, Conductor, and Inspector. I want is i click a button, all names in column "Name" that is classified as Driver will be the items of my combobox, also the other two. … |
| | **I am building a hospital managment system as a practice in visual basic. I am having some problem I want to write or read data from particular row or column with visual basics How do I o it? Thanks in Advance -Hassaan bin Jalil** |
 | just want to know the correct synthax for creating a table in access database using vb myqry = "CREATE TABLE HoldInvoide'" & k & "'(Barcode varchar(20) not null Primary Key, ItemName varchar(40) not null, Quantity int , Price double, Total double)" k is a variable i want to create a … |
 | i need some help how can you save the item in my textbox to the access database? For example i have Firstname.Text Middlename.text Lastname.text if i click the add button it will save it to my access database and also if i want to edit it and update it, how … |
| | I've been battling with this for the pass few days. I have an access03 database that is used to track training that we give to employees. i had a form that has, the training info and then a subform that lists all the attendees and their scores. Now I was …  |
| | Hi i wonder how can i delete my data using access as my database? for example i want to delete Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConAccessDatabase & "';") Dim cmd As OleDbCommand cmd = New OleDb.OleDbCommand("delete * from [" & EBU2DB_LOB & "] where Brand ='" & … |
| | 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 …  |
| | 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>  |
| | 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 … |
| | 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) …  |
| | 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, 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 … |
| | 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 …  |
| | 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 …  |
| | 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 … |
The End.