[microsoft:access] Forum Topics

How to connect vb.net to access database and save all the informations within a form. For example, I have a form name:Form1. Within that form, I have textboxes for Firstname,Middle Initial and Lastname. And when I click the button save. All of the information will be passed to my access …

hi...i want to save the date from datepicker control to database access... i have coded everything except datepicker...its my 1st time to use this control.. thank you...

Hey guys I was hoping you help, I have a ms access database on my webserver. I want to select all the records with a certain date. But it seems not to work. [CODE] <CFQUERY NAME="qStuff" DATASOURCE="MyDb" maxrows="20"> SELECT * FROM Stuff; WHERE (((Stuff.RegDate)=#5/1/2004#)); </CFQUERY> [/CODE] When I do this …

Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …

The command FileSearch does not excits in ACCESS 2007, my code is as follow: How do I import this filein a different code? Public Sub Import_Labolink() Dim sourcefile, destinationfile, miscresults As String Dim i, N, m, o As Integer 'Dim mFileSearch As New myFileSearch ' New code for filesearch N …

Hi I have an Access 2003 database and website that im trying to code using VB asp.net, it's basically a book and toy library website and what i want to do is have a webpage of items with pictures and when the user logs in to the site, they can …

Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …

i use the access and find product but if there is many same product name how can ı list these please write for access database in c# my normaly codes are below [code] baglan.Open(); // Sorgu içinde urun isimli bir değişken kullanmışsın ancak değişkene değer atamamışsın. Sorguya null olarak giriyor. …

Hi All, I have a requirement to create n Access 2007 database & some related tables from my application at runtime. I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010. Any pointers would be gratefully accepted. Thanks Charles

Hi There, I am trying to get the Sum values of a Column and want to check if entered value in Textbox is valid. Here is my code below [CODE]mystr = ("Provider=Microsoft.JET.OLEDB.4.0;" & _ "Data Source=K:\Amrut Diary\Amrut_Diary\ADDB.mdb") con = New OleDb.OleDbConnection(mystr) con.Open() strsql = "SELECT SUM(Available_Stock) As Avstk FROM STOCKDB …

Hello anybody I am trying to update table to access database in vb.net after changing password. But I have a problem in update error as following [CODE] Dim dbCommmand As New System.Data.OleDb.OleDbCommand Dim DBConnection As New System.Data.OleDb.OleDbConnection DBConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\thaeaye\Documents\Testing.mdb" dbCommmand.CommandType = CommandType.Text dbCommmand.Connection = DBConnection DBConnection.Open() dbCommmand.CommandText = …

Experts, I'm new to VB and I'm trying developing a VBA application to send and receive data to an RFID reader and put the result into Microsoft Access. Project has: Mscomm command1 (command button) Text boxes (Text1, Text2) At this stage i have developed the following code. [CODE]Private Sub Command1_Click() …

hi dear i i have two columns in an access table, first column is of percentage and second is of result . i want that result should be automatically calculated as if the percentage is les than 33 then ruselt fail and if percentage is greater than 33 then result …

Hello, Please I need an efficient algorithm for ranking records in a database. I know sorting and grouping can produce record ranks, but I want a means of inserting the ranks beside each record as arranged in the table. For example: [CODE=text]This figures will rank 10 - 3 5 5 …

First time poster here... My VB.NET program compacts and repairs my DB, but somewhere in the process unsets the database password. No problem, just reset it through VB, right? Ummm... not sure how to go about that task. So I either need to know how to compact it without losing …

Good Morining All i have an asp.net hosted in IIS. that uses the Com library "Microsoft Word 14.0 Object Library". I am using this to convert the word Document to PDF, on my machine it works. I have Office 2010 on my machine and on the server we have installed …

Hi, I'mvery new to VB2008 and have basically no idea regarding much of coding. I have attached a copy of my form. Basically, I have a db named "employee.mdb" with table "Employee". It has 3 fields Name, Dept and Designation. I want to connect my db with the form and …

I have been fighting this but I am not winning. So far I have looked up a ODBC JDBC connection string to connect to my simple database to java without any success. Firstly; I replaced 32bit MS Access 2010 with 64x one. Secondly; I installed all available updates sp1 and …

hi can any body help me i want to insert to data base the record save into data access data but when return to data base the record not exit this my code [CODE]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; using …

Hi Im new here-I wanted to create a Login System. I am using Visual Basic 2008 Express Edition, Microsoft Access 2007/2010 Beta. Ok this is my current code-the main problem I have is that I dont how to compare what the user puts into the textboxes and then check that …

Hi guys.. I'm using MS ACCESS for my dbase.. i have a tblborrow where you can find transac_num ..now, i have in my form a label which here, you can see how many transactions you have done already(i'll name it sa lbltransacno) and a save button.. what i want now …

Hi guys! Any one have an idea of how to create a sub category in vb.net? well I'm thinking of building a sales and inventory system of computer parts and peripherals and here's the logic. I'll be assigning each of them category like for example: Componenets[INDENT]Peripherals[/INDENT][INDENT]Networking[/INDENT] - Processor[INDENT]- Chasis[/INDENT][INDENT] - …

Someone can gave me a code for search as u type searching from may MS ACCESS DATABASE Thx GOD SPEed :P

I'm a newbie in vb. My first project is a grading system for a certain school. In my login form, there's a [B]Forgot Password button[/B]. In the Forgot Password form, the user is asked to answer a secret question that he filled up upon registration, and if the answer is …

this a serarcing button for list on the data table but give an error please find this this work in c# with access [code] DataTable tablo = new DataTable(); tablo.Columns.Add("no"); tablo.Columns.Add("urun"); tablo.Columns.Add("model"); tablo.Columns.Add("adet"); tablo.Columns.Add("boyut"); tablo.Columns.Add("aciklama"); try { DataRow satir; satir = tablo.NewRow(); while (oku.Read()) { // here satir[0] = oku[0]; …

[CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New DataSet Dim da As New OleDbDataAdapter Dim cb As New OleDb.OleDbCommandBuilder(da) Dim cn As New OleDbConnection Dim cmd As OleDbCommand Dim sql As String 'sql = "INSERT INTO Employees(GivenName, LastName, Gender, JobPosition, Month, …

ı created a project in c # and it loaded to data in access but searching button doesnt work every time find the last loaded please find the problem [code] baglan.Open(); veri = new OleDbCommand("select urun,model,adet,boyut,aciklama from ogrenci where 'urun='" + urun + ";", baglan); oku = veri.ExecuteReader(); while (oku.Read()) …

Hi, I want to use a Word table to collect responses which I'll then put into Access. I want to use drop down boxes in the table to limit the input options but when I convert the table to text so I can then get external data in Access, the …

please help me out in updating a MS ACCESS database via vb.NET...I am in need of the code.Thank You

Q--> i have a [U]employee[/U] table which cantain following field (eid,enm,salry,did) and i need a list which has employeies complete information whose get minimum saler in each department *** only single list cantain all employee info whose get minimum salry

HOw can i store image in ms access database...plz suggest

hi friends.. i m working with vb.net how can i get iteams in combo box from table of msaccess.. hoping for help thanx

Dear sir, may i try to insert data in ms access database through vb.net.but display the error COULD NOT FIND INSTALLABLE ISAM ERROR.How to solve it pls help me.

Hello everyone! I have a problem trying to get a user to be able to query the database with only the fields and specifics they want. Basically... User logs in, browses through record entries and then wants to see how many of the entries are under the age of 21 …

Hi all, I have a Website developed by PHP4.3.2 and Microsoft Access2000 Database. The Site is running under IIS5 in Windows Server2000. Now I have changed the OS from Windows Server2000 to Server2008 and IIS is 7.5 here. I have configured PHP with FastCGI. But, When I run my site …

[CODE]Imports System.Data.OleDb Public Class frmlog Dim con As New OleDbConnection Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click If ask() = True Then MessageBox.Show("Success") Me.Hide() Form1.Show() Else MessageBox.Show("Invalid") End If End Sub Public Function ask() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) …

Hi guys, I'm finding myself in a little trouble. I've tried to google this problem, but without much success. Hopefully its something simple I'm missing and someone will be able to help me. I'm writing a little program that will synchronize two access database schema's. It works, to a point. …

I have 3 microsoft access databases all with exactly the same structure called Nimdas,Nimdas1 and Nimdas2. I can work on Nimdas in a program that I have written in VB2008. Now I want to flit from one to the other 'on the fly' using the same program. How do I …

hi friends,when i tried to open my Ms Access 2003 file in Ms Access 2007 .i am getting the following error .Kindly let me know the idea .any help would be highly appreciated. [code] This error can appear if you try to convert an Access 97 database to a more …

could you help me, please ! ... because i am newbie, sorry :) at form vb net 2005, i can browse file .mdb (C:\my documents\db1.mdb), I have created a table in sql server database, where table is the same as the access table that will be imported, after that when …

hello out there,,i'm using vb6 and need to use calendar control. I managed to import the calendar using projects-->ms calendar and i've placed it on my form. Now i need to add the dates slected onto my MS-Access Database. How do i do that?? the summary::: i need guidelines,codes,functions that …

Good day, I'm new and glad to be here, I just need a help with the my code can anyone help me find the main error with it? The JList is giving me hell and since I migrated to a new laptop I'm failing to establish a connection with my …

I am using Access 2007(accdb) And ADODC in vb form.In a given date I have a lot of credit entries and Debit entries in text boxes. Is it possible to sum all credit entries and Debit entries an find the difference in a given date by using vb code? Is …

Hello, my name is Heather - I live in Queensland, Australia. My hobby is to develop databases in Access and love to troubleshoot visual basic. Most of my time is taken running a coffee shop - which keeps me well entertained. :)

I am using Access 2007 AND Adodc. [Date] is a field in my table1.What is the code for getting a record on a particular date?

Hi I am new to .jsp programming. I wanted to create a simple web page to display some information from an access database, but unfortunately I keep getting an error that no data is found. I created a DSN source through the ODBC tool in Windows, and I feel I …

hi, i would like to ask where should i put my access database before publishing my application?? its inside my "windowsformapplication1" folder in project folder.. but when i publish it, there's no database in it. lol, already created an application yer doesnt know how to publish w database. :D thanks...

i'm not too familiar with java...though... actually i'm trying to insert the values entered by the user into the access table but every time i click the add button on my application it shows [I]java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. [/I] error... [CODE]String str="insert into …

please tell me where am i wrong [CODE]try { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into purchase(pdate,bill id,ritem,suppname,smobno,qty,rate,amount,payment,balance) Values('" + dateTimePicker1.Text.ToString() + "','" + textBox15.Text.ToString() + "','" + textBox7.Text.ToString() + "','" + textBox12.Text.ToString() + "','" + comboBox2.Text.ToString() + "','" + textBox14.Text.ToString() + "','" + textBox13.Text.ToString() …

in my access database the column "foods" has multiline text..but when i view it in datagridview in my c# form it only has single line text,,, the width and height in datagridview is not the same as in my access database... my access database looks like this [U]|primary key|[/U][U]|foods|[/U][U]|servings|[/U] 00000001 …