473,289 Members | 1,929 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,289 software developers and data experts.

Continious Form Display

Access 2003

I have a Continuous Form. On Open I force it to go to the Last
Record.

When the form opens only the last record is shown at the top. To view
any of the previous records you must scroll. This give the appearance
at first glance that no other records exist.

Is there a simple method to populate the form with records and leaving
the cursor at the bottom allowing data to be shown above.

Thanks in advance.
Nov 26 '07 #1
3 2772
"Clint Stowers" <Ab***********@gmail.comwrote in message
news:14**********************************@v4g2000h sf.googlegroups.com...
Access 2003

I have a Continuous Form. On Open I force it to go to the Last
Record.

When the form opens only the last record is shown at the top. To view
any of the previous records you must scroll. This give the appearance
at first glance that no other records exist.

Is there a simple method to populate the form with records and leaving
the cursor at the bottom allowing data to be shown above.

Thanks in advance.
Right after your code that moves to the last record, try moving up 5
records:

DoCmd.MovePrevious
DoCmd.MovePrevious
DoCmd.MovePrevious
DoCmd.MovePrevious
DoCmd.MovePrevious

Fred Zuckerman
Nov 26 '07 #2
On Nov 26, 10:07 am, Clint Stowers <AbacusSupp...@gmail.comwrote:
Access 2003

I have a Continuous Form. On Open I force it to go to the Last
Record.

When the form opens only the last record is shown at the top. To view
any of the previous records you must scroll. This give the appearance
at first glance that no other records exist.

Is there a simple method to populate the form with records and leaving
the cursor at the bottom allowing data to be shown above.

Thanks in advance.
This works in Access 2002 with the Product List Form in the Northwind
Database.

Private Sub Form_Load()
' requires a reference to ADODB
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
Dim z As Long
With r
.ActiveConnection = CurrentProject.Connection
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
.Open "SELECT * FROM Products"
.MoveLast
On Error Resume Next
For z = 0 To (Me.InsideHeight \ Me.Detail.Height) - 2
.MovePrevious
Next z
On Error GoTo 0
End With
Set Me.Recordset = r
DoCmd.RunCommand acCmdRecordsGoToLast
End Sub

This is not tested code, nor is it recommended for non-coders. But
it's fun.
Nov 26 '07 #3
You can achieve complete control via the Form's SelTop property. See:
http://www.lebans.com/setgetsb.htm
SetGetSB.zip is a database containing functions to allow a user to Set or
Get the current position of a ScrollBar Thumb for a Form.

NEW - Apr. 02/2000 The current ScrollBar position is equal to the current
Record Number being displayed at the Top of the Form.

Works in Form or Datasheet view.

Ver 1.7

Fix bug in SelTop method. Now works with first page of rows properly and
sets the Top row correctly when moving forward in the recordset one row at a
time.

Ver 1.6

Use SelTop to save Restore current row's position after a Requery.

Ver 1.5

Added support for Horizontal ScrollBars.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Clint Stowers" <Ab***********@gmail.comwrote in message
news:14**********************************@v4g2000h sf.googlegroups.com...
Access 2003

I have a Continuous Form. On Open I force it to go to the Last
Record.

When the form opens only the last record is shown at the top. To view
any of the previous records you must scroll. This give the appearance
at first glance that no other records exist.

Is there a simple method to populate the form with records and leaving
the cursor at the bottom allowing data to be shown above.

Thanks in advance.

Nov 26 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Dan R Brown | last post by:
I have a large form that is generated dynamically in a jsp using xml / xslt. So, to break up this form into several "tabbed" sections, I break up the form using <div> tags. Each <div...
2
by: Sean | last post by:
Dear All, I have a table with many fields the relevant ones being ,,,. The table contains (at present) 16 records. I would like to create a form which displays these fields (preferbally in...
3
by: BakelNB | last post by:
I am new to the .Net environment, so please bear with me. I am passing a form object (e.g. formA) to an existing form (e.g. formB) by setting a property value defined in formB to hold the formA...
1
by: John Phelan-Cummings | last post by:
When I add the name of a new individual in a, bound form, it will not display that person’s name in a label control of a second unbound form. I have a scheduling program that I am working on. ...
3
by: giladp1 | last post by:
Hi, I noticed that by adding background pictures to my forms the application looks so much more interesting and professional. I want to keep just texture simple backgrounds in order to prevent...
2
by: Filips Benoit | last post by:
Dear All, Access 2003 adp on SQL_server 2005 A continious form showing 1 month based on table 'CALENDAR_MONTH_GRID' and fill with a SP. Fields: Companyname, Day1, day2, etc. The value in the...
0
bmallett
by: bmallett | last post by:
First off, i would like to thank everyone for any and all help with this. That being said, I am having a problem retrieving/posting my dynamic form data. I have a form that has multiple options...
1
by: chromis | last post by:
Hi, I'm having trouble fully implementing the edit section of a contact admin system, so far I have written the following: - Bean (Contact.cfc) - Data Access object (ContactDAO.cfc) - Gateway...
3
by: bibek24 | last post by:
I have a continious subform which is only visible when the main form gets open. The subform has a text box which is locked for the user.In order to enter something into it, a user has to click a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.