473,410 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,410 software developers and data experts.

The command or action 'Show all records' isn't available now Error

22
Hi,

I am getting this error "The command or action 'Show all records' isn't available now", i get this when i try to do

DoCmd.ShowAllRecords
DoCmd.GoToControl ("ID")
DoCmd.FindRecord Me!Text116

I am trying to do search on ID..but i get this error and i dont know how to proceed..

P.S My form displays all records(say 6000), it has a search functionality where a search on particular ID should be done, i am trying to do this and dont know whats happening even though this seems to be easy

Please help!
Thanks!
Edit/Delete Message
Apr 17 '07 #1
2 4204
ADezii
8,834 Expert 8TB
Hi,

I am getting this error "The command or action 'Show all records' isn't available now", i get this when i try to do

DoCmd.ShowAllRecords
DoCmd.GoToControl ("ID")
DoCmd.FindRecord Me!Text116

I am trying to do search on ID..but i get this error and i dont know how to proceed..

P.S My form displays all records(say 6000), it has a search functionality where a search on particular ID should be done, i am trying to do this and dont know whats happening even though this seems to be easy

Please help!
Thanks!
Edit/Delete Message
  1. Lose the Parenthesis
  2. I'll assume yiou are looking for the [ID] contained in Field [Text116]
Expand|Select|Wrap|Line Numbers
  1. DoCmd.ShowAllRecords
  2. DoCmd.GoToControl "[ID]"
  3. DoCmd.FindRecord Me![Text116]
Apr 17 '07 #2
pks00
280 Expert 100+
Is this a bounded form I assume.

have u got filters setup and is that the reason why u want t do ShowAllRecords?

try this alternative way


Me.FilterOn = False


Rest of your code seems fine
Apr 18 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: DC Fan | last post by:
Hi all... Been a while since had a question here, but I can not find a single thing about this in the group or even on the whole web! My Access XP application is running some stored queries and...
2
by: Paul Malcomson | last post by:
Hi. I'm having terrible trouble with a form that displays several parent/child relationships at one time. It is a sales force hierarchy - Sales force, district, territory, sales rep are the...
13
by: Lee | last post by:
Hello All, First of all I would like to say thank you for all of the help I have received here. I have been teaching myself Access for about 4 years now and I've always been able to find a...
0
by: Susan Bricker | last post by:
What possible situations (or set of variables) could cause the following error: "The command or action 'DeleteRecord' isn't available now." Error Number = 2046. The routine that gets the...
3
by: ILCSP | last post by:
Hello, I'm fairly new to the concept of running action pass through queries (insert, update, etc.) from Access 2000. I have a SQL Server 2000 database and I'm using a Access 2K database as my...
10
by: jimmy | last post by:
Hi again, sorry for posting two questions so close together but im working on a school project which is due in soon and running into some difficulties implementing the database parts. I have the...
12
by: ilucks | last post by:
I converted Acc97 to Acc2003 and got this error "The command or action 'SaveRecord' isn't available now" when i tried to open one form"Add Info form", which has Save button. I checked "reference"...
5
by: Ken OHanlon | last post by:
I wrote a short program that uses "SendObject". It works fine on my computer, it works fine on my clients computer, but when I copy/paste it up to the server to use it there also, Access issues the...
16
by: busterbaxter | last post by:
Hi All, I got a multiple delete working here but for some reason I occassionally get this error. The way the delete works is there is a text box where the user enters the quantity to delete. If...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.