johndohmen1963

I have a problem with my datagridview. And the following happens I have several buttons to load the datagridview. All these buttons are working correct So datagridview is loading as expected. Only when i press the right or the left arrow butoon and when then datagridview wil be selected with …

I have the following problem. when i pres buttun printpreview (button 5) the the print preview fires up. and when i close the print preview without printing and minimize the form (after close the printpreview), and when i maximize the form again the image in the picturebox is turned 90 …

Hi i have a problem with the print screen button. When i press that button my whole system is freezing. The only thing i can do is restart pc by hand. Since two weeks i have a new key bord it´s the Logitech K800 with setpoint installed. some info from …

Hi I have a broblem with my label text. The code is Public Class Form5 Dim a As Integer Dim currentDate As DateTime = DateTime.Now Dim jaarnu As Integer = currentDate.Year Private timeLeft As Integer Dim WithEvents timer As New Timer Dim milliseconds As Integer Dim monthnumber As Integer Dim …

Who can help me with the following For Each Con As Control In GroupBox1.Controls If Con.GetType Is GetType(Button) Then Con.BackColor = SystemColors.Control Con.UseVisualStyleBackColor = True End If Next Can someone help me to fix it with Con.UseVisualStyleBackColor = True or do i have to do the for all buttons separate …

Hi can someone give me the code how i make the first and last word of a string to Propr case The folowing gives all words to proper case Dim plaats As String = Replace(TextBox1.Text, "'", "''") plaats = StrConv(plaats, VbStrConv.ProperCase) I want, shall we say: "ohe en laak" to …

I have a datagridvied with several columns and one with date and the format is Me.DataGridView1.Columns("Doopdatum").DefaultCellStyle.Format = "yyyy - MM - dd dddd" or Me.DataGridView1.Columns("Doopdatum").DefaultCellStyle.Format = "dddd dd - MM - yyyy" Depends on the button i press My problem is when i reverse from "yyyy - MM - dd …

I have a question is there a way t write the following in a shorter way because i have to write this all about another 25 times. there is always one difference with one of all the textboxes. ' zonder roepnaam en zonder tussenvoegsel, wel vader maar vader geen tussenvoegsel, …

Hi i have a conflict with a string i want some words of a string to make lowercase shal i have as string Valkenburg Aan De Geul But i want it to make it as Valkenburg aan de Geul the folowing code dos not work ang gives a conflict If …

Hy It's a long time ago i asked something here. But now i am asking again something First i give my code Dim conc As New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\BurgerlijkeStand.mdf;Integrated Security=True;Connect Timeout=30") conc.Open() Dim cmdc As New SqlCommand("Select COUNT (*) FROM dbo.[Landen] ", conc) Dim i As Integer = cmdc.ExecuteScalar() cmdc = …

Who can help me with the folowing I have javascrip variable and a php datatable And i wand to read the datatable with the javascript variable here is the code i have if(!isset($_POST['bewerk_gegevens'])) { ?> <script language="javascript" type="text/javascript"> var newland = document.getElementById("geboorte_land").value; if ((newland != "" && newland != "Duitsland") …

There is a little bit prob with my code, My Prob: When i type name or place etc in search bar it show me the entire data stored in database, i need it show what i searching for... script for Search: <div id="wb_Form1" style="position:absolute;width:864px;height:147px;"> <form name="q" method="get" action="test-result.php" id="Form1"> <input …

Hi hope someone can help me with the folowing: if( $verscil_huwelijksdat_tot_zestien_jaar->format('%R%a') >= 0 ) { echo"bla bla"; } dosn't work it only works when >=1 or <=-1 and wy not >=0 ?

Hope someone can help me with the folowing. I have a date in a data table Works perfect to put a date in the table. But when i delete the date and the update with an empty date it wil update me the date of today. But i want it …

Hi i have a problem with the output to show the images horizontal in have the folowing code [CODE] $connn1 = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to MySQL database. ' . mysql_error()); mysql_select_db(SQL_DB,$connn1); $image=mysql_query("SELECT * FROM $weinachtfeier"); if (mysql_num_rows($image)<=0) echo "<br>Album does not exist or you are not …

Hi hope someone can help me with the folowing i have a string with a few words i want to delete some words before the string and uppercase the first letter from the string that over. $achternaam = "van der hurk"; $common_words = array("van", "der", "de"); $achternaam = str_replace($common_words, "", …

I have a question hw can i ad 18 years to the folowing date $rowy_geboorte_datum = new DateTime($rowy['geboortedatum']); $geb_dat_echtgenote = date_format($rowy_geboorte_datum, 'd-m-Y'); $rowy['geboortedatum'] is from a mysql data table and could even before 1902 as example 1820-06-10 thanks in advice John

Hi hope someone can help me with the following I am creating a webpage in different language with ip2country. i use the following code COMMON.PHP session_start(); header('Cache-control: private'); // IE 6 FIX header('Content-Type: text/html; charset=UTF-8'); if(isSet($_GET['lang'])) { $lang = $_GET['lang']; // register the session and set the cookie $_SESSION['lang'] = …

Hi hope someone can help me with the folowing How can i echo only the first letter of given words Example if i have: Jozef Margaretha Fransiscus i Want: J.M.F. Thanks

Who can help me with the following. I have an allertbox with text in it but i want different languages for the text in the allertbox $lang = array(); $lang['ALERTBOX_A'] = 'To do this, you must first be logged in.'; onClick="alert(' <?php $lang['ALERTBOX_A']; ?>')" In this case the language is …

Hi hope someone can help me with the following $query3 ="SELECT * FROM narr_turnier_bambini_garde UNION SELECT * FROM narr_turnier_bambini_garde_ster WHERE id_turnier_jaar = ".$idturnierjaar." order by rang, meestepunten DESC"; The WHERE clause dosn't work what i want because it give me all the rows from both tables and column id_turnier_jaar is …

can someone explain me wy the folowing query dosn''t work because i want to select only where the values are 1 , 2 , 3 , 4 and so ond and count these rows $link = mysql_connect("localhost", "bla", "bla"); mysql_select_db("db", $link); $result = mysql_query("SELECT * FROM narr_turnier_".$onlyconsonants." WHERE startnummer <> …

how can i tell in php that 01 is not equal to 1 and 1 not equal to 01 so that i can insert it in the data table $startnummer= ($_POST['Startnummer']); $query9 = mysql_query("SELECT werkelijkstartnummer,startnummer,turnier_jaar FROM narr_turnier_".$onlyconsonants." UNION ALL SELECT werkelijkstartnummer,startnummer,turnier_jaar FROM narr_turnier_".$onlyconsonants."_ster WHERE turnier_jaar=".$jaarnu." && startnummer = ".$startnummer." "); …

Hi hope someone can help me with the folowng I have two <input type="text" id=source1"> <input type="text" id=source2"> and one <input type="text" id=dest1"> i want the value from source1 and source2 to dest1 i put in source1 a name Like John Doe and in source2 only a * in dest1 …

Who can help me with the following i have 5 or more rows in a table the last column is called rank one row is called points. I want automatic insert the rank like when a person has 123 points is rank 1 the second person with 120 point rank …

How can i str_replace / with _ the folowing is not working $gemeente = str_replace ("/", "_", $gemeent); Thanks in advice John

Hi hope someone can help I have an array with daynames in dutch but when i use the day zondag it is not workin and i don't know why Can someone help me to make it work here is the code if($row3['geboortedatum']!= "0000-00-00") { $rss = $row3['geboortedatum']; $dayNames = array( …

i have the folowing code <?php $datumeind = date("Y-m-d");// current date $datumverleden = strtotime(date("Y-m-d", strtotime($datumeind)) . " -99 year");//current date -99 years $datumbegin = date('Y-m-d', $datumverleden); if(isset($_POST['zenden'])) { if($geboorte_datum <= $datumbegin && $inleven_dood == 'In leven' ){ ?> <script type="text/javascript"> <!-- var r=confirm("Klik ok als In Leven."); if (r==true) ("<?php …

Hi hope someone can help me How can i update a date field to NULL so that i have 0000-00-00 in the date field i have the following code but it's not working i tried a lot of things but nothing wil work if($_POST['geboortedatum'] == "") { $date = NULL; …

i have the folowing code that gives me the first letter of each word. $string = $rowec['doopnamen']; $punt ="."; $words = explode(" ", $string); $doopnamen = " "; foreach ($words as $value) { $doopnamen .= substr($value, 0, 1); } But how can i get a dot after each letter ? …