Visual Basic :: Storing A String On A Calender Control

Calender Control
I need major help on this. I DONT NEED ANY CODE (although I might need some examples on how to make it work?).

so i added ms calender control from the components. dragged it on, and did a

VB Code:
Private Sub Calendar1_Click()MsgBox Calendar1.Day End Sub

so i get the day. ok heres my purpose:

I am a student, and I have 4 days to work on this project. I am trying to make an organizer. so like, on the main page a calender is shown, and if they click a date they can add what "TIME" things need to be done, and whens it due and stuff.

how do I store the info? what do i need? any other components?

anyone wanna send me some examples?

Calender Control
On one of my clients machines that numeric dates are not appearing in the calendar control, instead there are just *. I have ensured the mscal.ocx is installed & registered.

Any suggestions?

Calender Control
Hi BassTeQ, doesn't the help file give u any info on this?

Calender Control
How can you set the value of a textbox to what ever date you select in a calender control?

Calender Control In VBA
Hello,
I have to use a calender control in my project.
And my project is based on VBA.
As i don't know VBA, plz help me.
My client want a calender which have to show his appointments,follow ups and vacations.
I don't know how to proceed further with this project.
plz help me.
---------------------------------------------------
Project description:
This is a German Real Estate Company,they r maintaining their database in MS Access.He want me to convert his database into SQL Server.(Completed).
He want some additional features to his forms,
and a calender form. (regarding this, i need help)

Thanku all.

Calender Control
The calender control on one of the forms shows only the month and year.
I would like it to show the date as well. Using Vb 6.
--

Chilangisha B Changwe

email@removed
--
http://www.fastmail.fm - Faster than the air-speed velocity of an

unladen european swallow

VB Calender Control
Hi,

I use Microsoft Calender Control in my program.
The calendar gives me the - Day / Month / Year.

Now How can I change the calendar to Month and Year view only e.g June 04
etc.

Regards,
Feroz

Need A Calender Control
Hi,
Does anybody know where i can find a calender-control that displays a whole month or year and where i can fill in a value for each day ?
Then i want to put those values in a database.

Thanks

Calender Control
Hi everyone, seems to have been a while since I was last on the forum with a question, but can somebody tell me why a small program I wrote with calander control in it does not work correctly on a pc with W98 OS. The program has functioned ok for a long time then I made a small change to it and now the calender control shows in the program but with no information on it (the dates on the day boxes do not show, however if you click on them it gives the correct date) The program still works ok on two machines running win2000 (both also have vb6 installed). What is the reason for this ?
Thanks

Farpoint Calender Control
Select Dropdown and select Date(FarPoint Calender) and click on the button or form leaves a gray box(the image of the calender on the form).screen shot attached for reference.Please help

Will Calender Control Work For Me?
Hello,

I'm trying to figure out if the calender control will work for me. I want to have important events displayed INSIDE the calender on the date they occur (like the real calender everyone has in their kitchen). Like inside the box labelled Oct. 10th I might put "Doctor's appointment: 3:00". The data can be seen month by month for the whole year, like flipping the pages of a real calender. The user might double-click a date to open a text box to enter a new event. I'm pretty sure you can't display anything inside the calender control itself; it seems to be for just picking dates where you could then print events somewhere else in the form. But what good is that? If you want to make plans for the month you want to see everything you're doing all at once not just one day at a time, right?

Thanks in advance,
neef

How To Use Calender Control/(UNRESOLVED)
Hi friends,

I m designing application for school and i need to design school attendance report with form in VB6, my database is in access2000. I don't know how to design 31 text boxes in single form. SO please tell me how to use calender control for this.

it's really urgent for me as this question is on forum for last 3 days and more.

with regards
pratik mehta

Problem With MS Calender Control.
Serveral users here have a vba app in which there is a form with the MS Calender control on it. However, for one user, his date is one day off from everyone else's. Makes no sense. It works fine otherwise.

I've checked his system date and that is correct. I've also tried un-registering and re-registering the ocx. But no luck.

Does anyone have any ideas as to why this could be happening?

Bruce

"If at first you don't succeed, try, try again. Then quit. No use being a damn fool about it." --W.C. Fields

Saba

HELP In Calender User Control
Hello,

Can anyone help me take a look at a Calender User Control coding that was able to compile before but as I develop it, it gives me a type mismatch error in:

k = Weekday(mday) - 1
mday = WeekdayName(Weekday(mday))

// Below is the whole coding source, please help me out. Thank you so much.

Private Sub UserControl_Initialize()
load = 1
mrow = 1
mcol = 1
With MnthCmb
.AddItem "January"
.AddItem "February"
.AddItem "March"
.AddItem "April"
.AddItem "May"
.AddItem "June"
.AddItem "July"
.AddItem "August"
.AddItem "September"
.AddItem "October"
.AddItem "November"
.AddItem "December"
End With
For i = 1980 To 2020
yrcmb.AddItem i
Next
yrcmb.ListIndex = 24
i = Month(Date)
MnthCmb.ListIndex = i - 1
Call loadgrid
End Sub
Private Sub loadgrid()
With MsCalGrd
.clear
i = 0
For i = 0 To 6
.ColWidth(i) = 500
Next
.TextMatrix(0, 0) = "Sun"
.TextMatrix(0, 1) = "Mon"
.TextMatrix(0, 2) = "Tue"
.TextMatrix(0, 3) = "Wed"
.TextMatrix(0, 4) = "Thu"
.TextMatrix(0, 5) = "Fri"
.TextMatrix(0, 6) = "Sat"
mday = (MnthCmb.ListIndex + 1) & "/1/" & yrcmb.Text
k = Weekday(mday) - 1
mday = WeekdayName(Weekday(mday))
mdays = Left(Right(DateSerial(yrcmb.Text, MnthCmb.ListIndex + 2, 0), 7), 2)
i = 1
j = 1
Do While (True)
.TextMatrix(j, k) = i
i = i + 1
If k = 6 Then j = j + 1
k = (k + 1) Mod 7
If i > mdays Then
Exit Do
End If
Loop
End With
End Sub
Private Sub MenuCmd_Click()
Unload Me
MainMenu.Show
End Sub
Private Sub MnthCmb_Change()
Call MnthCmb_Click
End Sub
Private Sub MnthCmb_Click()
If load = 1 Then
yrcmb.Text = Year(Date)
load = 2
End If
Call loadgrid
End Sub
Public Sub MsCalGrd_Click()
With MsCalGrd
mdate = .TextMatrix(.Row, .Col)
If mdate <> "" Then
.FocusRect = flexFocusHeavy
mdate = MnthCmb.Text & " " & mdate & "," & yrcmb.Text
datelbl.Caption = mdate
If .Row = 0 Then
Exit Sub
End If
actrow = .Row
actcol = .Col
.CellBackColor = vbBlue
.Row = mrow
.Col = mcol
.CellBackColor = vbWhite
mrow = actrow
mcol = actcol
.Row = actrow
.Col = actcol
End If
End With
RaiseEvent change
End Sub
Private Sub YrCmb_Change()
Call YrCmb_Click
End Sub
Private Sub YrCmb_Click()
Call loadgrid
End Sub
Sub clear()
With MsCalGrd
.CellBackColor = vbWhite
.FocusRect = flexFocusNone
End With
End Sub

Select Dates From Calender Control.
Hi, how can I use the MS calender control and select either a date or a range of dates? Thanks

Microsoft Calender Control Version 11
Hai friends ,

I am using VB6.0 and office 2003.
I am having a date control on a form . Pressing <f5> i open a form with a microsoft calender control .

Now the problem is the font size even though i set during the design mode , in the executable the font is not displayed properly. It displays as small dots.

Also if i keep the same control on a form in a separate project and make EXE , the same problem occurs.

kindly if any one has faced this problem let me know the solution

Thanx in Advance

Calender Control - Date YES But Which Week ....
Hi there,

I'm trying to figure out if it is possible to use the Calender control and somehow when you click the date can also find the week of that date (say it's "date = week 32 of the 2006) just like in a dairy. If it has to be any other control fine, but I would prefer the Calender cntrol to work with.

Thanks aktell

Calender Control Finnish Problems
HEEEELLLLPPPPPPPP

I have installed a system in Finland onto a Finnish PC. Now the calender control doesnt work on that pc. The OCX is there and vb6 runtimes are present but for some reason the chars dont appear???

Anyone had this before?

Calender In Common Control (resolve)
i am using date picker under ms common control.how do i change the date format to dd/mm/yyyy (eg 12 Janunary 1950) thanks!

Calender Control Current Date
Hello,

I have a Microsoft Calender control embedded in a form. I would like the control, when opened, to display the current date. Is there a way of setting the value of the calender control with the current date. Any help would be appreciated. Thanks,

Hellboy

Runtime Error While Using Calender Control??
hi,
can any help me to solve the runtime error while using calender control.the screen image attached.plz do the needful.

Jayakumar

Calender Control 10.0 Application Kick Out
About a year ago I experience an application kick out when I clicked on the VB6.0 calender control 10.0. It only did it on one of my PC and not on the others. The solution was to go into the PC set up and reset a calender funtion. After I made the adjustment all worked fine. A year later I havent been able to fine those instructions on any of my search sourses.

Can you help diect nme to this fix.

Ron

Calender View Control Position On Screen
Hi All

I click a number of buttons to open a calender view

Can anyone tell me how to get my calender view to always open next to the button i pressed to open it

thanks

Gibbo

Changing Recordsource Of Calender Control During Run Time
hi,
I am doing a project using calender control in vb and databases. I couldnt change the recordsource of the calender control during runtime. I need.... whenever i select a day from calender control the corresponding datas from the database should display in the datagrid used in the same form. I ll be very thankful if you give some suggestion for it.

Is There Any Control Equivalent Of MS Calender Control 8.0
we can specify dates but not time with a calendar control. Is there a control which allows to choose time too? Or do we have to include madkEd box or something like that?

thanks

Srikanth

Storing SQL Value In A String...
hi can anybody help me in storing the value of an SQL statement value into a string variable....

my query is as follows:-

rst.Open "SELECT SUM(Land_Sold_Price) as Total From Ticker_Land_Sold_Info WHERE City ='" & str11 & "' AND Land_Location = '" & str12 & "'", cnn, adOpenStatic, adLockOptimistic

i just want to store the value of "Total" from the query into a string variabe say "xyz"

Thanks in advance...

Storing A String
Hi All,

How can I store a string which contains a password in my program and make it changable while running the program then save the new password...
right now I have everything working ok I can even change the password then enter in the new one and it will work however if I exit the program then start it again it uses the old password...

what I have is 2 textboxs one hidden (which stores the real password) and one that is visible (which you enter the password in) then when u click 'ok' it checks if the textboxes are the same then if its correct it gives u the option to change the password...

I need to make it remember the new password if I change it

Thanks,
Mike

Storing Expression In String
I'm trying to store an expression in a string, which you sould say thats easy,
string = "expression", but the problem is the expression i am trying to store also has a " inside it. so it sees string = "expre"ssion" and thinks everything after the 2nd " isn't to be included. how do i avoid this?

Storing IF, Then Else In A Table Or String
OK, I am REALLY having some difficulty getting my mind to wrap around this. I am hoping one of you guys can push me down the hill in the right direction (and hoping there is no cliff at the end).
I need to pull information from a table, which is not my problem. The problem is, I need to be able to specify in some other FILE (either another table or a text based file) WHICH things to pull from the table, with the ability to have IF, then, Else statements in this other file. For example:

If [GROUPNUMBER] = "" then [INDIVIDUALNUMBER] Else [GROUPNUMBER]

If I was just hard-coding this information in it would be easy, because I would just use that as above, but I need to have the information on what to pull USER MODIFIABLE. The problem is, I cannot evaluate an If, then, Else statement to see if it is true when the entire statement is brought in as a string. I thought about having a table with colums

Type Field Qualifier Value Output
"IF" "GROUPNUMBER" "=" "''" [INDIVIDUALNUMBER]

but this is too simplistic. I sometimes need to have nested IFs, and sometimes IF statements may need to span several fields. For example:
If [GROUPNUMBER] = "" then
Fieldx
Fieldy
Fieldz
Else
Fielda
Fieldb
Fieldc
End if

has anybody had to do anything similar to this, and if so, how did you structure the customizable tablefile? Any ideas would be greatly appreciated.

Storing A Double In A String
Does anyone know how to convert a double into a byte array or a string, so that instead of having the ascii equivalent the actual values as stored in memory is used.

eg

NOT aString = cStr(aDouble)

but so that a string that represents 0 would be the same as chr(0) & chr(0) & chr(0) & chr(0)

UTF8 String Storing
Hello

How do I store UTF8 string using Visual Basic 6.0 to MySQL 5.0. Im using ADO 2.8. How do I save and retrive this string?

regards

Storing A String With Double Quotes
I need to store a string with double quotes and am having a bit of trouble. For example, I want the value of variable myString to be:

Curly said to Moe, "Wise guy!"

So if I code:

myString = "Curly said to Moe, "Wise guy!""

that don't work, eh?

I've tried several combination using the ` character but can't quite get the concept.

Please??

Regards...Tom

Storing Words From String In Array???
hi ppl..

I have a programe were i need to store each individual word of a string that can be any legnth into a variable legnth array..

i dont have any idea how to do this so any help would be much appreciated..

thanks in advance,
someone

Storing A String Variable In VB Application
Hi all,

Does anyone know of a way to store a string in a VB application, and being
able to change the value of that variable. Then next time when I run the
application again, it will remember the new value I have stored?

I figure I could use a 'Tag' but it doesn't remember what I have changed in
the last run. It always gives me the original tag value I entered.

Thanks in advance!

Tania

Storing Variable Names In A String
Hi Listers,

I am having a string/variable problem, which I imagine is straight forward,
but I have not been able to solve at this stage.

I am storing an sql query in an access database where the text(query)
contains a mixture of text and variables that will be populated with values
when the query is used in the app...for example

"Select" & sqlfields & " from " & thmeDataset & " where " & sqlsearchfld & "
in (" & SelListStr & ");"

anyway , the problem that I am having, is that when I read the sql query in
(in VB 6) it is all recognised as a string, so the variable names are not
replaced with the values that they hold. if I were to assign the above query
to a text variable inside the vb code, then each variable would be replaced
with the associated value...

do any of you know of a way to get around this? Do I need to make a
procedure which passes the query in and figures out what is a variable and
what is not?

thanks in advance,

Phil

Phil Bright BSc(GIS)
GIS Programmer
Demography/Population Program
Secretariat of the Pacific Community (SPC)
B.P.D5, Noumea Cedex 98848
New Caledonia
Phone (687) 26.20.00 ext(226)
Fax (687) 26.38.18
E-mail: email@removed
www.spc.int/demog

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.380 / Virus Database: 213 - Release Date: 24/07/2002

Storing Data Into String Format
I am currently working on import function from Excel spreadsheet into MS Access. The program is code in VB and the connection and recordset used are ADODB.

There is this particular field in excel that contains more than 255 words (inclusive the blank spaces). When i try to store that into a variable (let's name it strTemp), strTemp wont be able to capture the whole length.

Is there any way i can go around and fix this? I heard somewhere that it got to do with the driver and all that, does that change anything? The driver that i used is:

"driver={Microsoft Excel Driver (*.xls)};" & _
"dbq=" & sFilename & ";" & _
"Extended Properties=""Excel 8.0;HDR=Yes"""

Regards,
Mar

Removing The / 's From Date And Storing In String Format
Hi! Is there a way to remove the slashes "##/##/##" from a date. e.g. 01/01/01 would become 010101 and then to store that as a string.

Basically im trying to convert the current date into a string that has no "/"'s in it so that the date can be saved as a string to be used as a filename.

Can anyone help?

Thanks

SC

Storing Data Into String Format **RESOLVED**
Dear VBers,

I am currently working on import function from Excel spreadsheet into MS Access. The program is code in VB and the connection and recordset used are ADODB.

There is this particular field in excel that contains more than 255 words (inclusive the blank spaces). When i try to store that into a variable (let's name it strTemp), strTemp wont be able to capture the whole length.

Is there any way i can go around and fix this? I heard somewhere that it got to do with the driver and all that, does that change anything? The driver that i used is:

"driver={Microsoft Excel Driver (*.xls)};" & _
"dbq=" & sFilename & ";" & _
"Extended Properties=""Excel 8.0;HDR=Yes"""

Regards,
Mar

Edited by - marsulein on 11/9/2004 3:45:36 AM

Problem While Storing A Text String To MS Access
Dear friends

While storing a product id to ms access i am facing a strange problem.....
the product ids are like 12345/25, 20001/21, 34567/11 ........
but while storing to db it is stored as 493.8 (ie. 12345 divide by 25), 952.428
(20001 divide by 21), 3142.45455(........

I am storing the product id in a string variable also the data type in db is text....

cant understand where the problem is bcoz while debugging, the variable value
is correct but in db .......

pls help me out

How To Convert Grandtotal In To String Format In Vb6 Datareport Without Storing In Database
Hi,
I need to generate/print in datareport......grandtotal in words.
I wrote string conversion function....i am getting output if i store that string in database...
what i need is ....i dont want to store the string value in database.
when the user press generate invoice cmdbutton,
it should generate string convertion function and display the same in datareport.......
please help me......
regards,
madhu

Storing A VB6 Control In A SQL Server DB
Has anybody ever tried to store a VB control in a Sequel Server 2000 Database and then retrieved it with all its properties intact? Or am I going to have to store all the properties seperately and put them back together in VB when creating a dynamic form?

Storing Data For TreeView Control
I have a treeview control and a rich text box in a form..Each node in the treeview is connected to the rich text box for storing text data.ie, when i click on a node i have a text box to type text data for that purticular node and like this i have to store text for all nodes in the treeview and link all the nodes to the text box..I need help for the following tasks..

1) A way to bind the nodes and text box data with each other...
2) Store the treeview structure and it's associated text data(which is different for each node) in a binary text file
2)Poplate the treeview from the saved binary file.

Any help would be greatly appreciated,

Thanks in Advance,

Goravani

Storing Extra Information Using A Listview Control
Heya..

I've got an ic client I'm writing, and I'm attemtping to make a banlist viewer/editor.. Is there any way I can code something that would let me store extra info into a listview control.. eg:

Entries are listed like this:

OWNER host@mask.com
DENY host@mask.com
DENY host@mask.com

If I click one, my aim is to have labels next to it that would then contain the author's id (hostmask), bantime, and comment.

I've already got these variables.. it's just a matter of storing the extra info for each line of the listview so whenI click it it fills them out.. is this possible?

thanks,

m3rlin

Storing Images In SQL Vs. Storing Path To Image File
I'm writing a document management application whereby users will be able to scan documents into the application. Then from within the applicaiton the users will be able to access the scanned documents.

So the debate is whether I should store the image directly in SQL Server (7.0) or simply store the path to the image and put the image on a network folder.

I have heard people recommend storing only the path and not the image itself but I don't know the reasons.

Obviously the database would be quite large but can't SQL server handle it? Backups would have to be performed either way so... I suppose if the database was corrupted then all images would be lost as opposed to single image files being corrupted on the harddrive.

I guess I'd like to hear what others have done in the past, their opinions, etc.

Thanks in advance.

Storing A String On A Calender Control

im making a project and i want to have it so when you type something in and press a button it save a value and highlight the date on the calander you saved it to how would i do that?Edited by - Split on 12/10/2005 2:08:29 PM

im making a project and i want to have it so when you type something in and press a button it save a value and highlight the date on the calander you saved it to how would i do that?

Edited by - Split on 12/10/2005 2:08:29 PM