MS Access Newbie Trying to fill data based on another cellAccess 2010 Form Data Filtering Error In Navigation...
How can I write humor as character trait?
Why is this estimator biased?
Why can Carol Danvers change her suit colours in the first place?
Can the US President recognize Israel’s sovereignty over the Golan Heights for the USA or does that need an act of Congress?
How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?
PTIJ: Haman's bad computer
Strong empirical falsification of quantum mechanics based on vacuum energy density
Why did the EU agree to delay the Brexit deadline?
Sums of entire surjective functions
Can disgust be a key component of horror?
How should I respond when I lied about my education and the company finds out through background check?
On a tidally locked planet, would time be quantized?
Store Credit Card Information in Password Manager?
Plot of a tornado-shaped surface
Why Shazam when there is already Superman?
Fear of getting stuck on one programming language / technology that is not used in my country
Are Captain Marvel's powers affected by Thanos' actions in Infinity War
Is there a way to get `mathscr' with lower case letters in pdfLaTeX?
What should you do if you miss a job interview (deliberately)?
How to cover method return statement in Apex Class?
What exact color does ozone gas have?
What is the evidence for the "tyranny of the majority problem" in a direct democracy context?
How much character growth crosses the line into breaking the character
Pre-mixing cryogenic fuels and using only one fuel tank
MS Access Newbie Trying to fill data based on another cell
Access 2010 Form Data Filtering Error In Navigation WindowEnabling the User to Insert the Data in Access DatabaseEnforce referential integrity with linked tableMicrosoft Access Form - Auto Populate Form Field From Another FormMicrosoft Access 2003 - Multiple checkboxes to fill a text fieldConvert Access desktop application to Web basedAdd string to select query based on content of another field in Microsoft AccessLink To Another Record In a FLAT Access DatabaseMS Access: Validate field based on another recordhow do I copy data from one cell to another?
I'm attempting to create a table that is basically a company intranet staff directory and I have 6 office locations. 1 of the fields is the office phone number. I can't figure out how to copy the ph number across every row I want it in so I wondered if it was possible to have it auto fill based on the postcode field??
Basically if the postcode is 6000 then the next field should be 9222-0000. For post code 6100 the number is 9222-1111.
Honestly to go one step further both the postcode field and the phone number field could auto fill from the suburb field. If I could type it once then any entry that had the suburb would get that postcode and that phone number.
Win 10MS Access 2016 and almost no experience using Access if that wasn't already apparent.
microsoft-access
asked 2 mins ago
NathanielNathaniel
741313
add a comment |
I'm attempting to create a table that is basically a company intranet staff directory and I have 6 office locations. 1 of the fields is the office phone number. I can't figure out how to copy the ph number across every row I want it in so I wondered if it was possible to have it auto fill based on the postcode field??
Basically if the postcode is 6000 then the next field should be 9222-0000. For post code 6100 the number is 9222-1111.
Honestly to go one step further both the postcode field and the phone number field could auto fill from the suburb field. If I could type it once then any entry that had the suburb would get that postcode and that phone number.
Win 10MS Access 2016 and almost no experience using Access if that wasn't already apparent.
microsoft-access
asked 2 mins ago
NathanielNathaniel
741313
add a comment |
I'm attempting to create a table that is basically a company intranet staff directory and I have 6 office locations. 1 of the fields is the office phone number. I can't figure out how to copy the ph number across every row I want it in so I wondered if it was possible to have it auto fill based on the postcode field??
Basically if the postcode is 6000 then the next field should be 9222-0000. For post code 6100 the number is 9222-1111.
Honestly to go one step further both the postcode field and the phone number field could auto fill from the suburb field. If I could type it once then any entry that had the suburb would get that postcode and that phone number.
Win 10MS Access 2016 and almost no experience using Access if that wasn't already apparent.
microsoft-access
asked 2 mins ago
NathanielNathaniel
741313
I'm attempting to create a table that is basically a company intranet staff directory and I have 6 office locations. 1 of the fields is the office phone number. I can't figure out how to copy the ph number across every row I want it in so I wondered if it was possible to have it auto fill based on the postcode field??
Basically if the postcode is 6000 then the next field should be 9222-0000. For post code 6100 the number is 9222-1111.
Honestly to go one step further both the postcode field and the phone number field could auto fill from the suburb field. If I could type it once then any entry that had the suburb would get that postcode and that phone number.
Win 10MS Access 2016 and almost no experience using Access if that wasn't already apparent.
microsoft-access
microsoft-access
asked 2 mins ago
NathanielNathaniel
741313
asked 2 mins ago
NathanielNathaniel
741313
asked 2 mins ago
NathanielNathaniel
741313
asked 2 mins ago
NathanielNathaniel
741313
asked 2 mins ago
NathanielNathaniel
741313
741313
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1416558%2fms-access-newbie-trying-to-fill-data-based-on-another-cell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1416558%2fms-access-newbie-trying-to-fill-data-based-on-another-cell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
