Search results

I have a form with several subforms set up on a tab control. I am running into a problem where on every 2nd interview I go to enter, my 1st subform is skipped in the tabbing order and the user is jumped to the second subform (where they really needed to enter the first subform before moving to...

On the latest form I developed, there seems to be an issue with the command buttons. When one approaches the command buttons by tabbing through the form, there is no problem - i.e., one can press enter or return and the action of the command button is prompted. But a user is not always allowed...

I have a form with several subforms set up on a tab control. I am running into a problem where on every 2nd record/interview I go to enter, my 1st subform is skipped in the tab order and the user is jumped to the second subform (where they really needed to enter the first subform before moving...

On the latest form I developed, there seems to be an issue with the command buttons. When one approaches the command buttons by tabbing through the form, there is no problem - i.e., one can press enter or return and the action of the command button is prompted. But a user is not always allowed...

I have been reading the recent posts on relationship designations and earlier posts about many-to-many relationships (including the sample db) to see if I can determine how to set up my db correctly but I am at a loss. I have two tables thus far, each with information for individuals...

I am having trouble with a command button I created on the last of several subforms within a parent form. What I would like the command button to accomplish is, OnClick, for the user to be re-directed to the first control on the form and to then be able to add a new record on the form. Here is...

Forgive me if this has been discussed before...my quick search turned up nothing. What I would like to do is have the value of several controls be filled in based on the value of another (let's say gateway) control. I have done this before, but only when the value of the gateway control did...

I have a form with several subforms. The other day after adding some if-then code to automate the data entry a bit, I attempted to add a macro as well. After doing this, I received some strange messages about adding a module (which I was not trying to do but believe happened automatically...

I have a main form with several subforms embedded in it. At points in the mainform and several points in the subforms, the answers provided in combo boxes will determine where the user should be directed for the next portion of data entry. Thus far I have used macros to govern this. When an...

I am not sure how to accomplish what I seek to do and am hoping someone on this forum can help me. On my form, I have several text boxes, combo boxes, etc. In certain text boxes I would like to set a condition so that if a particular combination of letters are entered the user will be directed...

As i understand it from what I've found on a search of these pages, if an input mask is entered into a table it will not carry over to a form. Is this the case for all field properties?? If I set an input mask (e.g.) on...

As i understand it from what I've found on a search of these pages, if an input mask is entered into a table it will not carry over to a form. Is this the case for all field properties?? If I set an input mask (e.g.) on a form, will the entered data carry over into the table the way the...

Hello, I have posted this issue on the forms forum a couple of times but still have not found a solution to my problem. Perhaps the members of this forum can help... I have a tab control with a main form on the first tab and subforms on the remaining tabs (using Access2000). Each form is...

Hello, I have a tab control with a main form on the first tab and subforms on the remaining tabs (using Access2000). Each form is wider and longer than the screen itself, so if I want to modify the fields that are out of view when the form is centered on the screen, I must use the scroll bars...

Hello, I am working on a database with a form and subforms that reside on a tab control. I have been designing this database off and on for some time now, and so far each of the tests I have conducted with it have been successful. The other day it occurred to me that there could be a...

Hello, I have created two command buttons on my subform, one to set the focus back on the main form and the other to set the focus on the next subform. Here are the codes i have set up: Private Sub nextpgsub1_Click() Forms!Tabs2!R7toR9Form.SetFocus End Sub Private Sub prevpgsub1_Click()...

I have a main form on the first tab of a tab control and individual subforms that populate the remaining four tabs on a tab control. When I enter data into the main form, I can use the tab key to move my cursor from field to field and the part of the screen where the cursor moves to is...

I have a main form (TABS-2) that resides on the first tab of a tab control. I have four subforms linked to the main form (through the link child/master fields), each residing on a separate tab of the tab control. The subforms are named R4toR6form, R7toR9form, R10toR12form, R13toR15form. I...

Hello, I am a very new user of Access 2000 trying to do what seem to me to be big things. Here is my current dilemma: I am working with a form and several subforms I have set up on tab controls (just using drag and drop method) and would like to have a continuous tab order that starts on the...