Query Headers Disappearing

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Query Headers Disappearing

Post by Jhstephenson »

I have a weird thing happening when I select a record on a query, display a form, and then return to the query. My header information disappears.

Here is what I see...

1. Call up the query...
PASS_Reports_By_Reason_1.png
PASS_Reports_By_Reason_1.png (54.09 KiB) Viewed 3213 times
2. Open the form by clicking on a record...
PASS_Reports_By_Reason_2.png
PASS_Reports_By_Reason_2.png (51.83 KiB) Viewed 3213 times
3. Close the form and return to the query...
PASS_Reports_By_Reason_3.png
PASS_Reports_By_Reason_3.png (47.36 KiB) Viewed 3213 times
It probably isn't visible in the images I attached, but the headers actually disappear as soon as the form opens.

Any ideas on what might be happening?

Thanks,
Jim
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Query Headers Disappearing

Post by Jaymer »

you have any Init/Render Scripts running on the Form?
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Query Headers Disappearing

Post by Jhstephenson »

Nope
AndySK
Posts: 6
Joined: Fri Jun 04, 2021 12:27 am

Re: Query Headers Disappearing

Post by AndySK »

Hi
Apologies if you've tried this already but...

When you select your record to edit, are you opening in in the default pane? In your query, in the operations on records, your edit setting can be changed to open in a pop-up window. Give this a try to see if this makes a difference. Just a thought.

Cheers
Andy
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Query Headers Disappearing

Post by Jhstephenson »

The initial query was being called as a pop-up. When I changed it to default the issue went away. Which is nice, but it really doesn't explain why it was happening to being with. Even as a popup shouldn't the headings still be there?
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Query Headers Disappearing

Post by Jhstephenson »

Back to this issue.

I needed to change the way I opened the form from my query to use a process.

Now the called form opens as a popup, not matter what I tell it in the "Operations with records" for the operation that calls the process. I have told it to use the Default Output (result: opens as a popup), Popup (opens as a popup), New Tab (opens as a popup), Modeless Window (opens as a popup). In all cases the form opens as a popup when it is called from a process and when it does that the header row on the calling query disappears.

Any ideas?
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Query Headers Disappearing

Post by Jaymer »

it opens as a popup for 1 of 2 reasons:
1) using EDIT boname instead of VIEW boname
2) You are using VIEW, but its not the last statement in the Process - which means that process gets suspended and it has to be a popup to wait for input then close before the process can continue. If you need more statements to execute after the form is filled, then you attach a process to run after the Form is SAVEd
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Query Headers Disappearing

Post by Jhstephenson »

Thanks Jaymer,

Making it the last statement was the trick. Edit/View didn't seem to matter.

I had three operations in the process.

1. Set some session variables.
2. If logged In User is an employee VIEW PASS USING Main NOEDIT
3. IF logged In User is not an employee VIEW PASS USING Main

I changed 2 & 3 to be one operation as follows:

If LoggedInUser.AccessLevel='Employee' Then
VIEW PASS USING Main NOEDIT
ELSE VIEW PASS USING Main

Works like it should now.
Post Reply