thanks for jumping in Gina!
Bill, Gina has great links on her site, an excellent one to bookmark :)
~~
I have screen shots of my popup calendar (the beginning of this message) where it is also posted on RogersAccessLibrary:
http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html
AD has a ton of stuff on RogersAccessLibrary (close to 200) -- and he just posted a cool drag and drop thing for forms yesterday :)
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Bill Singer
Gina,
Thank you. I was briefly looking at this while at work. I have not quite figured it all out yet but I will keep reviewing. I really only need a person to log on to gain access to the database. At this point I do not see the need to restrict permission so I may not need all of those tables.
I think the code behind the login button will be the biggest trick for me.
Thanks for the help. I have put the website in my favorites.
Bill Singer
From: Gina Whipp
Bill,
I have one...
http://www.access-diva.com/f7.html
Gina Whipp
Microsoft MVP (Access)
Specializing in Microsoft© Access® Solutions
From: Bill Singer
Crystal,
Do you know if there is a sample of a login form somewhere on the Yahoo
site? I would like to see how to create a form that requires a user to
enter their name and password in order to gain access to the data base.
Thanks
Bill Singer
From: mailto:MS_Access_Professionals%40yahoogroups.com
[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of Crystal
Sent: Wednesday, June 27, 2012 2:19 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Calendar -- Popup Calendar posted
Hi James,
Popup Calendar that works with Access 2007 and above!
I posted a Popup Calendar form here:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
PopupCalendar_Crystal_120627_ACCDB.zip
f_PopupCalendar_Test loads automatically when this database is opened.
To use this feature in another database, import:
f_PopupCalendar.
I
usually assign this Double-Click [Event Procedure] to each date control:
DoCmd.OpenForm "f_PopupCalendar"
the popup calendar reads the ActiveControl to get date and, optionally,
time. When OK is clicked on the popup calendar, the control you came from
is updated with what was chosen.
Feedback is appreciated, thank you.
Warm Regards,
Crystal
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day :)
*
________________________________
From: Crystal
Sent: Friday, June 15, 2012 9:29 PM
Subject: Re: [MS_AccessPros] Re: Calendar
Hi James,
I have recently written a replacement for the ActiveX Calendar control that
was depreciated in 2007. I still have to pull it out of where it is and
write an interface to hook it up to resident tables ... Pat Wood is going to
help me ;) Ideally that will get done in the next couple weeks -- I'll post
it on RogersAccessLibrary.com (MVP Libraries) and here ... so check
periodically if you are still looking for ideas
If you are wanting something that is capable of colorful reporting, I have
code to output data from a query that you specify to HTML format and it lets
you set colors ... it isn't posted yet but I will try to remember to dig
that out too
Warm Regards,
Crystal
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day :)
*
________________________________
From: Duane <mailto:duanehookom%40hotmail.com <mailto:duanehookom%40hotmail.com%20%3cmailto:duanehookom%40hotmail.com> <mailto:duanehookom%40hotmail.com> >
To: mailto:MS_Access_Professionals%40yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Friday, June 15, 2012 7:49 PM
Subject: [MS_AccessPros] Re: Calendar
I have a sample annual calendar report at
http://www.access.hookom.net/Samples.htm. It's real basic but might get you
started.
Duane Hookom
MS Access MVP
--- In mailto:MS_Access_Professionals%40yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "James" <jewedel@...>
wrote:
>
> I would like to be able to draw out a year's worth of calendars and have
various dates colored in based on a table of stats, days closed, etc. This
is not a date picker calendar, just a display of the year. Are there any
links to this type of thing already done? If not where would I start?
>
> James
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar