5,053 Topics
 | |
| | Hello Frends, I have an application where I am trying to connect MS Access DB with a ASP.Net(C#) Page and the same application also connect to the MS SQL Server (Working Fine). While connecting I am having following [B]error:[/B] _____________________________________________________________________________________ [B]Server Error in '/manager' Application. The Microsoft Jet database engine … |
| | Can anybody help me in on how to connect my VB interface to a database. I have already designed the interface but I do not know how to connect it to Dbase. Damson  |
 | Hello folks, [B]System:[/B] HP a1649n computer, O/S XP Pro, SP3, BIOS 3.08. Processor Intel Core 2 @1.86GHz, Fam6, Mod15, Stepping6, 4GB RAM, connected to TWC through WRT54G Running Avast! and Windows firewall - this and other 6 computers on network have shown no issues in over a year with this …  |
| | Hi I'm doing an assignment on Rational Number calculations. I'm getting some compiling errors which I don't know how to fix. Here is the error message and the code is beneath the error message. I would really appreciate if someone could read over this and see if you know whats … |
| | I have 1 desktop comp at home running xp pro. Then I have 3 laptops. 1 with 7, 1 with xp pro and 1 with vista. I was always able to access the desktop from all the laptops until.... The desktop was not allowing me to upgrade to internet explorer …  |
| | 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] … |
| | I'm an intermediate vb programmer, i need help . I wrote a code that'll fetch a particular employee id (EM_ID) and print the report but its saying this whenever i compile and run. Runtime Error 2147217904 [80040e10] [ODBC Microsoft Access Driver] Too few parameters The code is below rs.Open "SELECT … |
| | Everytime I boot up my comp, I either see my desktop picture but no toolbar on the bottom or no desktop picture with the active desktop recovery screen. Whenever I get my desktop picture but no toolbar at start up, I normally bring up Task Manager and end explorer.exe. which …  |
| | 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 … |
| | Can anyone help please. When starting internet explorer get message "Internet Explorer cannot display the webpage". Computer is on line (signal excellent) and can access internet through firefox. Have run microsoft malicious software tool and nothing found. Any help appreciated, please make it simple as I am a bit of …  |
| | Cpu Usage spikes to 100% at various times causing the need to reboot. I have run MBAM, ATF cleaner, and Microsoft's Malicious software tool. Your assistance is appreciated in resolving this problem. Malwarebytes' Anti-Malware 1.46 [url]www.malwarebytes.org[/url] Database version: 4734 Windows 5.1.2600 Service Pack 3 Internet Explorer 8.0.6001.18702 10/2/2010 7:34:53 PM … |
| | I am using microsoft access as my database. When i click on the button Enter Details nothing happen. Please suggest where the mistake is. The doGet method contains the following code [CODE] super.doGet(request, response); String Name = request.getParameter("txtName"); String Designation = request.getParameter("txtDesignation"); Connection con = null; PreparedStatement pstmt = null; …  |
| | Hello, I am a current Java student and am having a problem when I run my compiled program from an in chapter lab assignment called "Stock Tracker". I receive a message from a dialog box "Cannot locate sun.jdbc.odbc.jbcOdbc Driver. Class not found exception creating database object. Following are a list …  |
| | I am using Visual studio 2005 and Access 2007. I get the following error "System.InvalidOperationExceptin: The ITransactionLocal interface is not supported by the 'Microsoft.ACE.OLedb.12.0' provider." Is this because transactions are not supported by access? Here is my code. [CODE] using (TransactionScope TransacScope = new TransactionScope()) { //insert and update operations …  |
 | 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 … |
| | So I have a small database for managing stationery orders (internally with my company - I order from the stationery dept). In the orders forms i have a subform with the list of items being ordered. I have the Item_ID, description, UnitsOrdered,UnitPrice, TotalPrice. What a code that will lookup the … |
| | I'm new to Access 2007 need some help in regards how to build expression for the following - Product Price $: * Product Quantity - % (any number). Started with the following expression: Total Cost $: [Product $:] * [Product Quantity:] - [Discount %:] |
| | My Problem starts when i borrowed my classmates USB flash drive i click a 'katrinascandal.vbs". . . Then not knowing anything i didn't think my drive was going to be infected with it Then i start opening "My Computer" then C: and i found out i have "Katrinascandal.vbs" So i … |
| | Hello. After scanning this computer in safe mode with Nod32, Makwarebytes, SuperAntiSpyware, and TFC I got rid of around ~700 infections. But still I believe that there is something left because malwarebytes sometimes finds some folders infected. I scanned again with all those programs and non of them found anything. … |
| | Please help. (NOVICE here...bear with me).... Installed SoundBlaster Video Card, (SB Audigy), some months ago. It has never worked. (Son's computer, recently had him bring it to me for help). Checked Audio Devices, (Device Manager) and found that Legacy Audio Drivers contain no information under "Properties." Searched further, (system devices) … |
| | Hi to all! it's my first time to post under the networking category since i'm really on the programming side so pls. bear with my ignorance. I'm just tasked to create a network with a very little understanding of it so here goes: i need to set up a small … |
| | Dear all, I would like to buy one or two (if needed) wifi access point for my lab. The lab hall is about 50 meters long and there is a concrete wall in the middle. This is mainly to give an internet connexion (so no huge file transfer). Would it … |
| | I have been working on a database in MS Accesss. I am trying to generate a query in the SQL view but the introduction to SQL class I am taking did not cover how to incorporate multiple WHERE conditions. Here is the query so far... SELECT intFID, COUNT(*) AS TotalAudits, … |
| | Hello Below is my entire code of a mobile application. The 4th form with the ID "bookDetails" is supposed to be used to retrieve data from a database called butternut3.mbd. I am currently stuck on writing a code in the script part, for a user to search and view details … |
| | Hi, I am using MS ACCESS. I want to make Do not click a button more than once. I made a calculation button. And want to be just one click. Thanks alot. |
| | hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = … |
| | Hello, I am having trouble with my laptop connecting to the wireless internet at home. Recently, a new internet router was installed and since then, I've been having trouble connecting to the internet wirelessly (not just at home). It connects to the network, but then says that I only have … |
| | hi guys, i'm having a problem manipulating the datagridview. i have an access database named "ETB.mdb" and a table inside it named "ETB" it is a read-only database and it has to stay that way, anyway, what i'm trying to do is to retrieve the data on the database put … |
| | Dear DaniWeb Programmers, please help me with my problem. im trying to fetch rows in 3 TABLES using JOined Queries im tried the query first in MS ACCESS and it worked but when i tried to show it in Crystal report it wont show its data. Heres the code below: … |
| | I work in a research lab and I'm building a new filemaker pro advanced 11 database to hold our study data. The variables that this database stores will occasionally be exported into excel documents and merged with exported data sets from another database. Unfortunately, the person who built the first … |
| | How can I retrieve data from a DB in Access to labels, or radiobuttons in VB.NET? I've search and to retrieve data people usually show Datagrids. I just need to know how to navigate in records, by the number of their position (?) and to place that data in labels/textbox … |
| | I am servicing a customer's laptop, a Toshiba Satellite L305-S5885, running Vista Home Premium x86 SP2, with malware infections and internet connection issues. I have gotten rid of all her 251 infections, and now am addressing her connectivity problem. I am unable to achieve internet connectivity on either her ethernet, … |
| | Hi wonderfull team of deniweb. short story of my sick computer - my internet explorer redirects me to random sites,very very slow, freezes all the time and lately turns off completly by itself.very annoying! I have followed the steps of your instrustions how to initially clea a little before posting … |
| | Hi, This is a from that take comment from the user. Everytime a user open this form, currentDate and Time will be generated although the user does not put comment in it. Today's date = 18/10/2010 earlier, when this user open this form, the date is still "18/10/2010" But, in … |
| | Hello all.. I am a new user of Windows Vista (came installed on my new laptop). Which Microsoft Office Suite is the best version to run with Vista. I want to install one that does not hog all my resources and take up too much space. Also, when you install …  |
| | [CODE]Guys I've a problem. I'm using access 2007. The file name has an extension .accdb . I created a table called 'login' in the db file named 'MySite_Database.accdb'. My HTML looks like this : [COLOR="Red"]<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="login.aspx.vb" Inherits="login_to_site._Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html … |
 | Hi all, I have AVG installed w/constant updates, I run spybot - S&D on alternate days with ad-aware, I have spywareblaster and spywareguard loaded. AVG now takes over 18 hours to run. Switching from one tsl task to another can take 10 minutes. And there seems to be no let … |
| | Hi Guys I'm new here so if my post is in the wrong place then please tell me where to stick it without telling me where to stick it if you know what I mean. Hoping one of you guys is inventive enough to come up with a solution for …  |
| | I have a Subjects table with a field Prerequisites, which contains data similar to the Subject IDs in the same table. So for example a subject4 may have the prerequisites subject2 and subject3. The contents of the Prerequisite field are delimited by ORs and ANDs, meaning if there are more … |
| | Hello... I'm a student who's only taken some basic coding classes. My project might be a bit ambitious for my skills, but I'm getting stuck on one small issue. I built an Access database for our personal library. I'm building a small application that will: 1. Display all records of … |
| | I have a query that has two counts in an if statement. I need the query to return all values even if they are null once equated by count. I have tried the NZ function to no effect. Any help would be greatly appreciated. [CODE]SELECT REPRESENTATIVE.Country_id, IIf([CONTESTANT.Team_id] Is Null,COUNT(*),COUNT(*)-1) AS … |
 | Guys, does anyone of you have Windows 7?... Okay, here is my problem can you kindy test this code in windows 7. [CODE=vb] Public Sub createAccessDSN(MDBPath As String, xDescription As String, xDSN As String, xUID As String, Optional xPassword As String) 'Creating the DSN #If Win32 Then Dim intRet As … |
| | All, While not precisely a newb, it has been a long, long time since I've done Access 2003 work and that's all they have in my new job (yay). I used to know how to do this, but first the structure: [B]Table_A[/B] Key Subject Date etc. [B]Table_B[/B] Key Boy y/n … |
| | Hey there, I can't seem to figure out why i can't access the member '*next' from the Node class to the Shuffle function. Any help would be great. [CODE]/* llist.h * LList */ #include <iostream> #include <string> using namespace std; typedef string ElementType; class LList; class Node { protected: ElementType … |
| | How to use TOP(1) keyword in MS Access query. select * TOP(1) from mytable orderby mycolumn desc; this querry gives me error; Any other alternate to implement this code; |
| | Hello, I have been attempting to export fields from an acesss query to a csv file. In each case the first time I export the file everything is perfect. However when I go to recreate the export (using the same query) the memo field is suddenly truncated. Any idea why … |
| | [B]Hi, I get this error .... I have seen it posted before but no-one seems to have a solution so I am posting it again. I have pinged IIS, set permissions in folders, reset IIS. Any help appreciated [/B] [B][COLOR=#000000]HTTP 500.100 - Internal Server Error - ASP error Internet Information … |
| | Hello everyone, I am very happy to have found this site. I have been looking for opinions about my future. First of all good day to you all, I hope you are having a greet week. My name is Anthony and I am a undergraduate in a 4yr university. I … |
The End.