opening a form with a large recordset at a specific record

Ian

I want to open a form at a particular record, but I think I'm running
into problems because the recordsource query is executing
asynchronously.

In the form's open event I use recordsetclone. findfirst to get a
bookmark and then set the form's bookmark to this value. normally that
works fine, but the form I am using has a very large number of records
and isn't being set to the correct record, even though it is found
successfully in the recordsetclone.

I think this is because the form doesn't yet have all the records and
so can't find a record with the correct bookmark (though how come the
recordsetclone appears to be complete??).

If I use recordsetclone. movelast before setting the form's bookmark
then the form gets set to the correct record. I have to confess I'm
starting to get confused between recordsets , recordsetclones and the
information the form has - I thought they were all (more or less) the
same thing, but this doesn't seem to be the case.

Am I right in thinking that I have to force the form's underlying
query to finish by using recordsetclone. movelast, before trying to set
the form to a specific record?

Thanks
ian

Nov 13 '05 #1

Subscribe Reply

3282

Allen Browne

Ian, are you aware of the bookmark bug? See:
http://members.iinet.net.au/~allenbrowne/bug-04.html

What version of Access?
If A97, make certain you have SR-2 applied. Are there any dlls that are
duplicated on your system where they could be called (e.g. in Windows,
Windows\System3 2, Program Files\Microsoft Office\Office.. ., or any other
folder on path)? This scenario was sometimes seen with Access 97, and is a
known cause of the bookmark bug not being patched successfully.

If A2000 or later, see:
http://support.microsoft.com/?id=238134
Again the service packs are crucial. You need to download the latest service
pack for your version of Office, and also the latest service pack for JET 4.
Both are available from the Downloads section at:
http://support.microsoft.com

If the problem still persists, we are *very* interested in taking it
further. Please provide version information for:
- msaccess.exe
- msjet40.dll (msjet35.dll if Access 97)
- dao360.dll (dao350.dll if Access 97)
- Windows
and also the number of records in this table.

One of our clients experienced the problem under a fully and correctly
patched A97, where the form had hundreds of thousands of records loaded. He
was in a different country and the data was too sensitive to send, but we
were able to demonstrate that the problem was real by logging it. We were
unable to solve it for him, but worked around the issue by changing the
RecordSource so the form only loaded only one record at a time.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ian" <ia******@yahoo .co.uk> wrote in message
news:2d******** *************** ***@posting.goo gle.com...

I want to open a form at a particular record, but I think I'm running
into problems because the recordsource query is executing
asynchronously.

In the form's open event I use recordsetclone. findfirst to get a
bookmark and then set the form's bookmark to this value. normally that
works fine, but the form I am using has a very large number of records
and isn't being set to the correct record, even though it is found
successfully in the recordsetclone.

I think this is because the form doesn't yet have all the records and
so can't find a record with the correct bookmark (though how come the
recordsetclone appears to be complete??).

If I use recordsetclone. movelast before setting the form's bookmark
then the form gets set to the correct record. I have to confess I'm
starting to get confused between recordsets , recordsetclones and the
information the form has - I thought they were all (more or less) the
same thing, but this doesn't seem to be the case.

Am I right in thinking that I have to force the form's underlying
query to finish by using recordsetclone. movelast, before trying to set
the form to a specific record?

Thanks
ian

Nov 13 '05 #2

Similar topics

2890

Form Slow, Then Fast

by: Neil | last post by:

I have a very puzzling situation with a database. It's an Access 2000 mdb with a SQL 7 back end, with forms bound using ODBC linked tables. At our remote location (accessed via a T1 line) the time it took to go to a record was very slow. The go to mechanism was a box that the user typed the index value into a combo box, with very simple code attached: with me.RecordsetClone .FindFirst " = " & me.cboGoTo If Not .NoMatch Then Me.Bookmark...

Microsoft SQL Server

4762

PLease Help: Pulling up a particular record using a form

by: Skully Matjas | last post by:

I am using the following code (created by the wizard) to allow to bring my form to a particular entery. But when I edit the entery (ex: put new information into a blank cell), it puts that record onto the bottom of the list (even though it keeps its record number). Also, There are certin names that i click on the list, and it will not bring it up, rather it brings to the first record (no matter how many times i try going to that...

Microsoft Access / VBA

1289

opening specific records in forms ?

by: BLUE WATER | last post by:

Help, When I am finished entering in data into my form A, I press the save button that saves this new data to a new record. However I would like my other form to open at a specific record, the record that I just finished working on. Ideas?

Microsoft Access / VBA

10142

How to handle Primary Key violations in a bound form without causing and ODBC error.

by: Abhi | last post by:

FYI: This message is for the benefit of MS Access Community. I found that this prblem has been encounterd by many but there is hardly any place where a complete solution is posted. So I thought I should give back to the community by posting our findings. Thanks you all for all your help till now by posting problems and their solutions. ~Abhijit

Microsoft Access / VBA

12103

How to synchronize current record in the form with value selected in a combobox ?

by: Zlatko Matiæ | last post by:

There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the combobox. What is the solution? Thank you in advance.

Microsoft Access / VBA

2425

Request.Form error - idHidxml="<recordset><record>

by: Tom | last post by:

Hi I have an aspx page which has javascript to configure xmldata. I added breakpoint to the button method. When I click submit button, it did not go to those breakpoint and show the following error System.Web.HttpRequestValidationException (0x80004005) Detect the potential danger of Request.Form value from client side (idHidxml="<recordset><record><...") System.Web.HttpRequest.ValidateString(String s, String valueName, String...

C# / C Sharp

6528

do i NEED to use .movefirst immediately upon opening a recordset?

by: MLH | last post by:

Here's a blurb cut from A97 HELP on BOF/EOF: When you open a Recordset object that contains at least one record, the first record is the current record and the BOF and EOF properties are False; they remain False until you move beyond the beginning or end of the Recordset object by using the MovePrevious or MoveNext method, respectively. From that HELP blurb, it would seem that the .MoveFirst in the lines below is simply not needed....

Microsoft Access / VBA

11716

(ADP) form problem: "This Recordset is not updatable"

by: radio1 | last post by:

Configuration: Access 2002 and SQL Server 2000 using a .ADP Project. I would VERY MUCH appreciate anyone's input into this problem I'm having. I have a form in Access that does not permit the user to add/change/delete any data, apparently as a result of adding a GROUP BY clause to a View used indirectly as the form's Record Source. I really don't believe that this restriction needs to be there, and I'm hoping that someone can suggest...

Microsoft Access / VBA

1998

Move to spec'd record in form. Better to filter or use record navigation?

by: MLH | last post by:

I've pretty much always applied a filter to a form to go to a specific record - filtering out all but the desired record. Am looking for code used to move to a specific record when keyfield value is known. This would leave my form in a state that PGUP and PGDN would still navigate up 'n down the dynaset. Seeking simplest methods.

Microsoft Access / VBA

8999

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9575

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9256

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8260

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6803

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6080

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4712

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2798

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2223

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General