This might be what I'm looking for. I'll try it.Patti
From: Dan Goldberg <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Monday, February 16, 2015 12:38 PM
Subject: [RBASE-L] - RE: emulate an F2 key?
<!--#yiv9872530263 _filtered #yiv9872530263 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv9872530263 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv9872530263 {font-family:Calibri;panose-1:2
15 5 2 2 2 4 3 2 4;} _filtered #yiv9872530263 {font-family:Tahoma;panose-1:2 11
6 4 3 5 4 4 2 4;}#yiv9872530263 #yiv9872530263 p.yiv9872530263MsoNormal,
#yiv9872530263 li.yiv9872530263MsoNormal, #yiv9872530263
div.yiv9872530263MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 a:link, #yiv9872530263
span.yiv9872530263MsoHyperlink
{color:blue;text-decoration:underline;}#yiv9872530263 a:visited, #yiv9872530263
span.yiv9872530263MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv9872530263
p.yiv9872530263MsoAcetate, #yiv9872530263 li.yiv9872530263MsoAcetate,
#yiv9872530263 div.yiv9872530263MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
"sans-serif";}#yiv9872530263 p.yiv9872530263msoacetate, #yiv9872530263
li.yiv9872530263msoacetate, #yiv9872530263 div.yiv9872530263msoacetate
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 p.yiv9872530263msonormal, #yiv9872530263
li.yiv9872530263msonormal, #yiv9872530263 div.yiv9872530263msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 p.yiv9872530263msochpdefault, #yiv9872530263
li.yiv9872530263msochpdefault, #yiv9872530263 div.yiv9872530263msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 p.yiv9872530263msonormal1, #yiv9872530263
li.yiv9872530263msonormal1, #yiv9872530263 div.yiv9872530263msonormal1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 p.yiv9872530263msochpdefault1, #yiv9872530263
li.yiv9872530263msochpdefault1, #yiv9872530263 div.yiv9872530263msochpdefault1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 span.yiv9872530263msohyperlink {}#yiv9872530263
span.yiv9872530263msohyperlinkfollowed {}#yiv9872530263
span.yiv9872530263msohyperlink1 {}#yiv9872530263
span.yiv9872530263msohyperlinkfollowed1 {}#yiv9872530263
span.yiv9872530263emailstyle171 {}#yiv9872530263 span.yiv9872530263emailstyle27
{}#yiv9872530263 span.yiv9872530263balloontextchar {}#yiv9872530263
p.yiv9872530263msonormal2, #yiv9872530263 li.yiv9872530263msonormal2,
#yiv9872530263 div.yiv9872530263msonormal2
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 span.yiv9872530263msohyperlink2
{color:blue;text-decoration:underline;}#yiv9872530263
span.yiv9872530263msohyperlinkfollowed2
{color:purple;text-decoration:underline;}#yiv9872530263
p.yiv9872530263msoacetate1, #yiv9872530263 li.yiv9872530263msoacetate1,
#yiv9872530263 div.yiv9872530263msoacetate1
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
"sans-serif";}#yiv9872530263 p.yiv9872530263msonormal3, #yiv9872530263
li.yiv9872530263msonormal3, #yiv9872530263 div.yiv9872530263msonormal3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 p.yiv9872530263msochpdefault2, #yiv9872530263
li.yiv9872530263msochpdefault2, #yiv9872530263 div.yiv9872530263msochpdefault2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 p.yiv9872530263msonormal11, #yiv9872530263
li.yiv9872530263msonormal11, #yiv9872530263 div.yiv9872530263msonormal11
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 span.yiv9872530263msohyperlink11
{color:blue;text-decoration:underline;}#yiv9872530263
span.yiv9872530263msohyperlinkfollowed11
{color:purple;text-decoration:underline;}#yiv9872530263
span.yiv9872530263emailstyle1711 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv9872530263 p.yiv9872530263msochpdefault11,
#yiv9872530263 li.yiv9872530263msochpdefault11, #yiv9872530263
div.yiv9872530263msochpdefault11
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Times New
Roman", "serif";}#yiv9872530263 span.yiv9872530263emailstyle271
{font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv9872530263
span.yiv9872530263balloontextchar1 {font-family:"Tahoma",
"sans-serif";}#yiv9872530263 span.yiv9872530263EmailStyle42
{font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv9872530263
span.yiv9872530263BalloonTextChar {font-family:"Tahoma",
"sans-serif";}#yiv9872530263 .yiv9872530263MsoChpDefault {font-size:10.0pt;}
_filtered #yiv9872530263 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv9872530263
div.yiv9872530263WordSection1 {}-->Just create a button and use: PROPERTY
TABLE <FORMTABLENAME> 'INSERT' Replace the <FORMTABLENAME> with the your
table name(without the brackets) Dan Goldberg From: [email protected]
[mailto:[email protected]]On Behalf Of Patti Jakusz
Sent: Monday, February 16, 2015 9:33 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: emulate an F2 key? Hi Javier, This isn't really
what I'm looking for. I really want an "insert" button that I can use in a
scrolling region. Thank you though, Patti From: Javier Valencia
<[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Sunday, February 15, 2015 9:55 PM
Subject: [RBASE-L] - RE: emulate an F2 key? Patti, I never insert a blank
row, too many abandoned blank rows that need clean up. I usually prompt the
user for the part number, employee ID, procedure code or whatever will identify
that row and, after it is verified as correct, I insert row the information
collected and default values for the other columns so there are no NULL values
for any of the columns: INSERT INTO your_table + (Col_ID,col2, col3, col4,
….) + VALUES(.vCol_Id, 0,0,0,…) PROPERTY TABLE your_table 'REFRESH' PROPERTY
TABLE your_table 'LAST' Now you should be able to edit that new row.
Hopefully this is what you wanted and it will work for you. Javier, Javier
Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137
From:[email protected] [mailto:[email protected]]On Behalf Of Patti Jakusz
Sent: Sunday, February 15, 2015 7:12 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: emulate an F2 key? Hi Tom, I'm not sure how this
would help them add rows to my table without hitting the F2 key. One thing I
neglected to mention is that the form is an "Edit using" form for table1. But
in the scrolling region, they are adding new rows to table2. John said that I
have to use F2 to insert a new blank row in Table2 and then enter the data.
Are you suggesting that I add about 10 or so new blank rows to a temp table and
they can just use how ever many they want? Then they don't need to hit F2?
Patti From: tfred <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Sunday, February 15, 2015 7:03 PM
Subject: [RBASE-L] - RE: emulate an F2 key? Make a small EEP for a button you
can place where you want: PROJECT a temp table using * WHERE LIMIT = 0, table
has no values INSERT some values to add one row UPDATE the temp as needed
APPEND the temp back to the original table DROP the temp Then use PROPERTY
commands 'REFRESH', 'RestoreOrderBy', and 'Last' to get it back in order and
open the new row. Tom Frederick From:[email protected]
[mailto:[email protected]]On Behalf Of Patti Jakusz
Sent: Sunday, February 15, 2015 4:21 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - emulate an F2 key? Is there a way I can put a control on
a form that will act as an F2 key? I have a scrolling region and I can't put
in a navigator bar, but we need to be able to insert new rows . But it would
be so much nicer if they can click on a button rather than go and find the F2
key. Patti
