hello,
I have a main form with one child form. This child form also has a child form. This last child form has two tab controls it. When I tab through fields on the form, I have to reposition the form so that I can see these last fields. Otherwise I have to tab blindly through them. How do I get the form display the fields as I tab to them ? I have to design the forms on the larger size because the users like that. Any suggestions would be appreciated.
thanks !
I have added the Allen Browne Calendar 2k control to my form.
My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1.
What is happening is that the Calendar is also being displayed on my 4th page, in the same position as page 1. When I try to move it, cover it or delete it from page 4, it is also gone from page 1.
Is there an easy way to make a full page address labels (30 to a sheet) without having to create it by dimensions? I can't seem to get all the dimensions correct.
I have created a table with name "Main". It consists of fields ID, Author, Title, Abstract, Page and Published.
I have created a form named "MFORM" with text boxes Author, Title, Abstract, Page and Published,and then I created a search and clear parameters buttons below the text box.
Then I dragged my Search Query into the bottom of my form MFORM and named it as "All Results".
When I click on search then the results are displayed in the new tab instead of bottom of my main form in Search query.
If I enter author name as Mike and then click on search button then results should display all the details related to Mike on the bottom of my form.
All Results [At the Bottom of my page]
Should display all the details related to Mike.
I had attached my database. I just need the search results at the bottom of my main form in stead of displaying in new tab.
While creating a report , I find that the number of fields are more for a single record, and cannot be accommodated in a single sheet of A4 size paper(Landscape). So what is to be done so that all the fields can be incorporated in the report for a single record on the same page? I don't mind if all the fields for the single record are displayed in two/three lines on the same page.
I have a form with a large amount of subforms on it.
The problem I am having is that I cannot tab between subforms when entering data.
The cursor just moves within the subform and browses off of the current record (Creates a new record, like when scrolling the mousewheel).
Anyone know how I can set it up so that I can tab betweek all subforms across the entire form and not create a new record?
In addition, I know access 2000/97 users had to use custom code to disable the mousewheel, but I read something somewhere saying that you can disable it in Access 2003 without using code? How do I do this?
I have 2 main forms for my database, both with multiple page tabs (I will call them pages to avoid confusion with tabs) and subforms.
I can set the tab order for the various pages to go through the fields and jump to the subform ok. 2 small problems I haven't been able to sort out are:
1) Once I have tabbed into a subform, in datasheet view, the tab takes me through the fields and then to a new record when it reaches the end. I can't tab out of the subform back to the page I came from and onto the next object.
2) When I tab from the last control on a page I want the focus to go to the first control on the next page of the form but what actualy happens is the next record is opened.
Neither of these are a big deal but it means using the mouse when I would rather navigate with a quick click. If I cannot set the tab order to get what I want for item 2, is it possible to put a control button on the page with some code behind it to move me to another page of the form in the same record?
I am trying to setup 3 text boxes to autotab once the required input has been put in.
I have in the table assigned each field the max number that can be inputted, which is 3, 4 and 5. Now when inputting it stops and you have to manually tab to get it to move over which is fine and good...but who I am designing this for wants it to tab. I could use input mask but it uses place holders which I dislike greatly.
I am looking how to do this in code, I am not sure which commands to call up. Right now I have this:
Private Sub Branch_Change() If Branch.length = 3 Then DoCmd.RunCommand acCmdTabOrder End If
I am still learning my code, so laugh at will :) cause I am sure none of that is right. Thanks.
Is there any way to change the order that the tab button cycles through the different fields in a form? Right now mine jumps ALL over the place and in some case even misses a field.
I have search the forum and have found many solutions to this same problem but so far none have worked for me. I am fairly new to Access so maybe I am just not understanding properly.
I have a form with a main form and many subforms. All subforms but one are continuous and the other is a single form that does not allow additions.
1. I can tab from the main form to the first subform but can’t get the next subform. I have tried this on the exit of the first combo box in the subform
Private Sub EventInitialActionTaken_Exit(Cancel As Integer) If IsNull(Me.EventInitialActionTaken) Then Me.Parent.[frmeventFsubform].SetFocus End If End Sub
This works until I open a new record from one of the subforms and then I get an error.
2.Then, my last subform is the single form with no additions and I want it to tab to a command button on the main form. Right now it just goes in circles throughout the sub form
3.Also, if I ask to start a new record while my cursor is in one of the subforms, the new record will open with my cursor in that subform field. How do I get it to default to the first field in the main form? I tried Me.EventID.Setfocus on the On Load Event of the main form but this didn’t work.
I think that if I get the answer to question 3 then the code I previously used in question 1 might work.
Any help would be greatly appreciated. Thank you in advance.
A quick search yielded no results, so here goes. What is the easiest way to automatically tab to the next field once a user has entered the maximum number of digits in the current field?
For example, I have a form with the 3-digit area code in one field, followed by the 7-digit phone number (this was set up originally by someone else, I don't know why the area code and phone number are split up). Since these fields will always be the same length, what I'm wanting to do is automatically set focus to the next field once the user has entered 3 numbers in the area code field, without their having to hit the 'Tab' key. Any thoughts?
everytime i try to tab from my subform, it creates a new record for that subform. Also, about the subform, the control that links the main form and sub form is unique. I have now set my Cycle property on my subforms and forms to Current Record. How can I tab from the subform to the main form and vice versa?
I want to populate the Class Code field based on the class they select. The code works fine except that the Class Code field does not update until after I tab past it. There is a field in between Classes and Class Code so I have to tab 3 times before the textbox populates. I expected the textbox to populate immediately after I selected the class. I also tried putting the code in the On Click event of the combobox but that didn't work either.
If I just keep clicking on different classes I'd like the class code to change each time without having to tab to another field. Is that possible? What am I doing wrong?
This is my first post to these forums, however I have leeched so much information off of all you guys that I can't even begin to express my gratitude. So, now, onto my problem... I'm developing a form for our call centre people to enter information regarding customer returns. Customer orders are placed on one of two systems. In my form, when the person is entering info, I have a drop down box to choose between the two systems, which calls up a respective subform to enter system-specific information. The problem I have is that I can use tab to enter the subform, however I can't use it to get out. There are two records in the subform - order date and order number. After I enter info into these 2 textboxes and try to tab out, it seems that the subform goes to a new record. How can I get my form to tab into the next required field on the main form? Hopefully this makes sense, I just read through it and its kinda questionable. Thank you very much in advance.
I have a form with a number of fields and buttons on it. The form is opened in "add new record" mode. I have noticed that when I move from the last field in the tab order to the first field in the tab order it saves an entry in the database.
This is causing me problems because when users move from the last field in the tab order to the field in the tab order an entry is saved to the database but it by passes all the data checks ensuring that certain fields have been filled-in etc.
I don't know why the movement between these two fields is causing an entry to be saved. I don't have code associated with either of these objects. I aslo changed the last field in the tab order to a different field and it still happens.
Any ideas or suggestions would be greatly appreciated.
I have searched this site and tried several things over the last 3 days and am getting frustrated. All of my forms are built from existing tables. I have a main form (frmevent) with the primary key being EventID. I have many "continuous" subforms e.g. event type, initial action taken, initial outcome that the user can enter more then one record. My Event Type continuous subform has a cascading combo box. One combo box displays the Event Category and the other combo box displays the Event Types. I have the cascading combo working so that when the category is selected on those types that apply to it show up. If the user tabs to the next record and doesn't enter anything in it I want it to tab to the next sub form. I tried (please note that EventInitialActionTaken is the first field in the form) Private Sub EventInitialActionTaken_LostFocus() If IsNull(Me.EventInitialActionTaken) Then Me.Parent.[frmeventFsubform].SetFocus End If End Sub I am getting a run-time error on the form '2452' The expression you entered has an invalid reference to the Parent property. What does this mean and can anyone help. Thank you in advance.
Is there a way in data access pages to have where the user tabs to a numeric field in an existing record, that it highlights the data? Or....... is there a way to have currency values null instead of $0.00 in an existing record on a data access page?
The problem I'm having is: For my data access page, the user queries to pull up an appointment. The user then enters various amounts in different fields. I have the tab order set up ok, but when they tab to a field to add an amount collected, it tabs to the end of the $0.00 which makes the user have to backspace 3 times to enter data, or highlight and delete and then enter data....... All of this, of course, is time consuming.
These values are null, but show as 0 in my data access pages.
How can I get these to remain blank, or how can I get it to highlight the data in each field on tab?
I created a form based on head/detail/foot kind of setup.
Now in the detail I have a combo box and a textbox. Is it possible for me to set focus to the next line textbox after the combo box fires onExit trigger?
so for instance:
form is empty. Fill in textbox, choose from dropdown, and then on Exit the focus is set to the next line textbox.
I have a form with a tab control on it. The input for respective fields are placed inside the tab control, and I have the "Confirm" button placed outside, on the main form. Now I wanted to be able to navigate my focus from a control from inside to tab control, out to the Confirm button on the form, to allow smooth flowing data entry.
However, it seems like Access separates the tab indexes for the controls in the tab control and outside on the main form, so setting tab index does not work. I tried using the code ON LOST FOCUS and SET FOCUS;
Private Sub txtPurchaseNote_LostFocus() Forms![frm Imported]![cmdConfirmPurchase].SetFocus End Sub
But then a dialog box appears:
Run-time error '2110' Microsoft access can't move focus to the control cmdConfirmPurchase
I have an interesting Access problem. When doing a query, and it does not matter which Access file it is all of them do it, if you tab out or click to another screen, sometimes, the query will stop. I have tried many different network related fixes but no luck. I am thinking the issue is with Access. I have no issue with Excel on Access files.
Newbie Access user here, with what I hope is a fairly easy task-- I have a form which contains fields for info about clients and a subform which has only one field for a corresponding video tape number. Is there any way to limit the record for this subform to one single entry, so that when I hit Tab after entering the single number, the second record in the subform will not appear, but rather I can jump to the next record in the main form? If not, then can I just tab through the main form, into the sub form and then onto the next record? Is there a shortcut to create the next record other than having to manually mouse click the next record arrow at the bottom of the form?
I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page.
I have a report that lists states and cities within the states. When a state name happens to be at the end of the page the individual cities appear on the next page with no State heading. I solved the second page problem by setting the "repeatSection = Yes" in the Section Header (though I haven't shown that in the example below).
But the previous page (which just shows the State Name and no cities looks dumb. Is there some sort of solution.?? (Actually I would also like any State that continues to a next page to not just have the state name but something like " Colorado (Continued)" Is there anything I can do in VB to make a page break if the section is going to print but therer isn't enough room for one detail line?
This is what I currently see
Alaska Ancorage Prudo Bay
California Whittier Anaheim
Colorado ------------------------Page Break --------------------------------- Denver Pueblo Colorado Springs
If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to not display the page header on the last page?
I have a report where the last page shows the page header - and the field/column labels on the page header - but for which there is no detail records left to display - on the last page. There is report footer information that should display. It just looks weird because the field/column labels show at the top of the page - but there is no data remaining to print under them on that last page.
I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.
MSODSC.DataPages(0).Recordset.Filter="AppID = 3";
My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.
