Recent content by robbie_1234

I won't do it again. It wasn't because the answer wasn't fast enough or too my liking. After perusing the questions, I thought my question belonged in a different area of the forum. Please accept my apologies.

Thank you for your response. I know I am not being very clear but I am not very familiar with the access 2010 database, VBA and form design (despite several classes). The original survey was in response to a youth gathering. The paper/pencil form asked first if the respondent was a youth or...

I have designed a simple access form for a paper/pencil survey with help from this forum. I have so far been able to design the form so that certain areas of the form are invisible and the tab jumps appropriately to the next question if the respondent is a (1) youth without comments or (11)...

I appreciate your help. However, none of the rest of this short form has page breaks. I am trying to do this by using an if then statement. i.e. if the value in section a is 1 or 11 then jump to x. if the value in section a is 2 or 22 then jump to y.

Background: I have designed a form in Access 2010 (with your help) to compile survey responses. The form starts by identifying the respondents as: adult (assigned # 1); adult with comments (assigned # 11) and youth ( assigned # 2); youth with comments (assigned #22). If the box adult no...

Fixed it. GinaWhipp had a spelling error in her code: DoCmd. GoToContol "numAC02" instead of DoCmd.GoToControl "numAC02" I put this code in as an event procedure in the "On Lost Focus" line of the property sheet for each of the text boxes that might have responses. When I tested it...

I only want to change the tab order if comments are written in the text box. Otherwise I want to keep the tab order as combo box to combo box to speed up the data entry as most questions do NOT have comments. I will be the only one entering data using this form.

When I typed the words you indicated in the "on exit" event procedure box for that text box I get the following error message: "The expression OnExit you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure...

Thanks for your help!

What wording in VBa is used to move on exit from a text box in question one to a combo box in question 2 on my form? Question 1 textbox is named txtAC01; Question 2 combo box is named numAC02. I have tried several combinations of words "move to," "jump to" however, I get an error message. Thanks

My survey database has several tables: one for all questions and the second for all possible answers. I do have the adult/youth field coded so that only adult questions show when 0i chose adult and only youth questions show when I chose youth. Since most of the surveys have combo box answers...

I have designed a form in Access 2010 to handle results of a survey. The beginning of the form has a question if you are an adult or a youth. There are 2 adult possibilities; adults with combo box answers only to questions and no text comments (in this case the text box for comments that...

I have a continuous survey form based on 2 tables, lookup table and survey table. The lookup table shows all the possible questions the survey table all of the possible answers. Most of the questions are designed with a combox plus a textbox for comments. I would like to do two things. The...