Normal Topic Problem in Search Mode (Read 616 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Problem in Search Mode
Mar 27th, 2006 at 5:27pm
Print Post Print Post  
Hello!

Opening the form in Search/Update, F10 to see the total number of records in the database.
With more F10 ít does not move to the next record!
so i can see only the first found record.
I deleted the On Form Exit and On Form Entry Programming but it does not help.
I have deleted the  2 Subforms but no success!

The add Mode have no problem.

Easy Fix? I hope.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Problem in Search Mode
Reply #1 - Mar 27th, 2006 at 5:32pm
Print Post Print Post  
How many records were found?

Any NotifyForm calls in the code that is running?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Problem in Search Mode
Reply #2 - Mar 27th, 2006 at 6:25pm
Print Post Print Post  
Thanks Mark  for such a quick response -

How many records were found?  1054 records.
without this Code in the GLOBAL CODE i am glad again in search Mode !

If @Update Then
{
  If @ResultSetCurrentPosition() = @ResultSetTotal() Then
   {
    NotifyForm(2)
   }
   Else
   {
    NotifyForm(-2)
   }
}


i want just to prevent User from adding records in Search/Update mode but allows saving.





 

  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Problem in Search Mode
Reply #3 - Mar 27th, 2006 at 6:40pm
Print Post Print Post  
Amor,

The problem is that your code is in GLOBAL CODE. Move it into On Form Entry and you should be fine.

GLOBAL CODE runs once when the Form is first opened and never again. Therefore, you tell your Form to prevent Advance when it is first opened. Since that code never runs again, it never gets the chance to allow Advance. Move the code to On Form Entry so it can run as you move from record to record.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Problem in Search Mode
Reply #4 - Mar 27th, 2006 at 9:32pm
Print Post Print Post  
Erika,

Problem solved.

Thanks, Erika
  

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