[microsoft:access] Forum Topics

in form hve 1 datagrid, 1 microsoft reportviewer and 1 textbox.. all data in datagrid binding from access database.. i put this code in textbox to search data in datagrid and automaticly data will preview in reportviewer..in data grid hve 2 column, like product & model.. [CODE] Me.Product_listTableAdapter.FillByproduct(Me.MydatabaseDataSet.Product_list, TextBox1.Text) Me.ReportViewer1.RefreshReport()[/CODE] …

I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the …

hi i want to sql database backup through the vb.net code.

Hey I am trying to do a project on Test Engine. I need to retrieve random rows of questions from access database. I did the following code, but every time I once close and run it again, the sequence of questions is same. How can I change the sequence every …

hi how to do insert ignore in access? is access support this function? [CODE] CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")" [/CODE] or how can i do a search for duplicate record first before insert? …

hi all, How to check if a particular row is exist before inserting it? my table has ID as Primary key, and 2 other columns, say Process and technology.. thank you

hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes, …

Hi, im a student doing a project on attendance system.... i have problem where the text entered (username)from formA jTextField1 need to pass to FormB in order to the combo box in FormB shows(subject,course,time) that correspond to the username was entered in Forma....i have try it....but got error... Here is …

good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not

I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here! First off I am programming a hotel booking system for my college computing project. This consists of a …

hi all hope some one can help me out im a php guy and ive got an application i want to make that will run on windows and ive never program for desktop before and i really need some advice. here is the scenario iv got my website with a …

i wonder it possible or not to put video in access form ? if anyone know please answer if not, what about flash ? if can please tell me too . thank you very much

Does anyone know how to programically create an html document for an Access WebBrowser control? For instance, in Access 2010, to browse to a webpage, say [url]http://www.daniweb.com[/url], then assuming you have a WebBrowser control named "webBrowser", then you would use the following: [CODE]Me.webBrowser.Object.Navigate "http://www.daniweb.com"[/CODE] Now say, you want to dynamically …

Hi all.... i have found code that displays treeview and listview from database but it is done for microsoft access ... i am try this code for sql sever but end up only in exception,..... can any one modify this code to access the sql database and display the listview..... …

Can we create Microsoft access database using linq programatically?

Hi I have a c# console app that calls some access 2007 queries. One of these queries throws an error "Undefined function 'MonthName' in expression". I understand that some functions that are available in VBA cant be called from c# and if i comment out the 'monthname' function the call …

I have a legacy VB6 application; simple VB6 front end and Access backend database. Works fine on Win 2000, WinXP, Vista, and 32-bit Win7. Bought a new laptop and everything seems to be shipping with 64-bit Windows now. Out of the box, the application worked fine after I manually re-registered …

hello i have a form and a database linked by SQL. i have checkboxes in the access database that are ticked when a product is sold is there a way to make a checkbox in access tick once the product has been selected in the form? thanks, help would be …

Hi. I'm having a problem to pull data from MS Access to my combobox. I know how to search one data using another data (e.g: using IC num to search name) but this time I just want to pull the data (e.g: name) that has several rows to my combobox. …

hello to all, i got some problem in vb 6 in reports. actually i tried to create a simple ordering system, and i used ms acces for my database, now the problem is that when i generate a report it will show the first data of the row of the …

Is it possible to create a microsoft access database (mdb) file through a java program? and how to register the thus created mdb file to ODBC center? thanx in advance

Hi all, actually i want to populate datagridview and it's include with date. i used calendar cell as in [url]http://msdn.microsoft.com/en-us/library/7tas5c80.aspx[/url]. now want to show date from database into the calendar cell. this is my coding to populate the information from the database. [CODE]Private Sub PopulateData() Dim DBClass As New clsDB.clsDatabase …

Ok, so after hours and hours of testing and searching online I'm almost convinced that this can't be done, but I'm asking here for help maybe someone can give me any idea as to why this isn't working. I'm doing this query: [CODE]SELECT * FROM( (SELECT t1.PAG5 from table1 t1 …

I have done this query : Balance:[Medical]![Price]-750 but calculation total didn't show up , and it show up to enter parameter value? help me....

Who can help me?? [B]Microsoft Visual Studio 2008 Window Form Application C#[/B] I'm want store some data and picture in access database and display the data and picture in datagridview. when the user double click the record in datagridview. it will display data and picture into above textbox for update …

Hi.. another post from me on how to retrieve a picture of a certain person from MS Access Database using the OLE Object.. Any one who can show me some samples how? Thanks for the time.

Hi, I am running this line of code to insert some data into table. I am using select case on one of the data. When I run it, this error was generated: "Syntax error (missing operator) in query expression 'CASE dbo_tblFinanceApp.UPADisclosed WHEN 0 THEN 'Undisclosed' WHEN -1 THEN 'Disclosed' END' …

HY DEAR i want to access or retriving pictures from MS access to C# program. what r the qurey to send . thanks

I am doing data analysis and for that I have to edit MS Access file in csv format to labelled format... ie. |Student, Name, Whatever | |12,XyZ,PPP | ------to--------- 1.Student 2.Name 3.Watever 1.12 2.XyZ 3.PPP Please help...

Hi, I am working on a project for work that requires the <%# Now() %> function output to be inserted into a text box field that passes it's value to an Access 2007 DB with the rest of the form data on submission. I am able to either make the …

hi! i am making a nso system(a citizen record system w/ ms access as database) i dont know how to make it work: there is a citizen, then under the citizen there is subdatasheets namely: father, mother, sibling 1-5. all i managed to do is have ONE subdata sheet under …

I am using Access 2010 and have 2 tables: ORGANIZATIONS [id], [categoryID], [requirements], [address], [city], [state], [zip], [web], [person], [title], [phone], [fax], [email], [paperwork], [brochures], and [dateModified] LIST [ID] and [list] The data types are either text, number, attachment, memo, hyperlink, or date I have a form with a listbox …

Haven't used this stuff in years since working at IBM and Compaq in the early 90s. Different career path. Need to fix a guy's access 2000 software by tomorrow -long story -totally corrupted - needs something from scratch and his pictures of screens. Don't have the time to program and …

Hi, I am changing the sql database to database access (.mdb). The problem is when i run my application using sql connection its work well and all the tables are updated but when i use mdb connection it update some of the tables and few other table it does not …

Hello can anybody help me with constructing a PHP ODBC code for retrieving records in a database? here's my code: [CODE] <html> <head> <title>HCPSMSHS: Grade Viewing System</title> <link rel="stylesheet" href="css.css" type="text/css" charset="UTF-8" media="all"> </head> <BODY> <?php $conn=odbc_connect('DB2','','') or die("connect error: ".odbc_error()); $username=trim(stripslashes($_POST['username'])); $password=trim(stripslashes($_POST['password'])); $sql="SELECT * FROM tblstudents WHERE S_ID='$username' AND …

Guys how do I save settings of a form like its background color, fonstyle, sontsize etc. I cannot save them as string or text into my access database.

Hello, I am trying to connect my html page to an ms access database using javascript. but I face problems when inserting values into the database. I have an ms access database with 9 columns. I want to insert the values got from an html form. Is it possible??? Could …

Hi all, I have a table where it stores Process. The Process has each processNumber which is unique, & the processNumber indicates the step of a procedure. My problem is, user request to add a Process in between existing processes. In other word the new Process overwrite the existing process …

Hi all i am havin a problem with my Jet oleDB connection i am getting an error and i am not sure if my code is completly wrong or it is a small problem any help would be great. This is the erorr i get: An unhandled exception of type …

There is Software Development, Web Development, Internet Marketing, Business Exchange, Hardware and Software, Why not ADD another part to this site -- DATABASE DEVELOPMENT, in which you can have posts for SQL, MySQL, MS Access?? This could be a nice addition to the site. What do you guys think? Ramanpreet …

The code below was written using C++.NET framework. How will the code be completed to retrieve all the records from microsoft access 2003 table PROFILE and display them in a form? [CODE] private: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e) { ADODB::Recordset ^ rst=gcnew ADODB::Recordset; ADODB::Connection ^ conADO; Object ^ obj; String …

can anyone tell me if it is possible to connect to a database (for example an access database) from visual c ++ 6.0? And if one can how does one do it? Is it some wholy complicated thing or is it as easy as doing it in visual basic 6.0 …

hi pls help me on this.. i'm using this code to get data from record: [CODE] MyNum1 = DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]") OutTxt.Value = MyNum1 [/CODE] my prob is when the data in [Outcome] is null , access having error to still get the null value from the …

I have a data base using access which has one column as jobno and which is empty. I want that when my form load (vb.net 2005) it generate a number which then appears in a textbox. Below are my codes please i cant complete it help me. Private Sub Form1_Load(ByVal …

Do anybody know where can i find example of database management system all topic especially fast food restaurant(if possible).

I have an odd issue. The company I work for has old databases that were built in Access '97. They've since upgraded to Access 2003, 2007 of course, and are in the process of upgrading to 2010, but a couple of databases still only work in '97. I'm tasked with …

Good day.. I'm having problem on how to store or create a table on my database using vb.net i'm having hard time to create a table on my existing dbase here my code; coould you tell me what's wrong!!! Dim ntable As OleDb.OleDbDataAdapter Dim mtable As New DataTable con.ConnectionString = …

hi people! I badly need a help regarding this program.. I want to insert this two data in my database... [CODE] try { OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\lenovo\Desktop\C CONTRUCTS\C CONTRUCTS\CONSTRUCTION.accdb"; conn.Open(); OleDbCommand ccmd1 = new OleDbCommand("INSERT INTO [ORDER_DRIVER]([DELIVERY_NO],[DRIVER_ID],[STATUS])" + "VALUES(" + "'" + textBox1.Text + "'" …

All i wanna do is simple, I wanna display an image from an access database. I try alot of things to no result. Like ascii code or nothing but a blank image with a red 'X'. [B]Here is the code :[/B] [code] <% set conn=server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.jet.oledb.4.0" conn.Open(server.MapPath("test1.mdb")) set rs= conn.Execute("SELECT …

Hi Can you help me please how can i encrypt my password in ms access just like this “¼ÞÔ:o½½ñ²6³' so that if someone will open my database they could not read the password..can you help me please.Thank you in advance hoping for your positive response....