Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Microsoft Access 2010 24-Hour Trainer
This is the forum to discuss the Wrox book Microsoft Access 2010 24-Hour Trainer by Geoffrey L. Griffith, Truitt L. Bradly; ISBN: 978-0-470-59167-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft Access 2010 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 3rd, 2013, 01:08 AM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Is this still active?

Just checkin'.
Reply With Quote
  #2 (permalink)  
Old February 4th, 2013, 06:04 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Yes...

I'm still monitoring...is there a specific question I can help with?

Thanks,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
Reply With Quote
  #3 (permalink)  
Old March 2nd, 2013, 01:44 AM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Wink New ACCESS 2010 DB from scratch

Hey Geoffrey,
I'm creating a new DB using existing excel spreadsheets that are pretty long (records wise- some approaching 1,000 records).

The basic design is what I'm struggling with. Basically, I have a spreadsheet that have autocad files, revision dates, drawing number, notes, last user edit. Bear in mind, some of these excel files go back to 1997 and (possibly) haven't been opened since them. But, a lot of them are newer and are used quite frequently. There is also another spreadsheet that has the drawing number, person requesting changes to drawing, status.

What I'd like to do is use excel as a front end UI for the DB and have them press a button to update the DB when they've edited it.

This DB would be basically for me and another user (my backup) and possibly a handful of engineer types.

I'm basically looking for a template of some type for this unorthodox situation. I have a some ACCESS experience, mainly as a user, but I've also created some pretty simple (but useful) DB's. This size of this project is what is daunting.

Any help would be great.
Reply With Quote
  #4 (permalink)  
Old March 2nd, 2013, 02:23 AM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Thanks for the message

Hello gisdude,

Thanks for the message back here. Hmm, I'm not really sure what to say about this. I don't know of any Access template that would store the EXACT data that you are looking for, but I might suggest the following:

1. The Access "Assets" template (possibly). You would probably need to modify it to store the exact data fields you want, but it sounds like a good place to start.

2. Given what you've said here, it sounds a lot like a "SharePoint Document Library" to me. I'm not sure if you have usage of a SharePoint server, but there are lot of options available out there and the "Document Library" might really be the thing you want to use here. But you would probably need to modify that "Document Library" from the base template (slightly) as well.

Anyway, I hope this all makes sense and at least puts you on the right track! Also, I should say that this forum is really about the Wrox "Access 2010 24-Hour Trainer" book and related questions, and really isn't monitored by a lot of people (as you can see by the number of posts, or lack there of). You might have better luck asking questions like this in main Access thread at: http://p2p.wrox.com/access-18/. Otherwise, if you have specific questions, need consulting or custom development work, please feel free to contact me via my website below, we offer low-cost services!

Regards,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->

Last edited by gjgriffith; March 2nd, 2013 at 02:35 AM..
Reply With Quote
  #5 (permalink)  
Old March 2nd, 2013, 04:46 PM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default thanks button?

Where is it?

I appreciate the reply. I'll do a little more homework on my end, sharepoint may be an option, but not sure. I think I can tweak the "ASSETS" template to what I need, but my confidence level...
Reply With Quote
  #6 (permalink)  
Old March 3rd, 2013, 07:47 AM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default On the bottom right of the post box

Hello gisdude,

Thanks again for the follow up message. GREAT - that sounds good, I'm sure you'll be able to get the Assets template to do what you need it too. Also, the "Thanks" link can be found all the way on the bottom right of any post box that isn't a post you wrote. I hope that makes sense and if there is anything else I can do to help, please just let me know!

Thanks again,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
Reply With Quote
The Following User Says Thank You to gjgriffith For This Useful Post:
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is Active Starters! Magxtopher Javascript How-To 0 November 7th, 2008 10:30 AM
Help to get a Toolbar active Lars Ronnevig Beginning VB 6 0 March 5th, 2007 04:00 AM
Active Directory TCSE305 Windows Server 1 November 22nd, 2006 01:26 AM
Active X razi BOOK: Beginning Visual C++ 6 0 July 22nd, 2005 01:37 AM



All times are GMT -4. The time now is 10:47 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.