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 Replies
ADVERTISEMENT
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
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
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
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
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
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
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
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
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 11 Replies
View Related
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
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
Jul 14, 2014
The above image is of a table which I need to update according to a new data on daily basis. As you can see when I added two records at the last , the AutoNumber primary key of the table jumped by thousands . I have used the following query to update the table
Code:
db.Execute "INSERT INTO D_Counterparty (CPTY_ENTITY_ID,CPTY_DESC)"_ & "SELECT Ctpy_Entity_Id,Ctpy_Entity_Legal_Nm"_ & "FROM NewCU LEFT JOIN D_Counterparty ON D_Counterparty.CPTY_ENTITY_ID=NewCU.Ctpy_Entity_Id"
I never changed the AutoNumber from incremental to random and I have also tried re-seeding it but had no success. Also when I inserted the sample values using a sample table ,the AutoNumber was working fine . Here's that query
Code:
db.Execute "INSERT INTO D_Counterparty (CPTY_ENTITY_ID,CPTY_DESC,) SELECT a,b, FROM sample"
I did not use join in this query ...
View 2 Replies
View Related
Jun 28, 2013
When we browse through records in a subform we store the records in the database.When we want to delete a records for example the third record from the five records always the first records will be deleted. How can we delete the records where the cursor is at? When we are at the third record and press the delete button the third record from the list in the subform should be deleted.
Code:
Option Compare Database
Dim FocusBln As Boolean
Private Sub Identificeer()
Me.[Datum Aangemaakt].Visible = True
Me.[Datum Aangemaakt].SetFocus
If Me.[Datum Aangemaakt].Text = "" Then
[code]...
View 11 Replies
View Related
Sep 13, 2005
Im not sure if this is the right place to put this but I was wondering if you could help me:
Say I have database with forms that display records or people ie name, address, postcode, etc. What I want to do is display a list of Names then from that list I can double, single click and open the record details.
Id call my self and amatuer at access and am probably guessing this is done via vscript or something else, but any help will do.
Thanks
Alex
View 14 Replies
View Related
Sep 16, 2013
I would like to select a record from my combobox dropdown list and have that record populate in my subform. Currently, I am only able to select the 1st record at the top of the dropdown list to appear in my subform. But I would like to select any record from the dropdown list and have it populate my subform.
View 8 Replies
View Related
Nov 24, 2014
I've been asked to get some information from my database and I'm a bit stuck.
I have a list of refunds in tbl_main and each one includes a dateReceived. I make a record in either tlk_located, tlk_unableToLocate or tlk_bulk depending on the outcome when we're trying to send the money back to whoever it belongs to. Each table has a time stamp (named locatedTime, unableTime and timestamp respectively) field
My manager wants me to report how many entries were unworked on each day in the year, and what the value of them was. An entry is unworked if there is no entry in either of the 3 tables.
So I need a query that lists a range of dates, and for each date counts the number of entries where tbl_main.dateReceived is <= to that date and either has no record in located,unable or bulk or has a record with a timestamp > than the date. (It has been processed now, but hadn't been on the date we are looking at)
I can manage a query that looks at a certain date that it prompts for on each run:
Code:
SELECT Count(tbl_main.trust2PK) AS CountOftrust2PK, Sum(tbl_main.amountRefunded) AS SumOfamountRefunded
FROM ((tbl_main LEFT JOIN tlk_located ON tbl_main.trust2PK = tlk_located.trust2FK) LEFT JOIN tlk_unableToLocate ON tbl_main.trust2PK = tlk_unableToLocate.trust2FK) LEFT JOIN tlk_bulk ON tbl_main.trust2PK = tlk_bulk.trust2FK
WHERE (((tbl_main.dateReceived)<=[cutoffDate]) AND ((tlk_located.locatedTime) Is Null Or (tlk_located.locatedTime)>[cutOffDate]) AND ((tlk_unableToLocate.unableTime) Is Null Or (tlk_unableToLocate.unableTime)>[cutOffDate]) AND ((tlk_bulk.timeStamp) Is Null Or (tlk_bulk.timeStamp)>[cutOffDate]));
I would like a query that lists all dates in a range, and shows the same information for each day listed.
View 9 Replies
View Related
Sep 16, 2011
I created a search form that searches for Customer Number, Part Number, and Revision Number. The results are displayed in a List Box.
I want the user to be able to make a selection on the List Box and click an "Open Selected" button that launches that record in another form. How is this possible?
View 9 Replies
View Related
Sep 5, 2006
Hi all,
Another problem bothering me. Wish someone can help me to solve it. I am doing the 'Edit' Option right now ... As a user friendly propuse, I had try to use a combo box to let user to choose my employee record with all the detail on but the problem is the program 'JUST' list the record they can not go to the current record!! When i try to edit my record, the program is not allow (for sure because they can't have a duplicate record on it). The reason is because the record just stay in the FIRST record but can not go to the current record. I do believe is the problem of i using the way of listing the record as below:
Me.EmployeeName = Me.EmployeeName.Column(0)
Me.IC = Me.EmployeeName.Column(1)
Me.Nationality = Me.EmployeeName.Column(2)
Me.Race = Me.EmployeeName.Column(3)
Me.Sex = Me.EmployeeName.Column(4)
Me.FMU = Me.EmployeeName.Column(5)
Me.Position = Me.EmployeeName.Column(6)
Me.SectionField = Me.EmployeeName.Column(7)
Me.DOEmploment = Me.EmployeeName.Column(8)
Me.DOResign = Me.EmployeeName.Column(9)
Me.Remarks = Me.EmployeeName.Column(10)
So, Could someone help me to solve it like when i can use the combo box to select the Employee record with the details are on as the same time can go to current record... Thanks alot!!!
i do have the confident if i can go to the current record then my edit option can be working properly.
P/S: I had attach the picture... showing my program problem (with the red circle)
View 8 Replies
View Related
Apr 4, 2006
I have an add record command button that will bring up a blank record where the user can fill in the information. My question is how do I get this record to be added to the combo list that will bring up the record i just filled out? I hope that makes sense. thanks
View 2 Replies
View Related
Mar 22, 2008
Hello Daily Post, I suppose,Here is what I've got:On one form resides a list box that get's it's results based on a customers sales history.The form contains all the customers prudent information, otherwise. What I'm attempting is such:Onclick for the listbox is DoCmd.OpenReport "RptIndividualSale" the source for the report is a query whose criteria is the unique SaleID [Forms]![Main]![LstSales].[SaleID] for the records in the list box.It also has a few other fields such as the item name, sale amount, etc. My hitch is that it is using every SaleID as a result in the report. What I wish to attain is a report that only generates the information for that single sale, instead of the entire history.So if the list had SaleIDs of 12345and a user clicked 5 a report would open showing ONLY the details of the Sale with ID 5, as stated it currently shows details for all the SaleIDs, so I have a report with 1, 2, 3, 4, 5. Any way to fix this?
View 1 Replies
View Related
Aug 15, 2006
Hello everyone,
i have 2 tables,
table one =client detials
table two = job information
both have field called ClientNumber in them and have Relationships
i have a form with list box in it with ClientNumber(hidden), Surname, First name and i have a button and i want when i choose a name of list box and click button to open a job information form and be on new record and i want the ClientNumber to be put in the ClientNumber textbox on the form
so if u click on eg: David scown and click button want it to open form and be on a new record and put his Client Number in the client number text box
View 4 Replies
View Related
Sep 19, 2006
Hi all,
Please refer to the pic 'figure1' to review my question. Thanks.
I need to use a combo box to select the employee name and show the following Ref No. by using the list box. is it possible to do that? If can make it, how bout i need to delete the selected record, any idea for that? Thank you.
View 2 Replies
View Related
Nov 8, 2006
I am experience brain flatulence and need some remedial assistance.
I am creating a data entry form. I have envisioned a tabbed format because I will have this idea utilized for Placement, Mentoring and Seminars data entry as well as recruitment. But I am open to other methods. Here is a description of what I have...
tblTeachers (this is the ONE)
Demographic data
tblRecruit (this is the MANY)
recLocation
recMethod
recYear
recSchool
Form
=================
List of teachers available to allow a user to see who has already been entered to prevent duplication
Use this same list for navigationrecord navigation
The problem I have is this:
I have created a tabbed control that has the data entry fields
I have created a subform to display ALL teachers from tblTeachers
I do not know/remember how to link these so that the list may be used to to display the select record in the tabbed control
View 1 Replies
View Related
Oct 25, 2004
Hi Everyone again, (i'll try my best to explain) (Sorry if it doesn't make sense)
I have a main form - everything on the formn is linked to the User ID
I have created a List box1 which contains many selection. (Lets say a menu for food)
Once one item has been selected i have a button which adds the selected choice to another List Box2
this can be repeated to show Every item the client has selected.
I have linked both List Boxes to the User ID
This all works fine, it reconises the user IDs on every record but i would like the List Box2 to be clear
instead of holding all the previous records data when a new record is created.
Any ideas or am i barking up the wrong tree,
Thanks again.
View 12 Replies
View Related
Aug 12, 2014
My main form has a union query as it's record source. This displays a list of items for which the user uses this form to apply a category for each of the items. This relationship of item to category is stored in a temporary table. I have a subform with a list box that shows the current selections and is based on the temporary table. The linking of the master and child is based on the "description" field. I would like the user to be able to select one of the items in the list and have the main form go to that record. (the list box has multiselect set to none).
View 14 Replies
View Related
