3,842 Topics
 | |
| | 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 … |
| | Hello all, Does VC++ Express 10.0 even support the ability to get text from a text box? I've seen related threads having conflicting solutions, none of which actually work. Ex: must have SDK version x.y. This functionality seems to be so basic and necessary that solutions would be all over … |
| | 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 … |
| | 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, I'm new here and I wanna know how can I use the default Windows folders in my code in VB 6. For example, in VB.Net I can use My.Computer.FileSystem.SpecialDirectories.MyDocuments shorcuts to know the path of folders like My Music, My Docs, etc. But I don't know how to do …  |
| | 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 … |
| | Hi, I have a problem with an VB aplication programmed in Visual studio 2005. Recently i was upgraded my computer with windows XP to Windows 7 Ultimate (fresh instalation). After that I made reinstallation Visual studio 2005 and service pack 1 for Vista/win7. My problem now is when I run … |
| | Hi everyone, I need a script that will redirect an excel API from one database to another using VB.net. I am still a novice. I need your help. Thank you. |
| | hi, im having a graduation project which i should make a windows mobile application using visual studio 2005, and really i dont know what topic can i choose and the doctor doesnt want to provide me with a topic,, so if anyone can help just with a topic, because it … |
| | I have setup a global variable. I need to store in this variable the value of Max(RequestID) from tblRequests. Then, I want to assign the variable to a label control on a form when the form opens (On Load event). Then, I want to run a query to include this … |
| | I need functionality to retrieve the new pk, like I could in DAO. I would like my "nLog" function (see code below) to return the new pk. I have found [URL="http://support.microsoft.com/default.aspx?scid=kb;en-us;815629&Product=adonet"]this[/URL], and I was able to make it work fine in my environment, so I'm pretty sure the problem I … |
| | Hello fellow Daniweb members! Really this forum can't be what it is without you guy's... Just a quick question, can you incorporate the windows file explorer in a C++ application to save and open to a chosen file path? I am asking because I have seen it in other app's …  |
| | I have 10 buttons and a textbox on my widow form. 11th button to fire the operation. Task is that i need to input a no. in the textbox ranging from 1-10, and press the fire button. This should change the forecolor of the respective button in the form. Suppose …  |
 | Ok, here's what I've got. I have a form that exports to an Excel worksheet (sheet1) and it works great, no issues there or anything. It's not a template, just a regular .xlsx spreadsheet, but I use it as my template. Now, the goal is for the end user to …  |
| | Hello everyone! Trying to setup a connection to a website to be able to update currently displayed data and push it on a regular basis to my spreadsheet. The link I have is a direct link to download the newly updated spreadsheet. I continue to get an error message when … |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack |
| | Adding excel data into hash table: [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataTable dt1 = new System.Data.DataTable(); da.Fill(dt1); System.Data.DataRow dr; //System.Data.DataColumn dc; #endregion # region adding excel file into hash table if (dt1.Rows.Count > 0) { for (int c = 0; c < dt1.Rows.Count; c++) { // if (c > … |
| | Can anyone recommend an ODBC driver for Excel in VB 2010 Express? This is a 'legacy' problem having just being forced to move from VB6 to 2010. Any help well appreciated |
 | Need some help understanding Server 2008's infrastructure. Running a program that requires access to the Document and Settings folder. I have full admin rights but it's still giving me an access denied message. Any help? |
| | First, sorry for posting this here, but I couldn't find a VBScript forum on Daniweb (which I find surprising). I'm working with binary data in several different projects. Below is an example of code that works to retrieve a static map image (PNG) from Google: [CODE]strFileURL = "http://maps.google.com/maps/api/staticmap?markers=2200+S+Western+Ave+Lisle+IL&zoom=14&size=400x400&sensor=false" Set objXMLHTTP … |
| | Hey there, I'm currently using NetBeans 6.8 running Cygwin GNU Bash version 3.2.49(23)-release. I'm having a problem running my program that uses pthreads, mutexes, and semaphores. After it creates 1 to 3-4 threads, it returns a Segmentation fault. I ran the program on a computer running Linux (using NetBeans as … |
| | I finally figured out how to auto fill a record in forms. YEAH! Yet I ran into a new problem. Sigh! tblEmployee holds frmEmployee information. qrySiteName pulls information from several other tables giving the details of each location. On frmEmployee, I have it to where when I select the SiteName, … |
| | I want to add first two columns of excel file into hashtable.. I wrote following code but it is giving me eror saying indexing not allowed in datacolumn... [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataColumn dc; // adding excel file into hash table if (dt1.Columns.Count > 0) { for (int … |
| | Hi, I'm trying to write a program for Windows that will control the mouse with the keyboard, but I'm not sure I understand how Windows works. My theory is that I will need to send mouse event messages for the mouse and hook the messages from the keys that are … |
| | I am having a problem trying to save records in a parent / child data relation. I have to tables tblContacts & tblMember. There is a fk relation on the ContactID field. The tblContacts table is the master record. I am using a set up bound windows forms controls to … |
| | I'm writing a query that will produce the athlete's id, their name (first name and last name combined into one column), the total number of games they have participated in, and the total number of medals they have won. This involves a number of tables. In one query, the number … |
| | Show the details of sales orders which are paid more than 14 days after the date of the sales order. SQL: SELECT SO.OrderID, D.DistributorID, D.FirstName, D.SurName, SO.OrderDate, P.PaymentDate, P.PaymentAmount FROM SalesOrder AS SO, Distributor AS D, Payment AS P WHERE D.DistributorID=SO.DistributorID AND SO.OrderID=P.OrderID AND DateDiff('yyyy',PaymentDate,Date( ) ) - DateDiff('yyyy',OrderDate,Date( )) … |
The End.