Search results

I created a custom shortcut menu for the report which seems to be working. Will do more testing later.

My Data Entry form is opened in acDialog because I don't want users to click behind it and do other things in the DB at the same time. I need to ensure that is the only thing they are working on at that moment. And, opening it normally will mean someone is going to accidentally click to the...

It seems there are two options (that I am aware of). Given that Print Preview is required to show the report accurately, including the Cancel on No Data in the subreports so they disappear: Since Print Preview can not display my buttons like Report View could: move Print, Send to Outlook from...

I think I figured it out: there is a conflict between windows opening in acDialog. Not sure I'll be able to sort this one out as the report is opened from an acDialog form. That means if I don't open the Report in acDialog, it opens in the background. And, as long as the report is open in Print...

Increased to 5000. Form opens while in Report View, nothing happens while in Print Preview. Tried opening form in dialog first - Print Preview then waits until you close the form to appear. Opening Normal, both open.

I might have to move the buttons off the report and onto the form - one for Print Preview, and the other to Print. The user would use Print Preview to view what it will look like in its current state, then close and hit Print on the form. Not the best workaround.

Thanks Colin. After what event does the timer start? Edit: test shows form opens during Report View, but not during Print Preview. If this is a fundamental Access restriction, I'm going to have to find another way.

Method I'm referring to is described here: https://answers.microsoft.com/en-us/msoffice/forum/all/can-i-hide-a-subreport-when-its-blank-to-save/9e4b0fdc-4780-e011-9b4b-68b599b31bf5 Edit: actually there's an idea at the bottom of that thread that I'm going to check out.

The latest version of my report uses a subreport to properly display the data structure. In order to prevent subreport headers from appearing when there is no data, I am using Cancel = True on the No Data event. Code doesn't run in Report View, so only Print Preview can display this report...

Yes.

Does that include using IIf and Nz on query fields?

Hi all, I have a report that I must show in Print Preview as Report View does not display my subreports accurately. Unfortunately, Print Preview means my on-form command buttons disappear, so I have reluctantly enabled the right-click menu to print and send as attachment. Two problems. One, I...

I'm not sure we're talking about the same thing. All of that is possible whether or not one uses table-level lookups. The table-level lookups are handy for admins who understand them. All it is is an auto-lookup instead of seeing values in your tables. It's an optional convenience feature. Now...

On the form, no - check out my DB and you'll see what I mean with the status. It's like Northwind.

It's nice to be able to change a value without having to consult the lookup tables yourself. There are fields on forms I don't allow changes to once a record is completed - there is no control for the "Status" field for example - unless you ask the admin nicely. :)

Another way is to create a tblReports with the following fields: ReportID ReportName (actual names of the report objects) ReportDescription tblReports is set as the record source for the form where the combo box resides, maybe a special popup frmReports. After update of the combo box which...

You know, I've read this a couple of times, but it just isn't clicking for me. I'm just not convinced it's a big deal if you know what you're doing and it can in fact have some benefits for an admin.

Am I the only one who read "Hello everyone" in Steve Bishop's voice?

What happens when you hit Windows + R and paste in \\Sjo2054\shared\Data_Files\ and hit ok?

Yes, it's the equivalent. This sounds like a design issue and there are solutions. For example, you may want two ways to get to the popup form: one button to add a new record, and another to view existing. I use a read-only record list with a link to open each record, in addition to a "New"...