[microsoft-access] Forum Topics

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 …