Search results

Greetings, Simply attempting to format an unbound textbox as either a date or a time only. A user would rightfully assume that when one formats a textbox as verbatim "Short Date" or "Short Time" in the design mode, the formatting would actually be a "Short Date" only---or a "Short...

MajP, Very clever. Awesome solution. This will clean up so much code in my app. I can't see how the raise event method would be any cleaner, or rather, as versatile. If you think the raise event method would be even simpler yet, I would be curious on hearing more about that. Thanks for the...

Hi, A common feature my apps require is getting a user selected value from a universal popup form and using that value in a sub. I have been lousely designing such forms where they are passed an input (open args) and based on that arg, the form passes to the next function in the stack. Heres a...

@MajP @arnelgp Two unique and awesome solutions. I find MajP's solution more flexible, but appreciate both answers. Thanks a lot!

Hi, I once saw a popup form being used like a class and multiple instances of that form could be instanced. This is a bit different from my question, but I have a feeling there are ties. I have 2 subforms on a main form. Both subform controls have the same source form. I would like to call a...

Now I remember the last time I wasted my time with this simple petty feature... To reference fields in these events you must capture the field value in a control on the report. Then reference the control value in VBA. Yeah--- very intuitive. Bravo to Microsoft on that peculiar nuance- probably...

What is the point of detail events (or any of the report events) if the report can't find your fields anyhow. A report is built off a recordsource... which as fields... therefore its reasonable to expect the events should capture those fields. Apparently not. Desired outcome: - Set a label's...

The report has to be open to set the object. Unless someone has a better way to get the paper size of a report.... which seems relatively trivial.

Somehow after the 100th try, I was able to get a browser control to display the PDF which is using Adobe Reader for IE. My next step to complete this is to get details about the report's page size and size the control to an aspect that better fits the underlying report's page dimensions. Thanks

Sorry for bombarding the forums today lol... I am trying to get the paper size of a report and return the acPaperSize to see what the report's current paper size is set to for printing. The result returned for a report with 'Letter' paper size in page setup gives value of 32512 when it...

I have a form similar to what you have. but I want the subform that shows the report to be exactly as I would print it. The only solution appears to be embedding a PDF in the form, which is a real PITA apparently.

Yeah, my report doesn't look the same as it would in print preview, and that's what i'm trying to achieve. I didn't think this was possible.

@MajP OooOO that looks nice. But I am skepticial... Are you certain that subform control is actually displaying the report in 'Print Preview' and not in Report View? I was unable to figure out how to get the subform control to display in Print Preview - even changing .DefaultView in the...

....

Yes, on both accounts - The browser control is trash. And by that, I mean it would rather download or open the file in chrome then even display it inside the control. The form loads and a prompt displays for 'Open' or 'Save'. You know, that one from internet explorer back in like 2003.

Displaying a PDF in a form is a real joy. Web Browser control - simply wants to open it in Chrome. MS couldn't update the web browser control in the last 20 years and ditch IE. Glad it's million's of user's license fees are being put to good use. (y)(y)(y) Using adobe reader - might as well...

This is a stretch... Can I display the a report in a subform control on a main form in 'print preview' mode? I'm trying to display a realistic, document-like , preview of a report. Converting to a .PDF and serving that seems like an unnecessary step and also a headache since Access makes it a...

Hi, I have a form I am trying to dynamically size based on a sub-report. The form opens, a report is loaded into the subform control (this is dynamic, can be any report), the form is sized appropriately to the report. For example, if a 4x6" report is loaded, the form detail is changed to size...

Uncle gizmo, I resorted to killing this feature. sadly, I have to work around access' flaws. I'm open to seeing if Solutions exist but not eager. thanks merry Christmas man!!

I have been under the impression that a click event was not fireable until any current code execution was complete. I.e. If a button once then again, the click event cannot be re-fired until execution of the first instance is complete. Apparently this isn't the case. That is improper and...