At present I'm running the company timesheets in Excel, but I'd like to store the information in Access. I'd prefer to keep the Excel front-end but willing to compromise. The timesheets are filled in throughout the day, so I'm looking at a change event to write the data to Access. Is this reasonably feasable?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Hey, Malcolm.
A similar question was asked here. I gave some links there to some targeted articles on this subject on my site.
HTH,
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Looks like I've got some reading/work to do!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Malcolm, I recently created an Access database for timekeeping input for Aussiebear but he decided to stay with Excel.
Would you like a copy to "play" with?
That would be great!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Malcolm, this database has a section on "job functions" that you probably don't need so you can just delete it, but it has got some interesting VB calcultions and queries that you can look at first.
If you do go down the Access route and need any help from me just pm me.
I also have another simpler timekeeping database which I will try and find and post as well.
Malcolm, these 2 are simple versions of time logging that I have helped others with over the years, they might provide you with some additional ideas.
Sorry, I can only upload 1 at a time.
Malcolm, did the databases that I posted provide you with any "inspiration" or ideas?
Or help you make up your mind?
Hi OBP.
I'll be having a look at them at the weekend.
Thanks
Malcolm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Excel can work reasonably well as a time sheet database within itself. As we all know, Excel is really a front end development tool, not just a spreadsheet. If it were me, I would use Excel exclusively for this project, but export certain rows of data for storage into tab delimited text files. If done right, the text files could work as make-shift "Database" without needing the back end of access.
Also, while not an option to many, a set up like this would be quite simple in VB6 or VB.net using Access as the container for the data....
Good luck with it MD.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
I'm working on something very similar and need to keep track of time via a tech project. Ultimately - I'd like to have these times transferred over to a database that will store the time sheet & travel data. Thanks for posting this.
Have a great day!
Hi GG
Welcome to VBAX,
If you have any questions, just ask.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
The Jet 4.0 Provider w/TEXT Driver can treat them just like recordsets with find, sort filter and copyfromrecordset() if you needed data back into Excel. Was that sort of what you meant? StanIf done right, the text files could work as make-shift "Database" without needing the back end of access.
Posting Permissions
Reply With Quote
