Popout Form for Task Entry

[Big_Apple]

Can this be done...



Form One: Contact Details ( See, CREATE TASK BUTTON ).

Form Two: Task Popout

What I am attempting to do is have a Button on the "Contact Details" form when selected will open a second form called "Task Popout". The Task Popout forms purpose is to associate tasks to the contact record that I can input, they are inventoried below, and later delete tasks as they are completed.

I would also create a report for the entire Contact Details table so I have insight on what tasks are due for each contact.

Also, this can't be done using macros because corporate won't permit them.

Thoughts?

[Welshgasman]

Well even the wizards generate code, so you are pretty much out of luck, in that case. I assume that form has no validation whatsoever, in that case?

[June7]

No macros but you can use VBA?

Why delete data? Just mark task "completed".

[Big_Apple]

I would say that VBA can't be used. Can a person create a popout as noted above?

[June7]

Not without macro or VBA.

How does corporate enforce this policy? Maybe you need to talk to IT?

Seems often apps using macros can be rejected by firewalls but VBA will pass.

Welsh, some validation can be done with properties.

[Welshgasman]

I would say that VBA can't be used. Can a person create a popout as noted above?

No, as mentioned even if you use the wizard to create that button and follow through to open a form, that will generate VBA.
I just tried it now and it generated an embedded macro and no way yo change to VBA. That appears not to work for embedded macroes.

[Micron]

Maybe an embedded macro would pass, but I don't think I've ever used them so who knows? Besides, can't all of this be avoided by making the task list a subform? Then you can append/edit tasks in the subform. I agree - flag the task as completed instead. Even better, give it "Complete" as a task status and have a LastUpdate Date field. You can only date stamp the last task status that way. If you need to maintain task status history you need a table for that.

[June7]

Welsh, even embedded macros can be converted to VBA. Form in design view, choose "Convert form's macros" from ribbon.

I almost never use wizards because they do things I don't like.

[Welshgasman]

Welsh, even embedded macros can be converted to VBA. Form in design view, choose "Convert form's macros" from ribbon.

I almost never use wizards because they do things I don't like.

Thank you June7. I was looking in the macro views.
Using the wizard for form actions, I could not see how to open in acDialog mode?

[June7]

It's a WindowMode option of OpenForm embedded macro. Make this change after wizard builds macro.

I just did testing with Outlook. Files with macros or VBA are blocked unless you zip them. Zip file prompts a warning but the file passed. Opened zip folder and moved db to local folder just fine.