[microsoft:access] Forum Topics

I have a small project in c# and ms-access I use query builder to manage my tables in ms-access. the problem is, select qeury works great, update query works great, delete doesn't work , and there is no error msg!!!!!!1 please help!! [CODE] OleDbDataAdapter adapter = new OleDbDataAdapter(); string queryString …

well, am glad i could make it to be part of daniweb. Am a second year student in the university studying IT as a program. i live in Finland. Some people may ask how did you get here Emmanuel? well, i say through search. Its all started when i was …

Hello, Being on Access, I would like to transfer some data onto Mysql. But I cannot. Is there an easy way to transfer data onto Mysql? I am thinking that it should not be that hard to do. Thanks for your help.

Hi I am trying to open a MS Access db via CommonDialog1. All is fine untill I click OPEN after selecting the db I want. What I then get is a dialog for ODBC entitled SELECT DATA SOURCE with two tabs: File Data Source or Machine Data Source. If I …

Hi everyone, I don't understand why this doesn't update my actual MS Access 2003 mdb file. During debug phase, I learned that it updates the dataset and creates new rows. But it doesn't reflect into the database. Why is it so? Please help me out. Thanks in advance.[code]else { //Auto …

I have a customer form, connected to an orderform with an order details subform. I want to select a customer record in my customer form and click a button (that I have setup) and it opens that customer record (using customer ID) in my order form. I created a button …

Hi, I recently imported about 18,000 records from filemaker into access. I initially exported the data as a csv file, i then opened it with excel and saved it as an xls spread sheet. Once i cleaned all the data i proceeded to import it into access, however i now …

I am trying to capture the COUNT of employees who are off by running a query from a table that has employee name and START DATE and END DATE of their vacation days throughout the years. I need to pull all employees who are GONE over a period of DATES …

OK I have an assignment on my Access course, I find this site really good and require some help if possible. Basically I have a login screen which checks the Access Database I am using the code I have is this: [code] Username = txtUsername.Text Password = txtPassword.Text 'Following code …

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 …

Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has …

I've written a VB 6.0 program that runs over Access 2003. I don't have any problem reading to or writing from the tables except in one table and one of its screens. When I initially create the record, there's no problem. But when I retrieve the new record (into a …

Hi, I've got a bit of a problem with an application I am writing at the moment. I know it has to be something small which I'm missing, but I can't figure out what it is. Basically, I have a Query (or Stored Procedure if you prefer) in an Access2000 …

Where should i store MS Access database after publishing my VB.NET Application. Database in bin folder before deployment. I am using connection string. Thanks

Hi all, How can i convert the excel worksheet into MS Access database, such that all the fields & data of excel becomes the fields of database, and then i could use that database for adding new item, modify and delete. I want to do this so as to avoid …

Hi there. Any idea on how to create a connection to microsoft access with C# to asp.net so that we can retrieve data from data base and compare. Using web application.

Hi all, I am having an issue with a form in Access 2007. I have a form with several combo boxes on it to allow the end users to select the name of a twon, the state it is in (in case there towns with same names in different states), …

I am having a problem updating an access database with new information from an updated dataset. the database consists of 4 columns: User_ID, Login_Name, Password, Access. The following code makes a connection to the database, fills a dataset with the data from the database, reads a txt file with user …

I am attempting to use VB2008 Express to Display, Edit, and Append an Access database. I can display information fine, but for some reason updating the database is posing an issue. The code below runs fine and doesn't throw any exceptions. However the Access database itself does not update. When …

Hi All, I have to convert Excel data to MSAcess .MDB file using VB.NET. VB.NET Code read the Excel fi;le and write ti to .MDB file. For the same I have below code, but I am stuck at the writing it to .MDB file which I have already created with …

When I am trying to connect to a MS Access database to display a data report, I am getting a dialog-box pop-up showing the different parameters for the connection string. Clicking on either the 'OK' or 'Cancel' buttons gives a "Couldn't find Installable ISAM" error. The database is not password …

Hi Daniweb guys, This is my problem: My .mdb (microsoft access 2003 file) is containing pricing table and client table. (I used visual basic 6 to create an application) The user can install my application in their own pc and record their client into a provided client table. But, the …

hi: [code] Module Module1 Public objconcetion As New OleDb.OleDbConnection Public objcommand As New OleDb.OleDbCommand Public Function open_database() As OleDb.OleDbConnection Try Dim route As String Dim cnn As New OleDb.OleDbConnection route = Application.StartupPath & "\" & "video.accdb" If cnn.State = 1 Then cnn.Close() cnn.ConnectionString = "provider=microsoft.ace.oledb.12.0;data source =" & route & …

I want to create a data base so that i can keep record of individuals and search their record easily Students under go different personality tests and checked by three different teachers of differnt departments. After their test these three teachers sit in a meeting to discuss each student in …

Hello, I'm trying to run a query to populate a gridview control such that the contents of a textbox are used as a selectcommand. My code is as follows: SelectCommand="SELECT [Organization],[Search Word 1] FROM [Main] WHERE [Search Word 1] = <%$ txtSearchWord01.Text %> ORDER BY [Organization]"> I get the following …

byte array size is 977kb when i try to store into ms access database its getting stored without error making the ms access database size 140kb(i know it uses different format to store so lesser kb) But when i try retrieving the same code from ms access database and when …

I am trying to do something I think should be fairly simple. Basically, I was going to do a multiple if statement, but there are 30+ values. I was wondering how I could have a text field and if someone types in a value, it searches a table to see …

Hi guys, I have a question, but first I'll explain my scenario. So I've got this datagridview where I use it as a look up for a certain table in Ms Access and I want to update just 1 field in that table. My question now is that, [B]can I …

Hi.... I am a student. When i tried to connect VB with Access, it is giving me this message "Run-time error 13, Type Mismatch" Below is the code [code=vb]Dim DBase As Database Dim RBase As Recordset Set DBase = OpenDatabase("DB Name") Set RBase = DBase.OpenRecordset("Table name") [/code] The funniest thing …

Hilp me please I want to read data of RS232 and store it in Access Data base

Hello everyone. I need to learn how to do it? Suggestions, any site tutorials that you find it useful or anything related to it would be very useful. Need this until 8 September! Help.

Is there a simple way to link up a data website to my newly created Access program? I need specific information to fill in the tables, and currently I am manually entering the info in from the site; it would be much easier to have this website post it for …

how i can draw chart for some values stored in Access Data base ? like this kind of chart in Excel chart wizard . i want frist to get the data or nimbers from the data base, then fill string grid by this data , then draw chart or certain …

dear all, what is the sql command for ms access 2007 to get the tables name of the database? and also how to put these names into a list box? thanks in advanced. 4ukh

Hi guys, I've created a program to write form data to an access database. Currently I am extending it so that I can read the data back from the database. I have created a new dialog with a datagridview to view the table data. I wish to be able to …

My name is Chuck. I am a semi-retired IT consultant. I got started in the computer field when minicomputers were still hot. Over the years I have done programming in a number of different languages, but my strength is probably more in financial application design. Currently I am trying to …

I need to write a query for the given crystal report. The database tables and the report is attached.Please see to it.

I'd like to select a week and pull data based on that week. Data selection starts on line 616. Thanks. [CODE]<%@ Page Language="VB" AutoEventWireup="false" Debug="True" %> <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Weekly Reprints</title> …

i installed MS Office home and student 2007 into my laptop.. and then i activated it.. the problem is.. i can use all of the apps(ms word, excel, ppt,etc) but not MS Access.. it prompts for a product key, but when i entered the product key, it says "The key …

Hello, does anyone knows how to install a ms office access database in mobile phones like n97? Pls give a procedure or some sites for download...thanks

Im trying to make a simple system using VB and Access. Does anyone have requirements list for such a system? I have the basic ones but if i can get a few more it wont be too bad. Thanks

Unrecognized database format <Faculty of Science>. (Error 3343)

i have created a database for subscriptions in MS Access 2007. I want to link it with my forms using the code below but its saying unrecognised database format. [B]Dim conn As Connection Set conn = New Connection conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb".......[/B] Now i have converted it to Access 2000 format …

Hi i am working on a sotre inventry project. I just want to fill grid from my ms accsess data base but i can not understand what i can do please help me in deeply it is very urgent

Hey guys, I recently started having some issues with my pc. I am running Win XP SP3 and running McAfee anti-virus program. It loads fine and I am able to get online but I no longer have the link to Control Panel on my start menu and I cannot access …

Help! I think that this should be easy but I have not been able to find the correct VBA code to get the Form to print only [U]the current record [/U]not all 1651 records. I have a command button (Print) and walked through the wizard correctly to print "only the …

i want to create student information system. but i have not a single idea regarding this problem. the requirment is thatit should have tables, forms,subforms,relationships,switch board manager,macros, main form. queris,(DDL and DML),SQL functions of the following entities STUDENT,TEACHER,DEPARTMENT,COURSE. u can also contect me on my ID. <EMAIL SNIPPED> please i …

hi i have a program that uses ms access database in [B]vb.net 2003[/B], when i run the program it seems to work fine but if i press a button that uses an openfile dialogbox and try to open again my database the program crashes... it seems that is losing the …

Hello everybody, :) I'm trying to import an access database to mySQL by using c#, I'm using this software: MS Access to MySQL from Bullzip, and it seems to be working ok; by using c#, I can display all data from tables, using this connection: [CODE] private void btndisplayBooks_Click(object sender, …

can u help me how to connect to MS Access database using java codes?? import java.applet.Applet; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.lang.StringBuffer; import java.io.IOException; import java.io.*; import java.sql.*; public class sample1 extends JFrame { private DataPanel myDataPanel; private Connection dbconn; private static int numPeople=0; private static String info; …