Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-02-2019, 04:24 AM   #31
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,814
Thanks: 56
Thanked 1,028 Times in 994 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: The pitfalls of VBA proficiency

what I really meant was, that if you can mange the data with a query, it's generally much more efficient than iterating a recordset. Sometimes you have to do the latter though.

Obviously you have to use code to manage your interface, and for a lot of data validation.

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 12-02-2019, 06:52 AM   #32
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,675
Thanks: 93
Thanked 1,701 Times in 1,574 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: The pitfalls of VBA proficiency

Quote:
! was told, in general, the answer is a query.
This is off-topic, but my wife has this 'fridge magnet...

"If the answer is chocolate, who cares what the question was?"

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pitfalls of Family Research The_Doc_Man The Watercooler 22 07-06-2018 03:10 PM
Maintaining proficiency - expiry of count spikepl Queries 4 05-26-2014 01:30 PM
Data model to specify and track proficiency/currency spikepl General 2 04-13-2014 07:29 AM




All times are GMT -8. The time now is 12:18 PM.


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

Featured Forum post


Sponsored Links


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