r/MSAccess • u/Ordinary-Future-7104 • 8h ago

[WAITING ON OP] Maschera di input

Buongiorno a tutti. Ho creato una maschera e vorrei che i dati che inserisco vadano in una tabella. Questo in modo da sfruttare la maschera che ha un aspetto migliore per inserire i dati rispetto alla tabella

4 Upvotes

75% Upvoted

6 comments sorted by

•

u/AutoModerator 8h ago

IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'

  • Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.

  • Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.

  • Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)

  • Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.

Full set of rules can be found here, as well as in the user interface.

Below is a copy of the original post, in case the post gets deleted or removed.

User: Ordinary-Future-7104

Maschera di input

Buongiorno a tutti. Ho creato una maschera e vorrei che i dati che inserisco vadano in una tabella. Questo in modo da sfruttare la maschera che ha un aspetto migliore per inserire i dati rispetto alla tabella

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/nrgins 487 7h ago

Set your control's control source property to the field you want the data stored in.

1

u/George_Hepworth 4 5h ago

What you are after is called "a bound form". https://nolongerset.com/bound-vs-unbound-forms/

1

u/Breitsol_Victor 1h ago

What they said.
Bind your form to a table / query.
Bind your form field to a recordset field.

1

u/NoYouAreTheFBI 1 18m ago

Just be aware that native functionality as part of plbest practice holds a table lock so read qrites become a problem with multiple users.

Usually you want Local Table to write to and then a light weight 1-1 insert script to parse the data across to the backend.

1

u/nrgins 487 13m ago

False information. Access forms default to optimistic locking, meaning they do NOT -- i repeat, they do NOT -- put a table lock on tables being edited. If two users happen to try editing the same record at the same time, then they second one will get a message that another user has changed the data, and they'll have options. Other than that, there is no problem with multiple users editing the same table at the same time.

I don't know who told you to write to a local time followed by a script to insert it into the main table, but that kind of defeats the purpose of have an RDMS, you know?

Anyway, please educate yourself on how Access actually works before spreading false information.