Hi Mhary Cristina, In case your problem is not already not solved-
If your target is just to view video images over internet at any remote location then you don't even require any sort of programming. You just need to provide and set-up static IP to your 'Camera-Recorder system' and it will let you view display in any supported browsers via http requests.
This is just a CCTV-Internet system you must be aware of.
On...
neo008
Last Activity: Jul 8 '21, 11:25 AM
Joined: Jun 5 '07
Location:
-
Hi tutu saint,
First of all you shouldn't subtract 90 days rather add three month to the today date.
If your $oneDate will be having the date of +90 days from the todayDate then if you find all products which are about to expire within 90 days simply fire a sql query like -
"select ID, EXPIRY_DATE from tblProducts where EXIRY_DATE between $todayDate and $oneDate order by EXPIRY_DATE ASC";
...Leave a comment:
-
Yes, Luuk is right. Either you assume your web-server's time to consider a day or correct it for your local time zone.
Now that depends on your requirement, if the web-server's date/time is more suitable to you and if you have saved the date into your database/same table than simply put where condition (where date between dd/mm/yyyy and dd2/mm2/yyyy2 )with above solution.
NE☼Leave a comment:
-
Hi Cristina, that sounds interesting.
I also don't know the exact answer to your question but I can discuss the scenario at least and I hope this will make some clear picture for you-
If in case you don't already know,
1. If it is the matter of PHP than you must recall that it is a server side scripting language which reflects that your hardware must be connected to your server itself.
2. PHP...Leave a comment:
-
VB6 : DataGrid absolute (current) position problem
Hi all,
I'm using Datagrid to show data on forms. All other things are working fine..like add,update, delete and pointer movement.
I have selected HIghlite row property of datagrid and it highligts each row selected by mouse. But it does not highlight row when I traverse programatically .
for example by using refresh method DATA POINTER goes to the firstmost position in current recordset. but why does it... -
VB6 : Create DSN Programatically
Hi all,
Can somebody help me about creation of Data Source Name (DSN) programatically .
I'm using ADO control for connections. MS-Access as database
Thanks
-NEO -
VB-APP : How to do Insert, Update and Delete operation in VB 2005
Hi All,
I'm very new to .NET and want some help regarding database accessibility.
I know about VB 6 but how database operations are performed in .NET, I have no idea.
I have created database connection and also bound to controls on the form. I am using MS-Access database.
I saw some of the properties like ADD, ADDNEW....but did not get a solution yet.
can somebody please refer examples... -
User Login
Hi all,
I want to make a website where user can enter and see contents only by using given user ID and Password.
Can somebody suggest me what technology should I adopt for best and easy way. (like vbscript/asp/php/...??????)
I'm good at VB but never gone for vb scripting. Can somebody help me where can I start from learning VB scripting for web development?
-NEo
http://www.trisha... -
actually I was assigning an integer value there (in Else condition) as cancel is of integer type.
but I forgot what I had used to allow closing application and vice versa. (because I'm not using it anymore)
though, asked by hariharan I put the code and ....did what u caught.
:D...Leave a comment:
-
How to scroll Excel sheet in OLE (VB6)
Hi all,
Again with same problem as it does not seem to be solved.
I am making reports first time in VB and found embedded Excel sheet as a good way. But I got stuck when it come to scroll OLE sheet to see all data in it.
Does somebody know how to do it?
Or can somebody tell me the best way to generate reports, where selected data can be shown?
NE☼ -
no boundaries are there for good programmers. your correct Killer. But I am doing lots of calculations on currency.....al so rounding it off upto two decimal places in code. but how to show eg. 123.40 and 123.00
i dont even want to think to arrange each digit place by place and add decimals at suffix. i'm scared.
I dont know much about it Hariharan that is it my system date format or not.....but...Leave a comment:
-
Correct Killer.
As hariharan asked here is the code i've used. but its not good for me due to other reasons. Moreover I want to make it "Invisible" not disable because it will look ugly in my case.
.
And I think it is as same as hassan suggestedCode:Private Sub MDIForm_Unload(Cancel As Integer) If Picture3.Visible = True Then Cancel = 0 Else End End SubLeave a comment:
-
VB6 : Can I make control box of an MDI form 'Invisible' ? (Cross button)
Hi All,
I want control box of my MDI form Invisible. I dont want user to click on cross button to exit.
I tried Unload events but I dont find it suitable for my project.
Can somebody help? I'm Using VB6
-NE☼ -
Well Killer, Do I have to really bind that text box with database for Dataxxxxx properties (DataFormat).
Anyway thanks for your time Killer.
Ya Jacob, its my fault I did't mention the version I'm using. Let it go coz one of my problems is solved by Lee and problem regarding date I'll keep fighting as usual.
Each of your ideas have values for me. thanks.
-NE☼...Leave a comment:
-
Hi Killer,
Control box property has well worked but I also want to do same with MDI form.
I did not find any control box property for MDI form but I really want to make invisible all three control buttons for it.
With Unload event I have to code for multiple conditions moreover it won't look good in user's perspective.
How can I achieve that. can you help
...Leave a comment:
-
Thanks for your kind help friends.
KILLER-- I'm really sorry I forgot to mention the version i'm using. and its VB6.
And the format i am talking about is standard "Date" fromat chosen through property "Data Format". There are so many standard formats are there and i chose e.g. 05-August-2007. [dd-mmmm-yyyy]
Moreover...Code:ShowDate.Text = Date
Leave a comment:
-
Thanks Killer,
I just check it out.
I rate you "Excellent" . :D
-NE☼...Leave a comment:
-
Friends I'm still not getting solution and its become urgent now.
Can somebody please give me any idea about it??
I just want to scroll my excel sheet inside an OLE control.
I am generating reports and user can see excel file in OLE control. But scrolling is necessary to see all data without opening excel sheet.
Help.
-NE☼Leave a comment:
-
How to use Date and Time in VB?
Hi All,
1. How can I show live clock (system's clock) on my MDI form? (Continuous updation)
2. Fetched System Date is being displayed in MM/DD/YYYY format in a text box. Even when I set data format property to DD-Month-YYYY.
can somebody help me.
-NE☼ -
neo008 started a topic Can I prevent user to press cross button. (Quit Application)?in Visual BasicCan I prevent user to press cross button. (Quit Application)?
Hi All,
Can I prevent user to press cross button?
I want to disable all three buttons for minimize, maximize and close for parent as well as child window.
Is it possible? I'm using VB6.
Can somebody help in this.
-NE☼
No activity results to display
Leave a comment: