3,842 Topics
 | |
| | 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 … |
| | 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? |
| | 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 … |
| | 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 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 … |
| | 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. …  |
| | 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 …  |
| | 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 …  |
| | 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() … |
| | 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 … |
| | 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 … |
| | Hi, I am having trouble with a question and am wondering if someone knows where I am going wrong. I am to list the patients of a hospital (persons that have been admitted) that have a next of kin listed as a staff member. I am to list the patient's … |
| | i need help, i am making a web browser in vb 10 and i have a built in media player and i want to make a play list. i got it to work with a listbox but not anything else. For the menustrip [CODE] Private Sub PlaylistToolStripMenuItem_DropDownItemClicked(ByVal sender As System.Object, … |
| | Hi, I have a java program with quite a lot of classes. I'm facing a problem with accessing some variables from another class. May I know how to I access it? Is it possible? |
| | Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center … |
| | HI All, My name is s0ur and I am not a programmer. Isn't that the first step to recovery? I am hoping that the experts can help a noob. I am trying to write a python script that will run on windows login. it should do the following: 1) ping … |
| | Hi, I have a table Employee that has a coloumn EmployeeID, SupervisorID, and Active(values Yes or No).. I need to find the number of Active Employees(with Active as Yes) under each supervisor.. how can I write the query? I am using Access 2007. Thanks! |
| | Hi I have 2 tables say A and B. Table A has EmpID, First Name and Last Name. Table has Award Recipient, Award Presenter ID(EmpID format). I want to write a select query where I want to fetch First and Last name of the Award Presenter from table A based … |
The End.