Hello, I am facing a very little problem but I am totally confused how to resolve it I have two tables in my access database which have similar items in it from the first table i.e **tbl_reci_inds** I have selected **reci_prod_code** which is a product code, also in this table this product code is used multiple times for different items e.g. +----+----------------+-----------+----------+ | ID | reci_prod_code | reci_inde | reci_qty | +----+----------------+-----------+----------+ | 74 | 123518233 | hello | 15 | | 75 | 123518233 | New Item | 80 | | 77 | 123518233 | Egg | 1 | …

Member Avatar
Member Avatar
+0 forum 2

Dear all, I have created project database in msaccessdatabase. It contail ![Msaccess.jpg](/attachments/large/4/a91d2278c08f244b439891bcf7c3b36e.jpg "align-center") form layout as shown in image & i have attached code for reference Imports System Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'Project_DatabaseDataSet.Project_Data' table. You can move, or remove it, as needed. Me.Project_DataTableAdapter.Fill(Me.Project_DatabaseDataSet.Project_Data) Dim dt As New Project_DatabaseDataSet.Project_DataDataTable For Each col As DataColumn In dt.Columns col.AllowDBNull = True Next Me.Project_DataTableAdapter.FillByMountingType(dt) cbo_MountingType.DisplayMember = "Mounting Type" cbo_MountingType.DataSource = dt End Sub Public Sub BindCombox() BindComboBox1.DataSource = Project_DatabaseDataSet.Tables("Mounting Type") BindComboBox1.DisplayMember = "product Name" End Sub …

Member Avatar
Member Avatar
+0 forum 1

Dear all, I have created database like this. I have 2 manufacture . I would like to create 2 combobox. COmbox 1 -> Manufacture list combox 2 contain -> model no Can some one share example code where it explained. if particular manufacture selected display only his model in combobox 2. Based on manufacturer & model no. datashould be loaded into further calculation. if manufacture1 clicked model relevant to manufacture 1 only displayed. Similarly for manufacture 2

Member Avatar
+0 forum 0

I have created an MS Access Query named **GetContactCategory** select GetCategoryNames(contactId) as CategoryNames from Contacts The Function **GetCategoryNames** is the function written in a module of same database. Now when i call this query in my c# application using ADO.net it throws error. Following is my c# code ` using (OleDbCommand cm = new OleDbCommand()) { cm.Connection = AccessConnection(); cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "GetContactCategory"; cm.Connection.Open(); using (OleDbDataReader reader = cm.ExecuteReader())//This line throws error { //some code } } ` The error which is get Undefined function '**GetCategoryNames**' in expression. what is the problem and whats the solution.

Member Avatar
Member Avatar
+0 forum 1

A question for VB.NET - Access DB folks here, although some might consider a strictly DB question. Is there an order of operation when a SQL query 'does its' thing' relating to the 'WHERE" clause with multiple parameters? In other words, could you rearrange the elements [filters] of the WHERE clause to enhance the speed. I have a query that just seems slow; it responds with the answer in 1.3 seconds...but that's not really important here. I'm not being sexiest here; just thought this illustration was easy to imagine. With all else being equal, and in a normal coed college …

Member Avatar
Member Avatar
+0 forum 1

i am developing a project in c++ and i need database to save details.i googled but so far have bot come across a good tutorial for c++ database . most of the articles i have found are obsolete. please suggest what are APIs for database in c++?

Member Avatar
Member Avatar
+0 forum 3

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 control panel and Open the Administrative Tools icon in your Control Panel. 2. Double-click on the Data Sources (ODBC) icon inside. 3. Choose the System DSN tab. 4. Click on Add in the System DSN tab. 5. Select the Microsoft Access Driver. Click Finish. 6. In the next screen, click …

Member Avatar
Member Avatar
+0 forum 5

**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 its self window i want customer id 1 only detail not others detail.. how to do any one having any idea related to these... thanks in advanced for the help ??

Member Avatar
Member Avatar
+0 forum 1

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>

Member Avatar
Member Avatar
+0 forum 2

hello :) i'm developing an app in VS 2010 C#, linked with an MS Access Database. i want to use a table name as variable. i have tried: [CODE] string tblname = students; string query = "select * from '" + tblname + "' where rollno=123"; [/CODE] but it's not working :( kindly guide me. thanks :)

Member Avatar
Member Avatar
+0 forum 1

Hi! I'm having a bad time on learning how to store and retrieve image files on MS Access. This is some sort of uploading profile picture thing in my software. The open file dialog stuff and the storing of image file in the MS Access Database are taken care of but I don't seem to be able retrieve it. I'd like to retrieve the image and load it into a picture box. By the way, if you guys can also give me some sort of good references that explains briefly how do you store and retrieve files in MS Access, …

Member Avatar
Member Avatar
+0 forum 5

Hello friends, I am new to Jsp Here am facing a problem while trying to retrieve the data from ms access db using student no(number) form.jps ========= [CODE]<html><head> <BODY style="background-color:SteelBlue"> <center> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <form method="post" action="search.jsp"><h3> Enter Ur Number: </h3><input type="text" size="3" name="no"><br /> <p><input type="submit" value="Submit"> </form> </center> </body> </html>[/CODE] ============ search.jsp ================================ [CODE]<%@ page import="java.sql.*" %> <html> <BODY style="background-color:SteelBlue"> <form> <table border="1"> <tr><th>No</th><th>Name</th><th>qual</th></tr> <% int num=Integer.parseInt(request.getParameter("no")); // no is student id taken from form.jsp eg no=1 //String num=request.getParameter("no"); //int x= Integer.parseInt(num); %> <% Connection con=null; Statement stmt=null; ResultSet rs=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("Jdbc:Odbc:student"); //out.println("connection ok"); String …

Member Avatar
Member Avatar
+0 forum 4

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 ViewToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ViewToolStripMenuItem.Click Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim ds As New DataSet Dim dt As New DataTable Dim da As New OleDbDataAdapter Try cn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=I:\doc_cntl\Doc_Control Lists\MS Access Logs\2009 MDL_be.accdb;Persist Security Info=False;") 'provider to be used when …

Member Avatar
Member Avatar
+0 forum 3

I'm making an application associated with MS access for its database... I set one of the field to text and the other to object for images..but the object suggest to insert pictures through paint.. [COLOR="Red"]Is it possible for animated images(gif) in ms access? I'm getting stuck with bmps... [/COLOR] -------------------------------------------------------------------------------- I have a datagridview(MSACCESS) one column for text and one column for image. so that each text has a corresponding image.. [COLOR="red"]is it also possible to store songs in access so I have a row of text,image and music file?[/COLOR] I used the random function so that I can access …

Member Avatar
Member Avatar
+0 forum 3

I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates OK RelatedLocationType - string length 4, not required, not indexed RelationshipType - string length 1, not required, not indexed. From Java, I check first to see whether the entry exists, then try inserting it if it doesn't. This is why the SELECT, which has no problems, immediately precedes the INSERT. …

Member Avatar
Member Avatar
+0 forum 3

Hello Every one! i'm trying to encrypt my ms access database using the encrypt tool in ms access2003. After i encrypt it, i want to decrypt it, using visual basic so that i could run my visual basic forms. Can somebody help me how to do it? Thank you very much in advance!

Member Avatar
Member Avatar
+0 forum 1

I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the application's folder while it loads up. As a convenience, if the database file is not found, then the application creates a new (structured, yet empty) database. The creation of the actual *.accdb file and the creation of the tables is complete and is also working well. What I cannot figure …

Member Avatar
Member Avatar
+0 forum 1

I made a query for inserting a value from text box to MS ACCESS db [CODE] sql = "INSERT INTO Equipment (port_number,display_name,equipment,tonnage,user_privilage) VALUES (" & CLng(txtPort.Text) & ", '" & CStr(txtDisplay.Text) & "', '" & CStr(txtCA.Text) & "', " & CLng(txtTonnage.Text) & ", '" & CStr(cmbUser.Text) & "')"[/CODE] Actually I meant for inserting the data entered in the text box, but now saving is the code itself i,e; in port_number column 'CIng(txtPort.Text) ' will be saved I dont know what's the problem Please help me

Member Avatar
Member Avatar
+0 forum 3

I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep Master 2 has Name, manager, zip So, I need UPDATE the records as per: From master 1 to tb1 with the client index (auto increment), name, details. From master 1 to tb2, salesrep, tb1.clientindex, where tb1.name=master2.name if not found, create a new record update tb2 set clientindex=tb1.clientindex, update tb2 set …

Member Avatar
Member Avatar
+0 forum 1

Hi all :) I'd like to make a little vb.net program that executes searches on a msaccess database. I use a textbox to get the value to search and than i'd like to search all the values that has the textbox value in the middle. So, the queries should look like this: SELECT Rec1, Rec2, Rec3 FROM Table1 WHERE Rec1 LIKE "*" & txtTextBox.Text & "*" My problem is that i don't know how to pass the "*" character to my query, if I build a string that i pass to OleDbCommand(), the query returns nothing *PS I use OleDbCommand …

Member Avatar
Member Avatar
+0 forum 2

please guys... help me to connect a textfield on my mobile app to be connected in ms access... thanks alot :)

Member Avatar
+0 forum 0

The End.