199,114 Archived Topics
Remove Filter  | |
 | Dim Values As Range Dim CurrentSheet As Worksheet Set CurrentSheet = ActiveWorkbook.ActiveSheet Set Values = Rows(5) For j = 0 To 20 For i = 1 To Values.Cells.Count - 1 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=Delimit2!$A$" & i, Formula2:="=Delimit2!$B$" & i Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font Color = -16383844 TintAndShade = 0 End … |
 | This may sound confusing but I have a textbox which is a cell number textbox and I want when the max length of 10 has been reached then fire the php code which is inside the same html page as form and this php code will then get the value … |
 | Hello I am needing some assistance with setting up a function to check if a user is logged in or not with Passport.js using the local and slack strategy. I have a localstrategy which works fine but I also want to implement a sign in with slack as well. I … |
 | I work in VB.net only. I cal read an entire file in one statement, sort it with another statement and write it bacl in another. Three statements to sort a csv file! This is aswome, but I wan to know how to sort the file on different columns. Here is … |
 | Hello Friends, I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but when i click on report it dosent work and generates error :System.TypeInitializationException: The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception. …  |
 | I need a list of all 5160 name Indian cities by district name in xls/csv or sql format. Where can I find them?  |
 | $count1 = array(); $count1[0] = " 1"; $count1[1] = " 2 1"; $count1[2] = " 3 2 1"; $count1[3] = " 4 3 2 1"; $count1[4] = " 5 4 3 2 1"; $count1[5] = " 6 5 4 3 2 1"; for ($b = 1;$b <= 6;$b++) { echo …  |
 | I have a pascal script, which basically pushes information into a 3rd party system. I have an excel macro written, which saves raw data into a CSV file, which I would like my script to read, and take the data (each row is 1 record) and put each portion in … Programming pascal  |
| | I'm making a device that will display the weeks and days until a specific date (in this case my wifes maternity leave start). I am using a Raspberry Pi with a 4" screen. The plan is to use a python script to display full screen the weeks and days left … |
 | sqlconnection = new SqlCeConnection(ConnectionString); sqlcommand = new SqlCeCommand(); sqlconnection.Open(); sqlcommand.Connection = sqlconnection; sqlcommand.CommandText = (@"UPDATE ItemStock_Info SET Quantity =@qun WHERE [Item_Number]='"+ textBox1.Text +"'"); sqlcommand.Parameters.Add("@qun", qun);  |
 | I have a vb based software which is very old running on sql server 2000. When I tried to take a report, it says "runtime error 9 Subscript is aout of range".where to find this subscript? Please help me out.Thanks in advance |
 | Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature … |
| | I'm developing a GUI using wxPython (Boa Constructor IDE). My GUI has the following: Rich text control Start button Stop Button My requirement is that when I press the START button, numbers (1, 2, 3, etc.) should start printing in the text control; it should stop when I press the … |
 | i have a file .txt with some variables printed for a c program. Precedente lettura: 7129.00 m3 Attuale lettura: 7288.00 m3 Totale Generale: 159.00 m3 Lettura Carmen: 2597.00 m3 Consumo Carmen: 72.00 m3 Lettura Coppola: 487.00 m3 Consumo Coppola: 47.00 m3 Lettura Sarli: 1903.00 m3 Consumo Sarli: 37.00 m3 Eccedenza: … |
| | hi. i have a really basic question (really new to python). how do i read an entire binary file? from https://www.devdungeon.com/content/working-binary-data-python , `data = binary_file.read()` is to read the whole file at once. so i have a .dng file to test, which is 16.2mb, and i did: with open("portrait1.dng", "rb") …  |
| | I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( … |
| | Below program in completly executing but no data was inserted through sqlloader. Inline Code Example Here public class CSVDataLoad { public void runSqlldr () throws InterruptedException { String[] stringCommand = { "bash", "-c", "/usr/bin/sqlldr username/password@sid control=/path/to/sample.ctl"}; System.out.println("SQLLDR Started"); Runtime rt = Runtime.getRuntime(); Process proc = null; try { proc = …  |
| | **-EIQ Studio's-** is looking for new/semi-new web developers looking to further their skills and experience in Web Development by assisting the Community with our Website. Once completed, A percentage of all profits that come through the website will be awarded to the developers.  |
| | I have a wx.DatePickerCtrl with the dropdown popup window that allows the user to pick a date from the calendar. What I would l like to have my program do is process an event when the user has clicked on a day in the dropdown calendar. Unfortunately the only native … |
 | A person starts out as the "Curator" and stands at the end of a field. Everyone else playing stands at the far end (distance depends upon playing area selected). The object of the game is for a "Statue" to tag the Curator, thereby becoming the Curator and resetting the game. … |
| | [B]The following problem comes from an old JavaScript Textbook, JavaScript – First Edition, by Patrick Carey and Frank Canovatchel. This problem is not used in the Second Edition, making the question I shall ask a fair question. The problem is Case Problem 2, Chapter 9, pages 519-20. Here are the …  |
| | I managed to get the value of an enum via reflection. I have to use reflection since I have different objects with enums in them. But how do I get the name of the enum? Let's say I have [CODE] enum MyEnum { A, B } [/CODE] I can get …  |
 | I am trying to understand the SynchronizedMap and I ran the below code. I get the below Output with an exception. According to my understanding the exception is caused when the get() methods are trying to access the syncmap when a thread is still executing a write on the map …  |
 | Hey guys: I am trying to make this form to clear after being submited. As it is now the form submits, however, the input fields do not clear and when you refresh the page it ask you if you want to resubmit. Can anyone help? <?php // Message Vars $msg … Programming php  |
| | This is my custom module: [CODE]class Player(object): def __init__(self, name, score = 0): self.name = name self.score = score def __str__(self): rep = self.name + ":\t" + str(self.score) return rep def ask_yes_no(self, question): response = None while response not in ("y", "n"): response = input(question).lower() return response def ask_number(self, question, …  |
 | So, the title may seem confusing so hopefully I am able to explain myself better via the thread body. I am developing an application for a friend that wants to have a blue light reducing effect for his every day browsing. I have been able to accomplish the task by …  |
 | hi i used this simple form which are these..but i want to protect password from oracle database if user enter wrong name and password then not login otherwise login <!DOCTYPE HTML> <html> <head><br> <style> .error {color: #FF0000;} </style> </head> <body style="font-family: verdana, sans-serif;";> <hr /> <div style="width: 77%; height: 300px; … |
 | Hi. I have a .raw file and I want to display it as hex. why? because i want to try and replicate what 010 Editor can do which is read any sort of file and display in whatever format user desires (plus it can be used to edit and stuff) … |
 | Hi there, I would love to make a list and have a collection of database servers, could you all please help me? It would be nice if you could provide a link to their homepage. If you post, I will update the first post. [list] [*]MySQL ([url="http://www.mysql.org/"]http://www.MySQL.org/[/url]) [*]PostgreSQL [*]Access [*]MSSQL …  |
| | Hello experts i need help about screenshot code. i have two form ( Form1 & Form2 ) form1 have one button and picturebox. and form two is empty. i want to take screenshot with form width and Height. mean's where i move form2 and press Command1 button on form1 then … Programming microsoft visual-basic |
 | <?php require('db.php'); include("auth.php"); $id=$_REQUEST['id']; $query = "SELECT * from new_record where id='".$id."'"; $result = mysqli_query($con, $query) or die ( mysqli_error()); $row = mysqli_fetch_assoc($result); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>View Records</title> <link rel="stylesheet" href="css/style.css" /> </head> <body> <div class="form"> <p align='center'><a href="index.php">Home</a> | <a href="view.php">View Account</a> | <a href="logout.php">Logout</a></p> …  |
| | Hi everyone. I'm having a very seriouse problem where I have a textbox and I want a button and I want to take whatever a user type in this textbox/textarea and set it to the `data-name` which is a button's parameter. Here is the codes. Textarea: `<input type="text" id="dCell" value="Cellphone …  |
| | I was wondering what would be the best way to implement an algorythm to figure out what side a circle has collided with a rectangle? After check to make sure a circle has collided with the rectangle im trying to figure out how to know what side of the rectangle … |
| | hi everyone I am currently practicing my java skills by doing this program called car rental management system. I am creating a login page where when the user login it should bring up a dashboard. but the problems when the user login and it say "credentials match, the dashboard doesnt … Programming java java-swing mysql |
| | Hi, How can i calculate time difference in swift 2 between two dates/time and store in 2 different variables, one showing the full difference in terms of "Year, Month, Days, Hours, Minutes" & one variable for converting the total time difference in minutes. For example- First Date/time - 04/13/2016 8:11 …  |
| | Hey everyone, I have a table, that is going to used to calculate IFTA, its a fueltax calculator populated by each state and the rate of each state. My question is, do i need to create a formula for each state? or can i do 1 formula and have it … |
 | Hello i have a problem working with Camera on Ionic and i need some advice. I have installed both ionic camera and media capture plugins. I am using two scripts one to capture Video (Start Reocording) and one to capture a Photo (Take Photo) I am getting the errors displayed … |
 | Inherited [this page](https://library.kutztown.edu/newsteam), a mashup of an HTML5Up template called [Strongly Typed](https://html5up.net/strongly-typed) trying to work inside our content management system, which runs on Bootstrap. Though we cannot edit the stylesheets bundled with our CMS, we can override via inline declarations & custom page-level CSS; the [page in question](https://library.kutztown.edu/newsteam) has the … |
 | At the beginning welcome all. I have a big problem and I can not deal with it. I would like to refresh dategridview after adding and editing data. I try to add ShowData() function on closing Form2 and that didn't work. Thanks for any help or advises :) and link …  |
| | In the below code about the synchronisation between threads, according to the output generated why is the control being transferred to the execution of the new thread despite the lock being acquired for the same object "dt" in the main method ? public class DemoThread extends Thread { public DemoThread() … |
 | |
| | I am trying to run the below concurrency code: import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; import java.util.concurrent.TimeUnit; public class TestThread { public static void main(final String[] arguments) throws InterruptedException { ExecutorService executor = Executors.newSingleThreadExecutor(); try { executor.submit(new Task()); System.out.println("Shutdown executor"); executor.shutdown(); executor.awaitTermination(5, TimeUnit.SECONDS); } catch (InterruptedException e) { System.err.println("tasks interrupted"); } finally … |
| | I'm creating an online learning courseware using PHP 5.5 and connecting via PDO. But I'm confused as to how to get the courseware to work, as I want. This is what I've done: I created a table for students and named it "users" and another for courses and named it … |
| | Guys and gals, I am trying to do a simple LITTLE DIVIDE problem using jQuery its getting the values, but when its returning the results, it as if they are being divided by 10000, but I know its not... E.G. 50506/1000 = 50.506 in my jquery problem, it is coming … |
 | Hi, I am testing a Tcp client C# windows form application I am able to send data to Tcp server Software(Hercules 3.2.8) But when i sent data from Tcp server to windows form then i am getting the following error: System.InvalidOperationException: Cross-Thread operation not valid: Control 'MessageList' accessed from a … |
 | Hello, I'm not able to display the whole select result information in the table and I have no idea what I am doing wrong, I would appreciate your help so much. So here's my code: <?php $DBServer = 'localhost'; $DBUser = 'root'; $DBPass = ''; $DBName = 'world'; $conn = … |
| | I want to add text into icon of the listView , how do I write the code ? You see the image file attached, for this example I add the word "special" color green. http://www.mediafire.com/view/ieaac6fe58wo4ye/GianhRieng.jpg |
 | Hi, i am working on program that connect to database, and user then cans see, edit, insert and delete data in mysql database. I have problem whit update query, can somone help me whit this. User need to click on cell and enter/change data, then hit enter to save changes. … |
| | Greetings I'm fairly new to python, and I know that this is possible but I'm having trouble with syntax: I'm reading a file from the command line and putting it's contents into a dictionary. Keys are repeated in the file, so the values must be placed within a list. In … |
 | I'm not sure if this is the right forum to ask this in, sorry if it isn't. It's been a while since I've been to this site. We have a MS SQL database that contains a table with some columns that are no longer used (or shouldn't be). The data … |
The End.