[microsoft:access] Forum Topics

Hello Everyone, Need help with posting this problem I have with Access 2003. There is no field named contact in the current record. thanks

Hi, I am fairly new to vb.net and seem to be having some probelms doing an SQL statement. I am selecting data from more than one table from my Access database. A surname held on a database is typed and it is supposed to display results, related on the MemberID. …

Hi everyone, i am someone with a weak database background and i have been given a project to design a database for a convenience store which will be used in a customer relationship Management system can anyone offer me any help, thank you. Am not asking for my work to …

hi..i am newbie for vb.net.i jz wan to ask how to link microsoft access field with my text box.i jz wan to get the information from the table to my textbox.i already connect it to my form. this is how i connect to form.. 'TODO: This line of code loads …

[code=sql]CREATE TABLE Persons ( FirstName VARCHAR, [Last Name] Text, Gender int, [Date Of Birth] DateTime, MaritalStatus Integer, IsMarried Bit, PersonalIncome Money, HouseholdIncome Currency );[/code] Can u plz tell me where I have to write this Query in MS-Access to craete the Table.

hello any help me to open and run ms access mdb file with access-report and access-form

hi i aam trying to develop a project using vb and access i have got a problem i have 3 tables in access 1.Cust info table(fields are listed below) cust id,name,age,sex,country...etcxc(primary key cust id) 2,indate(fields are listed below) custid ,packageid,date,intime,outime(no primary key) 3.package info table(fields are listed below package id, …

Hi, I have a Filemaker 7 database that has been developed for me for my fine art photographs. I have a table of Galleries (who stock my work)/Table of all my images etc. I want to list all the images the gallery got delivered under a delivery note number eg …

hello all, i have a popup, security system protection control panel. possible spyware, and wants me to install program. before i only had mcafee scan and firewall. but i've tried quite a few programs trying to correct this. at first i didn't have control of task manager and my wallpaper …

I need to [U]create [/U]a data file called students.dat and [U]insert [/U]a few records into it. I need (3) fields: 1) student id no. 2) last name 3) first name I thought it would be pretty straight forward, but I get a compile error: Invalid Outside Procedure and "students.dat" is …

I am to create a form with 2 text boxes to receive numbers as input and 1 command button that displays a message box containing the larger of the two numbers. To do so, I need to write code in the Click event of the command to call a user-defined …

I made a hotel software and connected it to a access database created using the visual data manager. The software runs very well but when records in a table for daily stock taking reaches around 2000 the software starts messing up with my table. I am suspecting that the table …

hi i aam trying to develop a project using vb and access i have got a problem i have 3 tables in access 1.Cust info table(fields are listed below) cust id,name,age,sex,country...etcxc(primary key cust id) 2,indate(fields are listed below) custid ,packageid,date,intime,outime(no primary key) 3.package info table(fields are listed below package id, …

Hi all, I haven't used 'Data Base' in VB 6.0. Now, I would like to create small data base with microsoft access 2003 for testing. Could anyone please give me some guidelines to do this or give me some good link to start to lean? Best Regards, zawpai

dear all, I know how to correctly execute SQL statement using con.execute() (where con is type of java.sql.Connection). But how can I execute Microsoft Access Query Object, which require one or more parameters? Do we need to use PrepareStatement ? Thanks

Hi everyone, Im really new at VB and Crystal Report and i know nothing about Crystal Report 8.5. My problem is, i have this application called CustomerManagement that will keep data in Microsoft Access called 'dbCustomer' In the form customer ('frmCustomer') i've created a command button 'cmdView' so that the …

Using VB ASP Access. Here's the error I'm getting: [QUOTE]Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch /RP_Ref_Guide/RP_search_results.asp, line 23 Browser Type: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1) Page: POST 109 bytes to /RP_Ref_Guide/RP_search_results.asp POST Data: Partner_Name=Agilsys+Hospitality+Systems&Relationship=&Industry=&Partner_Manager=&Territory=&RP_Search=Search[/QUOTE] Here's the code: [CODE=VBSCRIPT]<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!--#include file="Connections/RP_DB.asp" --> <% rp_name = Request.Form("Partner_Name") …

Hi, guys I don’t know if anyone can help or not? I've made a form for a search list using an SQL query which is linked to my form. Basically the user selects a class of a car and the price is shown and then the user inputs what dates …

A publishing firm that consists of twenty five employees utilizes a Microsoft Access database system to store and process requests related to their business transactions and operational data such as product sales and customer information. Over the last five years the firm has experienced tremendous growth; as a result, the …

A publishing firm that consists of twenty five employees utilizes a Microsoft Access database system to store and process requests related to their business transactions and operational data such as product sales and customer information. Over the last five years the firm has experienced tremendous growth; as a result, the …

Hi, I am very new to ASP and am trying to export an entire table from access to an excel file through the browser. I simply want the user to click on a link and then have excel launch with the queried table. So far I have written a little …

Hi all, Iam newbe to this forum and seeks some help. I am using a msflexgrid in vb6 which uploads data from the net. What I want the uploaded data in msflexgrid having 10 cols and 10 rows to be saved in access database and also want to save the …

I would like to open a access database using VB.NET. However i want to be able to connect to a Access database at runtime and have this appear in the datagrid. how do you do this? I would also like to create a database using VB.Net and have fields weight,comment …

can anyone give me some guidance: i'm using VB6 as GUI on my project which is print the data that i received from wavecom modem.my only prob now is how can i extract the data from hyperterminal and save it to my microsoft access database before i process it using …

This is my first exposure to arrays. I need to create a 1-dimensional string-based array with five elements. I need to assign 5 different names to the array. Use a for loop to iterate through each of the array elements, displaying the names in a message box. I would truly …

Perhaps someone can help me... I'm trying to figure out how to transfer Access data to Word documents so that the data for each contact will transfer with a command. Does anyone know how to do this?

i am doing the database connectivity using the flash and access database... The problem is i m not able to do any insert or update query on my database.. the only thing i can do is an select query.. The error is as follows.. [B]Error Type: Microsoft OLE DB Provider …

I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this: [code]CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2 MEMO, Check3 INTEGER, Check4 DOUBLE, Check5 DATETIME, Check6 BOOLEAN) VALUES (1, 'DefSML', 'DefLRG', 0, 0.0, …

hello there..i just want to ask how to connect database written using MS Access to interfaces created using Dreamweaver... having headache since i need to build an online system and i don't know how to connect the database to the interface...thank you...

hello there..i just want to ask how to connect database written using MS Access to interfaces created using Dreamweaver... having headache since i need to build an online system and i don't know how to connect the database to the interface...thank you...

Hi Everybody I am making a software for my business I have easily connected my access database to add new records in it's tables but don't know how to show these tables with updated data in another form. Please suggest any way! Thankx

Hi everyone, I have a third-party application which uses DSN (in this case, only system and user DSNs) to setup database connections. I created a connection using the "Microsoft ODBC for Oracle" driver, but everytime my application needs to access the DB, I'm asked for password. I cannot change the …

i did a project in VB6 with ms access 2003 in which i successfully run but whn i take the exe file then Package & Deployment Wizard, after whn i install and open and user login for particular user name and pw(it available in the DB), it says that "runtime …

can anyone help me on [COLOR="Red"]how to create or to set a username and password [/COLOR]for [COLOR="red"]my ms-access 2003 database [/COLOR]and how can i save or [COLOR="red"]set that username and password in ADO control [/COLOR][COLOR="red"]so that i can edit that database in my vb project without opening that database in …

hey im making a database on licnese issuing authority now i want get data retrived frm da database ma access to list boxes but i want data only of the data which i slelect fmr da dtpicker can u plz suggest a code for this thx

hello i am nireekshan i have some prouble in database connection send my erres pless see and send Some Code . //...............................// [code=java]import java.sql.*; class Student { public static void main(String args[]) throws Exception { try { import java.sql.*; class Student { public static void main(String args[]) throws Exception { …

Hi im currently having a problem with taking data from a field in a database and then using it within the form, when supplied with a telephone number by inputting in to a text box, the number needs to be checked against the database and then if a record matches …

help me.i woul like to make my access 2003 database be network database.im using vb6 as front end.thanks

I have a program created in vb 6 and has a backend of ms access 2003 and it only runs on a single pc. i want to install that program to more pc but i don't know how to configure my database so that all pc can read/wrtite on it.please …

i am trying to develop a database management software.using MS ACCESS 2003 as back-end and VISUAL BASIC 6.0 as front end.. i am having a problem..can any one help with this.. [B]i have typed the code below in a module for the connection to the database...and connection to the record …

Dear Readers I have spent the past 3 days trying to work through the Microsoft White Paper on how to insert data into my MsAccess database and send an email confirmation to the viewer. At one stage I had the details being inserted into my database, NO EMAIL, now i …

Hi! I'm a foreigner working in japan and my job has recently put me in a position where I have to use Access for the first time. I've managed to create some tables and establish relationships between them, but I got stuck trying to create a form with subforms. I …

Greetings, I'm using Flash MX connecting to an MS Access database via JET. I've stored dates using Flash/Jet into my database as 'dd/mm/yyyy hh:mm:ss' into a DATE/TIME field. However I can't update because of the WHERE clause as I am not specifying the date correctly. I believe syntax wise I …

hai iam nireekshan i have davalep the one Neu User Enter form in html .In this form Fillap After SUBMIB After Useing MS-Access in THis create New User ENtrey Fields table and i am using TomCat Server and write jsp code and my database name NIREE Table Name New User …

hi i am nireekshan iam using only jsp how to connect database in Microsoft Access Drived hi i want to use database MS-Access, how to connect the jsp to Ms-access, plse send code

hi I designed simple program of computing the petrol bill and save it into MSACCESS data base. This bill included decimal places. But everytime I check my msaccess database. The number is automatically rounding up or down. I try to set standard settings with two decimal places but the number …

I am to develop a web based application for a telephone company. I am a novice so plz be deliberate and detailed in your solution. The company has a set of exchanges at various places and needs a daily status of their circuits and calls made by the customers at …

helllo, I do have a problem with access... this is my code: <% var connection= new ActiveXObject("ADODB.Connection"); connection.Provider="Microsoft.Jet.OLEDB.4.0"; connection.ConnectionString = "Data Source=" +Server.MapPath("/database/Training11.mdb"); connection.Open; var SQL = "INSERT INTO User (FirstName, MiddleName, LastName) VALUES ('lolo', 'keymo', 'rub')"; connection.Execute(SQL); connection.Close(); %> And i do get this error message: Microsoft JET Database …

Hi Guys I am a beginner in ASP and Access and need some help. I have a database and an ASP page that I need to connect together. The only problem is that I get an error message saying- [B][U]Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] …

hi i am trying to do a simple access database, with quantities, and a query with a report I have create a table with one of the variables being a numeric value, but i need to have 2 decimal places. when i format with 2 decimals, what ever i type …