- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 4
- Posts with Upvotes
- 4
- Upvoting Members
- 2
- Downvotes Received
- 5
- Posts with Downvotes
- 5
- Downvoting Members
- 5
VB6, PHP, ASP, ASPX
- Interests
- Web Programming
- PC Specs
- Windows, Linux
150 Posted Topics
 | 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 … |
| | I have not tested this.. but this should work.. Dim ojbIni As New FileSystemObject Dim IniStream As TextStream If ojbIni.FileExists(App.Path & "\inifilename.ini") Then 'checking if ini file is present on the root of your vb project, if not it will automatically create Set IniStream = ojbIni.OpenTextFile(App.Path & "\inifilename.ini", ForWriting, False, … |
| | 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 … |
| | good day! I just want to ask if is it possible to have count on dinstint? I have a query below but it produces error in the expression. Im pulling data in MSAccess using ADODB. SQL = "SELECT" & _ " (SELECT COUNT(DISTINCT DateOInvoice) FROM InvoiceMain AS A WHERE (DateOInvoice>=DateValue('" … |
| | Good day! I have problems running my union all query..It only executes the first select statement but the 2nd and 3rd union was not executed. My backend DB is MSAccess 2003.. If rs_dailySales.State = adStateOpen Then rs_dailySales.Close SQL = "SELECT SUM(NetAmount) AS totalCashSales FROM InvoiceMain WHERE InvoiceType='Cash' AND DateOInvoice=DateValue('" & … |
| | Good day! I just want a little help on how to add the textbox data onto the datagrid when a button is click? I have 3 textboxes(txtname,txtaddr,txtcontactno) and a datagrid with 3 columns(Name, Address, Contact #). When a button is clicked, the data of the 3 textbox shouls be transferred … |
| | Good day! Anybody has experienced the same problem Im facing? I cant restore my BIOS to its original state after overclock. My board is MS-7267. Ive have tried this solution but no luck. 1. Detached the power supply plug at the back of the system unit. 2. Pressing the power …  |
| | Is there a way to open a form in vb6 when they clicked on one of the field in crystal report? Ex. If I want to update certain deposit, when clicking on crystal report, it will open the vb6 form to display for editing.. Ive found 1 in vb.net from …  |
| | Good day! I have this datasets format in sql server! AccountID AccountName 1/30/2013 2/30/2013 3/30/2013 4 Credit Cards 20,000 30,000 12,000 5 Loans Payable 5,000 6,000 5,000 How can I load all this data to listview? The colums are dynamic. It could be 6, 7, 8, or 12, or higher. … |
| | Good day? Ive flushed my TP-LINK WR941ND with DD-WRT and it works find. Ive created a Virtual Interface AP for my guest Wifi. Now I want to use the captive portal of Pfsense to work with my DD-WRT Guest Virtual Interface AP. Ive already setup the pfsense in Oracle Virtual … |
| | Good day! I have a variable string that will hold numbers...I need a function that will check if the number meets the below criteria: **( Acceptable format )** -accept positive numbers -accept negative numbers -accept single decimal place (ex. 567.89) -will not accept double demical place (ex. 567.89.678) -will not …  |
| | Good day! I just need a little help on how to create this program the precise way. Example if the user will enter 123450, it should output the sum of all individual integers, in the example the result must be 15. If the user will enter a character or a … |
| | I have a program created in dev-C++. It works find and no errors but when I transfer to microsoft visual C++ express edition I got this error. "No such file or directory found for "windows.h". In dev-C++, I can found windows.h in C:\Dev-Cpp\include but not in Microsoft VC++. Whats the …  |
| | Good day! I just one to ask if there is a function in C++ that can format a currency directly. Example if I have a float of *10000.00*, it shoud output *10,000.00*. Note the comma separator. Thank you!  |
| | Good day! I have this query that produces 5000 list of items in 10 columns in list view. I found that it slowly load the items at about 30 seconds. Im planning to divide the result @ 1000 per list. Moving the list per 1000 by using adodc control. How … |
| | Good day! How to move to a specific record base on the current recordset of adodc control? I have this employee_(empID, empName, EmpSalRate). I have load all employees data by using this code: dim Sql as string Sql="select * from tml_employee order by empName Asc" AdoDc.ConnectionString=Conn AdoDc.RecordSource=Sql AdoDc.Refresh Thus, I … |
| | Good day! I knew this is easy to all of you guys. But I need the most precise way to parse this string "**45:50"** and store the result in **two dimensional array with int as datatype**. The delimeter is "**:**". Thank you!  |
| | Good day! I have started a little inheritance on my simple class that takes the addition function of two numbers on the other class but the sum is always zero even if it is not supposed to be. Here is my code so far: #include<iostream> using namespace std; class Addition … |
| | Good day Gentl'men! Is there a way in c++ to convert a string variable that holds time of format like "17:30" to time_t variable? Lets say!: #include<iostream> #include<ctime> using namespace std; int main() { time_t timein,timeout; float timediff; string stimein,stimeout; cout<<"Enter time-in: "; cin>>stimein; cout<<"Enter time-out: "; cin>>stimeout; //convertion from … |
| | Good day! I have this code that is assume to get the difference in time. Is it possible to get the difference of from a string time variable? Or, whats the best way to implement this? #include<iostream> using namespace std; int main() string timediff, timein, timeout; cout<<"Enter player time-in between … |
| | Good day. I have this running query that I want to pivot the sum of CurrentBalance where in Monthdate =[2011-11-30],[2012-12-31]...etc. But everytime I try to put the Pivot, it cannot detect the CurrentBalance column alias. Here is my query so far. use MFR_Merchandise go declare @MonthColumns as nvarchar(max) declare @SQLtext …  |
| | Good day! I have this class for Players: #include<iostream> using namespace std; class Players { public: char Level[2]; float SetPower(); }; Players Pl, float Players::SetPower() { switch(Pl.Level) { case '1': return 5000; break; ......... } } int main() { Pl.Level='1'; cout<<"Your current Power is: "<<Pl.SetPower()<<endl; system("pause"); return 0; } Now …  |
| | Good day! I am currently developing a notepad storage to hold the players information! In notepad I have this data: Where data is seperated by a comma. First is the playerID, PlayerName, PlayerScore. 202, Andrie Velez, 4500 203, Joseph Josh, 3500 200, Carl J0sefana, 4000 Ive created a sample code …  |
The End.