Search results

Hello all! Long time no post. Hope you are safe and well. I have a hyperlink field for the email address in my contacts table. On my Insertion Order form, the email address is used for a command button procedure to 1) save the Insertion Order to pdf and 2) attach that PDF to a new Outlook email...

Thanks, everyone. Got it working! MIB1019

It ALMOST works. Gets hung on the first .ColumnHidden = True when the main form first loads, requiring reset. I think it's not seeing the subform (subfrmIODetailsDates) until the form loads, so current event can't complete. Maybe needs an error trap? Code is below. Also, I'd love to shorthand...

Hello, all. Hope this fall day finds you well. Simple problem, I think. I want the On Current Event of a subform to trigger hiding/showing field columns on datasheet of a second subform. If subform1 field called Plot = "Weekly" Then These fields/columns on subform2 should be visible: AirWeek...

I am posting my code again. Added additional variables to complete the addnew to the lookup table. It's not working though. If I answer Yes, the standard comes up telling me to pick an item in the list. If I respond no, it gives me that message but allows me to move on. Here's the revised code...

Hi. Hope everyone is well. I'm not sure this is possible so I'm here to find out. I have a combo box on a form with LimitToList property set to Yes. The data for the list is from a lookup table. Sometimes the user will select an item from the list but then may need to add a little more info...

I figured it out! Thanks for reading.... MIB1019

Hello all, This is probably easy, but I cannot figure it out. I have this function in the module of a subform. The subform filters the data for a specific DetailID on the main form. All works correctly except that it is returning 's' for all dates in the underlying table, not filtering for...

Hello again. Let's forget that last post of mine, about the wrinkle. Got that working properly. Back to the airdates listbox. It works correctly to add the dates to tblIODetails_Dates, filling the new rows into the table after the user finishes selecting dates in the listbox on the dialog. Now...

Another wrinkle. My user wants easy easy input. Here is a wrinkle. Sometimes the Dates listbox needs to fill with Week starting dates, rather than daily dates. I've got that part working on the little form we've been addressing. Where the listbox fills with dates, there would be another field to...

Thank you everyone. Looks like it will work. Working on other aspects right now. Will keep you posted if any further questions...I suspect there will be ;)

Hi all, I am attaching a small db file to get some help with a new approach I am trying to take with my project. Currently, I have the user doing input to a similar dialog with a subform of dates (some of you have been a big help on that form). Anyway, he's finding that a little cumbersome, so...

Duh, that makes sense :)

arnelgp, for some reason, I get a function not defined error on calling it from the current event on the child form. The public function is in the code for the main (parent) form. Doing a recalc on the parent form in the afterupdate event of the air_date field on the subform works well though...

Recalc works, but applies to all calculated controls on the form... i.e. me.recalc. It can be direct it to parent form though, so it accomplished what I needed. Had to add a command to move the cursor to the next record in the subform. Thanks for the advice! Still wondering why requery didn't...

Sorry. Thought that since I had closed it as solved, this might not get any answers. Won't do it again...promise o_O

No, but thanks for that tip. I assume I can direct the recalc method to the parent form...?

The box under the Label 'Dates' updates to the values in the subform records. Its control source is =DatesToTextbox. The box would display 11/30, 12/2, 12/4, 12/7, 12/9, 12/11, returned from the function. Thanks! MIB1019

Hello all, I need to revisit a previous thread that mostly resolved my problem. I have this popup form with subform that user enters dates into. I have entered a series of dates in the subform. The Dates box on the main form is calculated ... =DatesToTextBox(), code as follows: Public...

Hello everyone! Hope today finds your safe and healthy. I need to revisit this thread and the update text box. One the first post in this thread, I sent a picture of my popup form to get dates. The txtDatesSelected textbox has a this function as its control source: Public Function...