Search results

Gasman thank you for your help... I actually decided to ditch my OCD and remove the field from my report header since the same field was in the detail section and when generating the reports for all facilities it displayed correctly there.

The OpenArgs has always been an enigma for me... time for some heavy reading

If I may ask another question on this subject (well sort of) I added a field to my reports that will display the facility in the header when you choose one from the first combobox and it works as expected. However when I choose to not choose a facility it will display a random facility in that...

I did the tests with the current code in place and it did as you said it would other than when I deleted the report it showed in the list as #Deleted and I closed the form and re-opened it and it was gone from the list but it all did as you said.

Well Colin, I put the code back the way you originally posted it in post #15 and it is working now. I can only assume it was not working for me while I was in design mode I was testing it without actually logging into the database so it was not knowing what AccessLvlID I had. I don't know what...

When I log in... as an Admin (found in the tbl_accesslevel, field name AccessLvl, field value is Admin and the field value ID is 1)

It is using the function in the credentials module. I knew it would need that part. I understand a little but without the code looking to show all reports, the only way I was able to accomplish that was to have the originally posted query code (from post #1) put in the IF and keep yours in the...

I got a blank combobox Credentials is a module that deals with the AccessLvlID of the users who log in and is the basis of what they can and cannot see in the database like forms, fields, labels etc and now reports. In my database when you want to restrict or allow access to areas or items the...

I changed it to this and now it works Private Sub Form_Load() If Credentials.AccessLvlID = 1 Then Me.cboReports.RowSource = "SELECT [MSysObjects].[Name] FROM MsysObjects WHERE (Left$([Name],1)<>'~') And ([MSysObjects].[Type])=-32764 ORDER BY [MSysObjects].[Name];" Else...

Ok that makes sense. I tried putting it in the form load like this but it didn't show the "Admin" prefixed reports whether you were logged in AccessLvl = 1 or not Private Sub Form_Load() If Credentials.AccessLvlID = 1 Then Me.cboReports.RowSource = "SELECT MsysObjects.Name FROM...

Ok so I moved the code to the before update event like this: Option Compare Database Option Explicit Private Sub cboReports_BeforeUpdate(Cancel As Integer) If Credentials.AccessLvlID = 1 Then Me.cboReports.RowSource = "SELECT MsysObjects.Name FROM MsysObjects WHERE...

I like the looks of this but it has me a little stumped. I tried using this in the query but I believe this belongs in the VBA code so I added it in the code for the form like this (code in red): Option Compare Database Option Explicit Private Sub cmdGenerateReport_Click() On Error GoTo...

If it is easier I can make another report generator page only accessible from the admin console page.

Sorry about that... my post was intended to follow Colins' but another post snuck in between. I used Left([Name],5)<>'Admin' and it worked after closing and re-opening the form. I cannot say the others didn't work too because I was not closing and re-opening the form (I thought I tried that but...

That worked... at first I thought it didn't because after saving the query and renaming the report... the report showed up in the combobox with the changed name but then I closed it and re-opened and the renamed report was gone. Thanks Gasman, Colin and June7

I attached a screenshot of it so you can see it didn't work.

I tried changing the "~" to "Admin" and then renaming a report with Admin at the beginning and it still displayed all reports including the one with Admin at the beginning. I guess I have no idea what the tilde is doing.

I agree on the embedding... I have changed that since I started this thread. Putting a tilde in front of the report name didn't hide it... it displayed with the tilde in the report name in the combobox.

I have a form with 2 comboboxes and a command button. Combobox 1 is irrelevant for this question. Combobox 2 is for pulling a list of all reports. Command button is for generating the report from the choices in the comboboxes. Combobox 2 has this imbedded query in the Row Source: SELECT...

I have started many threads on this forum over a short period of time and while I have been vigilant in clicking the "Thanks" link in their posts... I wanted to take a few minutes to properly thank the people on this site that helped me (and everyone else). Isladogs (Colin)... you nudged me in...