[microsoft:access] Forum Topics

Hi To All, Once againg I'm in a big problem. I'm using C# 2008 and Access 2007. My DB contain 2 tables Customer and Booking. Both having Relation on CustomerID column. Customer -> CustomerID (PK) and Booking -> CustomerID(FK) Now I want to display the few columns from Customer and …

I'm trying to create a database to store product and customer information. An item have many batch numbers (batch ID) a batch number can only belong to one item an item can be in many products a product contains many items an order can contain many products a product can …

This is the syntax i have written in vb.net to compare the text entered in textbox with the database. If existing, the value will be entered in databse, if not, it will give a msgbox displaying to add a new contact. I am new in vb.net. The database is Ms …

Hello !! I am trying to implement datagridview using b.net and ms access. While I import the data from database, the connection is established and test connection succeeds. But, during the last phase, i get an error saying : Could not load type 'Microsoft.VisualStudio.DataDesign.SyncDesigner.syncFacade.SyncManager' from assembly 'Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage, version 9.0.0, Culture=neutral,PblicKey …

Does anyone have any experience using curl from MS Access. I would appreciate some pointers,

Hi, I am trying to query a database to retrieve information about a product. Firstly the user must select a product from a Combo box, and what i want it to do is when they have selected a product for it to search for the items that are within the …

Public Class Form1 Inherits System.Windows.Forms.Form Dim con As New OleDb.OleDbConnection Dim dbprovider As String Dim dbsource As String Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim run = New OleDb.OleDbCommand Dim sql As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load dbprovider = …

How can i compile my application so the access database is inbuilt in the executable file so i can use it without installing microsoft office.

hi i'm making a little application in vb.net and i need to use a data base. so i used some of my aspx functions and the same data base. the problem is that every time i run the application and do something that needs to get values from that db …

Hello, I developed a vb.net application using Ms-Access 2007 as backend. Now can i deploy this application in a machine where Ms-Access 2007 is not installed. Is Ms-Access runtime necessary for running the Apllication in machine not having Ms-Access 2007 installed?

Hello, I need help I'm making a thesis about a business which is a pet shop. All i can think is all their transaction are recorded in the MS Access. Also recording all the details about the animals such as their habitat, food proper grooming etc. but my professor said …

I have one access database and one windows form. I have some text field and one picture box. I want to Store some data and image into my database, i have written following code to do the task but it says "Syntax error in Insert into statement". I am pasting …

-- hello there!, here i am again asking for some help... i want to retrieve my data from my ms access database and i it gave me this error.. [COLOR="Green"]"Index was outside the bounds of the array."[/COLOR] ------ can someone help me about this?.. i put my code on my …

Hey guys I'ld really appreciate if u can help me with this. I'm building an application that has an access database for storing codes for voters. my problem is that after i update my database with the usual vb codes, i'll have to exit the application before the datagrid view …

I have a datagridview which retrieve data from my ms access file also I hid the primary key. If I added another row and used da.Update(dt) it gives an error because the primary key is empty. now I have a separate textbox for that primary key how can I update …

I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database.

Hi, I wrote a vb script in text file to send an automated email as a reminder to 36 recipients. I'm loading recipients from access database. I can send out email when i tried with test db, whereby there's only one recipient for each category (TO, CC, BCC). However, i …

I just want to know about the new extension in Access 2010. I need to create a database with .mdb and I can't do it with Access 2010 'cause the new extension is .accdb or something like that (I don't remember :$) As you can see, I don't use it …

Hellow everyone Could somebody show me some code Searching/Finding record on a Database Access. example when i type in textbox1 the last name and first name all the record will be displayed on datagrid and when no record is found it will generate message that the record dont exist. Plss …

Hi, I want to make a report of several fields - however, rather than showing each record for each field I just want to display totals. Given this I think it would read a lot better if I had the field headings in one column down the page, so it …

What is wrong with this code in IE, rest of the browsers its working fine, but when it comes to IE, it gives an error popup, Access is denied. Can some one help please. [CODE] var IE = false; if (navigator.appName == "Microsoft Internet Explorer"){IE = true} if (!IE){document.captureEvents(Event.MOUSEMOVE)} document.onmousemove …

I have 2 table [EMPLOYEE] Emp_ID Emp_Name [ATTENDANCE] Emp_ID Emp_Name Time_In Time_Out How do I display it like this. I hope I present this right [CODE] +--------++----------++---------++---------+ | Emp_ID || Emp_Name || Time_In ||Time_Out | <---- FROM ATTENDANCE +--------++----------++---------++---------+ | 1 || Josh || || | <---- FROM EMPLOYEE +--------++----------++---------++---------+ …

Login form contain two nos.of textbox anb one no.button How to connect VB.net2008 with MS-Access-2007.

I have been trying to run a command from the SQL view I'm getting a syntax error [CODE] CREATE VIEW TopLevelCust AS SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit FROM Customer WHERE (((Customer.[CreditLimit])>=10000)); [/CODE]

Hi I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it. Tanks in advance

i have a case study about election aND i want to make a election that can call a picture

I got many things try but it always an error somebody know this problem? i want to delete all data using only one command button. :(

i have ADO connection in MS Access, when i tries to execute con.execute command, MS-Access gives error like MS Access encounter serious problem and needs to be closed. any help or suggestion. thanks in advance

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 …

guys can you please help me in displaying columns from my ms access table to a listview in vb.net.. i use oledb in connecting to ms access..

DATA TYPE MISMATCH ERROR CRITERIA [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text <> " " And TextBox2.Text <> " " And TextBox3.Text <> " " And TextBox4.Text <> " " And TextBox5.Text <> " " And TextBox6.Text <> " " And TextBox7.Text <> …

Please tell me that in Html website what is the code in javascript to connect to a MS Access database that is hosted on NIC Server. If not so possible in javascript then any other option what can added in HTML website

im tr table only 2 column exist , first1 time period of text type nd 2nd is rate ,i.e also text type,my code is [code] try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:DRIVER=Microsoft Access DRIVER (*.mdb);DBQ=trrelation.mdb"); String tp=(String)mTimePd.getElementAt(cTimePd.getSelectedIndex()); PreparedStatement ps=con.prepareStatement("select Rate from tr where TimePeriod=?"); ResultSet rs=ps.executeQuery(); ps.setString(1,tp); while(rs.next()){ tRate.setText(rs.getString(2)); } con.close(); } …

Hi Everyone, I am writing a program in VBA (within Access 2010) that grabs a specific .txt file, split up the fields as per given specification and imports the values in to an Access table. So far, I can open the file and see what the program is seeing and …

I need to update a column in access where I should be removing the 7 leading characters in a field.Example: Column value before: AB34567213. Colum value after: 213 So, I tried using VB in Access and this is what I got so far: [CODE]Private Sub delete_leading_chars() Update table_name Set col_name …

Hello How can i save an MSFlexgrid to microsoft acess database ????

Hello to all java programmers I have a java database problem specifically the auto increment. In my MSAccess I have a table named "[B][COLOR="Red"]Confirm[/COLOR][/B]" and in that table I got two fields, the "[B][COLOR="Red"]confirm[/COLOR][/B]" which is set to text and the "[B][COLOR="Red"]id[/COLOR][/B]" which is set to auto number or auto …

hi everyone i am 19 years old and have just finished ICT level 2 at college and have this great idea for a website but looking into it seems i need a database driven website and im nowhere near smart enough. ive played around with microsoft access and notepad and …

hi there, can anyone please help me how to insert, search and delete a picture in vb.net and Microsoft access 2007? A picture that will be store in access is inserted in a form or a picture box. But it seems i have the wrong codes.. and when i click …

Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes …

a

Can anyone help on how to show a message box showing that existing record has been entered in database if i tried to enter the new record. However, if the input is new record (record added), the record is saved into the database. I'm using visual basic 2008 and Microsoft …

Im using Microsoft Visual Studio 2010 Microsoft Acess 2010 This is for practice Lets See First off i was able to get to insert records(Code Below) Now im trying to get the program to prompt a message when the id or field exists on the key down event and not …

hi. i have a main form and log-in form. when i try to log-in and entered a wrong user or password it gives me error and i dont understand why the error is in the main form??? heres my code in my login form.. [CODE] private void Lgbtn_Click(object sender, EventArgs …

ı want to update datagritview in c# . ı need to this codes.firt ı use edit and ı will edit after the termineting ı click save how can ı write ı use the access database my last codes but can not work urun = comboBox1.Text; boyut = comboBox1.Text; model = …

Below is my code connection to my database..I highlight with red color my target database. And I would like to ask, what is the safest way to target the database. Because Im thinking, what if my database is change to another directory. If that happens, it will cause trouble to …

Hello, I want to run a java project but I can't run it . you can download here : [url]http://www.persiangig.com/pages/download/?dl=http://fatima10.persiangig.com/document/bankapplication3.zip[/url] The error is : Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: Uncompilable source code - cannot find symbol symbol: class ResultsModel location: class bankapplication3.Display2 at bankapplication3.Display2.<init>(Display2.java:35) at bankapplication3.Database.<init>(Database.java:9) . . . I'm …

Hello community, I wanted to see if the following scenario would be possible with VB. We have 13 different locations. What I want to do is open an access database. I want to open a table in access and sort it by a particular column by date. Once sorted I …

i want a code to connect the access database 2007 in vb.net i made login form having 2 fields name & password also made an access database having nameid and pwd as two columns,table name is Reg and access database file name is also Reg

I'm still pretty new to this and I need some help. Here's the situation. First the user opens a form to select which database (one of 3) they are working in. Then they will be using several forms. The same set of forms are always used no matter which database …