David McAfee
davidmcafee at gmail.com
Mon Feb 28 17:53:11 CST 2011
The ease of populating comboboxes and listboxes: Me.lstHistory.rowsource = "EXEC stpGetMachineHistory " & nz(me.txtMachineID,0) Cascading combobox (On Enter of comboBox): Me.cboModel.rowsource "EXEC stpSelectModels " & nz(me.cboMake.Column(0),0) On Mon, Feb 28, 2011 at 3:43 PM, David Emerson <newsgrps at dalyn.co.nz> wrote: > Why is that? Once the concepts were learnt (thanks to Susan and Martins > book, along with Chipman and Baron's Microsoft Access Developers Guide to > SQL Server) I found it much easier to do all the development in the Access > environment (including table, view, sproc and functions) than switching > between Access and enterprise manager. > > David > > > At 1/03/2011, Stuart McLachlan wrote: > >> .ade! Yuk! >> >> The best thing that MS ever did for Access was depreciating these :-) >> >> -- >> Stuart >> >> On 1 Mar 2011 at 12:01, David Emerson wrote: >> >> > >> > > "Are any of your developing full blown ACCESS/SQL Server >> > > applications for clients? If so what type of an app is it?" >> > >> > I have done a couple of apps like this. >> > >> > One was a full prospecting/client management/billing/reporting system >> > for a gas company. Access XP ade with SQL2000. The other is a stock >> > management and reporting system for oil companies. Access XP ade with >> > SQL2005. >> > >> > Both cases are multi user and have lots of business logic that was >> > done in SQL. Both required the better security and data integrity >> > that SQL provided over Access. >> > >> > Regards >> > >> > David Emerson >> > Dalyn Software Ltd >> > Wellington, New Zealand >> > >> > -- >> > AccessD mailing list >> > AccessD at databaseadvisors.com >> > http://databaseadvisors.com/mailman/listinfo/accessd >> > Website: http://www.databaseadvisors.com >> > >> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >