Hi i'm using this code i've put together from various websites i've googled about outlook appointments, My VBA isnt really good, but i have a form ive created where i can book appointments into outlooks calendar
when im trying this code the .start = me.txtDate.value + Me.txtTime.Value doesnt seem to work, can anyone help?as i need to try and use the .Start line to for date and time.
Please Login or Register to view this content.
cheers
Can you post a working example file? Can't run the code to help you debug without creating all of those objects, which is time consuming.
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
there you go
thanks
Are you addng the txtDate.value and the txtTime.value together? or do you want to have the date and time together as a string?Originally Posted by gmc2k2
...using the "+" adds the values together mathmatically
...if using as a string, take out the "+" and replace it with a "&",
....if you need spaces inbetween the date and time, then type it like this:
.start = me.txtDate.value & " " & me.txtTime.value
what i want it do to is for the .start be whatever it needs to be to book an appointment in the outlook calendar for the time and date the user has put in the user form, so would it be & for this to work correctly?
when ive tried it either way it keeps on saying mismatch?
Looks like you are going to have to enter the start date and start time separately, in Outlook they are in seperate fields....problem I have is suggesting the property for the start date...everything I tried didn'y work correctly and gave a mis-match error.
Eventually sorted this out, thank you very much for your help, helped me greatly i used this code and had F2 cells =C2+D2
Please Login or Register to view this content.
So it works now?....I was getting an error when stepping through using debug where .Start = something and me.txtDate = something different....same with .Duration.
....so there was the error...but I couldn't figure out why they were different.
Keep it simple:
Please Login or Register to view this content.
snb, that works good....thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks