Error using locate


Hi,

For the first time I am usin an 'Access' database in my application. Everything is working fine except for the 'Locate' function in one table.

I have a numeric non indexed field, and I need to find a record with the information I have on this field. For some numbers the Locate function works properly and put the correct record as the current one. But for other numbers it goes to the first record and returns True.

Am I doing something wrog?

Paulo Hoffmann



.

Relevant Pages

  • Re: How to Distribute a New Version
    ... about preserving the test data that your users have already entered. ... The agency stuck me> with doing this project even though I am a legal assistant, not a database> developer! ... > Looks like I am stuck spending hours on the phone doing it the hard way> having users import tables, do append queries to add the data to the new> tables and then deleting the old tables. ... Front end has a "first time run" routine that>> establishes the links to the back end file automatically when first run. ...
    (microsoft.public.access.gettingstarted)
  • Re: SetOption "Default Database Directory"
    ... As I said it works except for the first time the database opens and is set ... even with the rowsource problem solved. ... Database and reopen it and the form, ...
    (microsoft.public.access.formscoding)
  • Re: Storing Password
    ... allow to create their password the first time they use the program. ... file, the Registry, etc.) there's always a chance a user could delete it. ... could store the password in the database itself, ... you could save the file to a network folder for ...
    (microsoft.public.vb.general.discussion)
  • Upgrading a databse to ms access 2007? Help
    ... I have a ms access 2003 database that I would like to ... The first time I opened I had to fix a few ... I have tried to run it as a 2003 file and as a converted accdb file, ... show every thing but then the list disappears and only the first one ...
    (comp.databases.ms-access)
  • Re: How to Distribute a New Version
    ... > How do you developers distribute a new improved copy of a database that ... My "first time run" code described above will apply all of the changes to ... template file for the new back end and have my "first time run" routine ...
    (microsoft.public.access.gettingstarted)