Go Back   Access World Forums > Apps and Windows > VB.NET

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-07-2016, 06:27 AM   #1
SkyCraw
Newly Registered User
 
Join Date: Oct 2013
Location: Canada
Posts: 98
Thanks: 18
Thanked 2 Times in 2 Posts
SkyCraw is on a distinguished road
Question Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

Hello,

I`m currently trying to accomplish the following (forum link to save duplicate posting):

http://stackoverflow.com/questions/3...ndows-form-app

Anyone on these forums know how I would go about doing this?

Any help at all would be greatly appreciated

SkyCraw is offline   Reply With Quote
Old 07-07-2016, 08:50 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 8,958
Thanks: 295
Thanked 692 Times in 660 Posts
Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about
Send a message via Skype™ to Uncle Gizmo
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

From the image you show I think you are showing me a table with sub tables sat on top? If that's the case then you are not really showing me Access functionality, it's the tables. What I mean is, you wouldn't present your user with that. You would present your user with a form and subforms.
__________________
Tony Hine - My Aspiration --- Finding a better way of Explaining ---
From this YouTube:-

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Uncle Gizmo is online now   Reply With Quote
Old 07-07-2016, 08:59 AM   #3
SkyCraw
Newly Registered User
 
Join Date: Oct 2013
Location: Canada
Posts: 98
Thanks: 18
Thanked 2 Times in 2 Posts
SkyCraw is on a distinguished road
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

No, they are indeed forms with subforms. I've attached a sample database showing this functionality. Yes, there's a table and sub-table, but that's not how I'm allowing the end user to interact with the data.

I've also attached a snippet of a more dignified example that we're currently using in our live systems.
Attached Images
File Type: png AnotherExample.PNG (36.7 KB, 127 views)
Attached Files
File Type: accdb TestQuote.accdb (1.95 MB, 103 views)

SkyCraw is offline   Reply With Quote
Old 07-13-2016, 09:51 AM   #4
SkyCraw
Newly Registered User
 
Join Date: Oct 2013
Location: Canada
Posts: 98
Thanks: 18
Thanked 2 Times in 2 Posts
SkyCraw is on a distinguished road
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

Anyone else have any suggestions for this?
SkyCraw is offline   Reply With Quote
Old 07-14-2016, 04:05 AM   #5
stopher
AWF VIP
 
stopher's Avatar
 
Join Date: Feb 2006
Location: Southampton, UK
Posts: 2,396
Thanks: 20
Thanked 309 Times in 292 Posts
stopher is a jewel in the rough stopher is a jewel in the rough stopher is a jewel in the rough stopher is a jewel in the rough
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

The solution you provided is a datasheet form as the main form and then a continuous form as the subform. vb.net does not have sub forms as such.

If you have the budget then you could use a 3rd party tool such as flexgrid (approx $900 for the activex version) which gives you mind-blowing opportunities, not least the one you ask for:
http://our.componentone.com/2015/09/...l-data-in-mvc/

Also look here which looks like what you are after:
http://www.codeproject.com/Tips/8355...l-Datagridview

Also here for info:
http://10tec.com/articles/datagridvi...o-recipes.aspx

hth
Chris
stopher is offline   Reply With Quote
The Following User Says Thank You to stopher For This Useful Post:
SkyCraw (07-28-2016)
Old 07-28-2016, 04:36 AM   #6
SkyCraw
Newly Registered User
 
Join Date: Oct 2013
Location: Canada
Posts: 98
Thanks: 18
Thanked 2 Times in 2 Posts
SkyCraw is on a distinguished road
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

Thanks for the info Chris!

I think the second link you supplied is the best direction indeed for me to take. Now, I just need to make this editable... should be fairly straightforward right (currently searching as I post this)?
SkyCraw is offline   Reply With Quote
Old 09-21-2016, 06:24 AM   #7
SkyCraw
Newly Registered User
 
Join Date: Oct 2013
Location: Canada
Posts: 98
Thanks: 18
Thanked 2 Times in 2 Posts
SkyCraw is on a distinguished road
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

Just following up with this as it's been almost two months since my last post, noticing this forum post has gathered lots of views too.

Anyone make any headway on an editable master detail datagridview? If I can make this editable, this will propel my current VS research project forward. Otherwise, it will put a major stall in it and might not be fully achievable in a vb.net windows form app.

SkyCraw is offline   Reply With Quote
Old 11-30-2016, 07:56 AM   #8
GBalcom
Much to learn!
 
Join Date: Jun 2012
Location: Georgia
Posts: 376
Thanks: 20
Thanked 2 Times in 2 Posts
GBalcom is on a distinguished road
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

SkyCraw,
Did you resolve this? I'm starting to feel like VB.NET just isn't worth the extra effort....
GBalcom is offline   Reply With Quote
Old 12-01-2016, 03:27 AM   #9
SkyCraw
Newly Registered User
 
Join Date: Oct 2013
Location: Canada
Posts: 98
Thanks: 18
Thanked 2 Times in 2 Posts
SkyCraw is on a distinguished road
Re: Access 2007 subdatasheet form to Visual Studio 2015 VB Windows Form App

Not yet, thanks for asking though GBalcom.

Is there any other programming language/assembly/reference I can incorporate (without monetary investment) that would allow me to have this functionality?

SkyCraw is offline   Reply With Quote
Reply

Tags
access 2007 , vba access 2007 , visual studio , winforms

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Studio and Access mfaqueiroz Modules & VBA 7 05-13-2016 07:04 AM
difference in visual basic on access and visual studio iworkonline Modules & VBA 1 05-26-2010 01:49 PM
How to create a web based data enrty form in visual studio 2008 cbrace09 VB.NET 1 04-14-2010 05:02 AM
Question How to create a web based data enrty form in visual studio 2008 Alisa General 2 11-29-2009 10:38 PM
visual studio and access NigelShaw General 1 05-24-2008 02:37 PM




All times are GMT -8. The time now is 04:49 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World