1,597 Topics
 | |
| | Hello, I have just started using databases, but I am totally stuck. I made a database and table using MS Access. The table has three columns. ID, Code, and Letter. Basically, the Code column stores a number for each letter (eg. 1 = A, 2 = B, 3 = C, …  |
| | Respected Friends.. I need help from your side.. Im using Visual Basic 6.0 with MS Access, I wish to create a automatic serial number for my program, It will show HITE001.. HITE002...HTTE003... same time it will show in form load stage it will automatically show in combo box( last record …  |
| | I use Docmd Open query to open one append query in the script that has another code in it. When I run the script, this option will opo out: "You are about to run an append query that will modify data in your table" "Yes/No" If I answered "Yes", the …  |
| | I am receiving my secure WiFi from a distance and would like to set up an access point to strengthen the signal at the receiving point. My current setup is a D-Link Randbooster wireless N Router with WAP security. My Belkin wireless N router has the ability to be set … |
| | Hi I am new to VB.NET but for my final year project have started a system for childrens daycare center. I want to create user accounts which I think I should be able to do in acess. How do I link this to VB.NET? is it hard? what will vb.net … |
| | Yesterday mom mom got a nasty that is not allowing her to access anti-virus sites for updates or downloads. I found some mirror sites and stuff, and ended up getting Malwarebytes, Spybot, the Stubware and HJT. I will post the HJT log here in a second, IVe tried all kinds …  |
| | Hi! I have a vb.net project on a jump drive that connects to an Access (2003) database (located on the jump drive). My problem is when I change computers, I have to change the drive letter the jump drive is located. Currently, I have the following code and have to … |
| | Hi there, I got this annoying problem... I have to create dynamically an image control that has got to be accesses later through javascript. In other words, I got an image that was created in the page code, and using javascript I got to be able to work with it … |
| | Can you help us for our project in creating a daily record transaction? Do you have any codes out there or samples, and help us in connecting it to the database thru Microsoft Access. Your feedbacks are highly appreciated ASAP. |
| | Greetings. I have a question regarding MS Access Me.Filter. In short, I am building a personal database for my CD and DVD collection and I have a few CD's that start will a number instead of a letter - such as the band, 3 Doors Down. On my form, 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 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. … |
| | Deck.h [CODE]#ifndef DECK_H #define DECK_H class Deck { public: struct card{int symbol; int value;}; card card_list[52]; void generate_deck(); void main(); private: static int const diamond = 1; static int const club = 2; static int const heart = 3; static int const spade = 4; }; #endif [/CODE] Deck.cpp [CODE] … |
 | When you are programming web pages it is very important to optimize your code for better and faster performance. In this part I will show you how to optimize code for filling multiple dropdownlists with data from Microsoft Access. The same thing is with SQL Server. I'm using asp.net 2.0 … |
| | Hi Ive written my own MVC framework, which uses the mod_rewrite apache tool... first part of the url is the controller and second part is the 'action'... some of my controllers have functionality which is publicly available, and other functionality which i want to restrict to logged in users... i … |
| | Hello there, first of all hi everyone, this is my first post here. i'm pretty new to PHP but i do know enough about programming to understand advices at any level. Here is my question: I've done a login algorythm which is working fine, everything is managed by an idex.php …  |
| | Hello, Here is my dilemma and I hope someone can help me: [ICODE]Table1 [B]First Last Dept[/B] Dan Smith Accounting Joe Doe Admin Mary Boe Accounting[/ICODE] [ICODE]Table2 [B]Contact[/B] 068097110032083109105116104 (for ref. this is Dan Smith) 074111101032068111101 (for ref. this is Joe Doe) 077097114121032066111101 (for ref. this is Mary Boe)[/ICODE] I'm using … |
| | Hello, I am new to Access and VB, but I have used C# and C++. I am trying to update a whole bunch of records in a table, only one field. For example [CODE] [Employees] [ EmpCode ] [ FirstN ] [ LastN ] [ 019871 ] [ John ] … |
| | I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates … |
 | Hello all, I have msaccess that I use to insert data into a mysql database on a local in house server. Now what I would like to do is I have the below query [CODE] INSERT INTO User_logins ( GroupWiseID, ConnexLogin, [Password] ) SELECT NewHireIDs.[GW ID], NewHireIDs.[LIC ID], NewHireIDs.[ACD ID] … |
| | Hi All, I am in a process of trying to concatenate related fields field in Access. eg: consider the following table Awarded to On Date Emp1 01/01/1990 Emp2 02/01/1990 Emp1 03/01/1990 Emp3 04/01/1990 Emp2 05/01/1990 I want my query to return something like: Awarded to On Date Emp1 01/01/1990, 03/01/1990 … |
 | Hello to all, I am always mad about this problem. If I type a name with two words in a textbox like "google corporation" it will be registered in the database ms access as "Google Corporation" now that is okay. What I want is, there should be no duplicate of … |
The End.