Prevent tabbing across multiple records

Samuel Hon

Hi

I'm trying to prevent users from moving between different records in
forms in Access 2000.

I've turned off the record selectors and disabled the mouse wheel.

I've now found that you can reach other records by tabbing through all
the controls on the forms.

Any ideas on how to stop this?

Cheers

SAm

Nov 12 '05 #1

Subscribe Post Reply

2280

Mal Reeve

Check the property sheet for the form..
There is a tab behaviour Cycle property to select between just the current
record and going to a new record.

Mal.

"Samuel Hon" <no*****@samuelhon.co.uk> wrote in message
news:c8*************************@posting.google.co m...

Hi

I'm trying to prevent users from moving between different records in
forms in Access 2000.

I've turned off the record selectors and disabled the mouse wheel.

I've now found that you can reach other records by tabbing through all
the controls on the forms.

Any ideas on how to stop this?

Cheers

SAm

Nov 12 '05 #2

Samuel Hon

Excellent! Cheers Mal

"Mal Reeve" <lo*****@earthlink.net> wrote in message news:<xW*****************@newsread2.news.atl.earth link.net>...

Check the property sheet for the form..
There is a tab behaviour Cycle property to select between just the current
record and going to a new record.

Mal.

"Samuel Hon" <no*****@samuelhon.co.uk> wrote in message
news:c8*************************@posting.google.co m...
Hi

I'm trying to prevent users from moving between different records in
forms in Access 2000.

I've turned off the record selectors and disabled the mouse wheel.

I've now found that you can reach other records by tabbing through all
the controls on the forms.

Any ideas on how to stop this?

Cheers

SAm

Nov 12 '05 #3

Similar topics

insert multiple records

by: shank | last post by:

I have a recordset that contains multiple records of product a user is purchasing. For clarity, I converted the recordset fields to variables. I need to take that entire recordset and insert it...

ASP / Active Server Pages

Prevent tabbing across multiple records

by: Samuel Hon | last post by:

Hi I'm trying to prevent users from moving between different records in forms in Access 2000. I've turned off the record selectors and disabled the mouse wheel. I've now found that you can...

Microsoft Access / VBA

A97 does not prevent entry of new records from a form bound to a table

by: MLH | last post by:

I have a form frmEditAdminData. Its AllowAdditions property is set to No. I thought this meant the form could not be opened in a manner that allowed the appending of new records to its source...

Microsoft Access / VBA

Adding rows to DataGrid across multiple PostBacks

by: Andrew | last post by:

Hey all, I am very new to ASP.Net (and .Net in general), but that isn't stopping the boss from wanting to begin new projects in it. This latest project has me kinda stumped and after a couple...

ASP.NET

Combine multiple records into one

by: musicloverlch | last post by:

I have a table with multiple records in it. I am being forced to combine multiple records into one record in order to be uploaded to a website, and I only get one record per client. How can I...

Microsoft Access / VBA

Pixel positioning across multiple printed pages

by: Bart Van der Donck | last post by:

Hello, I'm having a hard time trying to configure printed output that consists of multiple pages. The idea is the following: <div style=" border: 1px solid blue; position: absolute; top:...

HTML / CSS

Copy/paste multiple fields into multiple records; in a form

by: 4Him | last post by:

First off, let me say this is a great site! I've just started working with Access and much of my success is from what I've read here! Background: I have a form, driven off a single table. Goal:...

Microsoft Access / VBA

Radio Button/Design Question - Setting a Preferred Condition Across Multiple Records

by: Rathman | last post by:

Hi, I'm trying to create a general form with multiple subforms. The subforms contain discrete pieces of information such as Customer, Work Order, etc, while the main form is simply a front-end...

Microsoft Access / VBA

Validating Multiple Records in Same Table

by: adversus | last post by:

Good evening all, I have a problem that I've been banging my head against for a few hours and was looking for some advice. Consider a table with the following data: SSN (int) first_name (char)...

Microsoft SQL Server

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

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...

Computer Hardware