Subform with .ADP ???

[BobJacksonNCI]

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!
Bob

 

[BobJacksonNCI]

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.

ARGH!

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)

 

[neecie]

Bob,
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!

 

[Databaseguy]

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

 

[Silvertri]

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.

 

[BobJacksonNCI]

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!
Bob