Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old December 4th, 2012, 11:46 PM
raca4u raca4u is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2012
Posts: 2 raca4u User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 25 m 46 sec
Reputation Power: 0
Using VBA, MS Access and Excel

Dear All,


I want to prepare a system which consists of no. of inputs excel files like cusomter orders and other files.

These should be loaded into access with click of a button on excel file.

And with another button they should be displayed in other sheet.

I wanted to prepare a complete business spreadsheet from getting customer orders, inventory management, planning and scheduling, delivery for a small manufacturing firm.

How can i go about with this? is it advisable to use VBA, MS access and Excel ? I have chose excel rather than VB application since i'm not much aware of VB coding and they already have many excels, which will make my job easy.

Thanks in advance.

Reply With Quote
  #2  
Old December 6th, 2012, 04:02 PM
June7's Avatar
June7 June7 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2010
Location: The Great Land
Posts: 256 June7 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 Days 9 h 29 m 29 sec
Reputation Power: 5
I wouldn't use Excel for a sophisticated relational database application. Regardless, will need to use code with either approach. If use Access alone then code can be macros, otherwise VBA. Macros in Excel are really VBA code. Macros in Access are very different.
__________________
I like to know if my suggestion helped you. One way to let me know is by clicking scales at top right corner of post.
Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

Reply With Quote
  #3  
Old December 6th, 2012, 04:51 PM
raca4u raca4u is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2012
Posts: 2 raca4u User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 25 m 46 sec
Reputation Power: 0
Smile

Thanks alot for the reply.

What i understand is i can use a vba in excel to read input excels and then load it to Access. Then generate different reports depending upon queries triggered by clicking some buttons on the spreadsheet. Let me know if my understanding is incorrect.


what are the drawbacks and plus points of this approach?

Reply With Quote
  #4  
Old December 7th, 2012, 04:55 PM
June7's Avatar
June7 June7 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2010
Location: The Great Land
Posts: 256 June7 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 Days 9 h 29 m 29 sec
Reputation Power: 5
It is possible for Excel to push data to Access tables. Also, Access can pull data from Excel. The latter is easier.

You want to run Access reports? Never tried to run Access report by code in Excel. I don't think can be done unless the Access file is open.

Reply With Quote
  #5  
Old January 4th, 2013, 03:09 PM
65bit 65bit is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2012
Posts: 5 65bit User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 36 m 42 sec
Reputation Power: 0
Quote:
Originally Posted by June7
I don't think can be done unless the Access file is open.


I sure have never been able to write to access through excel vba. Not for lack of trying.

Reply With Quote
  #6  
Old January 5th, 2013, 03:33 AM
giliakareo giliakareo is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Posts: 9 giliakareo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 45 sec
Reputation Power: 0
Let me know if my understanding is incorrect.

Reply With Quote
  #7  
Old January 5th, 2013, 07:46 AM
Suzan1ne Suzan1ne is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Posts: 4 Suzan1ne User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 53 sec
Reputation Power: 0
These should be loaded into access with click of a button on excel file.URLURLURL
URLURL

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Using VBA, MS Access and Excel


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap