Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Subform with .ADP ???

Subform with .ADP ???

Subform with .ADP ???

Good Morning!

I'm developing an Access Project and this is my first .ADP.  Access 2000 to SQL 7.

Question 1.:  Is it feasible to create a form-subform bound to one-to-many tables when the tables are on an SQL Server?

The first form/table/report I created took extra time versus straight Access, but is working fine.  The next form/tableS/report would be well-suited to a form-subform setup bound to one-to-many tables.  Simple enough in Access but is challenging in a Project.  It appears that I'll have to jump through numerous VBA hoops to make it work.

Question 2.:  Would it be easier/faster/better (pick two) to develop this as an .MDB with links to the SQL Server rather than developing it as an .ADP?

As always, thanks a LOT for your assistance!

RE: Subform with .ADP ???

Thanks for reading and please ignore my post.
Access has so many things to remember...

Like selecting the subform upper left corner and right-clicking to see properties.

BUT, if you want to see the LinkMasterFields and LinkChildFields properties, you need to select the BORDER of the button and right-click.


Access is a capable product, but for people like me with failing memories, maybe I'd be better off with SQL tables and writing from scratch in Visual Basic.

Bob M.E.A.N.
(Moderately Esasperated Access Novice)

RE: Subform with .ADP ???

I am glad to know that I am not the only one who feels I would be better off without involving Access!  

I have been trying to convince my boss, without success, to dump Access and use VB for a long time.  

It is good to know that I am not the only one who feels this way!

RE: Subform with .ADP ???

I just bind my subform to a seperate stoped procedure, and feed the parameters from the main form into it....

RE: Subform with .ADP ???

Access forms using the Wizards is heaps easier than VB, however the ADP environment has a big impact on access form construction because of the SQL based procedures.
I am documenting conversion issues on a separate thread.
Large application 400 forms , 200 reports , 1600 queries, all developed in Access with extensive use of wizards only about 10% code for event procedures etc.

RE: Subform with .ADP ???

Thanks for posting, Folks!

I got side-tracked and probably won't get back to my .ADP project until after the 4th...

BUT, Databaseguy, I WOULD appreciate an explanation/example of feeding the parameters to the stored procedure.  I've written 2 SP's so far (hold the applause) and that was just to increase speed.

Silvertri, I'll do a search using your handle to find the thread you mentioned and see how that's coming.

Thanks again and have a Great Holiday!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close