General discussion


Veiwing 'New Record' number in InfoPath

By stephen.dishon ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by stephen.dishon In reply to Veiwing 'New Record' numb ...

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.

Collapse -


by Coder_For_You In reply to


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.


Collapse -

Now you are completely

by Tony Hopkinson In reply to Outsourcing

out of the picture.
As a professional I only deal with professionals.
It's an ethic of mine.

Collapse -

Oh Boy

by Tony Hopkinson In reply to Veiwing 'New Record' numb ...

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.

Related Discussions

Related Forums