Weekly Calander
Well, I did a little searching around.... what I'm after is a weekly calander based on either Now or other user input.
So therefore, An array of 7 labels that will have from sunday to saturday with dates for either the current week (now) or any other date the user enters.
I have been looking at DateDiff and DateAdd etc... just wondered before I re-invent the wheel if I should be using some kind of control for this?
any ideas would be much appreciated.
Thanks
Max.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Current Weekly Data, Not Year Weekly Data
Greetings all,
i want to retrieve current week number (assuming week start from Monday). i can retrieve week number start from January 2005 with my SQL statement
VB Code:
rsDepartment.Open "SELECT " & _ "SUM([RATE_DATA].[" & varRate1 & "]) AS SumQty, " & _ "SUM([RATE_DATA].[" & varRate1 & "])/(SUM([RATE_DATA].[" & varRate1 & "])+SUM([RATE_DATA].[" & varRate2 & "]))*100 AS SumRate, " & _ "[RATE_DATA].[DEPT],FORMAT(CUTT_DATE,"ww") " & _ "FROM RATE_DATA " & _ "WHERE ([RATE_DATA].[MONTH] = '" & cboMonthly.Text & "') " & _ "GROUP BY DEPT,FORMAT(CUTT_DATE,"ww")", conn, adOpenKeyset, adLockOptimistic
this week number will be in format 29,27...(started from January and Sunday as the default starting day).
my data consists of more than one month data...thousand of lines...
so is there any code that i can use so from the weekend number that i captured in my SQL statement, i can display the week number based on what month the users choose? ( user will choose month in YYYYMM format and i want the data will show the weekly data of the month).
please help.thanks in advanced.
Weekly Report
i need to create a email that is sent out on weekly!!! how would i program to say on (e.g) monday 1000 am sent this report?!
(im know how to send a email, and will be able to create the report...i dont know how to make it so the system automatically sends it weekly?!)......
Weekly And Monthly
Q. pls...
How can i make a weekly report? (the data must be shown in grid)
ex. i have a table with inputs dating 1/1/03 to 3/31/03
i wanted an output from the table on a weekly basis
the starting day of the week is monday to sunday
can i have some codes... thanks in advance
output: in grid
week1(monday to sunday)
1/3/03(:note 1/3/03 is wednesday ) - 1/5/03
TOTAL # of calls
96
week2(monday to sunday)
1/6/03 - 1/12/03
TOTAL # of calls
96
week3(monday to sunday)
1/13/03 - 1/19/03
TOTAL # of calls
79
week4(monday to sunday)
1/20/03 - 1/26/03
TOTAL # of calls
79
week5(monday to driday)
1/27/03 - 1/31/03
TOTAL # of calls
73
february *week1 starts again*
week1(saturday to sunday)
2/1/03 - 2/2/03
TOTAL # of calls
74
HEH Calander
OK next question new thread..... im using the vb calander component ......... i have it now so that if a date is clicked it brings up frmdates.... on frmdates they are able to put there daily tasks or what ever they feel like is there a way to save that text to that day so that if they click on that day it comes up again with that text?
Weekly Calendar Control
Is there anywhere that I can get a clandar control that shows by weeks instead of by months at a time?
Thanks
Four Weekly Rather Than Calendar Months
Hi,
Im experimenting with a program which handles simple rentals over a four weekly basis rather than the typical calendar month system. This gives 13 "monthly" payments a year rather than 12 under the calendar month system.
I have been experiementing with adding integers to data variables but haven't had a great deal of success yet, can someone suggest the type of functions I may wish to use to achieve this approach?
Thanks
Weekly Calendar Days
sorry guys,, but its just one of those days when it seems nothing is going right...
user input year ( any year) system will display how many weeks r in inputed year and also display days range per week i.e. week 1 will display january 1 - january 7..
leap year is highly consideralble and user input week end day (Sunday, Saturday or Friday)..
10x
Calander Control 9.0
With the Calander Control 9.0, is there any way to change the fill color for just one particular day of a calander?
Import Into A Calander
I am a little rusty in VB 6.0 but I am getting back into it
and I am trying to create a calader project. I will not be
using VB's calander. I created my own calander with 31 labels
boxes in an array . What I am trying to do is, I am tring to
import a file, txt would be fine and the data will be populated
into each date. Each date will have 4-5 events
Example
8/1 John 8:30, Mary 10:30, Alice 10:30, etc
8/2 Mary 4:30, Bill 6:00, Larry 1:00, etc.
This list will continue for the entire month. Once the events
are added they will be printed on paper. Any ideas or help
will be greatly appreciated thank you
A Reminder Using A Calander
Hi
Can anyone help me with the syntext needed to use the calander.
i Want to write code for the following.
On the form I need the calander , button and inputbox.
I want to fill in a date and on that date a message box pops up to remind me of certain appointment. In effect a electronic diary.
Thanks in advance
Rob
Calander Control
hi all
i want to make a clander control like as outlook...
any idea any one you have...
thanks
shakti
Calander Program
<VB noob here
Im trying to make a calander-ish program
but i suck.
I need it to look like this.
[text box-month][text box-day][text box-year]
[command button]
[textbox-day of the week]
What I need it to do is you can enter any date(9-12-1988, 10-23-1623) and it will tell you what day of the week it is(wednesday, Tuesday, ect)
So if you put in 9 12 2004, it will say Sunday when you click the command button.
thanks
Calander Control 8.0
I have a form with a calendar on it. I want to be able to click on a day and have a input box open so you can add text to the calendar for that day. Basically like righting notes for each day to remind you of a event.
Thanks
John
Calander Problems
I am having problems with the microsoft vb calander. I can add the component to the tool bar but when i try to add it to a form the program crashes with out any reason. I as well currently have a vb program that has a calander on it that i did at school(where it works fine) and i can open the form and even run it but as soon as i click on it, it crashes. Im not sure if their is a confilict with another program or maybe a reference that i need to make with in vb. Not sure....... Any Answers
Making Reference To A Workbook Name That Changes Weekly
How can i make a reference within a formula to a workbook when its name changes weekly, in changes i mean a week number:-
ALL AC DBS WK40
ALL AC DBS WK41
ALL AC DBS WK42
ALL AC DBS WK43
How would i be able to call for the present weeks workbook without having to change the week number in all my formulas?
Code:
ActiveCell.FormulaR1C1 = _
"=SUBTOTAL(3,'[ALL AC DBS WK44.XLS]BT001_DBS'!R2C1:R2000C1)"
This is my current formula. Thanks guys.
I Need To Save Daily And Weekly Values, How Can I Do Them?
I have an application, that has so many controls: Weekday,Date,... I need to save all the weekly values from all these control arrays to a file at the end of the week.
Anyone knows how i can go about this? At the moment the values display each week. Also I need to keep track of daily start and end times and sum them at the end of the week and save them to a file, how can i achieve this?
Weekly Reports From Daily Data
I want to write reports in a fitness database that takes entries on a daily basis based on a week compared to other weeks. Measures I can think in terms of are rank the weeks for the year in terms of caloric intake for each week. Or rank the 10 worst weeks for Heart Rate during the course of a year. How about the months with the most fat intake. How do I aggregate days into weeks? I'm thinking Sunday to Saturday weeks but treating every 7 day increment possible is useful as well. How is this done?
Mick
Microsoft Standard Calander
I am in a class called EAST lab in school. I am doing a project that records journal entries for the day. I have a calander control and a rich text box. I need to know how to let the users click on the date and a command button and have the program save the entry with a file name that corresponds to their user name across the network and the date of the entry. Also I will need to access the files from a different program. I am very new at this so I probably sound stupid. If you can help or just want to call me stupid go ahead.
Calander Control Closes Vb Down
Hi all,
Seem to be having a bit of trouble with my Calander control.
I have it in my tools box, but when I put it onto my form a msgbox comes up with "VB has to close now, sorry for Blah Blah Blah"
Any ideas? All the other controls are fine just this one.
Thanks
How To Summarize A Weekly And Monthly Sales Report?
help...help...help
ellow to all kind-hearted vb gurus out there...
could you pls give me some code snippet on how to summarize a weekly and monthly sales/inventory reports... im currently using an access database....and im not so familiar about building it on sql statements...
pls reply soon... or im dead...!
thanks guys....!
What Is The Easiest Way To Schedule / Daily / Weekly Ftp Transfer
Hi,
Could you please give me suggestions of what is the easiest way to schedule ftp download.
I have a website that I manage, and I want to have a daily backup of the files and folder..
Could anyone help me?
is it fairly simple to create a VB script or VB application that will do this..
Thank you..
Running Weekly, Monthly Reports Automatically
Hi all,
I got a little problem.
I have an application that i would like to generate reports on it's own without any user intervention.
I need to be able to have it determine days, weeks and months in calendar format.
for week reports i'll need the app to start every monday and generate a report for the past week. ( monday to sunday)
for the month report. generate report for the past month. ( 1st to last day of month)
Are there any controls or such i may be able to use?
Any suggestions are welcome.
EL
Adding Events On Specified Days Over Weekly Period
The following code allows users to enter reoccuring events into my calendar on either specified days or weekdays only.
<%
Function tfld( name )
tfld = "'" & Replace( Request.Form(name), "'", "''" ) & "',"
End Function
Sub InsertRecord
Set calConn = Server.CreateObject("ADODB.Connection")
calConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.MapPath ("/calendar/calendar_database/calendar.mdb") & ";"
calConn.Open
DIM inter_count, NewDate, calConn, baseSQL, SQL, daily, DateFinish, weekly
' all the SQL is the same for each record *except* the
' "event_date" field. And conveniently, it is the last field!
'
' So we set up all the SQL except the value of event_date ahead of time:
'
baseSQL ="INSERT INTO advevents " _
& "(event_title, event_teams, event_hostedby, " _
& "event_providername, event_provideradd, event_providerphone, " _
& "event_provideremail, event_providercontact, event_other, " _
& "event_type, event_members, event_cost, event_payment, " _
& "event_paymentto, event_paymentphone, event_meeting_class, " _
& "branch_location_name, event_additional, event_venue, " _
& "event_venue_location, start_hour, start_minute, start_ampm, " _
& "finish_hour, finish_minute, finish_ampm, event_description, " _
& "contact_person, contact_number, contact_email, other_location, " _
& "other_address, other_suburb, other_postcode, " _
& "other_phone, event_date) " _
& " Values (" _
& tfld("event_title") _
& tfld("teams") _
& tfld("hostedby") _
& tfld("providername") _
& tfld("provideradd") _
& tfld("providerphone") _
& tfld("provideremail") _
& tfld("contactperson") _
& tfld("other_type") _
& tfld("class") _
& tfld("members") _
& tfld("cost") _
& tfld("payment") _
& tfld("paymentto") _
& tfld("paymentphone") _
& tfld("meeting_class") _
& tfld("branch") _
& tfld("additional") _
& tfld("location_select") _
& tfld("sublocation_select") _
& tfld("starthour") _
& tfld("startminute") _
& tfld("startampm") _
& tfld("finishhour") _
& tfld("finishminute") _
& tfld("finishampm") _
& tfld("notes") _
& tfld("addedby") _
& tfld("phone") _
& tfld("email") _
& tfld("other_location") _
& tfld("other_address") _
& tfld("other_suburb") _
& tfld("other_postcode") _
& tfld("other_phone")
select case request.form("reoccurance")
case 1
NewDate = CDate( request.form("date1") )
DateFinish = CDate( request.form("date2") )
daily = ( CINT(request.form("option")) = 1 )
If daily Then
inter_count = 1
Else
inter_count = CINT( request.form("daily") )
End If
Do Until NewDate > DateFinish
If ( Not daily ) OR ( Weekday(NewDate) <> 1 AND Weekday(NewDate) <> 7 ) then
SQL = baseSQL & "'" & NewDate & "' )"
Calconn.execute(SQL)
End If
NewDate = DateAdd("d", inter_count, CDate(NewDate))
Loop
This adds 'daily' reoccurances, and works well as I have tested it with no problems.
Its this section here that handles 'weeklys' where im a little lost. What im allowing is, users on the previous form to select event reoccurs every 'x' number of weeks over a given period on monday, tuesday, wednesday, thursday, friday, saturday, sunday.
Eg. Event starts on April 2 and finishes on December 11. The event happens every 2nd week on Mondays and Fridays only.
How is it possible to identify the days of which they have selected. The users make these selection with a simple checkbox which sets thier values to '1'
So if a user selects that an event reoccurs mondays only monday would = 1.
case 2
NewDate = CDate( request.form("date1") )
DateFinish = CDate( request.form("date2") )
monday = request.form("monday")
tuesday = request.form("tuesday")
wednesday = request.form("wednesday")
thursday = request.form("thursday")
friday = request.form("friday")
saturday = request.form("saturday")
sunday = request.form("sunday")
weekly = ( CINT(request.form("weekly")) * 7 )
inter_count = weekly
Do Until NewDate > DateFinish
**************SOMEHOW IDENTIFY THE DATES/DAYS HERE?********
SQL = baseSQL & "'" & NewDate & "' )"
Calconn.execute(SQL)
NewDate = DateAdd("d", inter_count, CDate(NewDate))
Loop
end select
'done!
Calconn.Close
Set Calconn = Nothing
response.redirect("../events/thankyou.asp")
End Sub
%>
Any suggestions?
Storing Multiple Recurring Weekly Events
Hey guys, I'm lookin to see if anybody has a clean way to do this.
I want a way to store events that happen on given days of the week in a recurring fashion. Ex: Every Tuesday and Thursday. I know I could make booleans for every day of the week and use that to generate each week's events, but that seems messy to me. Can any of you guys think of a cleaner way? Thanx.
Timer/calander Control Problem
Ok, I don't understand why this doesn't work. I know every single person on this forum will, but It's not clicking for me.
I'm going to post two scenarios here.. one that works, and one that doesn't. I don't see how they are different, except for the fact that I'm using the timer control in the one that doesn't work, and I must be using it wrong. But the timer is so simple, i don't understand how even I can screw it up...
Code:
Private Sub Form_Load()
Dim DtDate As Date
dtDate = Date
Calendar1 = Date
This shows the calendar control with the correct date, everything is wonderful.
Now, I throw a Timer into the mix to keep checking the date so if the user is using the application before and after midnight, it will change the calendar during runtime. Maybe that is where my problem is?? Maybe that control can't be changed during runtime? I can't find much information about the calendar control, so I don't know. Is there something wrong with my logic ?
Code:
Private Sub Form_Load()
Dim DtDate As Date
Timer1.Enabled = True
End Sub
Private Sub Timer1_Timer()
Timer1.Interval = 1
DtDate = Date
Calendar1 = dtDate
End Sub
Need To Create Form Look Like Outlook Calander
Hi,
I need to generate form look like outlook calander(attached image). i have the data(appointment timings) in my access database. is it possible to do in vb same like outlook calander?
Thanks
Balakumar
Help Needed In Calander Control 9.0 In Userform.
Hi.
guys. i am using calander control 9.0 in my userform on excel.
when i click a button it should popup, when i select the date and close the calander, the date value i,e 4/4/03 should be entered in the textbox.
Like select the date from the calander, that date should reflect in the text box.
If any of you know this, please help me.
Thanks,
Chandra
Need To Create Form Look Like Outlook Calander
Hi,
I need to generate form look like outlook calander(attached image). i have the data(appointment timings) in my access database. is it possible to do in vb same like outlook calander?
Thanks
Balakumar
Retrieving Calander Info From Exchange Server
I am interested in writing an app that will retrieve a user's information from the calander that lives on an exchange server.
App will know the following and be able to get all appointment and meeting data:
Exchange Server
Login
Password
Date to retrieve
Any Ideas?
Thanks,
Error To Use Calander Control In Window XP, Development In Using VB 5.0
My Development Environment is as Below
OS : WIN 95/ WIN 2000
Development Tool : VB 5.0
Application Setup Programme (For Installation) : Toolkit Setup given with VB 5.0
When I install my application in WIN 95 or Window 2000 it work ok but when install in Window XP, Application work properly in but when I try to use calander control graphically it will not show properly and some time generate error but same application work in other OS properly.
To Soleve above problem I do remove calander control Window XP and also Remove refrence from Registry then install my application Now it works fine with same calander control. (In XP system higher version control make problem for me)
Is there any way to solve this problem ?
Is there any way without remove higher version of calander control from window XP system ?
Error To Use Calander Control In Window XP, Development In Using VB 5.0 And 6.0
My Development Environment is as Below
OS : WIN 95/ WIN 2000
Development Tool : VB 5.0
Application Setup Programme (For Installation) : Toolkit Setup given with VB 5.0
When I install my application in WIN 95 or Window 2000 it work ok but when install in Window XP, Application work properly in but when I try to use calander control graphically it will not show properly and some time generate error but same application work in other OS properly.
To Soleve above problem I do remove calander control Window XP and also Remove refrence from Registry then install my application Now it works fine with same calander control. (In XP system higher version control make problem for me)
Is there any way to solve this problem ?
Is there any way without remove higher version of calander control from window XP system ?
|
TRACKER
