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...
2. Open the form by clicking on a record...
3. Close the form and return to the query...
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
Query Headers Disappearing
Re: Query Headers Disappearing
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
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Query Headers Disappearing
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
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
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Query Headers Disappearing
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?
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Query Headers Disappearing
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?
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?
Re: Query Headers Disappearing
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
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
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Query Headers Disappearing
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.
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.