3,459 Topics
Hey guys, Basically i want to create a database in Access 2002 that will hold names of functions of a mobile phone. When the user enters a search the databse should query the information held within it, display the appropriate search results. It should be able to serach for precise …
can anyone please help me with my update statement, i am trying to update a row within a access 2007 database here is my code. [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & Database & ";Persist Security Info=False" con.Open() cmd.Connection = …
Hey there. I have a program that uses access, and everytime i go to install it for some one i have to keep my fingures crossed and hope they have office installed on their pc. Is there a way to run my program without buying microsoft office? (using access database) …
Please Help: I need to connect access database through code in VC++ .6 and i've to read data from edit text and compare this value to the primary key of my database. if those are matched then i need to get all data from the database and i need to …
Hello everyone, I have created a c# project( visual studio 2008 ). The application retrieve some data from access db. I'll use setup wizard. I'm just wondering how to deploy my database inside the setup folder. How should i define my connection string and how to get the directory of …
Guys i need help regarding this issue , Im using ms-acess 2007 as database and this issue is ridiculous !! i run the FORM and enter some details ! and now i click display and display the data that was entered! this thing happens while im DEBUGGING !! sometimes when …
I have just started using Access 2010 and am experiencing problems with it corrupting the database. To take one example I have a database with one module in it. Today when I open the module in design view Microsoft Access falls over with the error "Microsoft Access has stopped working" …
search button for vb 2010 ultimate in access 2007 database and filtering on a datagrid Hi all! I am trying to make a search button which filters a datagrid. First of all, I have a tab and on this tab a have a datagrid (dgr1). When I load this tab, …
i need to retrieve Date/Time column type value from MS-Access Database. what to write here in this case? [as we write rs.getString() to retrieve String type data from Database]?
Greetings, I have just went from Access 2003 to 2007.... I have a project requiremtn to output some reports to PDF file format... Don't know how to do it.... I tried doing a little research but.... :-( I am open to ideas... I would like to automate the process so …
plz help me How to link Access data base with java code. [CODE] public class DataBaseCon { public static void main(String a[]) throws Exception{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:DataBase"); System.out.println("Sucessfully Connected "); Statement st= con.createStatement(); ResultSet rs= st.executeQuery("Select empid,ename from emp"); while(rs.next()){ System.out.print(rs.getString(1)); System.out.println(rs.getString(2)); } st.close(); con.close(); } } [/CODE] Exception in …
Hi Guys, I want to use the Autonumber function in my table in a specific format. The format is SP10000. And I want Access to automatically number each entry by one with each new entry eg. SP10001...SP10002...SP10003. Please let me know how I can do this as when I use …
Hello guys, I am new to vb programming. Can anyone tell me how to access command button of one form onto another? I have one mdiParent form on which i have command button "PRINT" and "Add New Client", I want to disable Print button, when i clicked on "Add New …
I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the …
I have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error. I've been trying to google the answer but I cannot find solution for this. …
how to make offline database use vb.net and microsoft access?? please help me.. urgent
Greetings, I need to have a way to veiw/print reports designed in MS Access in my Delphi application. I have a MS Access 2007 db for the backend of my Delphi2010 application. I have reports I had defined and saved in my Access db. I would like to place a …
[B]Read a CSV file into a DataGridView[/B] [CODE]'12/4/2011 'Code to read CSV file with headers using 'ACE.OLEDB.12.0 Connection 'The following is a Sampling of <EXTENSION.csv> 'The CSV file contains all the Extension on my Desktop Computer 'The full file has 923 Rows with Headers: 'EXTENSION,DESCRIPTION,EXECUTABLE_PATH '.mde,Microsoft Office Access MDE Database,C:\Program …
Hello masters! I have a project and need a bit of your help. I would like to access/get values from certain fields from a database and assing that value to a variable. Database is included into my project along with DataSet. Is there any simple way to access certain field? …
I have a server that I just did a clean install on with Server 2008 Enterprise x-64. I have been having issues installing certain applications and unfortunately, I am at a loss as to why. I installed SQL Server 2008 Std, which went fine, but SQL Server management studio will …
I'm looking for a line (or more) of VBA that would tell me how to set the "required" property of a field to "No" instead of "Yes" Just so you have the context, I'm helping someone write a module that imports data into an Access database. Of course, sometimes a …
Hello I am having some trouble here, I created a Microsoft Access dataset (.accdb) It is being used with some listboxes, comboboxes etc. The problem is when I publish the whole thing the datasets do not publish along with it and my program opens but there are not values. Anyone …
I am trying to create a web app using C# 2005 where I can upload an excel document, store it in memory and read the contents. I have my code working if the file is saved on the hard drive, but i don't want to have to save the file …
i have file that is named record.mdb and i want to open it using microsoft access but when i try i get message that is could not lock file how can i open it
Hi everyone, Well, First of all m glad to join a community of all master minds. My question is : I have a datagridview and each time i enter values in database the values are not reflected in the datagrid untill i load the form again. I want a method …
Hello all! I'm making a Applicant Record Keeping System. I'm a newbie with MS access. And i'm having a really hard time understanding how queries work. I have three forms: (Sequentially) Background Checking Criteria.. Document.. So, this forms are for one applicant and they have common details. Background Checking's common …
Hi guys, I'm not very good with ASP but atually I need to fix some stuff and I'm encountering weird problem when I tried to connect to Access database into my localhost. Actually when I do something like this: [CODE]conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("/cms/db/cms.mdb")[/CODE] I return this error: …
Hello community, I am importing data from access into excel using a data import from a microsoft query using OBDC. I have 3 stores importing their their sales into each row daily. I cumulatively add these in a row at the bottom of each column. The issue I am having …
I'm creating an Excel spreadsheet from within Microsoft Access. This is declared at the top: [CODE] Public OpenExcel As Object Public OpenSheet As Object [/CODE] This is in my sub-routine: [CODE] Set OpenExcel = CreateObject("Excel.Application") OpenExcel.Visible = False With OpenExcel .Application.DisplayAlerts = False .Workbooks.Add .ActiveWindow.DisplayGridlines = False .ActiveWorkbook.SaveAs FileName:="" & …
How can I open a Record from a Listbox Using a Command Button?
i connect a database (.mdb) but getting error when i try to save a data in field more than 50 character. i also set document field for 255 char. then cant change it even i edit it from ms access. how can i set mdb. file to input 255 character …
hi am a newbie in programming please can someone help me with how i can search a datagridview with datetimepicker using the .value property.tanks.am using access 2007 as databse
Am using date time picker control in vb 6 to show time but when i try to store that in a access database it stores the default can somebody help me make it modify to store only time...
Hi everyone, sorry to bother. I am new in Visual Basic and I am using this in my final year project as a GUI. My system is an attendance tracking system which requires student to scan their rfid tags to make sure their attendance is taken. A lecturer can view …
Hey guys! I have limited experience with Visual Studio and have a question about Querying an Access database. I have created a Visual Studio application that displays and modifies an access database. I have use datagridview and detailed view to insert data and view data in the Access database. I …
Hi guys i'm trying to just do a simple email/password validation on two text boxes. This code runs but when i type in a correct email address it throws an error "Object reference not set to an instance of an object." on [CODE]AdAcc.InsertCommand.Connection = OleAcc;[/CODE] I'm thinking i may need …
Hello friends, I am looking for a bit of help. Here is the scenario. I am trying to compile sales data for a number of stores from multiple databases and import them into excel for the current month by day. I have a field for date and sales. The problem …
I'm writing a program has access to a database (a database where an other software stores data that users type). This database has several colums, but in my code, i need to use the two columns that describes where the data is from, and the the date when the data …
Hello Folks, I am trying to create a Crystal report using data from two Access 2007 tables but it only displays the data from the first table only. when I do same with Access 2003, I am successful but it does not work in access 2007. Please help me to …
Hey guys. I have written a program to create, edit and delete record in MS Access using a visual studio program. I am keeping the program and database divided into a front end and a back end to allow concurrent users. I am going to place the back end on …
afternoon.. i need some help..:'( i created 20 tables in ms access.. and only one table is connected to vb 2008 using the DataGridView?.. how can put the remaining tables in ms access to the vb 2008?.. thanks for the replies.. i hope that someone can help me in this …
Ok I have a project and I pretty much have no idea what I'm doing. Our project is to make some simplified POS software, in our case, for a restaurant. The form I am currently working on is where you pick food items and add them to a listbox which …
Ummm hi, Ive been having some problems with a program ive been working on. I want to insert a new value in a column in a table from a calculation i get and replace the original value. Heres the part of the code: private void button11_Click(object sender, EventArgs e) { …
Hi All I am writing an import program to import data from an access database to a SQL database. The table structure in the SQL and Access are the exact same with the same field names. I was wondering if there was a quick way to get the data into …
hey im new to microsoft access and databases.im trying to create database with Tables for 1.Researchers(have that) 2.Test performed by researchers (at least 5 different tests)(have that and my 5 test are diabetic,blood type,high blood pressure,positive for drug tests and eye sight) 3.and Results of the tests given by researchers …
i've just created an access database using three forms and a query. it is rather simple database but i have tried to include a navigation page to control the database overall. each form works perfectly in the naivigation page except the form i created for the query. each time i …
i am having issues with an update query. i normally use SQL 2005 but for this project i am using an access 2007 database please can anyone point me in the right direction, [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & …
Hello, I am creating my project now and I am using Dreamweaver CS3 ASP VBScript and Access 2007. Can you teach me how to restrict the database to add only three records on the table; say, a student has a MemberNo and he can only use his MemberNo to borrow …
Hi Guys, Is it possible to dynaically create table name in MS Access: Below is my CODE: [CODE] strSQL = "CREATE TABLE" + Me.Text + "( ID Counter," & _ "Name TEXT(50) NOT NULL," & _ "PRIMARY KEY(ID) )" [/CODE] But,im getting a run time error that syntax is wrong. …
Guys,i want a small help from you.I have a created a database in MS Access and now i want to connect it to with Java Application by using ODBC Administartor.But when opens it,it doesn't show any driver for MS Access DBs.Do u guys know any driver for that.I'm using Windows …
The End.