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
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!
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
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
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 RelatedI'm trying to clean up a form a bit and have it only show certain subforms/graphs if the data exists. I already have columns in a combobox query to show an "X" for if certain data appears:
Now, I know I could build another query and have some system go through and identify these things, but the easiest thing would be to reference the "X" in the columns of the combobox. Is there an easy way to reference values in the other (non-primary) columns? Or can you think of an easy way to make these subforms only be visible when the data exists? Maybe have an on load event for the subform?
I have a tab controled form and when it opens in form view the tabs are to high to be seen on the page and you have to use the scroll bars to have access to them.
What in the world am I doing wrong. I cannot get this to open correctly and my form fits just fine on one screen in design view.
Tammy
I made a form with 2 tabs. I created controls on it and I saw that some controls belong to both of the tabs. How can I set the controls to belong only to one tab?
Thank you in advance!
I've been sent a form which retrieves company information divided into 4 tabbed sections. Really need to print all this off but can't even print the tab which is showing - it only prints the part of the firm outside the tabbed area (company name and number)
Would be really grateful for an idiot's guide on how to do this! Reluctant to provide a link as it's confidential information.
I have a survey DB with many forms, several of these have tabs. If for some reason there was a cutoff in the survey I save the form name and question name (which is always the first Ques on any form, or the tabctl value) into FormSE and QueS, respectively, so I can return directly to that spot later on. On the forms without tabs I use the following code to open the forms:
stDocName = FormSE
stLinkCriteria = "[RespID]=" & RID 'Respondent ID
DoCmd.OpenForm stDocName, , , stLinkCriteria
However, for those forms with tabs of course the form opens on the first page always. The tabctl0.value was saved into a variable called QueS, similar to the FormSE variable in the above code, which houses the form name.
How can I open the tabbed forms to the correct page (or tab)?
I have a small problem, I have designed a form, and when I pressed tab at the begining it work fine, but then when I started adding text fields and removing them, now when I press tab, it just goes everywhere , in other words the tab goes text field by text field that I have added in chronological order, is there a way to make it jump to the text field beside it.For example I have 3 text fields, StudentId, StudentName, Cource. when I pressed tab it went from StudentId to
StudentName then to Cource. Then I desided to change StudentName into StudentFirstName and StudentLastName. When I did that the form starts at StudentId then jumps to cources when I press tab then jumps to StudentFirstName and StudentLastName, but it is not their order. Since their order is StudentId, StudentFirstName , StudentLastName , Cource.
Anyway to fix that.
Hello
I set up my tabs at the very top of the Detail section. In design view I can see the tabs but when I open the form I can't see the tabs. (Within the Tabs I have placed sub Forms, and when the Tabbed Parent form opens it just displays the contents of the child form... NOT the tabs from the parent Form)
Infact I can't even see what I put in the Header section of the Parent form.
How can I make the Tabs appear? How can I get my stuff in the Header section to appear?
Thanks very much.
I have a tab control form with about 5 tabs. However when I move to the tab that has a datasheet form, the page moves down. You have to scroll up to see the above tabs. Is there something I'm missing on this simple tasks? Is it better to have it as a basic form for easier interface.
View 2 Replies View RelatedGreeting 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.
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
I have a form with a lot of data structured in tabs. Since the tab loads all the data at once while the navigation form browses to the desired form. I have tried but the issue is the Master-Child link. The form in the navigation form is not considered as a subform, hence, no way to set a Master-Child link. The navigation form itself is the subform but even when setting up a link there it has no influence on the form displayed by the navigation form.
[URL] ....
I am creating a database in which to store my data collected in my research. I have 8 tables that are linked by a SampleID number. I have created a form which has tabs, the first tab contains the information required for entry on table 1; how I am going to add the controls from table 2 onto the second tab.
I know how to make additional tabs and I have created a separate form for table 2 with the form wizard, cut and pasted the fields into the second tab on my first form BUT how to establish the source for those controls back to the second table. To make matters worse (of course not to be too dramatic here) I can see the other table in my Field List of related tables.
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.
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 RelatedI'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.
I have a master form named frmCustomer. I then have a set of tabs (not the navigation tabs) embedded within frmCustomer. The tabs are Invoice (frmInvoice), Contacts *frmContacts), Notes (frmNotes) and Orders (frmOrders). All form are Single Form. There is another form named frmInv that displays an invoice in a formatted manner. frmINV gets its data from a q1uery called InvQ.
It has a criteria that reads [Forms}![frmInvoice]![Invoice_ID]. I placed a button on frmInvoice that calls frmInv. If I run frmInvoice separately outside the tab the correct invoice displays. If I click the buttom from within the tab I am asked to enter the vale of [Forms}![frmInvoice]![Invoice_ID]. How do I call the frmInv form from the tab?
I have a tabbed form built in Access 2007. It's a series of about 32 different questions, with some being fill-in, some drop down boxes to select from, some radio buttons to choose a rating from 1 to 5. The reason I used a tabbed form was just to keep things consolidated on one screen where no scrolling was involved. All of the entries on each of these tabs are deposited into the same single table. I have 7 tabs, and all of the fields on the 7 tabs compose a single record in the table.
I have the actual tabs hidden, and instead use a button to switch to the next tab (Continue button at the bottom) once all the fields on that tab have been completed. I have all of the necessary fields set to be required, but Access does not validate the entries until the very end of the survey when they click a 'submit' button that actually saves the responses and returns to the opening splash page to start the survey again.
What I want to happen is for the fields on the current tab to be validated before it lets the user move to the next tab with the continue button. If they click continue and have left any fields blank they should get a message that all required fields must be completed or something similar to that.
I have found a thread here entitled "Form Validation before Moving to another Tab" which sounds similar to what I'm doing, but using the button method to navigate to the next tab, there is no BeforeUpdated event to assign that code to.
Please see the screen shot attached.
I have a single form with multiple tabs. At the top of the form appears the name of an individual and below the name are multiple tabs containing information specific to that individual. Each tab has a separate underlying table, which is the data source for the information contained on that tab.
As best as I can tell, I can only use one single data source (a query at the moment) to populate all the data that appears on all the tabs. Is there a way that I can have a separate data source (namely, a table) for each tab?
I have navigation form with 2 tabs I'd like to limit access to users with certain type of account.
There are 2 tables in database that contains user names and types of accounts (tblSecurityLevel and tblUser), and they are used to set user name, login and security level.
It works this way: when you open form, it checks if PC name corresponds to name in UserLogin field (tblUser), if it does it gives appropriate access level depending on set user security, if PC name is not on the list user will be logged as guest.
So far, I used this code and it works great for limiting access to 1 tab:
Code:
Private Sub Form_Load()
Dim UserLogin As String
Dim userLevel As Integer
UserLogin = Environ("Username")
Me.TxtLogin = UserLogin
[Code] ....
Is there a way to expand the code and add second tab (or even third) with this table structure (I'd like to be able to keep login which 1st checks for pc name).
I have an Access 2003 database. I have a form with 5 tabs. I want to prevent some users from editing data on some of the tabs.
I added some logic to the OPEN property of the parent form but it does not work. "Object doesn't support this property or method." What is the correct way of controlling access of the data on the tabs?
In the logic below I first determine the user's permission for each tab. If the user has read-only access they will not be allowed to edit anything on this tab. There are 50 fields on the accounting tab and a subform. If possible, I don't want to have to specify each field individually in the code. Plus there are 5 tabs with numerous fields on each.
BTW: [add designer] is the parent form and [accounting] is the tab.
If DLookup("[permission_studentacct_ReadOnly]", "Users", "Contact_ID = " & Forms![Global]![UserID]) = True Then
Forms![Add Designer].[Accounting].AllowEdits = False
Else
End If
I have created a new form with a few tabs, I need to let the value's of the last record be carry to a new record, but it must only show when I press the first letter on the new record, I did rerad about this, but only find it for normal forms. Did try to get it to work, but it dows not work on tabs form
View 2 Replies View Related