accessinuganda
New member
- Local time
- Today, 08:40
- Joined
- Jun 1, 2013
- Messages
- 1
Hi,
I'm using Access to create a data interface for a country-wide survey being run in Uganda - our surveyors use tablets. So, I'm in Uganda, the survey is set to start in a few days, but I'm still struggling with a specific problem. Clearly, I'm desperate for help! I just started using Access when I started creating this survey, and have copied other people's VBA codes when necessary, I don't really understand it
My situation: In many parts of my survey, I have "qualification forms" where you if answer a question with "yes" (e.g. have you undergone any household shocks?) you go to one page (e.g. a shocks module) and if you choose "no" then you skip to the next section. Say that first form is Shock-Qual, then the second is Shock, and next module is Assets. I've coded the skip through simple "If Then" macros within the "next" button in Shock-Qual.
My problem: Say I choose "yes" in Shock-Qual, in order to go to Shock, begin filling out Shock, and then realize "oh actually there are no shocks." So I hit the "back" button and go to Shock-Qual, and change to "No." now when I hit the forward button, it will take me to the Assets page. At first this would leave the Shocks page open, but then I realized I can program a "close form" command into the forward button macro, which closes the Shock form. However, if I do that, the record I 'accidentally' filled out on the Shock page saves when the Shock page closes, since it is now dirty.
That's the problem. So basically I want to put something in the forward button on my Shock-Qual form (and other similar qualification forms) that says "if the record in the Shock form is dirty, and I'm choosing "no"within the Shock-Qual form, please close the Shock form without saving that dirty record." Either than or tell Access something like "if record in Shock-Qual says "no," wipe all data from the Shock able."
I know I'm not speaking in program speak here, and I'm sorry. If you have any thoughts on this, please help! I'm don't have a lot of programmers around in Uganda to turn to for help...
Thanks!
I'm using Access to create a data interface for a country-wide survey being run in Uganda - our surveyors use tablets. So, I'm in Uganda, the survey is set to start in a few days, but I'm still struggling with a specific problem. Clearly, I'm desperate for help! I just started using Access when I started creating this survey, and have copied other people's VBA codes when necessary, I don't really understand it
My situation: In many parts of my survey, I have "qualification forms" where you if answer a question with "yes" (e.g. have you undergone any household shocks?) you go to one page (e.g. a shocks module) and if you choose "no" then you skip to the next section. Say that first form is Shock-Qual, then the second is Shock, and next module is Assets. I've coded the skip through simple "If Then" macros within the "next" button in Shock-Qual.
My problem: Say I choose "yes" in Shock-Qual, in order to go to Shock, begin filling out Shock, and then realize "oh actually there are no shocks." So I hit the "back" button and go to Shock-Qual, and change to "No." now when I hit the forward button, it will take me to the Assets page. At first this would leave the Shocks page open, but then I realized I can program a "close form" command into the forward button macro, which closes the Shock form. However, if I do that, the record I 'accidentally' filled out on the Shock page saves when the Shock page closes, since it is now dirty.
That's the problem. So basically I want to put something in the forward button on my Shock-Qual form (and other similar qualification forms) that says "if the record in the Shock form is dirty, and I'm choosing "no"within the Shock-Qual form, please close the Shock form without saving that dirty record." Either than or tell Access something like "if record in Shock-Qual says "no," wipe all data from the Shock able."
I know I'm not speaking in program speak here, and I'm sorry. If you have any thoughts on this, please help! I'm don't have a lot of programmers around in Uganda to turn to for help...
Thanks!