If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Form entry order
Mark,
Thanks for your help with this. Yes I wrote the app a couple of years ago. I tried your suggestion on the remove filter/sort but to no avail...... Every time I enter a new invoice on the subform and click the bottom left arrow to go to the next entry form, the form I just entered becomes form 1. FJ "Mark A. Sam" wrote: Is this an app that you wrote? If it is someone else's work, there may be something in code causing this, like Ron suggested. But here is another possibiilty. Somone may have set the Sort Order using the short cut menu on the form. On the main form and subforms right click and select "Remove Filter/Sort. Someone may have inadvertantly saves the changes after sorting. God Bless, Mark |
#12
|
|||
|
|||
Form entry order
Arrow to go to the next form? I think I misunderstood the problem. Is the
arrow a button? In the click event of the button do you have a method: Me.Requery or Form.Requery? Maybe somewhere else in code? That would cause the form to go to record 1. I could open an event procedure and do a search on "requery" (without quotes) and see if it is being executed sometime after you click the arrow. "FJ Questioner" wrote in message ... Mark, Thanks for your help with this. Yes I wrote the app a couple of years ago. I tried your suggestion on the remove filter/sort but to no avail...... Every time I enter a new invoice on the subform and click the bottom left arrow to go to the next entry form, the form I just entered becomes form 1. FJ "Mark A. Sam" wrote: Is this an app that you wrote? If it is someone else's work, there may be something in code causing this, like Ron suggested. But here is another possibiilty. Somone may have set the Sort Order using the short cut menu on the form. On the main form and subforms right click and select "Remove Filter/Sort. Someone may have inadvertantly saves the changes after sorting. God Bless, Mark |
#13
|
|||
|
|||
Form entry order
No its not a button. I was referring to the genereic part of all forms in the
bottom left corner which shows the form number and has arows to go left or right or the beginning or end of the series. FJ "Mark A. Sam" wrote: Arrow to go to the next form? I think I misunderstood the problem. Is the arrow a button? In the click event of the button do you have a method: Me.Requery or Form.Requery? Maybe somewhere else in code? That would cause the form to go to record 1. I could open an event procedure and do a search on "requery" (without quotes) and see if it is being executed sometime after you click the arrow. "FJ Questioner" wrote in message ... Mark, Thanks for your help with this. Yes I wrote the app a couple of years ago. I tried your suggestion on the remove filter/sort but to no avail...... Every time I enter a new invoice on the subform and click the bottom left arrow to go to the next entry form, the form I just entered becomes form 1. FJ "Mark A. Sam" wrote: Is this an app that you wrote? If it is someone else's work, there may be something in code causing this, like Ron suggested. But here is another possibiilty. Somone may have set the Sort Order using the short cut menu on the form. On the main form and subforms right click and select "Remove Filter/Sort. Someone may have inadvertantly saves the changes after sorting. God Bless, Mark |
#14
|
|||
|
|||
Form entry order
On Fri, 9 Jan 2009 07:49:02 -0800, FJ Questioner
wrote: No its not a button. I was referring to the genereic part of all forms in the bottom left corner which shows the form number and has arows to go left or right or the beginning or end of the series. THAT IS YOUR PROBLEM. You're misinterpreting what that number *means*. That number *is not a form number*. That number is not a record number. That number is not stored ANYWHERE in your tables. It's merely a dynamic indicator of the current position being displayed in the form's recordsource query. It isn't associated with any particular record. -- John W. Vinson [MVP] |
#15
|
|||
|
|||
Form entry order
Yes I know that the number is not the record number in the underlying table
and isn't a stored value. However, I'm not concerned about this problem with respect to the integrity of the underlying tables. I'm looking at this from a user data entry point of view. Its a real pain when the form reverses the entry order. Doesn't it seem strange that the "dynamic indicator of the current position being displayed in the form's recordsource query" goes in regular sequential order for every form in my system but one ? Thanks again, FJ "John W. Vinson" wrote: On Fri, 9 Jan 2009 07:49:02 -0800, FJ Questioner wrote: No its not a button. I was referring to the genereic part of all forms in the bottom left corner which shows the form number and has arows to go left or right or the beginning or end of the series. THAT IS YOUR PROBLEM. You're misinterpreting what that number *means*. That number *is not a form number*. That number is not a record number. That number is not stored ANYWHERE in your tables. It's merely a dynamic indicator of the current position being displayed in the form's recordsource query. It isn't associated with any particular record. -- John W. Vinson [MVP] |
#16
|
|||
|
|||
Form entry order
That doesn't "go to a new or another Form", it is "Record Navigation" and
moves from one Record in the Record Source to another on the same Form. It's is worth learning the terminology of your tools when you rely on remote assistance. Larry Linson Microsoft Office Access MVP "FJ Questioner" wrote in message ... No its not a button. I was referring to the genereic part of all forms in the bottom left corner which shows the form number and has arows to go left or right or the beginning or end of the series. FJ "Mark A. Sam" wrote: Arrow to go to the next form? I think I misunderstood the problem. Is the arrow a button? In the click event of the button do you have a method: Me.Requery or Form.Requery? Maybe somewhere else in code? That would cause the form to go to record 1. I could open an event procedure and do a search on "requery" (without quotes) and see if it is being executed sometime after you click the arrow. "FJ Questioner" wrote in message ... Mark, Thanks for your help with this. Yes I wrote the app a couple of years ago. I tried your suggestion on the remove filter/sort but to no avail...... Every time I enter a new invoice on the subform and click the bottom left arrow to go to the next entry form, the form I just entered becomes form 1. FJ "Mark A. Sam" wrote: Is this an app that you wrote? If it is someone else's work, there may be something in code causing this, like Ron suggested. But here is another possibiilty. Somone may have set the Sort Order using the short cut menu on the form. On the main form and subforms right click and select "Remove Filter/Sort. Someone may have inadvertantly saves the changes after sorting. God Bless, Mark |
#17
|
|||
|
|||
Form entry order
Right. Thanks for the clarification. Its the record navigation number that
is reversing for some reason. Have you any idea as to what may be causing that? Thanks, FJ "Larry Linson" wrote: That doesn't "go to a new or another Form", it is "Record Navigation" and moves from one Record in the Record Source to another on the same Form. It's is worth learning the terminology of your tools when you rely on remote assistance. Larry Linson Microsoft Office Access MVP "FJ Questioner" wrote in message ... No its not a button. I was referring to the genereic part of all forms in the bottom left corner which shows the form number and has arows to go left or right or the beginning or end of the series. FJ "Mark A. Sam" wrote: Arrow to go to the next form? I think I misunderstood the problem. Is the arrow a button? In the click event of the button do you have a method: Me.Requery or Form.Requery? Maybe somewhere else in code? That would cause the form to go to record 1. I could open an event procedure and do a search on "requery" (without quotes) and see if it is being executed sometime after you click the arrow. "FJ Questioner" wrote in message ... Mark, Thanks for your help with this. Yes I wrote the app a couple of years ago. I tried your suggestion on the remove filter/sort but to no avail...... Every time I enter a new invoice on the subform and click the bottom left arrow to go to the next entry form, the form I just entered becomes form 1. FJ "Mark A. Sam" wrote: Is this an app that you wrote? If it is someone else's work, there may be something in code causing this, like Ron suggested. But here is another possibiilty. Somone may have set the Sort Order using the short cut menu on the form. On the main form and subforms right click and select "Remove Filter/Sort. Someone may have inadvertantly saves the changes after sorting. God Bless, Mark |
#18
|
|||
|
|||
Form entry order
On Sat, 10 Jan 2009 11:19:02 -0800, FJ Questioner
wrote: Right. Thanks for the clarification. Its the record navigation number that is reversing for some reason. Have you any idea as to what may be causing that? FJ, would you be willing to zip up this database and email it to me at jvinson at wysard of info dot com? I've been watching your requests for weeks here and I still don't understand what's happening or why. If the database is large or confidential, could you perhaps import this form into a pared-down test database? For that matter - have you tried recreating the form from scratch? Maybe it's a subtly corrupted form, and Compact and Repair doesn't fix it. -- John W. Vinson [MVP] |
#19
|
|||
|
|||
Form entry order
|
#20
|
|||
|
|||
Form entry order
On Wed, 14 Jan 2009 16:05:00 -0800, FJ Questioner
wrote: I sent the zipped file to you at on Jan 10. Just wanted to make sure you got it. I did... I've been under the weather and haven't had a chance to look at it. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|