Creating A Pop-up Calendar
Jun 15, 2006Does anyone know if it is possible to create a calendar, with term dates inserted by myself, that others could then use when planning courses ???
View Replies
ADVERTISEMENT
Creating A Date List Or Calendar
Dec 22, 2004Hi all~
A database front end which was built by somebody else got handed to me to do some updates (as the person who created it is no longer with the company).
The database currently has roughly ~30 reports, about 15 of which are pulled daily, and the rest weekly/monthly. Part of the report criteria selected by the user are beginning and end dates. Currently the dates are input via text boxes on a form, then referenced by the SQL statement which generates the report data.
The users want the text boxes to be changed to either a drop down list or a calendar which they can just click on a date instead of typing it in. I know .NET provides controls for a built in calendar which you can use for date selection, but this database is simply an Access front end, so I cannot use .NET.
Is there an easy way to accomplish this via VBA?
General :: Creating Individual Calendar For Each Record
Jul 16, 2014Not sure if it's possible but I'm trying to create individual calendar's for each staff member and client to put availability and bookings on to them. I've tried using the active x control but it's not really what I want, not sure how else to approach this as my access skills aren't that great.
View 3 Replies View RelatedForms :: Creating Calendar With Appointments And Schedules?
Jul 8, 2013I'm creating a database for a sales team. They need a calendar where they can enter the reminder like "call peter at 10:30 on 11th july" and reminder like " call frederik on july12 at 12:30am,etc. And they need a popup when the reminder is due. Is this possible in access.
View 6 Replies View RelatedReports :: Custom Reports Creating Chart Based On Month Not Calendar Year
Jun 15, 2015I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.
Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).
How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?
General :: Creating A Database For Creating Quotations
May 20, 2015I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?
View 3 Replies View RelatedCalendar
Jul 22, 2006Hy!
I've putted on calendar on an database but by example when I press first of June how can I make it recognise which week day is it?
Thanks
Calendar
Jan 2, 2007Hi All!
I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....
Please advice,
B
Calendar
Mar 18, 2008Using an activeX calendar. I have 2 questions.
1) Is it possible to have certain dates always highlighted in the calendar so the user can clearly see these dates. What I'm looking for specifically is to have each second thursday always highlighted with another color.
2) Using a seperate form and calendar than the one above, how would I go about using a calendar to search for old records (apply a query to it maybe, but how would I do that?) so that when I click on a date, the records for that specific date are opened.
I really appreciate any help that anyone can offer with either question. If you leave an answer in code, can you please clearly define what you named each item that I may need to replace, i.e. Calendar, Date, etc., because I'm not incredibly familar with using code.
Thanks in advance for the help, I will be able to respond quickly if you have any questions or if I didn't explain anything clearly.
Calendar
Jan 2, 2007Hi All!
I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....
Please advice,
B
Calendar
Mar 10, 2005I am trying to use a calendar to fill the date box on a simple form, I have used the examples from various threads on here but I cannot get the calendar to pop up.
The error message I get is
Run Time Error 2110
Microsoft Access cant move the focus to the control activeXCt161
Any thoughts on how I can fix the problem?
Pop Up Calendar - How?
Sep 28, 2005Hello,
I have seen pop up calendars in use in other databases and wondered if it was possible to put one into my current DB. (The standard little Microsoft style one).
Rather than using a direct entry date field in my form how do I go about adding in a pop up calendar. Can this be done easily?
Thanks
Calendar Help
Feb 8, 2006i cant hide the calendar when u open the form and i cant click a date without an error appearing help please
View 6 Replies View RelatedCalendar Help
Mar 17, 2006Hi all.
I'm trying tosetup a pop up calendar in my Access Database for users to select start and finish dates of activities. I have a calendar from here: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=413286
Here is my problem, When I run the database "Calender2000" it works fine. The calendar is displayed, but when I import the database (using get external data), and try running the calander, I get the following error:
"The expression you entered has a function name that Microsoft Office Access can't find.@."
I am fairly new to Access, and currently using Access 2007. Any help appreciated (I can follow instructions in Access 2003 format).
sugar05
Calendar
Jun 7, 2006I am getting myself into knots trying to solve this can anyone help:
I need a calender so that the user can book and check availability of courses for each date. ie course 1 has 5 places on this date, once one is booked then there should be 4 places left.
Does anyone know if there is a graphical form available which I can use for this function and serve the dual purpose of data entry?
Calendar
Aug 27, 2006Hi, I have find this calendar, wich is great for me as my ACCESS program is in italian and all calendars I have find gives me back date and month values in italian, this one I can set it either italian or english!!!
What I need is to make it visible on double clicking on the date on a form and once opened selecting the dae on the calendar it returns the value onto my date field on the form.
Thanks
Marco
Calendar
Oct 31, 2005I would like to create a text box that when it has focus a calendar pops up, allows the user to select a date and then disappears after a date is selected, leaving the date (mm/dd/yyyy) in the textbox. Anyone know where code may be available -- I am willing to pay for it? Thanks ...
View 5 Replies View RelatedCalendar Property
Jun 6, 2005Please pardon my ignorance, but how do I set up a ActiveX calendar in Access? The help files are missing from the version of Access 2000 I am using, and I really don't know what I am doing. I would be grateful for any help with this.
Thanks.
Calendar Format On DAP?
Aug 3, 2005Hi,
I've created a database to keep track of schedules, and have created a report that displays like a calendar.
Similar to Pat's example here
http://www.google.com/url?sa=D&q=http://www.access-programmers.co.uk/forums/showpost.php%3Fp%3D288791%26postcount%3D17
What I would like to do now, is create a DAP that will display in a similar format. But because the report uses subreports, it doesn't just tranfer over.
Does anyone have any ideas on how to create a simlar calendar format, within a DAP?
We want to use this on our intranet, so everyone can see each others schedules, and this is the only thing left I have to do. I just can't seem to get anything to work.
thanks
Chris.
Calendar Pop-Up Version
Aug 15, 2005Help!
I just created a calendar pop-up for data entry in Access Version 2002 and it does not work with Access 2003. Any help from anybody would be appreciated!
MSCAL.Calendar.7
Dec 5, 2005Does anybody know if MSCAL.Calendar.7 can be set so that Sunday shows as the first day of the week instead of Monday.My company uses a timesheet with a week begginning on Sunday.
Thanks
Reference Calendar
Aug 19, 2006Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?
View 5 Replies View RelatedActiveX Calendar
Sep 1, 2006I use the Calendar ActiveX to select a date.
The calendar have a dropdownlistto post the selectede date?
I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list.
I think that the control have a dropdownlist to show the selection, but i didn't found it.
Thanks,
Richard
Calendar In Access
Sep 27, 2006Trying to add to my DB. Looking to be able to keep track of time worked on stock parts on a weekly basis. Would like to be able to enter time at the end of the week, by week. IE; On the week of Sept 10th 29 hours were dedicated to restocking our shelves with stock parts. Is there an easy way to accomplish a calendar setup like this, as I seem top be over complicating the issue I think. If someone could point me in the basic direction on this that would be great.
View 3 Replies View RelatedCalendar On A Form
Oct 13, 2006I have been trying to find a calendar that I can put on a form to set up reminders, notes, and other things. I have had no luck finding such a thing.
I tried using Calendar Control 9.0, but that will not work for my needs.
If anyone knows where I can get a calendar like this, or if there is some sort of code that will make this happen, please let me know.
Thanks in advance,
PuJo
"On The Bayou"
Vacation Calendar
Oct 20, 2006Hi,
I was wondering if there was a way to make a calendar in Access 2003? I work in a group of 60 employees and we track their vacation, and personal days in a web-based application. The web-based application is going away, as it it no longer supported. Could I use Access to create a calendar for the 60 employees and have it require a user name and password for them to log into the database to look at what vacation they have?
Would Visual Basic or C++ be a better program for this?
Thanks,
Chris