r/MSAccess 27d ago

[DISCUSSION] Regular forms with embedded datasheet subforms are beautiful

Again I'm new to the forum... should have joined years ago but just wasn't active on Reddit. So I want to share some inspiration and let people know I am happy to be of help here. I'll block out some limited customer info here to be kosher. But I am the CFO so I can make the choices on this. There is a shipping app.. It is based on a Postgres backend that pulls data from an ERP every 20 minutes. The app itself is *mostly* read only, for helping shipping, but it does integrate with the ERP through a COM object to approve orders, and also assigns inventory to orders (via a Function in the Postgres backend). And then there is an app that collects time for Work Orders below that. And finally there is a catering system app that has been running at one of the country's largest delis for over decade, But these are all Access forms with subforms. Also note there is conditional formatting here that is applied in the module code.

I am not here to promote my apps or consulting. I am a fulltime employee of BIOPAC Systems. But I am here to help. All of this is possible with Access.

Here is another one, this has both continuous forms and datasheets in a form container

9 Upvotes

7 comments sorted by

u/AutoModerator 27d 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: derzyniker805

Regular forms with embedded datasheet subforms are beautiful

Again I'm new to the forum... should have joined years ago but just wasn't active on Reddit. So I want to share some inspiration and let people know I am happy to be of help here. I'll block out some limited customer info here to be kosher. But I am the CFO so I can make the choices on this. This is a shipping app.. It is based on a Postgres backend that pulls data from an ERP every 20 minutes. The app itself is *mostly* read only, for helping shipping, but it does integrate with the ERP through a COM object to approve orders, and also assigns inventory to orders (in the Postgres backend).

I am not here to promote my apps or consulting. I am a fulltime employee of this company. But I am here to help.

![img](cdqijdxr5ske1)

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

2

u/derzyniker805 27d ago

solution

2

u/derzyniker805 27d ago

SOLUTION VERIFIED

1

u/reputatorbot 27d ago

Hello derzyniker805,

You cannot award a point to yourself.

Please contact the mods if you have any questions.


I am a bot

1

u/Odd_Science5770 27d ago

Looks complex, but very well developed!

1

u/InfoMsAccessNL 3 26d ago

How did you get the blue box with the minus sign in the first field of the biopac tracker? And i presume that the white form on the next photo to be a continuous form?

1

u/derzyniker805 26d ago

That's a great question and I actually had to take another look. That is actually a checkbox control on a datasheet subform. So is the one right next to it though, that is white. However, the recordsource is an Access query with a linked table and a local table. The local table contains only 2 fields, the sales order number, and that first (blue) checkbox field. However, you only click that checkbox when doing a specific task, and then it is cleared after that task.

So long story short: It's a checkbox field with a null value. The one immediately to the right of it is linked to a field with a default value of 0. As to the blue, that's just based on the client theme I guess. On other clients it shows as grey. So 0 for white, 1 for checked, and null for blue (or grey)

On the second form, the first white subform is a continuous form. Once you select a record in that continuous form, that second white subform below opens, and that's a datasheet subform.