Discussion Locked

Veiwing 'New Record' number in InfoPath

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access 2003 database which our staff access via InfoPath. Up until now when a new record was created they have not needed to know what the unique identifier created with that entry is. As I expand my less paper office I need them to know as they enter the record what that identifier is. So when they click on ?New Record? it will clear the fields except the ID field which Access2003 would normally generate when the ?Submit? button is pressed.

As Access 2003 hasn?t created it yet I?m at a loss as to how to generate it?.if you see what I mean?

4 replies

by stephen.dishon

When programming the 'Submit' button if instead of clearing the fields for a new record after submitting the information remains then then unique ID appears.

by coder_for_you

Hello,

We are a group of professionals from India. We have been working for lot of our clients in US, UK, Cyprus, Singapore and Malaysia.

I saw your posting on TechRepublic and would like to offer you our services.

Our clients have always recommended us for our quality work and quicker services and we get lot of recurring business from them.

I would like you to try our services and see what we can do for you. There are many software consultants for whom we work. Sometimes its because fo their personal reasons or weekends or technical reasons they r not able to accomplish the work. We help them and work with them.

I look forward to hear from you. Please feel free to aks any questions you have.

Regards
Pooja

by tony hopkinson

Don't do it.
This is cardinal sin number one.
Get rid of the auto number and generate your own. Or keep it and add your own and display this.
Passing on the internal autonumber in a database to a downstream application is a disaster waiting to happen.
I've seen this banana skin many times after some careless person has cast it in front my feet.
As soon as you use the auto number outside of the database, it's not an auto number anymore it's a unique identifier across various systems that must be globally controlled.

This discussion is closed to new replies.