[microsoft-access] Forum Topics

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 …

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 …

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 …