Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 24th, 2004, 06:10 PM
Authorized User
 
Join Date: Aug 2003
Location: Austin, TX, USA.
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
Reply With Quote
  #2 (permalink)  
Old August 25th, 2004, 01:08 AM
Friend of Wrox
 
Join Date: Jul 2004
Location: , , India.
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.




Reply With Quote
  #3 (permalink)  
Old August 25th, 2004, 09:02 AM
Authorized User
 
Join Date: Aug 2003
Location: Austin, TX, USA.
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
Reply With Quote
  #4 (permalink)  
Old August 10th, 2013, 09:06 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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..
Reply With Quote
  #5 (permalink)  
Old May 23rd, 2014, 04:25 AM
Registered User
Points: 30, Level: 1
Points: 30, Level: 1 Points: 30, Level: 1 Points: 30, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2014
Posts: 8
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
Reply With Quote
  #6 (permalink)  
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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:46 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.