[microsoft:access] Forum Topics

how to find the number of fields and their names in ms access using vb6? i am using dao database.

hi i am trying to create a application for doctors n have to enter all the information regarding the patients i am using access as the database n nw the problem is tat the doc is supposed to save the patient details n when he opens it again he shld …

Hi I used the Data Source Configuration Wizard to connect to my access database, how do I write code to manipulate the data from the database? I read the book "Microsoft Visual Basic 208 step by step", it only teaches how to display data on the form. So how do …

I am designing a pocketpc app to manage service delivery at restaurants. I have designed the interface of the app and defined the schema of the database using a Microsoft SQL Server Compact 3.5 database file. I cannot figure out how to interact with this file tho, I'm using vb …

Hey guys, Although I decided against using a listbox and simply just using a subform, I did spend a lot of time trying to figure out how to get the listbox to store more than one values for that field. If the listbox multiselect property is on "None", it stores, …

Hi, I was wondering if someone could please help me. I have an access database with two tables. One table is Movie and the other is Genre all in a relationship. I have a foreign key in Movie pointing to Genre. My Movie table looks like this "MovieID, MovieName, GenreFK". …

Iv'e been searching this website forums for the right answer but i didn't find. Im using VS2008 and want to build some application that working with microsoft access database. in the database i have one table call "customers" with the coulmns = "firstName", "lastName", "address" etc.. I want to make …

Hello, This was supposed to be easy but I could not get it! I need to create a calculated field in Access (preferably in a table or maybe a query) that calculates the BMI. I have fields for the weight in kgs and Height in cm. The formula is: BMI=(Wt(in …

i want to create a simple form which stores date in to a ms access db so i created a form register.html and action user_register.jsp i also created a ms aceess db when i fill the form the data is passed to the Auction.mdb but the server shows error HTTP …

Hey people, I have a problem with connect to MS Access database... I use C#.NET and MS Access 2002-2003 Here is my code: [CODE] ... using System.Data.OleDb; namespace Потсетник { public partial class Form1 : Form { public OleDbConnection database; public Form1() { InitializeComponent(); string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=zapis.mdb"; try …

hi all, i m working on a component for MIS department. i need that when i run my component it should ask for: from where u want to retrieve ur data i.e. from Oracle/SQL Server/MS-Access. when i select one of these options for ex. if i select Oracle or SQL …

Hello All, I'm wondering if anyone can help me by either directing me towards a source that would help me understand Access syntax better or help me figure out if it's possible to convert this SQL syntax to Access. I've tried but can't seem to get it to work. my …

the heading says it all ... i have stored 6000+ entries in a DB and then now i wanna create a website that can search the DB and print relevant results. (the fields itself..) can anyone plzz help me or give an example for it... ------------------- There are like 6000+ …

Hi friends, Can u tell how can i connect to ms access table from a remote pc within LAN. I want to make a small programme for database manipulation on LAN. Whose database will be stored on a single pc and another can access that data from remote pc within …

Hi, I m getting this compiling error in asp.net .. "Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\needsunlimited\a2548f63\3bfeee38\App_Web_eg94tkhh.dll' -- 'Access is denied. '" Please any Help me..

I am currently developing an Access 2000 database for the purchasing department at work, and I'm learning as I go. The tables are all set up. I'm trying to create forms to update the tables, but I've run into a few problems. A simple example is the Parts table. It …

i have an access report with two sub reports. A text box in the main report adds 2 values in both sub reports together. One value is 10.22 and the other is 13.08 which should amount to 23.30 but the value is coming out at 23.29 which is off by …

Good Day, I am using an Ms Access Database to design a StockTracker applicaton. The application is used to check the stocks of users. Firstly I need to sign on as an administrator and then be able to add users and their stocks to the database. I have created the …

hello everybody nice to be in the community i have question regarding micrsoft visual 2008 i'm using asp.net with c# and i want to connect asp.net with access db 2007 i used select command and it worked it shows the data from access 2007 but when i tried to use …

Hi. i have taken my database from access and my table look like this. Example. object description words ball round, big, orange, big pencil long, blue, big, long ambulance alert, emergency, high emergency, alert emergency phone incoming message, message alert, high alert, message incoming, emergency, alert i am doing a …

hey .... i have a problem when i try to update/delete/add to the database (microsoft access 2007) it gives me the error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables. /internet project/delmsg.asp, line 7 LINE 7 is …

hi all, I want to read MS-Access database tables through VB. I try for reading excel file and i got success in reading excel file by adding reference microsoft execel library . But i am facing problem in reading access file. I had added the reference microsoft access library but …

I have an access database with to tables. They have a relationship with each other. I have put a combobox in my app. But it displays the Foriegn key id, instead I would like it, to display the text form its primary table. For example in the combobox its '1' …

Hi Every one. I have an MS access database table in which i have stored a data type of date/time in short time format. When i access the table from c# and diplay it into a data grid view the column in short time format diplay as long time format …

Hi Im using visual studio .net 2003 (not 2005) and I'm looking for a good database to work at and also helpful articles to help me, a newbie to c# and database, start creating a database and linking my forms' data from visual studio to the database. 1) If it …

Hello All, I am not knowledgeable in VB nor in MS Access, so kindly excuse my ignorance. I received an MS Access database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an …

Hi I am working on a VB.Net program using Ms Access Database i want to call a report from VB.NET to display an Ms Access Report Any help will be appriciated

hey .... i have a problem when i try to update/delete/add to the database (microsoft access 2007) it gives me the error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables. /internet project/delmsg.asp, line 7 LINE 7 is …

Hi guys, I've been developing basic websites for the past 2 years. Recently, a relative of mine had started a vehicle leasing company and has asked me to create the website for him. Now the majority of the site will be no problem to create however, as it is vehicle …

Good Morning All, I am not an MS Access Expert, so kindly excuse my ignorance. I received a database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an MS Office version difference …

Hi there, i am deeply troubled as my application runs successfully and adds new entry to the table and i can see that via datagridview. but as soon as the application closes and i check the database all is gone. there is no entry in the database. kindly see my …

I have yes no values in my access database the report displays it in true and false is there a way where I can program the values to display colors in the report if their is a change in bool.

Hey Everyone I have a client who uses a Micrsoft Access Application for their business. One of the reports that the program has, is a label type report. The report recieves the following parameters: 1. Number of blank labels to skip (should the user want to not print the first …

Hi all, I'm developing an online booking system. I'm freaking-out becasue this is my school assignment project which I'll be evaluated on but i'm pretty new in IT . I'm really struggling. I'm going to use MS Access as my db and Visual Basic.Net to develop the user interface. What …

I have an acces.db document, I want this document to be read or opened only using the MS access, and I need to disable the option to open the same document using any other application, like WORD OR EXCEL Now when I right click on the Access document and choose …

Good Day All, I have a problem with a database program. The program is to create a database for a Stocktracker program. The details for the code, I got directly from our textbook, and it compiles perfectly, but as soon as I run the program it gives me the following …

hii, da values in ms access should be multiplyed wit values given in text boxes in windows form application in c#.fr example: price of a book in access is stored as 50$, in c# form in textbox i entered 2, the resultant answer which i should get is 100$. how …

I have create a database in ms access 2007 but i don't have to connect this database to vb6.0 please help me.........

hi there.Good day!its me again.. Can you help with some codes that I have trouble with Im using visual c# 2008 and access 2000/2002 database,I have this database called VIDEO and some tables. theres add/edit/delete button in my form to add/edit/delete videos to the database. If the user adds a …

Have setup several ODBC links to local access DBs, and thought it would be just as simple wanting to link to an Access DB stored on my personal webspace, but no... Asks for username / password when I type in the url of the online DB in the ODBC setup, …

Hi, I work for a non profit child care centre in canada. We have developed a database for our children's registration, we used access 2003. We're opening a second site and thing it's a good time to reevaluate our database. I'm looking for suggestions on programs to use and some …

Hello to everyone !!! I have a problem with a tabels in Acces. Im making a software for minimarket and i have 2 tabels... First Table : Articles(IDART,NAMEART,PRICEART) SeconTable : Statistic(IDART,NAMEART,AMOUNT,PRICEART,DATE) My problem is this : When i'll put the ID of Article (IDART) in table Statistics then the name …

Hi, I have a MS access 2007 form with two fields TEST_ID and TYPE and a button. When button is pressed i want to populate all the entries matching TEST_ID and TYPE in datasheet view from table Test_Data. For this, i have added code for SQL query in FindData_Click. I'm …

Hi all, Can anyone please help? I have a .php user registration page that was created with the help of one of the many tutorials which works fine for the purposes of accessing/logging into an Intranet site. The registration writes 2 fields to a MySQL database a username and an …

This is a friends PC and he said it has been running slow lately so the topic says it all, please help and thnak you in advance. Here is his HJT log Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 9:50:49 PM, on 1/22/2008 Platform: Windows XP SP2 (WinNT …

Hi All, I am having problem regarding recordset. I am working in MS Access and VBA. I want to display records from the table(specific fields) depending upon the condition. I am very new to this and never used recordset because i am a database programmer now i have to develop. …

I have four to five different Databases and each one has its own forms. I want to make an HTML page which has Four buttons and when you click on any one of the button it takes you to the Appropriate form. How do I do this? Also is there …

Hello I've moved from graphic designer to static site builder and now want to begin exploring dynamic sites. I'm on a MAC and would like to use FileMaker Pro as my database app. Any comments? Thanks

Hi all, Im new to c#, please any one tell me how to get the column names of a table of ms access(.mdb). Here i used odbc connectivity to access the database, i got the list of tables in the database, but i dont know how to get the column …

Hi, I've been asked to create a proof of concept for a new database tool we need to develop, combining various existing databases. It’s been awhile since I’ve touched any database work and I’m a little unsure how to go about it. Let me explain the problem...the analogy I’m using …