Time form - ala calendar form

Posted on 2013-09-09
Medium Priority
Last Modified: 2013-09-09
Hey guys, you know how Allen Browne has a calendar form - is there a good time form y'all will recommend? Maybe something visual. Thanks guys!!
Question by:developingprogrammer
  • 4
  • 2
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39476897
"time form"?

Can you provide a bit more information of your request here?
LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 total points
ID: 39477008
You can certainly load a combo box with one minute increments from a table, ...then add that to your date value...

see this basic sample

Author Comment

ID: 39477367
ha cool boag2000! that's what i did as well!! just that i did it in 5 min increments haha. i considered using the FMS Components but after reading the help file that it requires installation on the users' computers, i chucked it out. hrmm for now at least ha. but hey you know i came across this other SUPER cool method to allow users to select excel cells from Access itself. that required installation of ocx as well. maybe because of that i will push through the admin rights issue and get these things installed. then FMS components can come along. but probably not for FMS components. too little benefits i feel ATM = ) i thought i could use them without installation!!!! BOO HOO!!!! haha = ))
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39477546
<i came across this other SUPER cool method to allow users to select excel cells from Access itself>
Sound like over kill

So where do we stand on this?

Author Comment

ID: 39477631
1) i think i will use the method you shared with me cause that is the way to do it without any installations.

2) it's definitely not an overkill!! = )) because if we need to import different worksheets each with different multiple row headers with and without merged cells, and we need to define the data table in the worksheet cause the other stuff are just dirty data, then this is goooollden = )) right now i'm using a BringWindowToTop function to show users the excel sheet so they can enter the right cell numbers in a custom input form so the import can start = ))

here you go boag2000, here's how it looks!! = ))

super cool huh? haha = ))
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39478504

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question