Styjun

Is tuition reimbursement a good idea if you have to stay with the job

Keeping track of theme when improvising

In Pandemic, why take the extra step of eradicating a disease after you've cured it?

Print "N NE E SE S SW W NW"

How to represent jealousy in a cute way?

Is the first of the 10 Commandments considered a mitzvah?

Identification: what type of connector does the pictured socket take?

Fastest way from 8 to 7

Why would a home insurer offer a discount based on credit score?

I sent an angry e-mail to my interviewers about a conflict at my home institution. Could this affect my application?

List of interesting Quantitative Finance podcasts

What do you call the action of "describing events as they happen" like sports anchors do?

How can religions without a hell discourage evil-doing?

Which are the methodologies for interpreting Vedas?

If absolute velocity does not exist, how can we say a rocket accelerates in empty space?

Undocumented incompatibility between changes and siunitx?

How to deal with an excess of white-space in a CRM UI?

Approach sick days in feedback meeting

What is the theme of analysis?

Why does there seem to be an extreme lack of public trashcans in Taiwan?

Tiffeneau–Demjanov rearrangement products

Remove the small black rectangle that appears at the end of environment

Purpose of cylindrical attachments on Power Transmission towers

Boss making me feel guilty for leaving the company at the end of my internship

Go to a record in an Access 2016 form that opens in Datasheet

How to list the tables in a SQLite database file that was opened with ATTACH?Datasheet view query in sub form determining controls' status on parent formAccess form to use SQL Server query/stored procedure to populate a fieldSelect next record on datasheet subform from separate form?Selections do not tally with the number of records moved — Access 2010MS Access form - New record on open and after saving recordSearch form with datasheet displayMS Access loading values from a different table to control source in datasheet formMS Access 2010: Is it possible to link datasheet subformsSetFocus to a control in a subform datasheet view where checkbox = True

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

This program is designed to allow a food pantry to take attendance. To that end,

1. The admin enters attendance by selecting names from a table called Dat_Household_Member keying on a field called IsHeadOfHouseHold (true or false).




2. When the admin checks a box called Attended a record is written to a temp table which is cleared after the final report is written.




3. The admin doesn't complete entering attendance in one sitting. So, I need to take her back to where she last was.




4. I have a temp table into which the Household_ID is placed after each record is appended to the temp table. This way I know which record was edited last - easily.

I want to open the form - called SigninSheet-Simplified and go to that record while the form is in datasheet mode:

• 
  OpenForm with a where clause doesn't do it. I get on one record. I want to open the form and go to that row. Should be simple.


• 
  FindRecord won't accept a variable.


• 
  GoToRecord doesn't either.


• 
  RunQuery runs the query outside the form.


• 
  DoCmd.RunSql returns an error even through the query from which the SQL comes works fine.

Here's the SQL -

SELECT dat_household_member.household_id, dat_household_member.[full-name] 
FROM dat_household 
INNER JOIN dat_household_member 
 ON dat_household.id = dat_household_member.household_id 
WHERE (((dat_household_member.household_id)=[forms]![MainMenu]![InProgress]) 
 AND ((dat_household_member.is_head_of_household)=True));

I'm open to any idea that will get this done as simply as possible.

sql forms ms-access

share|improve this question

edited Mar 25 at 0:46

Parfait

57.1k105173

asked Mar 25 at 0:11

falcon NAfalcon NA

1

add a comment | 

0

This program is designed to allow a food pantry to take attendance. To that end,

1. The admin enters attendance by selecting names from a table called Dat_Household_Member keying on a field called IsHeadOfHouseHold (true or false).




2. When the admin checks a box called Attended a record is written to a temp table which is cleared after the final report is written.




3. The admin doesn't complete entering attendance in one sitting. So, I need to take her back to where she last was.




4. I have a temp table into which the Household_ID is placed after each record is appended to the temp table. This way I know which record was edited last - easily.

I want to open the form - called SigninSheet-Simplified and go to that record while the form is in datasheet mode:

• 
  OpenForm with a where clause doesn't do it. I get on one record. I want to open the form and go to that row. Should be simple.


• 
  FindRecord won't accept a variable.


• 
  GoToRecord doesn't either.


• 
  RunQuery runs the query outside the form.


• 
  DoCmd.RunSql returns an error even through the query from which the SQL comes works fine.

Here's the SQL -

SELECT dat_household_member.household_id, dat_household_member.[full-name] 
FROM dat_household 
INNER JOIN dat_household_member 
 ON dat_household.id = dat_household_member.household_id 
WHERE (((dat_household_member.household_id)=[forms]![MainMenu]![InProgress]) 
 AND ((dat_household_member.is_head_of_household)=True));

I'm open to any idea that will get this done as simply as possible.

sql forms ms-access

share|improve this question

edited Mar 25 at 0:46

Parfait

57.1k105173

asked Mar 25 at 0:11

falcon NAfalcon NA

1

add a comment | 

This program is designed to allow a food pantry to take attendance. To that end,

1. The admin enters attendance by selecting names from a table called Dat_Household_Member keying on a field called IsHeadOfHouseHold (true or false).




2. When the admin checks a box called Attended a record is written to a temp table which is cleared after the final report is written.




3. The admin doesn't complete entering attendance in one sitting. So, I need to take her back to where she last was.




4. I have a temp table into which the Household_ID is placed after each record is appended to the temp table. This way I know which record was edited last - easily.

I want to open the form - called SigninSheet-Simplified and go to that record while the form is in datasheet mode:

• 
  OpenForm with a where clause doesn't do it. I get on one record. I want to open the form and go to that row. Should be simple.


• 
  FindRecord won't accept a variable.


• 
  GoToRecord doesn't either.


• 
  RunQuery runs the query outside the form.


• 
  DoCmd.RunSql returns an error even through the query from which the SQL comes works fine.

Here's the SQL -

SELECT dat_household_member.household_id, dat_household_member.[full-name] 
FROM dat_household 
INNER JOIN dat_household_member 
 ON dat_household.id = dat_household_member.household_id 
WHERE (((dat_household_member.household_id)=[forms]![MainMenu]![InProgress]) 
 AND ((dat_household_member.is_head_of_household)=True));

I'm open to any idea that will get this done as simply as possible.

sql forms ms-access

share|improve this question

edited Mar 25 at 0:46

Parfait

57.1k105173

asked Mar 25 at 0:11

falcon NAfalcon NA

1

SELECT dat_household_member.household_id, dat_household_member.[full-name] 
FROM dat_household 
INNER JOIN dat_household_member 
 ON dat_household.id = dat_household_member.household_id 
WHERE (((dat_household_member.household_id)=[forms]![MainMenu]![InProgress]) 
 AND ((dat_household_member.is_head_of_household)=True));

share|improve this question

edited Mar 25 at 0:46

Parfait

57.1k105173

asked Mar 25 at 0:11

falcon NAfalcon NA

1

share|improve this question

edited Mar 25 at 0:46

Parfait

57.1k105173

asked Mar 25 at 0:11

falcon NAfalcon NA

1

edited Mar 25 at 0:46

Parfait

57.1k105173

edited Mar 25 at 0:46

Parfait

57.1k105173

asked Mar 25 at 0:11

falcon NAfalcon NA

1

asked Mar 25 at 0:11

falcon NAfalcon NA

1

1 Answer
1

active

oldest

votes

0

IIUC - Simply use SearchForRecord with a where condition after opening datasheet form:

DoCmd.OpenForm "SigninSheet-Simplified"

DoCmd.SearchForRecord acDataForm, "SigninSheet-Simplified", acFirst, _ 
 "household_id = " & [Forms]![MainMenu]![InProgress]

share|improve this answer

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55329810%2fgo-to-a-record-in-an-access-2016-form-that-opens-in-datasheet%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

IIUC - Simply use SearchForRecord with a where condition after opening datasheet form:

DoCmd.OpenForm "SigninSheet-Simplified"

DoCmd.SearchForRecord acDataForm, "SigninSheet-Simplified", acFirst, _ 
 "household_id = " & [Forms]![MainMenu]![InProgress]

share|improve this answer

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173

add a comment | 

0

IIUC - Simply use SearchForRecord with a where condition after opening datasheet form:

DoCmd.OpenForm "SigninSheet-Simplified"

DoCmd.SearchForRecord acDataForm, "SigninSheet-Simplified", acFirst, _ 
 "household_id = " & [Forms]![MainMenu]![InProgress]

share|improve this answer

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173

add a comment | 

IIUC - Simply use SearchForRecord with a where condition after opening datasheet form:

DoCmd.OpenForm "SigninSheet-Simplified"

DoCmd.SearchForRecord acDataForm, "SigninSheet-Simplified", acFirst, _ 
 "household_id = " & [Forms]![MainMenu]![InProgress]

share|improve this answer

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173

DoCmd.OpenForm "SigninSheet-Simplified"

DoCmd.SearchForRecord acDataForm, "SigninSheet-Simplified", acFirst, _ 
 "household_id = " & [Forms]![MainMenu]![InProgress]

share|improve this answer

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173

answered Mar 25 at 1:01

ParfaitParfait

57.1k105173