auto-increment a field in MS Access 2016 form
I'm building a basic form and would like an id field in the form to auto-increment when the user opens the form (or could be a different event as well, just figured this is simplest).
I've written the following vb code, but there seems to be an issue:
Private Sub Form_Load()
lngNextID = DMax("[portfolio_id]", "table1") + 1
Form 1.portfolio_id = lngNextID
End Sub
table1 is the table I want the vb to look up for the next increment.
The name of my form is 'Form 1' and the field in that form that I'm looking to autoincrement is portfolio_id.
Any advice/modifications would be helpful, thank you.
ms-access ms-access-2016
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
add a comment |
I'm building a basic form and would like an id field in the form to auto-increment when the user opens the form (or could be a different event as well, just figured this is simplest).
I've written the following vb code, but there seems to be an issue:
Private Sub Form_Load()
lngNextID = DMax("[portfolio_id]", "table1") + 1
Form 1.portfolio_id = lngNextID
End Sub
table1 is the table I want the vb to look up for the next increment.
The name of my form is 'Form 1' and the field in that form that I'm looking to autoincrement is portfolio_id.
Any advice/modifications would be helpful, thank you.
ms-access ms-access-2016
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
Why don't you just use Autonumber type field? Exactly what is the issue - error message, wrong result, nothing happens? Syntax referencing form is not correct. Use Me.portfolio_id, However, if you load form with existing records, this code will replace existing data. Is this a multi-user db? Beware possibility of simultaneous users generating same ID.
– June7
Nov 26 '18 at 18:59
add a comment |
I'm building a basic form and would like an id field in the form to auto-increment when the user opens the form (or could be a different event as well, just figured this is simplest).
I've written the following vb code, but there seems to be an issue:
Private Sub Form_Load()
lngNextID = DMax("[portfolio_id]", "table1") + 1
Form 1.portfolio_id = lngNextID
End Sub
table1 is the table I want the vb to look up for the next increment.
The name of my form is 'Form 1' and the field in that form that I'm looking to autoincrement is portfolio_id.
Any advice/modifications would be helpful, thank you.
ms-access ms-access-2016
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
I'm building a basic form and would like an id field in the form to auto-increment when the user opens the form (or could be a different event as well, just figured this is simplest).
I've written the following vb code, but there seems to be an issue:
Private Sub Form_Load()
lngNextID = DMax("[portfolio_id]", "table1") + 1
Form 1.portfolio_id = lngNextID
End Sub
table1 is the table I want the vb to look up for the next increment.
The name of my form is 'Form 1' and the field in that form that I'm looking to autoincrement is portfolio_id.
Any advice/modifications would be helpful, thank you.
ms-access ms-access-2016
ms-access ms-access-2016
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
edited Nov 26 '18 at 18:42
Gustav
29.9k51835
29.9k51835
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
asked Nov 26 '18 at 16:08
user5831311user5831311
8918
8918
Why don't you just use Autonumber type field? Exactly what is the issue - error message, wrong result, nothing happens? Syntax referencing form is not correct. Use Me.portfolio_id, However, if you load form with existing records, this code will replace existing data. Is this a multi-user db? Beware possibility of simultaneous users generating same ID.
– June7
Nov 26 '18 at 18:59
add a comment |
Why don't you just use Autonumber type field? Exactly what is the issue - error message, wrong result, nothing happens? Syntax referencing form is not correct. Use Me.portfolio_id, However, if you load form with existing records, this code will replace existing data. Is this a multi-user db? Beware possibility of simultaneous users generating same ID.
– June7
Nov 26 '18 at 18:59
Why don't you just use Autonumber type field? Exactly what is the issue - error message, wrong result, nothing happens? Syntax referencing form is not correct. Use Me.portfolio_id, However, if you load form with existing records, this code will replace existing data. Is this a multi-user db? Beware possibility of simultaneous users generating same ID.
– June7
Nov 26 '18 at 18:59
Why don't you just use Autonumber type field? Exactly what is the issue - error message, wrong result, nothing happens? Syntax referencing form is not correct. Use Me.portfolio_id, However, if you load form with existing records, this code will replace existing data. Is this a multi-user db? Beware possibility of simultaneous users generating same ID.
– June7
Nov 26 '18 at 18:59
add a comment |
1 Answer
1
active
oldest
votes
Try with:
Forms("Form 1").portfolio_id = lngNextID
or the simpler:
Me!portfolio_id = lngNextID
However, that will update the opening record, so try setting the DefaultValue (a string):
Me!portfolio_id.DefaultValue = "'" & lngNextID "'"
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
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
});
}
});
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%2fstackoverflow.com%2fquestions%2f53485010%2fauto-increment-a-field-in-ms-access-2016-form%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try with:
Forms("Form 1").portfolio_id = lngNextID
or the simpler:
Me!portfolio_id = lngNextID
However, that will update the opening record, so try setting the DefaultValue (a string):
Me!portfolio_id.DefaultValue = "'" & lngNextID "'"
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
add a comment |
Try with:
Forms("Form 1").portfolio_id = lngNextID
or the simpler:
Me!portfolio_id = lngNextID
However, that will update the opening record, so try setting the DefaultValue (a string):
Me!portfolio_id.DefaultValue = "'" & lngNextID "'"
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
add a comment |
Try with:
Forms("Form 1").portfolio_id = lngNextID
or the simpler:
Me!portfolio_id = lngNextID
However, that will update the opening record, so try setting the DefaultValue (a string):
Me!portfolio_id.DefaultValue = "'" & lngNextID "'"
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
Try with:
Forms("Form 1").portfolio_id = lngNextID
or the simpler:
Me!portfolio_id = lngNextID
However, that will update the opening record, so try setting the DefaultValue (a string):
Me!portfolio_id.DefaultValue = "'" & lngNextID "'"
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
answered Nov 26 '18 at 18:45
GustavGustav
29.9k51835
29.9k51835
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53485010%2fauto-increment-a-field-in-ms-access-2016-form%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
Why don't you just use Autonumber type field? Exactly what is the issue - error message, wrong result, nothing happens? Syntax referencing form is not correct. Use Me.portfolio_id, However, if you load form with existing records, this code will replace existing data. Is this a multi-user db? Beware possibility of simultaneous users generating same ID.
– June7
Nov 26 '18 at 18:59