Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help w/ default expressions for a form

Help w/ default expressions for a form

Help w/ default expressions for a form

In my database I have five forms for entering in the blue print numbers. These five forms are for the size of the prints being entered. A size prints, B size, C size, D size, and finally E size. These forms are gathering the data through a query I made. In each of these forms the print numbers are for the most part in numeric order.
Is it possible to make a default value expression that would put the next number in the new record?

           PRINT #
      NEW* A30086 <-----"Need an expression that would
                         do exactly that


RE: Help w/ default expressions for a form

Check out Thread181-59887 and see if you'd like to use this idea instead. Text fields.....why's it always got to be text fields.... Gord

RE: Help w/ default expressions for a form

I seem to be getting a #name? message in my form box
I used =Dmax([drawing number],[n:\log\drawlog])+1
and I did try =Dlast, for the heck of it all.

Any thoughts to whats my problem?


RE: Help w/ default expressions for a form

Ya, like the post above says it doesn't fly with text fields which I guess you need 'cause of the "A". I could give you another cool choice so this would work: Split your number. Keep your number a number but have a "Prefix" field just in front. (I do this here as a matter of fact, where quotations are prefixed by province.) Works really well, takes a minute to make a prefix table: prefixID, Prefix.
Then add prefixID as a foreign field to your drawing table. If this appeals to you, start it out and write back if you need help in clipping those "A"'s from your drawing numbers before switching them to numbers from text.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close