Calibration Dates -
I have a 3 text boxes in my program, One textbox named txtLast, I assign a date. And in txtCal I put in any number and when I click on txtLast it gives me the date plus the number of weeks in txtNext.
It is a calibration program. I need to know when the gauge was last calibrated and when it needs calibrating again. It woks very good except that it will always give me todays date in txtLast. For instance if the the gauge was calibrated last week I need to put in that date, but it returns todays date all the time, this my code:
Private Sub txtLast_Change()
Print Format$(Now, "m/d/yy")
txtNext.Text = DateAdd("ww", Val(txtCal.Text), Date)
End Sub
Private Sub txtLast_Click()
Print Format$(Now, "m/d/yy")
txtLast.Text = Date
txtNext.Text = DateAdd("ww", Val(txtCal.Text), Date)
End Sub
I know Now will give today always, what other can I put in to achieve what I want?
Thanking you all.
Regards
Best practice for interfacing a class with a form -
I have a form called "Main".
I have a class that is called "Calibration".
In the past I have used buttons and events on the "Main" form to set values of properties in the class "Calibration".
The problem is that there are too many buttons
linking 2 tables 2 fields (dbase newbie) -
i have 2 tables , GUAGES and GUAGE RECORDS. The Common Key on Both Tables is 'guage number'.
I also have 2 forms.. The first form displays the guage data for each guage, and the second form displays the
guage calibration records for each individual guage.
The 'guage number' f
Linking 2 table, 2 fields(a dbase newbie) -
I have tried the database forum with no joy, Here is my problem..
i have 2 tables , GUAGES and GUAGE RECORDS. The Common Key on Both Tables is 'guage number'.
I also have 2 forms.. The first form displays the guage data for each guage, and the second form displays the
gua
Please please help -
I am not a vb programmer by occupation, but i have written a few VB programs in the past, however this is my first attempt with databases... The following is my problem.
Our Guage calibration system is very antiquated in that it is entirely paper based.
I plan to create a basi
showing word documents -
I am not a vb programmer by occupation, but i have written a few VB programs in the past, however this is my first attempt with databases... The following is my problem.
Our Guage calibration system is very antiquated in that it is entirely paper based.
I plan to create a basic
You Brainboxes, please help me.. -
I am not a programmer, so please bear with me...
using vis data, i have created a guage calibration table with fields such as Guage type, Guage number, date of calibration etc
However, each guage has its own work instruction document, which is a word document stored on the netwo
Calibration of PC monitors -
Hi!
Im working on a project where we need to have the LCD (and CRT) monitors almost perfectly calibrated. Im wondering, do you know of any software that will display test patterns I can use to calibrate the graphics cards and monitors. I have used a similar program at home on my hom
I need help on directsound! -
I have a serie of mp3 players i made and want to start on the next version. This time i dont want to use an integrated mediaplayer, but directsound.
The program will contain 2 players which must play seperate into the 2 speaker-outs of a 3d soundcard (like the LIVE! Player)
So I
How would I write this SQL statement -
Hi
Well I am not too familiar with SQL statements, as im only getting family with simple ones such as UPDATE INSERT etc.
Question
Column 7 named 'Dates' contains all dates and times, which are stored from a process (which doesnt matter)
Basically I have to combo boxes one w
Calibration Dates -
I have a 3 text boxes in my program, One textbox named txtLast, I assign a date. And in txtCal I put in any number and when I click on txtLast it gives me the date plus the number of weeks in txtNext.
It is a calibration program. I need to know when the gauge was last calibrated and
Overdue Dates -
I have a calibration program. I need the program to open and alert the user that he has so many gauges that are overdue. Each gauge is given a date to when it should be next calibrated, if the date has expired then the user is alerted each time he opens the program.
Error: no information enough to change or update the record. Why -
Hi, everybody!
I'm working with a form which displays a Data Grid like this:
=============================================
Expected Calibration Date - Consummated Calibration Date
=============================================
02/15/00
==========================
better way to compare dates -
hi guys! can anybody please help me...i have the code below which compare two dates,datenow and the alarmdate, and show the alarm notification when they are equal but as you can notice the way of comparing dates is first Convert both dates ToShortDateString and compare it and when they
Urgent..Please help..Comm works at 2400 baud, loses char's at 1200 baud! -
Urgent help needed (thanks!)
I'm using MSComm--extremely experienced (12+ years) of using serial comm. Just need to receive data continuously from comm port. Data consists of a sign-on sentence (each sentence, or block of data is terminated by CRLF), followed by a large (about 8
query help with dates -
trying to do some booking system here.
Basically I can retrieve a list of dates which are available for bookings, thats cool.
But now from this list, if the user chooses a date, I want to be able to bring me back another list which contains all the dates UNTIL the next date is no
I need help... A loop i think.. -
I need a way to create dates.
I want to be able to select 2 dates, say from 2 datepickers.
Say the user select this two dates: 24.02.03 and 28.02.03.
Could i make a loop that creates the dates between? It need to add one day at the time, until it gets to 28.02.03. And i want t
change dates formated as text to dates in excel from vb6 -
I have a spreadsheet with mixed dates and dates expressed in text. From VB6 I want to programtically convert all text dates to dates. I know it shoudl be simple ... Im just not getting it ...
any help appreciated!
Added [RESOLVED] to thread title and green &qu
Saving Dates (Help) -
Just wondering what the best way to do this would be.
I have a MonthView calender which allows for dates to be set as highlighted for various purposes. I want to be able to save all the dates that have been highlighted and have them highlighted whenever i start the program (so basic
comparing dates -
hi guys. i was just wondering how you compare dates. what i wanted to do is to compare two dates and see which one is earlier. One o the dates is retrieved from the calendar control and the other date is in a text box. PLease help. thanks.
dates and disabling -
Hi.
I have 2 datetime pickers, start and end dates
dates will be shown when a user selects a month.
now, when they change the month, I will be getting some datetime values from SQL, depending on the month they choose (or rather for each month they select)
now, these dates fro
[2005] Old Dates -
I have some old formatted text files with dates. The dates are stored as "09,05,2002". Will the comma's matter if I try to read them as dates? Will the DatePicker control (or any others) choke on this format? If so, what do I need to do to fix it?
Best practice for working with dates -
I'm putting some code into my app for working with dates etc. now.
Just wondering should I make sure that users enter dates in a particular format, or how should I deal with it ?
I'll also be searching for dates etc. in recordsets, how should I construct the SELECT query for that ?
adding date fields to random access -
I am modifying a udt and adding new fields, some are for future use
Havent worked with dates. I want to add 5 fields for billing dates and payments dates. Should these be added as strings or dates ?
Public Type Myudt
InvoiceDate1 as string * 15 or:
InvoiceDate1 as date
Payment
How to refer to previous fields in 2 different row -
HI there!
I'm new in Crystal Report programming. I have a report that generates dates in rows. I would like to calculate the different between 2 dates. For example, I would like to calculate the different dates between 1st row and 2nd row, 2nd row and 3rd row etc. The dates are from A
query help - dates -
This query does not seem to quite work.
I want to get results based between the year 2006-2007 from the month of 2006 to the month 8 of 2007. It only returns the 8'th month of 2006
it works well when the year is the same, just not when the years are different
SELECT CONVERT(
filtering dates in vs 05 -
I want to filter dates in a vs 05 data grid using two txtboxes.
So when the user types in the dates in the the textboxes it should return all of the results e.g.
txtbox1.txt = 12/10/05
txtbox2.txt = 18/10/05
It should return all of the dates between the start date and finis
Date Ranges Problem........ -
hi,
I need to find the dates between a range of dates......
eg:
the dates are in dd/mm/yyyy format
the user specifies 2 dates
Date1:15/4/2003
Date2:20/4/2003
I want to retrieve the dates between Date1 and Date2.i.e.
15/4/2003,16/4/2003,17/4/2003,18/4/2003,19/4/2003,20
International dates in VB and SQL -
I am having fun with international dates in VB and SQL. Can anyone give me some advice on dealing with international dates. It seems the best way is to use DateSerial in VB for storing the date. Its is the usual that it works on our system but not on the customers (maybe to do with the
Get number of weekdays between two dates. -
Hey guys, I was wondering if anyone had written a function that will return the number of work days between two dates. I figured this has been done many times, but I can't figure out how to go about it.
For instance if I put in the dates 2008-04-19 and 2008-05-02 it would return t
Problems with datetimepicker -
Hi to everyone plz help with me this dilemma:
I have two datetime picker from which i select two different dates. now what i want is to calculate all the dates which r found in the range i selected previously and store them lets say in an array. now my windows application is connected
Problem with Date Range -
I'm bringing back dates from a database and want to compare those dates to see if they're between a range defined by two dtPickers. I've tried using >= and <= but it doesn't seem to work for dates. I was testing to see if the dates were equal and that worked fine, although it may
sql dates -
Hi all.
i have a field dates with values in this date format.
dd-mm-yyyy
is it possible to sort the records by the dates field of the table?
i can't seem to achieve the sort i want with "order by dates desc"
thanks
Calendar Coded List Box -
Hi:
I have an Access Database in which I created a form. The form has a calendar (which shows three months at a time), a date bar (which showed the date(s) picked), and a list box (which shows the date, customer name, city, maintenance date).
All the sync codes I've entered work
find dates between to given dates -
hi
is there any way to find dates between to given dates. ie, suppose it is given 01-01-2006 and 04-01-2006 (in dd-mm-yyyy format), want to print the dates from 01-01-2006 to 04-01-2006.
Dateproofing my app -
I'm having some problems with my app, and I cant seem to get a handle on the best way to deal with it.
The problem relates to the date formats, dd/mm/yy vs mm/dd/yy.
I'm saving the dates to an access database, and will be perforning calculations on the dates (eg. 14 days from tod
OnComm vs. Alternate Methods (Most Efficient) -
After reading posts in forums on this site for the past months, I've been trying to find the best most efficient way to code for a specific situation that I have. I am working on a data acquisition system that transmits data from accelerometers, etc. through a PIC microcontroller and w
Finding # of months between two dates -
Good Morning folks,
I have two dates. I need to know number of months between these two dates. The dates always start on 1st of every month.
example:
date1: 02/01/2008 , date2: 12/01/2005. how to calculate the # of months between date1 and date2?
thanks
nath
setting a date range -
I'm trying to get a range of dates from one sheet to populate into another sheet. One sheet has dates written as example 02/05/05. In my source sheet I have one of two dates for every month either the 16 or the 31. written as 7/31/05. The date in my source because it is already exs
Compare dates from db to current date -
I have a problem. I retrieve some dates from a database in the format dd/mm/yyyy. These dates are stored in the database.
what i want is to compare the date that i retrieved, to the current one, calculating the days between the two dates. afterward i want to place this in a column i
SQL to search a database for results between 2 dates -
I am trying to write an sql that will take 2 dates from a drop down date picker box and perform an sql on a database to bring back the data logged between the dates. Can anyone help?