PinoyDev

Hi guys, I just need a little help. I have the below codes: dim var1 as string dim var2 as string dim year as string dim fullpath as string year="2017" var1="\\192.168.1.85\PDFLOC\FileName\القيود\" var2=year & " " & "قيود" & "\" fullpath=var1 & var1 I am expecting fullpath to be **\\\192.168.1.85\PDFLOC\FileName\قيود 2017\القيود\** …

Good Day, I have a Datareport designed in A3 size. Is there a way to print the report in A4 without having to re-design it again manually to fit in A4 size? I have lots of A3 size reports which needs to be converted All in A4. It would be …

How to make below function to return true if success, otherwise false. I have make return on it but the result is **'undefined'** when i call it to other javascript on the same page like `**if(onloadCallback == false)`**. Thank you for helping. <script type="text/javascript"> var onloadCallback = function () { …

Good day guys! I just want a little help on how to reference a repeater control in a function. Im using c#.net. My code below: private void Load_Childrean_byTypeID(int TypeID, **repeatername reference here**) { SqlDataAdapter mycommand = new SqlDataAdapter("Select Id, FoamType_ChildName, ChildIcon_ClassName, ParentTypeID From tbl_ProductType_Children Where ParentTypeID = " + TypeID, …

Good day! I am new to C# programming. I just need some help to display all images from images folder in my root directory in a form of href inside my div tag. Here is my Div tag code which I need to repat my images: <div class="row margin-bottom-20"> <div …

Good day! I just want a little help on how to loop from one cell to the end and set a sum Formula. I have Columns From **F to O **and created a Sum formula for column F. Is there a way to make it in a loop and pass …

Good day! I have the following sub-query that generates payroll report by a given date with format **(dd/MM/yyyy)** but I do not know why MSAccess **automatically changed it to (MM/dd/yyyy)** thus I am getting incorrect data. My regional date settings in **control panel is set to (dd/MM/yyyy)** format as well …

Good day! I have a running code but I found it not very fast in terms of saving data. Is there a way to make it more faster? I am using msaccess as databse. Set RsTrandet = New ADODB.Recordset Sql = "SELECT TranDetail.AccountNo,cashflowcode, TranDetail.Narration, TranDetail.TranNature, " & _ "TranDetail.TranAmount, Acctmaster.Accountname …

Good day! I dont know if this is the right thread for my problem but since I am developing the site with Php and MySQL Ive posted in here. My problem is, the **website can be pinged without www prefix** but when I browse it in the browser, I am …

I am creating a table dynamically of which fields are date. I have a running code below but I want to remove those doble quotes in both sides.. If I remove the chr(34) on both ends, I get this error saving "invalid field defination". My code and table screen shots …

Can I save the information from common dialog Save as Jpg or Bmp format to an INI file and retrive it when the program starts. Now I have this line Image4.Picture = LoadPicture(App.Path & "\test.bmp") to load the picture. and it's not good. I would prefer to have that the …

Good day! I just need a little help on how to get the last months date (dd/mm/yyyy) between two dates? I have two date pickers(fromdate & todate). Ex. If fromdate is 24/01/2015 and todate is 24/12/2015, it should enumerate the end of the months starting fromdate to todate. So the …

Good day! I just need a little help regarding my query..I need to get the opening balance by subtructing debit and credit column where date is less than fromdate(datepicker). But sometimes if the fromdate is a date without transaction, it still displays opening balance? I cant figure out whats the …

Good day! I have a news letter form and ajax validation on empty fields is working find.. But when I try to submit the form with all the required fields, I cannot get the data_html response from my php file? Maybe i missed some part that I cannot see t …

good day! I have a php form. I have made some ajax validation on it but everytime i click the submit button it does not validate, and when I try to issue an alert command on ajax function, it returns undefined on certain variables? Here is my present code: <Form …

Good day! I just want a little help on how to get all data from mysqltable where month=january or feb.. etc. and year =2015 or maybe 2014 I have a table with datefield(yyyy-mm-dd) example dates data are: 2015-01-17 2015-02-17 2014-12-17 2014-10-17 2014-03-17 And I have a span list of months …

Good day! I just want to ask a little help on how to redirect the user to the previous page after 5 seconds? Thank you!

Good day! I have a page let say page1.php and page2.php. In page1.php, I have build menus which names are taken from MySQL database like the code Ive made below: <ul> <?php do { ?> <li><a href="fullwidth.html"><?php echo $row_rec_tourismmenu['menuname']; ?></a></li> <?php } while ($row_rec_tourismmenu = mysql_fetch_assoc($rec_tourismmenu)); ?> </ul> I want …

Good day! Is there a way to identify if a given date is hijri/arabic? Thank you!

Good day! I have a combo box which is readonly. It is loaded with data from the database. However, there is a point that I need to set text on it, and those text is equal to one which is in its list aleady. The below code produces runtime error …

I have a datagrid on the form bind with recordsets. I need to know if is it possible to assign that datagrid object into a variable? I have created a preliminary code but its not working dim dbgridvar as DataGrid Private Sub Assign_Click() set dbgridvar=Form1.Datagrid1 End Sub Thank you for …

I have the following query that list all chemicals(chemical tbl) and its consumption(receipt tbl). However if the chemical codes are not in receipt tbl, it does not show the chemical name. It should display the name and put the consumption as zero. My codes below: SELECT Chemical.ChemicalCode, Chemical.ChemicalName, GroupDetails.GroupName, Chemical.LastRate, …

Good day! I have a listview loaded in a form in a **lvwIcon** view with checkboxes enabled.. I have checked some items from it, let say 5 items. Now when I switch the view to **lvwReport**, the checked items are gone. How to make it selected again? Thank you for …

Good day! Is there a way to make the data report to show only the fields selected by the user? I have a form where the user can select the fields(from ms access table) in the list box(checkbox enabled) to show in data report. The total fields is almost 50. …

Good day! I am now currently ugrading our database to mySQL. My problem is that, how to convert the any msaccess SHAPE command to a mySQL database syntax using 6 and get the same result? Below is the sample code: spath = App.Path & "\employeeaccnt.mdb" cn.Open "Provider=MSDATASHAPE; Data Provider=Microsoft.JET.OLEDB.4.0;Data Source=" …

Good day! I just want to know on how to correctly use SendMessage API. When the save as dialog box popsup, Save button will be automatically click. Let say I have hwnd and classname value. Please see below Public Declare Function SendMessage Lib "user32" Alias "SendMessageW" (ByVal hwnd As Long, …

Good day! I have a long list of menus created under menu editor. I need to loop all of its value list and put it in a combo box. I do not know a way on how to do this..? Thank you!

hi good day! I need some help here.. I have a SHAPE recordset..everything in the database has its value..Im stucked with this error: **"Error : -2147467259 - Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large."** My code below: cmd.ActiveConnection …

Good day! I want to save the data report with the .mdi(microsoft document imaging printer viewer) on a specidied folder.. 'Print to a Specified nondefault printer Dim PrintData As Printer Dim defprinterpos As Integer Dim currentPrinter As String For Each PrintData In Printers If PrintData.DeviceName = Printer.DeviceName Then currentPrinter = …

Good day! I just want to ask on how to drop a table. Let say all tables starting with "DailyCashSalesRpt". That means it will drop all tables starting that word. I use this code but it will only delete one specified table name.. How to use this with like? sql …