Populating 7 day calendar with information

I wish to add a 7 day calendar to the switch board form, but I'd like to 
populate each of the day boxes with fields from a query. In essence the query 
locates things to do in the week. For ease of the user i'd like them to be 
able to see a 7 day calendar with the fields "ownerid","make","model" based 
upon the value in "next_due" (eg "next_due" is during that week)
Thank you
0
Utf
11/7/2007 8:57:01 AM
access 16762 articles. 3 followers. Follow

1 Replies
1448 Views

Similar Articles

[PageSpeed] 19

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.mdb'

for some examples. You would need to write a bit of VB code.

Peter Hibbs.

On Wed, 7 Nov 2007 00:57:01 -0800, Accessidiot
<Accessidiot@discussions.microsoft.com> wrote:

>I wish to add a 7 day calendar to the switch board form, but I'd like to 
>populate each of the day boxes with fields from a query. In essence the query 
>locates things to do in the week. For ease of the user i'd like them to be 
>able to see a 7 day calendar with the fields "ownerid","make","model" based 
>upon the value in "next_due" (eg "next_due" is during that week)
>Thank you
0
Peter
11/7/2007 12:26:32 PM
Reply:

Similar Artilces:

Money 2006 Crashes Opening Calendar
I have been using Microsot Money for years. Upgrading to next version almost every year. I have been using Money 2004 Deluxe for a while. It works great. I tried upgrading to Money 2006 Deluxe ... everything works except when I try to open the Calendar. I get the message "Microsoft Money has encountered a problem and needs to close. We are sorry for the inconvenience." I tried a lot of different things (repairing the file many times, which shows no errors or no corruption or no broken records). I also just tried to go from 2004 to 2005. This actually works ... so I am now using Mone...

Move Information Store
How do you move the information store on an Exchange 03 server? On the 5.5 server you could run the "optimizer" and relocate the information store. Is there a way to do this with o3? tia This should help: http://www.msexchange.org/tutorials/MF001.html -- Mark Fugatt Exchange MVP http://www.exchangetrainer.com http://www.msexchange.org "smw" <anonymous@discussions.microsoft.com> wrote in message news:612501c42e27$172305f0$a401280a@phx.gbl... > How do you move the information store on an Exchange 03 > server? On the 5.5 server you could run the "op...

Calendar print format
When I print a monthly format calendar in Outlook, say for January, there are two small monthly calendars printed in the header for reference. One is for the following month, February, but the other is the current month, January. Shouldn't this other be December? How do I change this? It doesn't make sense. Thanks. Unfortunately, you can't change it for the built in print styles. Apparently Microsoft is trying to discourage people from living in the past ;-) You might want to take a look at some free Word templates that use your Outlook calendar data to create a calenda...

how to send calendar reminders to non-responding invitees?
Why can't you send true calendar reminders to invitees who haven't responded?? Outlook knows who hasn't replied, so why doesn't it let you send a reminder to those people?? (BTW -- Lotus Notes lets you do this. Another reason Outlook drives me crazy!) Outlook !=Lotus Notes. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. ALWAYS post your Outlook version. How to ask a question: http://support.microsoft.com/KB/555375 After furious head scratching, LDBW asked: | Why can't you send true calendar reminde...

Help with Populating StringMap table
I have a user request that I'm sure is made with some frequency, so I'd like to see if anyone lse has solved a similar probelm, and/or if my solution might work. My users requested that we replace the State/Province text box with a State drop-down list. Since this textbox appears in several places, and since the tools for populating and maintaining picklist are poor (to be generous), I decided to look into automating the process. I created a stagin database for just such things, with a mirror stringmap table. Through a query, I can populate the CRM stringmap table quite easily, with ...

How long should it take an Information Store to start with no edb.chk
We've been having problems with our 5.5 server (20 hours in now) Having performed a restore of an offline backup we started the Information Store with no edb.chk. I believe this will go through all the edb.log files and replay what it needs to. I have 26 log files (so 130Mb) and the priv.edb is around 31Gb in size. The information store has been starting up now for over 5 hours. There seems to be activity the service control "clock" is spinning. No errors in the Event logs whilst this happens. I read in article KB 200941 How the Restore in Progress Registry Key works that if...

outlook calendar #10
How can I set up the calendar so that each of my appointments are automatically given 15 minutes or 10 minutes ? set the time scale to 10 or 15 min. right click on the time scale in day view or change it in tools, options, calendar. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www....

sheet protection #7
why can't i protect some of my excel sheets? Is the workbook shared? Have you grouped multiple worksheets? jaci wrote: > > why can't i protect some of my excel sheets? -- Dave Peterson ...

Outlook 2003 won't start under Windows 7
Reinstalled Office 2003 after converting to W7. This error message appears immediately after starting OL: "Unable to open your default e-mail folders. The information store could not be opened." Try; Start Run Outlook.exe /resetnavpane (space between exe /) "Kay" <Kay@kayknapp.com> wrote in message news:eYf7cZufKHA.2184@TK2MSFTNGP04.phx.gbl... > Reinstalled Office 2003 after converting to W7. This error message > appears immediately after starting OL: > > "Unable to open your default e-mail folders. The information store ...

How can I stop repeatint information from appearing in my report
I am tracking Clearances for Foster Parents & their families. My queries work great (thanks, by the way to those that helped!!). I am now trying to create a report. Everything works great EXCEPT for the fact that I have repeating data appearing. I have the Foster Parent (FP) info and the Spousal information in the Header section of my report. In the DETAIL section I have the REsidents int he home (there can be many residents to one Foster Parent). Here is the problem. Becaue the REsident info is relating to BOTH the Spouse and FP info it is repeating TWICE. But if I put the Spousa...

Business Portal 2.5 installation error "Unable to validate company information in your backoffice data."
hi, i got this message Unable to validate company information in your backoffice data upon installing Business Postal 2.5 Please help.. tnx Stephen, Thanks for using the newsgroups. The error you got generally means there is a data issue with either the DYNAMICS..SY01500 or DYNAMICS..DB_Upgrade tables. Verify that all companies listed in those tables are still valid in your environment. Thanks, Rob -- Rob Bernhardt Software Quality Assurance Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. "Stephen Lee Glo...

blocked attachment #7
I have a user with outlook 2003 The user gets emails from our customer that has an attachment. The extension of the file is .snp Never had a problem with this before. But now, when looking in her inbox, it shows that there is an attachemnt, but she cant view it. If I R-Clcik on teh email and selct view, it shows teh file. If I try to open, it wont, if I tray to save it to teh desktop, I get a message saying Outlook can't save teh file. This was workign just fine earlier today, and emails recieved yeterday can still be opened fine. Restarted teh machine, no luck. Any ideas...

How Do I Delete My Local .PST Calendar?
How do I delete the calendar in my local .pst file? When I create new .pst files, there is no calendar in it. But if I then add a calendar to this .pst file, it screws up which caldendar my meeting requests go into. So I would like to delete the local calendar and just keep the service calendar. Ernest Maw wrote: > How do I delete the calendar in my local .pst file? > > When I create new .pst files, there is no calendar in it. But if I > then add a calendar to this .pst file, it screws up which caldendar my > meeting requests go into. > > So I would like to delete...

Changing Default Calendar Name
Not sure how I did this. While Setting Outlook up to work with Mobileme my default calander name changed from "Calendar" to "Work", something I thought could not happen. Have been trying to change it back but can not figure out how I managed to do it in the first place. Can anybody help me change it back to the correct name, or if not if I leavel the name change as is will it have any adverse effects going forward. "Mark" <Mark@discussions.microsoft.com> wrote in message news:E2357600-005B-41C3-AF4C-BDBA5BD0F1CE@microsoft.com... > Not ...

Exchange Mailbox
I have a client who uses Outlook at his office in conjunction with Exchange Server and Outlook at home with a totally separate POP3 mailbox and email address. He wishes to be able to see his Office Calendar and Contacts on his home machine but does not want his office mail delivered or synchronized with his home machine or visa versa. I have set up an Exchange Mailbox on his home machine and can access the Calendar and Contacts but have not found a way to stop the Mailbox picking up the email from the Exchange Server. I have tried every setting i can think of including modifying the Send an...

All Day Affair designation
I am presently using Office Outlook 2007 with Windows Vista. All my appointments show in the "To Do" window except those I have designated as "An All Day Affair". These are important commitments for me, how can I have them listed as upcoming appointments? Thanks for your help. Gene L. All Day Events don't show in the To-Do Bar of Outlook 2007, only on the calendar. If you upgrade to Outlook 2010 (due in the next several weeks) it does support All-Day Events in the To-Do Bar. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.roland...

Working time and days
I would like to be able to caculate working time when the cell format is 4/1/2005 6:40:26 AM (not seperated into date and time) Cell A1 dd/mm/yyyy h:mm:ss (First Day) Cell A2 dd/mm/yyyy h:mm:ss (Last day) Working hours would be 8:00 to 17:00 Public holidays need to be taken out too The result should be working days hours and minutes or just hours and minutes, so that Saturday, Sunday, public holidays & between the hours of 17:00 to 8:00 to the next working day would not count. I've tried using: =((NETWORKDAYS(A1,C1)-2)*9)/24+TIME(17,00,0)-B1+D1-TIME(8,00,0) But I think this ...

Outlook 2007 "stuck" in other user's calendar
Help! I just opened someone else's calendar from my Outlook 2007. When I went to Inbox, it showed my Inbox, when I went to Contacts it went to my Contscat. When I clicked theCalendar icon it went straight back to the other user's calendar. I couldn't find a way to close his calendar and get back to mine. I tried exiting Outlook and restarting, but the same thing happened. I evntually got out of it, but by then was so confused I don't know how I solved it! Is there a simple explanation? TIA Steve there should be a list of calendars in the navigation pane and you check (or ...

How can I get the day of the week (eg Friday) to display ?
How can I get the day of the week (eg Friday) to display instead of just the number. Thanks "Chicklet" <Chicklet@discussions.microsoft.com> wrote in message news:851C3A4F-C83D-467D-805D-CA861B88C558@microsoft.com... > How can I get the day of the week (eg Friday) to display instead of just the > number. Display where? -- Brian Tillman [MVP-Outlook] Change your Long Date Format to include the day. Found under Control Panel->Regional and Lanuage Settings->Customize->Date Tab. -- Milly Staples [MVP - Outlook] Post all replies to the ...

Subform
I'm having a problem loading data in a subform. The fields in the subform and main form are not bound. I'm using MSAccess 2007 I put VBA code in the "On Load" event of the subform to get records from a table and populate the fields on the subform after the main form is opened from a previous form but I'm getting the message: " MSAccess can't find the form referenced in the VBA code" (referring to the subform, mysubform) . As a test, I put the code to populate the subform (including, as the first line of the code, "DoCmd...

Calendar corruption in Outlook 2003
I was refered to the Exchange area from the Outlook area. You might have an answer other than "Known Issue". I am working with multiple users that cannot open recurring items in their Outlook 2003 calendars. This seems to happen only after opening their mailboxes in Outlook 2000. We have an Exchange 2003 server and a mixed Outlook 2000 & 2003 environment. The only way that I have found to fix this is by deleting their local profile and starting over. Does anyone know how to fix this without recreating the local profiles? Thanks. On Mon, 1 May 2006 08:57:02 -0700, ...

Internal server information broadcasted over Internet via SMTP
When I Telnet to my Exchange 2003 SP1 server from the Internet, it responds with the below information. Does anyone know how to prevent it from broadcasting it's internal information? Thanks! 220 servername.domain.net Microsoft ESMTP MAIL Service, Version: 6.0.3790. Here you go: http://support.microsoft.com/?id=836564 -- Teo Heras "Dragon" wrote: > When I Telnet to my Exchange 2003 SP1 server from the Internet, it > responds with the below information. Does anyone know how to prevent > it from broadcasting it's internal information? > Thanks! > >...

150 Badges Icons Set PSD.exe (7/7)
=ybegin part=7 line=128 size=1593874 name=150 Badges Icons Set PSD.exe =ypart begin=1497601 end=1593874 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n���J-����J�haak�]w���...

turn off use of System Volume Information
How do I disable the use of the "System Volume Information" directories to store MBs of deleted data? Especially on several drives where I manipulate large data files, I end up having to manually delete all the files and subdirectories every few days. I do NOT want any Restore Point capability; I want to have files deleted when I choose to do so. See http://bertk.mvps.org/html/diskspace.html & http://bertk.mvps.org/html/healthy.html#Adjust Frank wrote: > How do I disable the use of the "System Volume Information" > directories to store MBs of del...

Migrating from MFC 7 to 8 (error C2440)
Hello everybody. I'am migrating a project from MFC 7 to 8, and the compiler gives me the error: ....\MyCode.cpp(53) : error C2440: 'static_cast' : cannot convert from 'UINT (__thiscall CMyDerivedCwndClass::* )(CPoint)' to 'LRESULT (__thiscall CWnd::* )(CPoint)' Cast from base to derived requires dynamic_cast or static_cast The error is in the message map: BEGIN_MESSAGE_MAP(CMyDerivedCwndClass, CWnd) //{{AFX_MSG_MAP(CMyDerivedCwndClass) ON_WM_NCHITTEST() //Here is the error!!! //}}AFX_MSG_MAP END_MESSAGE_MAP() I need the MFC 7 version too, so, the c...