14,025 Topics
 | |
| | 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( )) … |
| | sir,i i have two date columns today_date and doj_date.both of them are varchar data type.now i want to update today_date='01/06/2010' to '01/04/2010' where doj_date='01/04/2010'.that means only the month column. ihave used the following code update installment_scheme_customer set substring(today_date,4,2)='04' where substring(today_date,4,2)='06' and substring(doj_date,4,2)='04' . but it is showing error like this … |
| | I have a simple form in which i have a contact name combo box. The combo box gets info from a querry (name, contact number 1, contact number 2). I want the name to display in the combobox (which it does) and then contact # 1 and 2 to display … |
 | Hello there I have this question. I have a PC with an old Pentium 4 and Windows XP installed on it. This PC has only 512MB. The Windows explorer's window gets really slow, almost stuck, whenever I browse "my images" folder inside of "my documents" folder. This "my images" folder … |
| | When under Windows 2008 Server with my C++-program (with a cicle) many directory are copiing, then the memory is increasing and remain at a high level. Waht can I do? |
| | Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 9:56:16 AM, on 28/06/2010 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Unable to get Internet Explorer version! Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccProxy.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Symantec Client … |
| | I've been having one problem after another since yesterday morning. The problems started with notifications that an application could not be executed, because the file is infected. I ran Malwarebytes Anti-Malware and that seemed to do the trick, at least until this morning, when problems started showing up. In order: … |
| | Hi, I need to compare following xml file USING C#: [CODE] <Issue> <IpIssueId>790</IpIssueId> <IpIssueGuid>11</IpIssueGuid> <IssueName>Summary</IssueName> <RuleQuery>Rule1</RuleQuery> <Classification>R</Classification> <IssueError>Summary</IssueError> <Severity>100</Severity> <IssueFormat>Total domains: [[DomainCount]] </Issue> [/CODE] with excel file like: IssueName Type Summary Risk(R) bb Health(H) I need to verify whether "type" column of excel matches with "classification" tag of xml file. |
| | Hi everyone! I have an installment payment program which have Hijri date (Saudi Arabia) and I already have the code for it's converter inside the forms (using datetimepicker for the Gregorian & maskedtextbox for the Hijri). I'd like to know how can I convert or produce the corresponding equivalent Hijri … |
| | Hi, please help me get rid of this nuisance. It opens sometimes in the background, or with an ad or annoying sounds. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 12:57:18 AM, on 22/09/2010 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet Explorer v8.00 (8.00.6001.18702) Boot mode: Normal Running … |
| | Thanks for your prompt replies. I just read the following on Prometric's website : "In order to sit for a Microsoft Certification exam at a Prometric testing center in India, China, or Pakistan, you must be a legitimate resident of that country. If you are a legitimate resident of that …  |
| | i have done hijack this and the report follows Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 22:00:40, on 18/09/2010 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe c:\Program Files\Common Files\iS3\Anti-Spyware\SZServer.exe C:\Program Files\Trusteer\Rapport\bin\RapportMgmtService.exe C:\WINDOWS\System32\svchost.exe …  |
| | Does anyone know how I can find the version of Microsoft Windows Installer(MSI)? I've found references to a "getdllversion," but it's not a standalone program. It's all code for different languages and I'm not a programmer and not sure what I would need to even run the code I'm finding. … |
 | [font=Arial][size=5][color=#0000ff][i][size=2][color=black][font=Verdana][color=black][i]I found this in a few different places around the 'net - hopefully it's helpful:[/i][/color][/font] [/color][/size][/i][/color][/size][/font][font=Arial][size=5][color=#0000ff]Increase Your Cable Modem or DSL Speed in XP[/color][/size][/font] [color=#000000][font=Arial][size=2]This tweak is for broad band cable connections on stand alone machines with WinXP professional version - might work on Home version also. It may also … |
| | This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) … |
| | I am experiencing lots of problems with internet connection recently: although the wireless network connection icon says "excellent connection", internet explorer highlights no internet connection. I have to right click on the wireless network connection icon, use repair and it works again for some time. The same thing happens several …  |
| | Hello. I'm running Norton Internet Security 2009 on WinXp with SP3. Two days ago, I checked my Intrusion Prevention log on Norton and found the following enrty: An intrusion attempt by PAULSHP was blocked. Application path \DEVICE\HARDDISKVOLUME2\PROGRAM FILES\MOZILLA FIREFOX\FIREFOX.EXE Risk Name: HTTP Misleading Application Download Request Attacking Computer: PAULSHP (192.168.1.2,1219) … |
| | I am using VB & Access to create a program for a clinic. I want to create a Report. The Report is - Toal quantity of each medicine received & Issued. I have created the Table in design time & in runtime contents in the table are deleted and new … |
 | I have been reading through a rather lengthy Microsoft document regarding UX (User eXperience) design and standards. There are many great suggestions that I have started to adopt. But something occurred to me last night while working on my solution and I wanted to solicit some ideas and possibly have …  |
| | I want to buy MS Office 2007 or 2010 Professional and I can find it on Ebay at an average price of $175 US. I am wondering if there is some reason I am not aware of to not buy any of these programs. What do I need to know … |
| | good day everyone! im a 19 year old noobie and i really need your help right here... im not sure if im in the right category but im hoping someone could help me here... when i log in to my account in normal mode, everything is [B]black[/B] (no wallpaper, not …  |
| | Hi, Helping a friend with their computer. They're currently having a problem accessing internet. In Internet Explorer they get message "Internet Explorer cannot display the webpage". Can only use Windows Messenger on internet. A couple days ago started getting all kinds of porn pop-ups. * Ran Windows Malicious Software Removal … |
 | Hi, I know you are all busy and I know I've been daft but someone's help would be most appreciated. I have suffered an attach by Anti Malware Doctor and immediately ran Malwarebytes Antimalware to get rid of it. I thought I had cleaned it up at first then strange … |
| | I am trying to create a switchboard button in Access 2007 that will open a password input box as a security for a form. The switchboard button calls a macro which will then invoke a macro to run the following code: [CODE]Public Function Password() Dim stDocName As String Dim stLinkCriteria … |
| | Having a problem here...not sure if it's something simple or not. I'll be honest, threading is new to me so I'm not quite sure what the problem is here. Let me explain the problem first and then I'll post some code. I have a method that runs in a wizard … |
| | Hi everyone! Im really stuggeling with excel. I do know how to import txt-files from web into excel, but when i do, the charset is wrong. So the Norwegian letters ÆØÅ is now wierd symbols (Ã¥Ã). This is not the case if im importing the text-file from a local folder. …  |
| | Hi, I am just new using the Microsoft Application Blocks .NET. I am using a custom one... The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...? [CODE]public void ExecuteNonQuery(SqlCommand sqlCmd) {...} public … |
| | Hi Daniweb Community, I have a application that opens a pdf viewer and I would like to email the current(one in the pdf viewer) as an attachment in Outlook. I have listed the code below that opens the pdf viewer and I have listed the code to send an email … |
| | Not sure if this is the right place to post this. I've built a number of websites but have just now been asked to provide a password protected page that allows different customers FTP access to download files. I feel dumb. Having never done anything like this before. Obviously I …  |
| | OK SQL documentation sucks. I know that, I've known that for years, but it can be helpful and useful at times, so I use it. I thought I remembered correctly what "~" did, but looked it up anyway. I'm reading the usual @#$%, but getting the basic information (While thinking … |
| | I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from … |
| | Hello friends, I am writing a program that behaves like a (Linux)shell (but it's not really a shell because it does not interpret commands itself). It will read some commands like in Linux shell and then run the command in the same window of course. The standard MSDOS shell does … |
| | I am attempting to create 2 fields that will create decimals so that I can take these decimals and create a percentage in a new field. Here is what I have and I can't seem to get the errors gone. [code] WOAVG = IIf("[WOIssued]=0", "", Val(Nz(WOCompleted, 0)) / Val(Nz(WOIssued, 0))) … |
| | I am using a shared MS Access database where I set the custom properties each time a user opens the front end, but for each property I am setting, they are being deleted by Error 3167. This has only started happening once the DB is being shared, but the code … |
| | I am currently trying to take two columns from a *.csv file... log10 transform them, and then plot them up on a graph. The graph is not the issue, I just need to edit those two columns and plot them. The file does have a header row, there are 8 …  |
| | Please help I'm on the verge of tears. 1) I cannot open most of the programs in my computer i.e. iTunes, My Computer, My Documents,Control Panel. A blank window just pops up and hangs. 2) I cannot 'Save As' files from the internet into my computer either. If I try … |
| | I need to make 2 tables for my computer class one would be the suppliers the otherone the products and I can't seem to get it started can you help me |
| | I need to execute a .exe file located in C:\Program Files\ABC\test.exe on my windows machine using PHP. I have installed WAMPP/XAMPP to run PHP. I have tried the exec() system() shell_exec() but I'm unable to run the file. [B]Can someone help me with the exact code?[/B]  |
| | Hi guys can anyone help me I would like to put files like application forms and pictures on my site to be available for free downloads. I have got no idea how to go about, can someone help me with the code. Regards Majaheni |
| | Hi team, I've written a windows program and it works nicely but its really slow when it retrieves the data from the server. Program Overview: The program allows users to search through a database and add contacts if they want. Some of the fields on the forms fill up depending … |
| | I am having trouble getting this to work in a subform My Form is called frmFacilities My Subform is called QAMain subform The first combo box in the QAMain subform is RiskLevel Its Row Source is: SELECT tblRiskLevel.RiskLevel, tblRiskLevel.Description FROM tblRiskLevel ORDER BY tblRiskLevel.RiskLevel; Its Event is: Private Sub RiskLevel_AfterUpdate() … |
| | Good morning. I read and followed the instructions posted on this site. I ran the Microsoft Malicious software removal tool and it identified the Alureon.h virus. I could not fully delete the virus as I was unable to access the Internet and get the rest of the manual steps to … |
| | I have made an application with MS Access 2003 as my database. I made its setup and installed in a pc which MS Office 2007 installed in it. I am getting an error of "Microsoft.Oledb.Jet.4.0 resource not found". And my setup is not working. What to do now? |
| | Windows 7 is the latest release of Microsoft Windows, a series of operating systems produced by Microsoft for use on personal computers, including home and business desktops, laptops, netbooks, tablet PCs, and media center PCs.[4] Windows 7 was released to manufacturing on July 22, 2009,[5] and reached general retail availability … |
| | Hello Friends. I want any resources or Ebooks on Couputer Basics in questions and ans format(multiple choice questions). these are for testing the knowledge of students on Computer h/w,S/W , DBMS, computer N/W ,and network security. thanks. |
| | I am not really looking for anyone to hold my hand through anything, but I am looking for someone to direct me to meaningful data/literature on the subject be it books/websites/videos/etc. I work for a small family business that repairs specific types of production machinery. We have a database that … |
| | I'm having trouble trying to update or delete records from my database. Basically, I have a datagridview(DGV) in my form and the following is what I wanna do. The user could directly change/edit the values in the DGV and just click the update button to update the database. And the … |
| | My specs are as follows: AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ 2.20 GHz Performance Rated at: 4.4 GHz 2GB's Ram Microsoft Windows 7 Ultimate Edition (build 7600), 32-bit HD 225 GB's My current Graphic Card is ATI Radeon X1550 Series and apparently it sucks, can someone please tell … |
| | For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time … |
| | My computer is infected with some sort of malware called AntiMalware Doctor. This is like a scanning program that appears to pop up and scan my computer. It also has a windows security logo that pops up on my taskbar. Aside from getting scan popups, the main problem is that … |
The End.