Normal Topic Form Use only in Search Mode (Read 643 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Form Use only in Search Mode
Oct 14th, 2008 at 7:18pm
Print Post Print Post  
Hello!
I would like to  automatically generate the CustomerNr from 1 to 99999
So iI can use my file only in search mode.
Anyone know how best to achieve?

Thank you for any help !
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Form Use only in Search Mode
Reply #1 - Oct 15th, 2008 at 12:53am
Print Post Print Post  
It sounds like you want to set the CustomerNr, then lock people out of Add mode.

If that is correct, you can use a Mass Update to assign the numbers, then put this code in the form's On Form Entry event:
Code
Select All
If @Add
{
	@Msgbox("NOTICE: You cannot add records to this database.", "", "")
	@Exit
}
Else If @Update
{
	// Prevent Extend Mode
	NotifyForm(7)
} 


  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Form Use only in Search Mode
Reply #2 - Oct 21st, 2008 at 2:09pm
Print Post Print Post  
Thank you Carl.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged