Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Access form to display data availability like a calendar


(!)

mihaufo's Avatar
mihaufo mihaufo is offline
Computer Specs
Member with 36 posts.
THREAD STARTER
 
Join Date: Mar 2012
Experience: Beginner
22-Jul-2012, 03:51 AM #1
Access form to display data availability like a calendar
I am trying to built an application to display the availability of data from different tables in a form of calendar.I have a table A, B, C.Now, I will have to display data availability on a certain date.if A, B and C are available display the date in the calendar as Green.if only A is available, then display the date in Orange and like wise.Kindly assist.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,517 posts.
 
Join Date: Mar 2005
Location: UK
22-Jul-2012, 04:45 AM #2
Have you created the Calendar Form yet?
If not do you have an example of how you want it to look?
mihaufo's Avatar
mihaufo mihaufo is offline
Computer Specs
Member with 36 posts.
THREAD STARTER
 
Join Date: Mar 2012
Experience: Beginner
24-Jul-2012, 01:49 AM #3
I have attached the xls file in which I tried to design the forms, Sheet 2 contains the canlendar form. Sheet1 has the tables and from the next forms.
Attached Files
File Type: xlsx tables and forms.xlsx (41.0 KB, 68 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,517 posts.
 
Join Date: Mar 2005
Location: UK
26-Jul-2012, 06:44 AM #4
I think that design may be a bit optimistic. Especially as various Months have a different number of days.
What does your table design look like?
mihaufo's Avatar
mihaufo mihaufo is offline
Computer Specs
Member with 36 posts.
THREAD STARTER
 
Join Date: Mar 2012
Experience: Beginner
26-Jul-2012, 06:59 AM #5
The tables are described in the Sheet1 of the attached "tables and forms.xls".
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,517 posts.
 
Join Date: Mar 2005
Location: UK
26-Jul-2012, 07:08 AM #6
OK, well you will need a table of dates to create your form from, the Activex Calendar that Access provides is very inflexible and can't do what you want.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑