Re: Read-only user & subforms
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: Wed, 19 Jan 2005 21:25:47 +0800
In the case of the report, you displayed that message on the main report.
You could do something like that on your main form, e.g.:
=IIf([Sub1].[RecordsetClone].[RecordCount]=0, "No records", Null)
Not ideal though: it flashes as the main form changes records and the
subform clears and loads its records, and it is not in the desired place.
You could also put a label behind the subform control (Format | Send to
Back, in Form Design view), and then toggle the Visible property of the
subform control. That would put the message in the right place, but I
suspect the flashing would be annoying.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "G. Wolfe" <GWolfe@discussions.microsoft.com> wrote in message news:446CA40E-AB91-4D07-A81D-2C2D8D59C6BF@microsoft.com... > Thanks for the reply... > > Is there a way to see a message that states that there are no records > available, something like this: > > =IIf(subfrmTrialCost_Details.Form.HasData,Null,"No Trial Expense has been > incurred at this time." > > I used this syntax on my reports when there wasn't anything available, but > I can't get this to work on my form. > > Thanks Again. > > "Allen Browne" wrote: > >> Unfortunately, this has been the way Access behaves for the last 5 >> versions. >> >> If: >> a) There are no records in a form, AND >> b) no new records can be added, >> then the Detail Section of the form goes completely blank. >> Read-only permission gives you condition b. >> >> The Form Header/Footer sections are still visible, but Access may not be >> able to get the values and display these correctly either. Details: >> http://members.iinet.net.au/~allenbrowne/bug-06.html >> >> >> "G. Wolfe" <GWolfe@discussions.microsoft.com> wrote in message >> news:66B72CDB-8B09-4BF8-8C56-9A90E433AEC5@microsoft.com... >> >I have just placed permissions on my database. I have found that the >> >group >> > of users that are set to Read-Only can not see my subforms if there are >> > no >> > records to display in the subform. The subform just appears as the >> > background color. If you switch to the next record on the main form >> > and >> > records exist for the subform, all the fields will appear. >> > >> > This looks very odd. I would like to see the fields even if the users >> > can't >> > add in new records... >> > >> > Any suggestions? >> > >> > Thanks in advance >> > G. Wolfe