Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 24th, 2004, 06:10 PM
Authorized User
 
Join Date: Aug 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default I want to display record number in data entry form

I've made an input form with a Data Entry setting of Yes and a Default View of continuous forms. I want the sequential number of each record to show in the form. That is, record 1 has a 1 in it, record 2 has a 2 in it.

Thank you for your help.

Mark J. Weisberger
__________________
Mark J. Weisberger
 
Old August 25th, 2004, 01:08 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

Use Total Count in the Begining and When you display a record get RowID and show as RowID/TotCount (1/10 or 1 of 10).

I hope you are taking abt the Master Record --> Transaction Records. Same way you using the count can do.




 
Old August 25th, 2004, 09:02 AM
Authorized User
 
Join Date: Aug 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm not sure what you mean, but I got the solution using CurrentRecord. I added a field to the underlying table called RecordCounter. Then I put this field in the input form as a bound text box. In the After Update event procedure of the first field of the form I put Me.RecordCounter = Me.CurrentRecord. This gives sequential numbering of the input records in the input form.

Mark J. Weisberger
 
Old August 10th, 2013, 09:06 AM
Registered User
 
Join Date: Aug 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Its something you need to do with Database.

Hello,

For automatic sequencing of the data. There are two methods you can go with. Please have a look:

1. In the database, you can make the first column auto increment, so with every entry it will automatically take the sequencing and will also make the data look good.

2. If you need it in the application, then you have to make a function to check the number of rows that you have entered and according to it you have to display the number.

I am a programmer, so if you need code then let me know. You may also check this article for some good stuff.

Regards
----------

Last edited by Gale2E4Shaw; August 12th, 2013 at 02:19 AM..
 
Old May 23rd, 2014, 04:25 AM
Registered User
 
Join Date: May 2014
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Database Security and why you need to review yours ... not something you can shun and pretend it's a monster under the bed
 
Old August 28th, 2014, 12:08 PM
blake
Guest
 
Posts: n/a
Default

Try with these steps

Open the form in Design view.
Double-click the form selector to open the form's property sheet.
Do one of the following:

If you don't want the form to display existing records, set the DataEntry property to Yes.

If you want the form to open with all records showing, set the DataEntry property to No.





Similar Threads
Thread Thread Starter Forum Replies Last Post
The best way to design a data entry web form cesemj ASP.NET 2.0 Basics 2 November 5th, 2007 02:44 PM
Need to dup a whole record in a data entry form markw707 Access 4 August 29th, 2005 10:09 AM
New Record Data entry one form lgpatterson Classic ASP Basics 1 February 8th, 2005 12:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.