3,459 Topics
hi...friends i am rocky doing my 2nd b.tech(it)in this i have to do a dbms project with ms access as front end and vb as back end i choosen student data base with name,regno,dob,address,marks,attendancepercentage please help with coadings 4 this..,
I am new to VB.Net and have a question. I am trying to connect VB.Net to Access. What I want to do is , when i select the database name, I want to popup the tables in the database...when one of the table is seleted, then the fields in the …
hello every one i had created one application front end as vb.net and back end is Access 2003. after this i had created a setup of that application. it perfectly work on my computer but when i am installing setup on my friends computer it install and run time it …
[QUOTE=khanhtrung;460562]Hi omoz4real. In your code,i found that you hadn't opened your connection before executed a command,so you probably couldn't connect to the database. If you didn't intend to execute a command which return a table as a result,you should use another way.There is [B]xxCommand.ExecuteNonQuery().[/B] I have a small attached program …
Hi there, i new here and i would like to seek for advise or help regarding this matter. I have trouble in joining 2 table. the error is "type mismatch in expression" the query is Select R.*, P.HphoneNum, P.HeirHpNum from PendingReport R, PatientTable P Where P.PatientID = R.PatientID but when …
Hullo, I would like some one to help me connect my access database to my website. The Database Name is school.mdb and the website is <URL SNIPPED>. Thanks
Hello guys, I am new in ASP, ADO and IIS, but I find a good tutorial in w3schools. I've started reading the ADO tutorial, because I want to create a simple web page, which is connected to a database. I will use Access database (.mdb). So, I've created two web …
Ok, lets see if I can expain better, unfortunately I am somewhat of a beginner. I am using Microsoft office access 2007, using Microsoft Vista, and visual studio 2008. I am writting a program that uses a GUI to show and change a Access data base. When I first tried …
Hi I have created my website in Visual Studios and it is connected to an Access database, i now need to create automatic email and login without being connected to a server... Any ideas how to create a login which is connected to the access database? Plus i need my …
Hi! I have a program that use a data base for save information about store products, all is OK, but the problem starts when i protect the DB with a password. I put the password in this way: [CODE]Usar una contraseña para cifrar una base de datos de Office Access …
Hello Friends I am newbie To Vb.net. i am building an vb.net 2005 application with ms-access 2000 as back end for practice. i just want to know that suppose user entering new data to the database if this record already exist then user should know that how can i do …
hi,i need some help on vs 2005 form,i have 1button,1textbox,1datagridview.i want to make a search button with it to search for student id..any help pls...i use ms access..example i type 12-200705-0005 on the textbox,then i click search button,then the data with student id will show at datagridview...thanks.. :S
How to make Database of Super market in vb and connect to access
I am using XSL to transform the XML.I am generating a Excel sheet using XML/XSLT. I want to password protect the sheet. If a user try to modify any cell then it ask for password? <?xml version ="1.0" encoding ="utf-8" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:my-scripts" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" …
Hello all, I am trying to create a database using Microsoft Access based on the folowing scenario. However, before doing this, I am trying to figure out the logic and draw an ERD. The scenario is as follows: "The Meantime agency manages properties for rent in South East London. Clients …
Hi, plz help me.... I'm working in VB 6.0 with Access I have got a problem, Adodc1.RecordSource = "select * from marks where roll = 710028" 'It's working.... but Adodc1.RecordSource = "select * from marks where roll = troll.text" 'It's not working.... plz help me....
Hi All Can anyone help me with this problem please. I am writing a program in C# and have an access db07. The user should be able to enter a date into a text box then that date is addedd to my sql query and then return all record with …
Hi, I want a two tables in an access database. They are 1. a student table with information regarding students along with a markingID field. 2. a marking table with a markingID primary field and module1...module12 marks. I want to create a form using data binding techniques that will display …
[B]Helo everyone , I am beginner in programming , it have been 6 month I just start studing at university , right now I am working on project creating a dynamic website where people could live coments above the images or videos like in youtube for exemple. What concern PHP …
Hello , I am working on getting this Mortgage repayment calculation code to work for my Access07DB, the code for was copied from some 2006 post on a vb forum. But some things I cant get to work [COLOR="red"]I will put the bad lines in red[/COLOR] [CODE] Option Compare Database …
Sir, I am using front end as a VB.net 2005 and I am a beginner in this language. I am creating Desktop application and using controls TAB controls 1st tab control is Contact in contact I am using one text box, two button and one datagrid while I am using …
Hi all! I hope someone has a solution to this MS ACCESS 07 report problem: I have two textboxes in reports details (lets name them box1 and box2) Both area populated by report recordsource. Both show fine. But I would like to colour the bottomborder of box1 with different color …
Hi, I'm writing my first application in VB and need some help with my Access database. I have 2 problems; the first one is the most important, the second I would just be very grateful for any help/advice. Firstly, I need help updating a record from my database. I have …
I've inherited a project which pulls data from 2 DB (*.mdb), one is access 97 and one is access 2002. DAO 3.6 is referenced. We use OpenDatabase and OpenRecordset instructions. When running, we get "Unrecognized data format" error or error code 3343 when attempting to refresh any table in the …
Good Day, Im new to visual basic. i created a simple database form using microsoft access as my database. my question is how can i create a browse button or text box where i can change the database path at runtime. please help. Tony
Hi everyone, I'm at my witts end and need some advice. I need to create a new table in MS Access from a datatable and I just can't get it to work. I have tried SQL with no luck, but I've been spinning my wheels in the mud. Any advice …
plz give me one example and how to generate Driver of data base
Hi friends, I have implimented a project. I connect it with Access database but problem is that I don't know how to make it as a Installaton file which can run on other machine (System) that donot have Visual Basic. Plz. give me the solution.
Hi Can anyone have a look at my code and tell me where im going wrong??? What im trying to do is display my details in a listbox then the one that is selected frm the listbox is displayed in the textboxes and when delete button is clicked it is …
I have problem in database file which I made in Access, language C#,It works fine after installation in default location "C:/program files/default company name/project name/abc.mdb", but when I install it in different drive (non-window drive) then my project doesn't find the database file.So,how can I remove this problem.
When i try to log in i keep getting this error and i dont have a clue what it means the code i used is below along with the error message: code - Dim dr As OleDbDataReader = cmd.ExecuteReader error - Syntax error in FROM clause
Hi I'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB. This is the …
Morning I have a question here How do I go about it in Access say if I want to split a line (row) into different lines like these fields? Drug name1 Drug name2 Drug name3 Drug name4 Drug name5 Drug name6 So what I want is to split the Drug …
Hi thanks for reply, I just tried that and it does the same - both phrases on the same line in the RTF memo field Ive used vbnewline in a msgbox before and works fine, but it stumped me as to why its not working in memo field. once i …
how do i connect access 2007 to vb6
using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Data.OleDb; using System.Web; using System.Configuration; using System.Data; using System.Collections; using System.Windows.Forms; //using System.Data.ConnectionState; namespace QuanLiDSSV { public partial class Frm2 : Form { public Frm2() { InitializeComponent(); } private void btnBrowse_Click(object sender, EventArgs e) { OpenFileDialog sh = new OpenFileDialog(); sh.FileName …
Hi there (Can DoCmd.openform allow formname from stored string value?) I am needing to vary the FormName part of the .openform based on a result looked up in another table. as I have 10 Different forms that will be specific to a certain kind of record. My code something like …
Using Microsoft Access 7, I want to print out labels from my database, on 30-up label stock ( 10 rows, 3 across, 1" high by 2-5/8") using HP Deskjet D4360. I can't get the bottom row on the sheet to print. Everytime I change the margin, it never stays the …
hai please any body can give me code how to insert one row in already prepared table in ms access
Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is …
How will i add lesson to chapters?? that when i add a lesson it will relate to the chapter .. for example: Chapter 1 Lesson 1.1 Lesson 1.2 is it possible in vb.net? please help ..
Hi Ladies and Gents. I have written an application that reads data from a MS Access database. What I am trying to achieve is that on my data report connected to only 1 data environment, I would like the user to select what fields they want displayed whether it be …
HI everybody I am a beginner and have a very simple question to ask. I am working with M.S. Access in Microsoft works version 9.I want to set the current date in every new record i visit without actually typing the date.As in access 2003,Cntrl+; key is not working.and i …
In my VB6 project i have a text area field, iwant to insert data which i give in that text area wants to insert into Access database. For that which data type i need to take for that column. 1) If i take Memo or text as datatype: only singleline …
Hello everyone, I currently doing a database project, which is part of my coursework, and I am having some difficulties. So, I am making it in Microsoft Access 2003. In my form, I want have to tabs (Client and Music Store), and I already have 2 tables, for each tab. …
Hello all. I have a moderate knowledge on how to create databases in Access but I am having a problem. I want to be able to improve the exams we write by tracking the questions which were answered wrongly to be able to improve the exam. Here is what I …
Im in over my head and have a small project to complete using MS Access. It involves setting up 3 tables, creating forms, queries and a report. I have a narrative that describes what is needed. I am willing to pay to get this done, but for somebody that is …
Hi- everyone. Good morning. I have an access data table and I designed a form in ms vb 6.0 Placing lavel, Textbox, Command button, datacontrol for connecting with ms access table. Thus I succeed and the form is showing the records from ms access table. but now I want to …
when I try running this asp using iexplorer, it does not return anything other than 'Country..... City..... Currency..... Population' as heading. How come it's not connecting and getting the data from the database?? Please help! Thanks [code=vbscript] <% @language = VBScript %> <head> <TITLE>ASP - Country Query</TITLE> <body> <% Dim …
Hello. I am new to c sharp . I want to know how to store image in access database. And retrieve back to picturebox . Which data type is used to store image..? Plz help.....
The End.