If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > freeze columns in paradox 10

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-27-04, 16:17
stuman413 stuman413 is offline
Registered User
 
Join Date: Sep 2003
Location: Richmond, CA
Posts: 11
Exclamation freeze columns in paradox 10

In Microsoft Access there is a feature that allows you to freeze a column scroll to the right without moving the frozen columns.

Is there a similar feature in Paradox 10?
Reply With Quote
  #2 (permalink)  
Old 03-02-04, 09:04
lmckelvy lmckelvy is offline
Registered User
 
Join Date: Oct 2003
Posts: 107
Use Ctl-R when you are in the last column you want to hold. I think that sounds like what you want.
Reply With Quote
  #3 (permalink)  
Old 03-03-04, 12:44
stuman413 stuman413 is offline
Registered User
 
Join Date: Sep 2003
Location: Richmond, CA
Posts: 11
Wink

no, ctl-r only moves the screen to the right without dropping down to the next record



Quote:
Originally posted by lmckelvy
Use Ctl-R when you are in the last column you want to hold. I think that sounds like what you want.
Reply With Quote
  #4 (permalink)  
Old 03-03-04, 14:07
lmckelvy lmckelvy is offline
Registered User
 
Join Date: Oct 2003
Posts: 107
Something must have changed in version 10 then, because in every version prior to that it holds all columns to the left of the current one, scrolling the remaining ones in order.
Reply With Quote
  #5 (permalink)  
Old 03-24-04, 13:45
Maroonotmoron Maroonotmoron is offline
Registered User
 
Join Date: Sep 2003
Location: Dallas
Posts: 182
Angry Rephrase your question

Ctr-R was never meant to move from record to record but rotates the columns in a table. Freezing the columns has little to do with moving from record to record unless you have a multi record form designed with records going horizontally across the form.

What are you actually trying to do?
Reply With Quote
  #6 (permalink)  
Old 03-24-04, 14:04
stuman413 stuman413 is offline
Registered User
 
Join Date: Sep 2003
Location: Richmond, CA
Posts: 11
Post Freeze columns in Paradox

In Access there is a way to freeze a column, so that when you scroll to the right, that column stays in place. This is used for example if you have a "LastName" column, and you want to match it up to another column that is maybe 10 columns to the right. By freezing the "LastName" column, you can scroll over and view the other column on the screen at the same time.

In Paradox 10, I cannot find this function. That is what I'm trying to do.

If you can help with this tiny problem it would be most appreciated.

Thanks

Stu
Reply With Quote
  #7 (permalink)  
Old 03-24-04, 14:23
Maroonotmoron Maroonotmoron is offline
Registered User
 
Join Date: Sep 2003
Location: Dallas
Posts: 182
Then you do want Ctrl-R.

In table view, go to the left most column that you want to match up with and then move one colum to the right and hit ctrl-r until the othe column you want to match it with rotates into view. That view will remain until you close the table you can save the view (you will be prompted when you close the table) and that view will remain until modified and saved.

I just checked and it works in version 10 without a problem!
Reply With Quote
  #8 (permalink)  
Old 04-21-04, 06:25
Shores Shores is offline
Registered User
 
Join Date: Aug 2003
Location: Bologna - Italy
Posts: 209
In Paradox 10 you can lock columns to the LEFT of the view by dragging the arrow you see in the table on the bottom left of the table window, just over the horizontal scroll bar.

This would lock in place the leftmost n fields, and they would not scroll out when you scroll to other fields in a row.

Note that this function is NOT available in tableviews o table frames put in a form, it's only available if you directly open the table file.
__________________
The only failure is not trying to do it.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On