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...

Hi Neil, Just to make sure I am understanding you correctly -- if I have the ID entered in a textbox on the form, are you saying I should be able to use one table wherein a new record is created for each residence number of each person? Cheers, Elaine

Sorry for not having been clear about the relationship set-up (I am still feeling fuzzy about this myself, particularly with the suggestion to explore a new set-up from that which I originally conceptualized)... You are indeed correct in assuming that multiple people can share the same...

Also, the residence ID is something we create -- and it is replicated across people. For example, an individual may only have residence R1 or may have multiple residences R1, R2, R3, R4, R5, etc. The residence numbering scheme starts over for each individual. Initially I thought the...

Actually, in this particular database we are not entering anything to identify a person as an individual other than the person's unique ID which is not an autonumber ID but a unique ID we have created and need to use to ultimately link all databases of information on this cohort. Thus I don't...

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 a similar problem and am wondering if you have found a solution. I am not exactly sure what you mean by 'filtered.' In my case, the problem occurs on combo boxes where SelectCase is designated - which perhaps is akin to the filtering you refer to. If you have solutions, please post.

I program an afterupdate event to setfocus to the next subform and then GotoControl to move the user to the first control on the subform. For example: Forms!MH_Form.SetFocus DoCmd.GoToControl "combo5" Good Luck!

Do you have this form opening automatically upon startup? I have had similar problems when trying to direct a form to open upon startup. The solution has only come for me when I play with the form by saving it in the position I wish to open it in. Access is very testy about this, but...

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...

I am dealing with the same issue, but am trying to use a command button on a subform to open a new record for the form. Can I use the code Mile-o-Phile suggested? Do I need to set the focus to the form first, before inserting DoCmd.OpenForm "MyName", , , , acFormAdd ?? Cheers, e.

EXCELLENT!!! This was exactly what I was looking for but had not encountered it until you brought it to my attention. I have reprogrammed and the Select Case command works very well. Thank you, thank you!!! :D

thank you for the suggestion, but i already re-created from an earlier version...all seems to be running fine now...i just need to figure out how to solve the next problem (see my other thread on filling in value of control), which I now see was how I originally locked up the form/subform...

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...

Fortunately i did save a back-up, albeit of an older version. What I have been able to do so far was delete the form that seemed to be corrupted and copy the old one in, in its place. I think it will work out just fine, with a minimal amount of re-programming. Now if I could only remember...

Ouch--that's what I was afraid of...thanks for letting me know...at least I can say I'm not the only one to have locked up The Great Access! Cheers, e.

I should have specified earlier--I cannot open in design view or otherwise...thanks for the thought though...