1,597 Topics
 | |
| | hey guys i really can't solve this problem, hope you can help me. the problem is, i use this codes to get the data type of a column from an access database Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE) but what displays in my listview are numbers like (130 , 3 so on..). How can i …  |
| | hey guys i really can't solve this problem, hope you can help me. the problem is, i use this codes to get the data type of a column from an access database [code] Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE) [/code] but what displays in my listview are numbers like (130 , 3 so on..). How … |
| | Hi All I got lots of help from this site Here I am facing 1 simple problem but can't point it out, So I need urgent help from you all. I am using Windows 7, VS C# 2008, Access 2007 My Access database have 1 photo column of OLE Object. … |
| | So I've been reading a lot about Access 2007, but all the books and tutorials don't talk about the stupidly easy questions. I have a SharePoint 2007 running on a server that my team has access to. From what I've read, SharePoint can easily display information and generate reports based … |
| | search data in listview by using a textbox, this is my code sample cos i have been able to display data in access on listview so i want to perform a search function... Imports System.Data Imports System.Data.OleDb Public Class Form9 Dim Passport As String = "" Dim searching As Boolean … |
| | Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of … |
| | Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my … |
| | Hi, i have this main form that has several tab. In the tabs, there are several fields. I want to call/get/set the control/field inside this tab, how to do it? for example, in the main form there is a textbox control called "InvoiceNo", to call this one, i will use … |
| | I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=) |
| | Hi all, I have designed an application in MS Access 2007 that will be used in some schools (over 60 schools). Each time I start the application, it shows an alert in the message bar that the VBA macros are disabled, and gives me the option to enable it for … |
| | [B]how can i disable the save function. The database that I am making now is being shared by many users and i do not want them to mess up with my design and programming stuff that i had done. I have tried making the file into ACCDE format but it … |
| | I have inherited an Access 97 database with a VBA front end. I know nothing about VBA front ends, but can work with Access The system is vital to our organisation. At some point I will look at re-writing the full thing in Access 2007 as the VBA does nothing … |
| | Hi, I have this set of coding when i use it when i am in ms access 97 but not ms access 2007. this is a set of coding for login form of ms access. Whenever i log in with the correct userid and password, it always promt me "wrong …  |
| | hi can anyone plz tell me how to create a ms-access database with table in run time i mean i want to create a database when user run the application thanks |
| | Hi I am having trouble with how to access my documents. So I did a bit of research and says that I should change the way I save and access my documents templates. Any tips of where I should save my document templates and how to access them? I thought … |
| | hi everybody i need some code for auto inncrement in msaccess database file and in form textbox and if we add any data the number should increment automatically please help meee thanks in advance  |
| | Hi All, Im trying to Insert a new row into a database and refresh the dataset. This is what I have so far: [CODE]void ButtonInsert(object s, EventArgs e) { string connectionString = null; OleDbConnection connection; OleDbCommand cmd = new OleDbCommand(); string sql = null; connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;data source=Book.mdb"; connection = … |
| | Hi all.. I have made a database in Mcrosoft Access 2007. In my Database there are four tables. ORDER, ORDER DETAILS, CUSTOMER & ITEM. I have made order and order details combine form from Form Wizards. When flling the form of any order when i give the Item_id in the … |
| | Hi Guys need a bit of help. I right a c# program that connects to a database and do various things. One of them is to delete a record. currently I can delete a record that i specify but i want it to delete a selected row in the dataset. … |
| | Hi Everyone, Ive been messing around the OLEDB in C#, What im trying to do is create a program that would read from a Access Database, and then the user has the right to add,edit and delete a records. So far i can get the Database to display and are … |
| | there are quite i few data that are required to update in one time... And the default setting for a list box is that u need to update once at a time? Can any1 plz teach me how to select 2 or more item in the list box and update … |
| | Hi I have this form which works well when it is in list box. but when I change the list box to combo box, the form does not works and I will be stuck at "record does not exist" even though i choose the record from the combo box. this … |
| | Good day! Im a new programmer in vb.net and it seems that i cant update my table in access 2007 here is my code. [code] Try con = new oledb.oledbConnection("Provider = Microsof.ACE.OLEDB.12.0"; data source = |DAtaDirectory|\Attendance.accdb; Persist Security Info = False;") con.Open() sql = "INSERT INTO tblProf VALUES('"&txtEmpNo.Text&"', '"&txtProfName.text&"','"&txtProfLname.Text&"')" cmd … |
| | The small business which I work for uses Microsoft Windows Small Business Server 2008. Using SBS Console I can navigate to the Users and Groups tab and then to the individual user. When I click on a user's properties and then click on the Computers tab I can see access … |
| | Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL … |
| | I'm probably overthinking and been staring at this too long, but I'm having a huge brain fart and need help. I have 3 fields on a form: EMPLOYEE (visible), EMP NUMBER (not visible) (from a seperate table) and EMP NUMBER ENTRY (visible). I want the employee to choose his/her name … |
| | I have quite a long list on my listbox. And when I wanted to search for words like "Boy", I need to go through all the letters before 'o', for example, 'bacon', 'banned', 'because' and so on. I know that the listbox allow the user to search for the first … |
| | I'm trying to join two tables and group the results. The tables are joined on an EventID field. The basic query gets all upcoming events for the following month: [CODE]SELECT StartDate, EndDate, StartTime, PresentedBy, EventDescription, AdditionalInfo, VendorEventID, FeaturedText FROM EventCalendar, Events WHERE EventCalendar.EventID = Events.EventID AND StartDate >= NOW() AND … |
| | The question I am going to ask involves Mircrosoft Access and VB and I am stuck with it. This is the question: I have 4 peoeple: L, M, N, O, P there are 4 object: a, b, c, d, e L has: a, c, d M has: a, d, e … |
| | I'm trying to create a tree with the following very small access database. I'm still getting a few errors, 'rdr' is a 'variable' but used like a 'method' and trying to get tree to actually populate.. If you find any other errors or recommendations, they're greatly appreciated. Thanks a lot. … |
The End.