Prevent Form From Jumping Back To Top During Requery?

Mar 20, 2006

Hello All,

I'm a newbie to the forum, but hope that someone can point me in the right direction to solve a problem.

Background:
I have a db that I use much like Quicken to maintain a ledger and reconcile accounts. To reconcile credit card transactions, I have a continuous form that lists each transaction as a record in the Detail. Each record has Check Boxes for Yes/No criteria pertaining to "Cleared Status", "On Statement", and "Missing Receipt". Checking the box for "On Statement" allows a subsequent report to include the items that are checked. Likewise, an Update Query used later in the process sets all all items in the reconcile to "cleared" so that do not reappear on the list of items to reconcile. In order to cause the Report and the Update Query to reassess the Yes/No status for each item and thus function properly, I have set the Event Proceedure for these Check Boxes to Requery the underlying data.

Problem:
As you can imagine, the list of Credit Card Transactions is a long one. Each time a Check Box is clicked, the requery causes the list of records to jump back to the very top of the list. This really slows down the process of completing the reconcile. Is there a way to hold the continuous list in the detail section still as the requery takes place?

Thank you very much for any help you can provide.

Gordon

View Replies


ADVERTISEMENT

Prevent Form From Displaying New Record And Save It When Form Requery Or Close

Aug 26, 2014

I have a split form that's like a list of pending tasks. The data source is a linked SharePoint 2013 list where users submit requests. The user takes the information from each record and performs an action. When it is done, the user presses a button and the task status changes from "Pending" to "Processed". The form record source is based on a query that finds only records with a status of "Pending" so when the user changes the status of the task, it is removed from the list. It works fine except when there is only one task left in the work list. If the user processes the last task, the form refreshes and it goes to a new empty record and I get an error message that says I must enter a value into one of the required fields. I tried making the field non-required but it just creates an empty record in the table.

View 3 Replies View Related

General :: Split Database - Prevent Linking To Back End

Jun 25, 2015

I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution.

As the database is on the network drive, is there any other way to prevent people to link to the db? Can I hide the db in the network drive? Or should I hide tables in the BE. Should these still be available to be linked?

View 6 Replies View Related

Jumping Through A Form

May 22, 2006

Hello again,

Is there a way in determining how the users jumps from one text or combo box to another on a form?

When I press enter I want the cursor to move to a different text/combo box than the one it automatically moves to.

Is there a way of doing this?

Any help appreciated!

View 2 Replies View Related

Jumping Form Using Tabs

Mar 1, 2005

I have a long form that has a tab control at the bottom of it. You have to scroll down to get to the tab section. After I scroll down, when I click on one of the tabs the form jumps up. It doesn't jump up to the beginning of the form but somewhere near the beginning. I've checked everything that I could think of but nothing helps this situation.

Does anyone have any ideas?

Thanks

Sue

View 2 Replies View Related

Jumping To Form View Record From A Query

Apr 10, 2007

Hi, new to the forum hoping someone can help :)

I'm half way through a project and want to have 3 queries to search personal information (Surname/DOB/Ref Number) is it possible to select the record in data view from the query search and jump to the record in form view? Would I have to display the query differently or is it possible to just click within the normal query view?

Any help would be appreciated, thanks Harry

View 1 Replies View Related

Forms :: Continuous Form Cursor Jumping Around On Entry

Mar 5, 2015

I have checked the tab order and have cycle for my form set to = all records (but have also tried current record). After I update one of any of my textboxes in the details section and then click or tab into the next box, the cursor jumps back to the first record, first field.

View 1 Replies View Related

Forms :: Requery Moves The Record Back To 1st Record

Sep 2, 2013

I have a form which has 3 subforms based on a table with a combo box. When I select value from the combo box the data on the subform changes accordingly using the 'Requery'. However, they also show the record from the 1st value of the combo box. Is there a way I can get this solved?

View 1 Replies View Related

Remember The Selected Record - Requery - Then Go Back To Selected Record...

Jun 28, 2005

Hi guys,

Bit of a problem I'm hoping someone can help with. I have a telephone call logging system. The system is a tabbed form with each tab representing a person's Telephone Call Inbox. As new calls are entered into the database, they appear in each person's inbox until they are marked as dealt with.

This all works fine and there are no problems with the basics of it, but the problem I do have is that after I have split the database into a Back end and a Front end and distributed the Front ends to each user, when a new call is entered it doesn't appear in the persons inbox until they do a requery.

At first I sent the form to requery using the ontimer event, but the problem I have is that after every reqery the form goes back to the first record. A user on the office forum suggested I use the following code:

vCurrent = Me.Bookmark
Me.Requery
Me.Bookmark = vCurrent

But this gives me invalid bookmark errors, so I was then told to add

On Error Resume Next

But this stops the bookmark function working and instead the first record is loaded every 1 minute (as set by my timer).

Can anyone recommend a better way that actually works without invalid bookmark errors?

View 14 Replies View Related

List Box Jumping To First Record

Oct 12, 2005

Greeting All!

I mentioned this a while back but was never able to solve this problem.

I don't have any nails left to chew so I hope some smart person on this forum can spot the error or know how to solve it.

Here goes...

On the main form you have a building that you can click on, once you have done so it will then list all the fire fighting appliances in that building that need servicing.

The problem is that when I'm editing the records the list box jumps to the first record after saving it & you have to scroll to the last record again to continue.

It's not so bad if you only have a few records to edit but it is a pain when you have more than can fit on the form.

I hope someone can spot where I'm going wrong and help me out as I have no idea how to solve this.

Thanking you in advance.

View 10 Replies View Related

Jumping To The Next Line In VB Code

Jul 7, 2006

hello,

okay, simple question. How in visual basic code do you tell the prompt to go to the next line in the same control on a form? In other words, how do you mimic the behavior of the enter key in code?

D

View 7 Replies View Related

Jumping Of Autonumber In A Non Ascending Order

Jan 5, 2005

Hello,

I have a simple invoice database with a primary key in the main table (with autonumber as invoice no.) and a subform with the item details which is without a primary key with the data type as numbers. In addition, I had the tables linked as one to many relationship. What happen is that when I am entering the data, the number jumps . For eg: It was suppose to be 7123 but the next entry was 7150. Pls kindly advice.

View 3 Replies View Related

Forms :: Fields Jumping When Have Focus

Sep 1, 2013

When the client clicks in a text-Box or Combo-box in a sub-form, the field seems to jump to the side. in this image it jumps to the left, but jumps to the right to..., it is quite irritating, especially attempting to open a combo-box list, and see the button jumping aside.We renewed the file many times, so I don't think it is corrupted, but go know..the file can be accessed via network or terminal server, the pic is from terminal, but happens via network too.

View 1 Replies View Related

Reports :: Controls Jumping About When Try To Move Them

Apr 24, 2014

I've recently upgraded on of my systems from Access 2003 to 2010.

In the past I've always used to the ctrl key and the cursor keys to move and fine tune the position of my controls on my reports. However since upgrading the controls jump about all over the place when I try to move them.

I have noticed that when I've selected the controls and start to move them a little black line appears on the vertical ruler and when I release the controls they seem to move to it's position.

View 9 Replies View Related

Forms :: Requery Form And Subform After Popup Form Close

Aug 19, 2013

I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.

Form 1
subform 1 > button to open pop up form
subform 2
subform 3

I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.

On pop up form close, what's the correct syntax for re-querying subform 1?

View 2 Replies View Related

Duplicate Keys - Records Jumping Screens

Apr 24, 2008

The problem now is when two data entry people are
working on the DB at the same time, sometimes the
client records one person is the are working on jump
from one computer to another computer.

Attached is an example caught:
Louise data entry user was logged into the database
on one computer entering data.
Mary data entry user was logged into the database on
a different computer entering data on a different
client.

The client data from Mary's computer "jumped" to the
screen of Louise's PC. And then worst to the
database table of contact data kept.

This is kind of hard to believe if there was not
screen images catching it in the act, which we have.
Is there a record locking MS-Access global setting I
need to turn on?


Also, we have at least 3 time where we get a duplicate MS-Access record-id key on the DB. That is not suppose to happen. I can e-mail the DB and mass out the real person(s) names if you would like.

Any of your great thoughts or insights will be appreciated.


Hope all is going good for you at America General and the earth quakes are not too shaking.

Thanks

Russ

View 7 Replies View Related

Forms :: Subform Jumping To First Record Field

May 28, 2014

I have a form with a subform for tracking the stocks trading. I use the subform to enter new transactions. This was working fine until I have made some modifications in the design, which started giving me the trouble. Whenever I try to input any transactions by selecting a combo box in the subform, it takes me to the first record, even before completing my entries. I tried my best to solve it. But not successful. I am attaching a sample file for reference.

View 14 Replies View Related

ReQuery A Different Form

Jul 19, 2005

Can someone please check this code for me, I just need to make sure that what I am doing is correct!

I am trying to requery a form from another form:

[Forms]![Form1].[Text1].Requery

View 4 Replies View Related

Requery Form

Apr 3, 2006

I am new at Access and have a database that has 2 tables (Donors and Donations). My donations form's source is a query. I have a combo for the DonatorID on the Donations form. I have a On Not in List macro that opens the Donors form so they can enter the name of a new donor. This works great but when you close the Donor form and the focus goes back to the DonorID combo, the new donor isn't in the list. How can I requery this so the new donor that was added to the Donor table shows up in the combo? I played around and added another combo that had tab index 0 and then everything works but this aint the solution.

Thanks for your help.

Art

View 1 Replies View Related

Prevent Form From Opening

Oct 5, 2005

I need to prevent a form from opening if
no data (no picture) is found in an image
control on the form that needs to be
opened.
The form is opened in this manner:

DoCmd OpenForm StDocName,,,stLinkCriteria

Certain records will not have a picture so the
form doesn't need to be opended.

Thank you

View 8 Replies View Related

Prevent Form Closing

Mar 18, 2005

Hi

Can somebody tell me please how to prevent a user from closing a form if a specified other form is open?

Thanks
tt

View 2 Replies View Related

Requery Continuous Form

Jun 2, 2005

Is there a way I can requery a continuous form. Basically my form runs from a query. If when certain criteria become true I want that record to move to a different form, (working on another query) Basically I am saying is that if checkbox1 = true then I want to hide that record. Does that make sense?

View 2 Replies View Related

Requery In A Continuous Form

Oct 6, 2005

Hi,

I have scanned through the forum but have not found an answer for the above..

How do I do a requery only for the combo box of a particular record in a continuous form?
To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all sub-sectors based on the value selected in the previous primary sector combo box.

When I do a requery using the following code,

Me.cboDACCode.Requery

all the records in the form get requeried.

All the field are bound field.

There was a similar post in the form but was not complete.

Thanks...PH

View 10 Replies View Related

Requery Another Form When Pop Up Unloads

Nov 3, 2005

i tried this

DoCmd.Requery ([frmpcinfo.AssignedBadge])

somehow that doesnt work.

all i wana do is requery a combo (assignedbadge) on the form (frmpcinfo) when the pop up form unloads/.

please assist :confused:

View 1 Replies View Related

Requery A Previous Form

Apr 30, 2006

Silly query, think I am missing something obvious but I shall ask anyway.

I want to update certain lists in my form do the user can select from this list to update a field, so i click on a button and open a table, update a record and then close it to return to the form.

the List does not update unless I close the form and re-open it again.

Is there a property that automatically updates the list on exiting the query / table you are updating?

Thanks in advance

Hiten

View 2 Replies View Related

Requery List Box From Another Form Vba

Apr 24, 2008

I have a main form....I click a button on this form and another form opens...an edit is made....(BOTH MUST BE OPEN)
WHen I close this form I want to Refresh a List box on the Main form to reflect this edit.

I am trying this with no success

MainForm.SubFormName.Requery

MainForm.SubFormName.Refresh

What am I doing wrong????

THanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved