Wrox Programmer Forums
|
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 September 18th, 2008, 05:36 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Part Default Value

Hi All
I need to set six digit default value with the first two digits
 93 so that when users open a form the first two digits remain when the other four digits remain

Thanks

Brendan Bartley
__________________
Brendan Bartley
 
Old September 18th, 2008, 09:47 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I am not sure what you mean by this. You want a key for the record, or you want a case number? Where are the other 4 digits coming from?



mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old September 18th, 2008, 10:11 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi
The 93 is the default number in the tbldetails. It appears on the form under sort code. I want the user to enter details into the form but when they enter numbers into the sort code the number 93 remains and they only enter the four digits to complete the six degit number

Thanks

Brendan Bartley
 
Old September 18th, 2008, 11:41 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I had a lovely post, but this forum keeps hanging on me and it was lost. Please email.

mmcdonal

Look it up at: http://wrox.books24x7.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
What web part have they used? sharepointbaby BOOK: Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 ISBN: 978-0-470-12449-9 0 May 30th, 2008 08:51 PM
Getting Part of a String needelp Access VBA 4 September 19th, 2006 06:22 AM
Web part soso_soso SharePoint Development 0 September 7th, 2006 07:37 AM
Part Solution... Aaron_j XSLT 0 July 28th, 2005 08:01 AM
The difficult part k0023382 Access 1 October 8th, 2004 03:37 AM





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