Hi Gurus
This is a cry for help to all of you. I am looking for some sort of
plug-in/active X/code/link to outlook/what have you, which I can add to my
MS Access database for my users to manipulate dates.
For example, as part of my project, I have a roster. I want my users to
change the start and end times of the rostered people using a drop and drag
scenario rather than entering data.
Is there anyone that can send me in the right direction. I am happy to pay
for it, but it has to be versatile, good looking and user friendly.
Any suggestions? ( I have searched significantly)
Thank you
- Nicolaas 5 3378
Search Google for "Access date picker"
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:aM******** ***********@new s.xtra.co.nz... Hi Gurus
This is a cry for help to all of you. I am looking for some sort of plug-in/active X/code/link to outlook/what have you, which I can add to my MS Access database for my users to manipulate dates.
For example, as part of my project, I have a roster. I want my users to change the start and end times of the rostered people using a drop and
drag scenario rather than entering data.
Is there anyone that can send me in the right direction. I am happy to
pay for it, but it has to be versatile, good looking and user friendly.
Any suggestions? ( I have searched significantly)
Thank you
- Nicolaas
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message
news:jq******** ************@co mcast.com... Search Google for "Access date picker"
"WindAndWav es" <ac****@ngaru.c om> wrote in message news:aM******** ***********@new s.xtra.co.nz... Hi Gurus
This is a cry for help to all of you. I am looking for some sort of plug-in/active X/code/link to outlook/what have you, which I can add to
my MS Access database for my users to manipulate dates.
For example, as part of my project, I have a roster. I want my users to change the start and end times of the rostered people using a drop and drag scenario rather than entering data.
Is there anyone that can send me in the right direction. I am happy to pay for it, but it has to be versatile, good looking and user friendly.
Any suggestions? ( I have searched significantly)
Thank you
- Nicolaas
Hi Darryl
I took up on your suggestion, and I did find some simple date pickers, but
nothing that really cuts the mustard.
Unfortunately, I need something that is more than a datepicker, I need a
date/time manipulation tool, similart to, for example, the calender in
outlook (i.e. something sophisticated that allows the user to visualise
dates and times and move them around).
Thank you
- Nicolaas
Suggestion 1:
Search Google for a third party utility: "ActiveX calendar access"
Suggestion 2:
Try adding the ActiveX calendar control available in Access to a form and
working with that. I've never used it, and don't know what functionality it
gives you. (Calendar Ctrl 10.0 in Access 2002)
Of course, your customization options will be limited.
Suggestion 3:
You can use the functionality of Outlook if all of your users have Office.
This would seem to me to be by far the hardest way to go, but would also
yield by far the best results.
Suggestion 4:
Depending on your skill and time, create your own form, starting with the
same sort of look that the Calendar Control has, then making it do what you
want - 35 buttons, a few labels ... This would be the route I would
personally take, since I'm too cheap to buy third-party tools, Outlook is
too complex to spend the time to learn, and I'm too picky to use the given
ActiveX control.
Hope this is of some vague help.
Darryl Kerkeslager I am looking for some sort of plug-in/active X/code/link to outlook/what have you, which I can add
to my MS Access database for my users to manipulate dates.
Unfortunately, I need something that is more than a datepicker, I need a date/time manipulation tool, similart to, for example, the calender in outlook (i.e. something sophisticated that allows the user to visualise dates and times and move them around).
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message
news:Mt******** ************@co mcast.com... Suggestion 1:
Search Google for a third party utility: "ActiveX calendar access"
Suggestion 2:
Try adding the ActiveX calendar control available in Access to a form and working with that. I've never used it, and don't know what functionality
it gives you. (Calendar Ctrl 10.0 in Access 2002) Of course, your customization options will be limited.
Suggestion 3:
You can use the functionality of Outlook if all of your users have Office. This would seem to me to be by far the hardest way to go, but would also yield by far the best results.
Suggestion 4:
Depending on your skill and time, create your own form, starting with the same sort of look that the Calendar Control has, then making it do what
you want - 35 buttons, a few labels ... This would be the route I would personally take, since I'm too cheap to buy third-party tools, Outlook is too complex to spend the time to learn, and I'm too picky to use the given ActiveX control. Hope this is of some vague help.
Darryl Kerkeslager
> I am looking for some sort of > plug-in/active X/code/link to outlook/what have you, which I can add
to my > MS Access database for my users to manipulate dates. >
Unfortunately, I need something that is more than a datepicker, I need a date/time manipulation tool, similart to, for example, the calender in outlook (i.e. something sophisticated that allows the user to visualise dates and times and move them around).
Dear Darryl
I liked your answer, that is interesting. I am already using that active X
thing. It is very useful, but also very limited (it is a date picker and
not a date manipulator that shows you events and the like).
From your options I would choose 4, but the problem is that I do not have a
spare three weeks. Therefore, I reckon I may want to explore 3. I will
start a new post to see if there is anyone out there who has used the
Outlook Calender.
Thank you once more
- Nicolaas
Nicolaas,
If you like to read the background stuff, there's an example of
manipulating the Outlook calendar from Access in Scott Barker's book,
"Access <version> Power Programming". Otherwise, I'm sure it's on the
MS site. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: perplexed |
last post by:
How do you convert a user inputted date to a unix timestamp before
insterting it into your database? I have a form, with a textfield for
a date that the user inputs in the format mm-dd-yyyy and three dropdow
boxes for hours, minutes, and AM/PM. All of these need to be considered
together and converted to one Unix Timestamp and then inserted to the
MYSQL date field. The type of field is INT (11) so that I can instead
of the standard...
|
by: jason |
last post by:
I'm tearing out my hair here: ACCESS 2000:
When I attempt to overwrite a date in my date field with a new user selected
valid date eg: 05/23/99
my date field changes to the TIME I updated the field
and does not display my desired date: 05/23/99
Instead it reads: 12:12:03 AM
I am going nuts - even considering converting the field to text. The field
|
by: What-a-Tool |
last post by:
How does the expire date work setting it server side with asp.
I know with javascript setting it client side it will be set to the clients
local time, and therefore expire when the clients local time reaches the set
expire-time.
But if it is an expire time set on my server in California, and the cookie
is put on a computer that is running on London Time, and the expire time is
set at the server as 20 minutes from now, the London computer...
|
by: John Kiernan |
last post by:
Hey JavaScript gurus!
Here's a weird one:
If I check (with an alert) this line:
vStrDate2 = vDate.toLocaleString();
I get: Saturday, August 14, 2004 7:57:30 PM (as I should)
but this operation...
|
by: sgershon |
last post by:
Hi.
I know this is should be a simple question.
I know server-side web-programming, and never needed to use client-side
scripting... until now :)
I have done so far a little number of scripts that work well. But there
are two that I am having special difficulties with:
1)
| |
by: Graham Feeley |
last post by:
I have a date field named rcdate
it is a general date eg:
12/08/2006 3:30:00 PM
12/08/2006 3:00:00 PM
I used to update another empty field named rdate with the
with using in a update query " Left(Ratings!RCDate,10)"
This now does not work for some reason
gives me the error
"undefined function in left function"
|
by: Luvin lunch |
last post by:
Hi,
I'm new to access and am very wary of dates as I have limited
experience in their manipulation and I know if they're not done
properly things can turn ugly quickly.
I would like to use a calendar control to allow my users to enter a
date but I need them to enter a time as well. It doesn't look like the
calendar control will allow times to be entered so I was thinking of
having two text boxes. One text box would contain the date...
|
by: Billy |
last post by:
This string is supposed to provide all records from an MDB database
that match the courier and date specified in the query. I
Response.Write the query and I get a date as 1/27/2007. The date
format style is exactly the field specification as I see in the MDB
Date field in the Courier table. The data for this query exists - both
the courier and date that I'm selecting.
However, when the file continues processing and the results are...
|
by: GorseFox |
last post by:
Forgive me. I am new to PHP and am a little confused by date
manipulation and would appreciate some guidance.
I have a string containing a date which has been parsed from and RSS
feed. This looks something like: "Tue, 25 Mar 2008 04:28:18 -0500" and
is stored in $rssdate
I would like to manipulate this date to correct the timezone
adjustment. (I happen to know that the item I am referencing was
actually timestamped at 09:28:18). I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |