473,320 Members | 2,180 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,320 software developers and data experts.

How to show groups of 10 records on a continuous form?

I want to show a table on a continuous form 10 records at a time. I want to be able to update a single field in the currently displayed group of records, and then scroll to the next group.

I'm not sure where to start. Can you help?

Thanks,

Gerry Goldberg
Jul 9 '10 #1
5 4280
nico5038
3,080 Expert 2GB
The "easy" way is to use a subform 10 rows in hight. By clicking in the scroll bar below the "ruler" the subform will jump 10 rows down, etc.

When you want this controlled by code it's a bit more work...

Nic;o)
Jul 9 '10 #2
I think that will work ok. Now, if I want to update the same field (with the same value) on each of the records that are showing, how do I do that with VBA?

Thanks,

Gerry Goldberg
Jul 9 '10 #3
nico5038
3,080 Expert 2GB
No VBA needed, just an UPDATE query will do the trick like:

Expand|Select|Wrap|Line Numbers
  1. UPDATE tblTest SET Columnfield1 = 1
  2.  
Nic;o)
Jul 9 '10 #4
Thanks for your quick response!

Your example shows an Update query to update the data in my continuous subform. Since I only want to update those records currently being displayed, I wondered if the query would limit itself to those records, or try to update the entire table. I need to affect only the records being displayed.

Thanks
Jul 9 '10 #5
nico5038
3,080 Expert 2GB
This will be harder and will require some VBA coding.

I've attached a sample that's holding code that shows how selected rows on a datasheet can be processed (the sample shows the fields at the bottom and can be transformed to an UPDATE query with a WHERE clause).
Looks to me more versatile to be able to select a range instead of all rows of the subform, but that decision is up to you :-)

Let me know what you think of this.

Nic;o)
Attached Files
File Type: zip Sample-Listbox-Selection2000.zip (64.6 KB, 239 views)
Jul 9 '10 #6

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

Similar topics

2
by: John Baker | last post by:
Hi: I have a sub form which i would like to show all the records selected from a table. There may well be over 100 of them. For reasons I cant fathom, the form will only show six, and then...
4
by: Bob Alston | last post by:
I have some dates which show in a continuous form, multiple rows at a time. I would like to color the background yellow, or the text yellow or some color other than black that would stand out,...
4
by: glenhong | last post by:
Hi I need some help here. I am running Access 2003. I have an Access DB linked (Front-end) to another Access DB (Back-end). I have a Form which has a third party grid on it. The grid is...
4
by: Kathy | last post by:
What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. ...
20
by: Robert | last post by:
Need some help to stop me going around in circles on this one.... Have a nested subform (subform2) which simulates a continuous form for the record on the parent subform. Subform2 has rows of...
13
by: eighthman11 | last post by:
using Access 2003 and sql server version 8.0 Hey everyone. Created a text box where the user types in an Inventory number and it takes them to that inventory number on the contimuous form. The...
7
by: ggfota | last post by:
I have problem creating Access (Continuous) Form with indepenent CheckBox for each record. The user should be able to select records that will be processed by VBA based on ChceckBox value. When I...
5
by: Kaloyan Krumov | last post by:
I have the following setup: Table containing record for transactions with products – in and out of a warehouse. Continuous form for entering transaction information. I have filtered the form to...
2
by: Ian Anderson | last post by:
Hello there, SO i have the followign VB code in my continuous form... 'Purpose: This module illustrates how to create a search form, _ where the user can enter as many or few...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
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...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.