Losing First Record After Scrolling - Microsoft Access / VBA

Wayne

Is there a workaround to the bug that loses the first record in a
continuous form after using the scroll wheel if the available records
don't fill the form? I know that the "up arrow" section of the
scrollbar can be clicked to show the record again but this is hardly
intuitive to the user.

Any help is appreciated.

Jun 22 '07 #1

Subscribe Reply

2339

Tom van Stiphout

On Fri, 22 Jun 2007 03:37:06 -0700, Wayne <cq*******@volc anomail.com>
wrote:

Do I understand correctly: you have a form with a lot of records, more
than fit given the size of your form. You object to the top records
not being visible at all times as users are scrolling down to see more
records.

If I understand this correctly, you have some options, including:
* Keep the number of records low enough so users don't have to scroll.
* Buy bigger monitors so you can increase the size of the form and
show more data.
* Train the users about the scrollbar and scrolling UP as well as
Down.

-Tom.

>Is there a workaround to the bug that loses the first record in a
continuous form after using the scroll wheel if the available records
don't fill the form? I know that the "up arrow" section of the
scrollbar can be clicked to show the record again but this is hardly
intuitive to the user.

Any help is appreciated.

Jun 22 '07 #2

Wayne

Thanks for the reply Tom. I probably didn't do a very good job of
describing the problem. It is a bug that has been referred to on this
forum that I haven't been able to find a suitable solution to. The
bug appears on continuous forms or subforms when the available number
or records does not fill the space available on the form.

Suppose the form or subform has room to display say, 10 records but
the available data doesn't fill the whole form, say there are only 5
records available. If the user accidentally scrolls down (I emphasize
accidentally, because there would be no reason to intentionally do
this with only 5 records) and then scrolls back up, the first record
is not visible.

The only way to make the first record visible is to use the "up" arrow
on the scroll bar to bring it back into view i.e the scrollwheel
doesn't scroll right back to the top and leaves the first record
hidden. If the user knows about the bug, then there isn't really a
problem. If they are not aware of it, they wonder where their first
record has gone.

Jun 22 '07 #3

Similar topics

3228

SQL Losing Data

by: Neil Ginsberg | last post by:

We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC linked tables. I recently created a new set of tables for the app, and users are complaining that unsaved data is being lost when they move to a new record. This seems to be the case when there are multiple users. When there is a single user using it, we don't seem to have that problem. It seems that we had this problem when we first converted from an MDB back end...

Microsoft SQL Server

3433

Mouse Wheel Loose First Record

by: jv | last post by:

I have quite a few of continuous form and subform where I do allow scroll bars. I run into problems with the mouse wheel whenever the data on the form does not take up the whole page. In this instance, whenever a user uses the mouse wheel to scroll down, the first record disappears off the screen and they can't get it back unless they click on the Refresh button or Page Up. The mouse wheel never scroll back up to the first record. ...

Microsoft Access / VBA

5259

Displaying first record of subform in parent form.

by: tdmailbox | last post by:

I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test box that is populated with the code =subfrm_media_review_sec_party.Form!first_name & " " & subfrm_media_review_sec_party.Form!last_name It works except that when I flip through the names it populates the parent form with the name of what ever...

Microsoft Access / VBA

3056

Cross-joins and non-updateable record sets

by: Stephen Poley | last post by:

I have the following situation: - a table of employees, keyed on employee-id; - a table of training sessions, keyed on session-id; - a requirement to log who was present at which session, plus optional extra textual information (e.g. "left early due to illness"). The solution I had in mind was: 1) create a presence table, keyed on employee-id and session-id, containing a 'present' yes/no field and a comment text field; 2) cross-join...

Microsoft Access / VBA

1455

creating a csv file and losing a letter

by: Tog | last post by:

Hello all. here is a little conundrum for you to get your teeth into. I am creating a csv file from an access database. The code I use is below and it works well .. except for one small annoying feature. When it creates the csv file the first letter of the name of the first field is missing. The database field name is Start of Record - and in the csv file it becomes Tart of Record. I can overcome this by renaming the database field SStart...

ASP / Active Server Pages

9423

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9994

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9863

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

7408

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

6673

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

5298

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

5447

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3958

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2815

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