Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-28-2018, 03:06 AM   #31
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Re: Requery Method

Hi Colin,
I do like to understand what I am doing rather than just sticking code in so hence my curiosity. A bit of confusion set in here as I think what I was seeing occurred when there was no If clause. It went to the last record as you state with no scroll bar but then attempted to move back, created the scroll bar, moved the record to the top and then failed due to lack of records.

Time to accept the quirk, many thanks for all your help.

Tieval is offline   Reply With Quote
Old 11-28-2018, 03:46 AM   #32
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,345
Thanks: 115
Thanked 3,107 Times in 2,825 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Requery Method

You're welcome but I'm not sure this is a quirk. Seems perfectly sensible to me.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs 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
Error "Method or data member not found" on requery peter2012 Forms 2 09-25-2014 12:18 AM
Method - TRANSFERSPREADSHEET is a hidden method Bilbo_Baggins_Esq Modules & VBA 2 08-14-2013 11:21 AM
Cause of 'object can't support this method' error using find method? Margarita Modules & VBA 2 04-11-2012 04:51 AM
where to put call to combo boxes requery method garethl Forms 3 06-25-2007 05:30 AM
Method not found - requery Minkey Forms 2 08-10-2004 11:31 AM




All times are GMT -8. The time now is 12:22 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