Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text box not saiving updates (Access 2000)

    I have a database for simpletons (including myself!) - I have a "view only" screen for cases, and an "edit case" screen accessed via this view only screen - (figure it makes people think about editing stuff). I have various bits of info on these screens, but one particular text box for "case details" doesn't always save the updates that are entered. (ie. Update the details box in the edit only screen, but nothing has changed when you exit back to the view only screen). However, these cases can be edited in the table and then viewed on the view only screen. The cases this has happened to do have more info in the "details" box than the others, so I am wondering if there is a size limit to the text box that only allows a certain amount of data to be entered? (Although it can be viewed if entered into the table - this has flummoxed me!) If so, how do i make this limit bigger?
    I hope this makes sense and thanks for any help you can give,
    Al.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Text box not saiving updates (Access 2000)

    Your approach is a pretty good idea - editing data needs to have some controls. As to the original screen not being changed after an edit, are you doing a requery of the view form when you close the edit form? I would guess that may be the problem. On the problem with the text box not taking all the data, I presume you are dealing with a memo field here, so the 255 character limit of text fields shouldn't be an issue. As far as I know, there isn't any limit on the text box control - we've used it to edit some pretty large fields. One thing you should be if it is more than one line high are scroll bars (unless they are turned off). In addition, you should be able to use the Zoom dialog (SHIFT/F2) to see all the contents of the text field. Hope this helps.
    Wendell

  3. #3
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text box not saving updates (Access 2000)

    To be honest, I have no idea if I'm doing a requery...I just chose the right button when I was building it ("close form" I think? It saves it as well). It is literally only 2 out of nearly 800 cases that i have this problem with - all the others edit and save fine. It is a memo field - that's the first thing i checked. And I have scroll bars on the "case details" boxes.
    Another wierd thing is with these 2 cases is that you cannot delete any info from the "details" text box either....you delete info in the edit screen, close / save the screen using the wee button....and it is still there on the view screen! Like i said though, it can be edited in the table.
    I think I'll probably accept it as a quirk of the database - I ain't no expert in it so nothing expert is expected of me. Besides, the whole point of a database is to build something that others don't understand isn't it? Fixing it keeps you in a job!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Text box not saving updates (Access 2000)

    <hr>Besides, the whole point of a database is to build something that others don't understand isn't it? Fixing it keeps you in a job<hr>
    I'm sure you meant that humorously, but it definitely is *not* true of any ethical developer. One of the primary responsibilities we have is to build a maintainable application, so that if we get hit by a truck, some other qualified developer can step in and maintain the application. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Charlotte

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Text box not saving updates (Access 2000)

    I'm pretty sure it isn't a quirk of Access or the database. Is the data source for the two forms the same table or query? Also, how did you build the button to open the edit form - using the button wizard by chance? Finally, all you should need to do is add one line of code in the code in the OnClose event for the edit form to do the requery of the view form, and it would look something like this:
    Forms![myViewForm].Requery
    If you want to test this process before you implement it, you can do a manual requery on the view form once you've edited a record on the edit form by doing a SHIFT-F9.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •