VB Form Error

Yahoo Archive
1
I had the same thing happen to me once several years back (on 5.0)... a
call to tech support and they had to send me a fix utility (VBRESET.r)
to clear the form. Call info is below. You will probably need to call
tech support to the get the vbreset.r file for Vantage 6.0 and then
start over on your form...

-------------------------------------------
Please reference call # 727732PSC if you have any additional questions
on this issue.

The document below should explain the problem you are seeing. Attached
is the VBReset.r fix program and instructions for 5.00. Keep in mind
that when you reset the form, you will need to add the exact same inputs
back in when you recreate the form, otherwise you will not be able to
access the existing data that might be out there attached to the form.

************************************************************
*** Page ID: 340.611
*** Status: Closed Reviewed
*** Created On: Mar 23 1999
*** Changed On: Nov 10 1999
*** Added By: Marcy Hake
*** Product: VANTAGE
************************************************************
PROBLEM DESCRIPTION:

After I modified a VBForm for the OrderHead file, I could not save the
changes, and I received the following error:

'VBFormDetail record not on file. (138)'

There are currently 2 character fields, 3 date fields, 1 editor field
and 1 text field on the form. I have run the recycle program for this
table, but still get the error message. Other forms can be modified and
saved successfully.

PROBLEM RESOLUTION:

There is a fix program (VBRESET.R) available from Vantage Technical
Support that will reset the VBForm causing this error.

Install the program by copying the VBRESET.R file to your \Vantage
directory on the server.

To run the program:

1) Start a Vantage session.
2) Select menu options: System Management --> Vantage Basic -> Command
Window.
3) In the command windows key the command EDITPROG and press ENTER.
4) In the Procedure Editor window enter the command RUN VBRESET.R and
press F2.
5) The program will then prompt for table name to be reset.
6) The program will end by displaying a completion message.
7) File|Exit|No to save buffers to leave the procedure editor screen.
________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] VB Form Error

We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended
recipient only and may contain confidential and privileged information.
No one else may read, print, store, copy, forward or act in reliance on
it or its attachments. If you are not the intended recipient, please
return this message to the sender and delete the message and any
attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.f-
<http://www.f-secure.com/> secure.com/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
2
before I create my vb form for QuoteHed,I do a recycle. After, I
create my VB Form if I save my form the following error message
appears : **VBFormDetail record not on file. (138)
3
We are on Vantage 6.0. We are trying to add fields to the RMAHead VB Form, but we get the following error: VBForm Detail, Record Not on File(138). We can add fields to other VB forms, but not this one. Any help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]
4
I just tested it out on 6.1 adding a text field to Character01 on
RMAHead and it worked fine.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] VB Form Error



We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
5
I am able to do it on my stand alone test database, but when we try to do it on the live data base, we get that message. The RMAhead is the only VB Form we are having that issue with so far. It is driving us nuts.
----- Original Message -----
From: Chris Clunn
To: vantage@yahoogroups.com
Sent: Wednesday, March 28, 2007 1:42 PM
Subject: RE: [Vantage] VB Form Error


I just tested it out on 6.1 adding a text field to Character01 on
RMAHead and it worked fine.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] VB Form Error

We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
Can't swear to this but a vague recollection I have says something about VB form fields when they are deleted needing to have some process to make them available again. Some sort of refresh process. I am wondering if something has gotten corrupted in the VB forms table and has flagged the fields as unusable. maybe someone used them once and deleted them from a form. Perhaps running the field restore (or whatever it is) will set them straight. Check the help screens for info on VB form fields...I am pretty sure I saw this in there once. Something to check out. Caution....I also recall something about data in the fields gets wiped and the process might affect more than deleted fields in just that table.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Tom Ford
Sent: Wednesday, March 28, 2007 3:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] VB Form Error



I am able to do it on my stand alone test database, but when we try to do it on the live data base, we get that message. The RMAhead is the only VB Form we are having that issue with so far. It is driving us nuts.
----- Original Message -----
From: Chris Clunn
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, March 28, 2007 1:42 PM
Subject: RE: [Vantage] VB Form Error

I just tested it out on 6.1 adding a text field to Character01 on
RMAHead and it worked fine.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] VB Form Error

We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f- <http://www.f-secure.com/> secure.com/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
7
Can't swear to this but a vague recollection I have says something about VB form fields when they are deleted needing to have some process to make them available again. Some sort of refresh process. I am wondering if something has gotten corrupted in the VB forms table and has flagged the fields as unusable. maybe someone used them once and deleted them from a form. Perhaps running the field restore (or whatever it is) will set them straight. Check the help screens for info on VB form fields...I am pretty sure I saw this in there once. Something to check out. Caution....I also recall something about data in the fields gets wiped and the process might affect more than deleted fields in just that table.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Tom Ford
Sent: Wednesday, March 28, 2007 3:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] VB Form Error



I am able to do it on my stand alone test database, but when we try to do it on the live data base, we get that message. The RMAhead is the only VB Form we are having that issue with so far. It is driving us nuts.
----- Original Message -----
From: Chris Clunn
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, March 28, 2007 1:42 PM
Subject: RE: [Vantage] VB Form Error

I just tested it out on 6.1 adding a text field to Character01 on
RMAHead and it worked fine.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] VB Form Error

We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f- <http://www.f-secure.com/> secure.com/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
8
Can't swear to this but a vague recollection I have says something about VB form fields when they are deleted needing to have some process to make them available again. Some sort of refresh process. I am wondering if something has gotten corrupted in the VB forms table and has flagged the fields as unusable. maybe someone used them once and deleted them from a form. Perhaps running the field restore (or whatever it is) will set them straight. Check the help screens for info on VB form fields...I am pretty sure I saw this in there once. Something to check out. Caution....I also recall something about data in the fields gets wiped and the process might affect more than deleted fields in just that table.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Tom Ford
Sent: Wednesday, March 28, 2007 3:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] VB Form Error



I am able to do it on my stand alone test database, but when we try to do it on the live data base, we get that message. The RMAhead is the only VB Form we are having that issue with so far. It is driving us nuts.
----- Original Message -----
From: Chris Clunn
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, March 28, 2007 1:42 PM
Subject: RE: [Vantage] VB Form Error

I just tested it out on 6.1 adding a text field to Character01 on
RMAHead and it worked fine.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] VB Form Error

We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f- <http://www.f-secure.com/> secure.com/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
9
I had the same thing happen to me once several years back (on 5.0)... a
call to tech support and they had to send me a fix utility (VBRESET.r)
to clear the form. Call info is below. You will probably need to call
tech support to the get the vbreset.r file for Vantage 6.0 and then
start over on your form...

-------------------------------------------
Please reference call # 727732PSC if you have any additional questions
on this issue.

The document below should explain the problem you are seeing. Attached
is the VBReset.r fix program and instructions for 5.00. Keep in mind
that when you reset the form, you will need to add the exact same inputs
back in when you recreate the form, otherwise you will not be able to
access the existing data that might be out there attached to the form.

************************************************************
*** Page ID: 340.611
*** Status: Closed Reviewed
*** Created On: Mar 23 1999
*** Changed On: Nov 10 1999
*** Added By: Marcy Hake
*** Product: VANTAGE
************************************************************
PROBLEM DESCRIPTION:

After I modified a VBForm for the OrderHead file, I could not save the
changes, and I received the following error:

'VBFormDetail record not on file. (138)'

There are currently 2 character fields, 3 date fields, 1 editor field
and 1 text field on the form. I have run the recycle program for this
table, but still get the error message. Other forms can be modified and
saved successfully.

PROBLEM RESOLUTION:

There is a fix program (VBRESET.R) available from Vantage Technical
Support that will reset the VBForm causing this error.

Install the program by copying the VBRESET.R file to your \Vantage
directory on the server.

To run the program:

1) Start a Vantage session.
2) Select menu options: System Management --> Vantage Basic -> Command
Window.
3) In the command windows key the command EDITPROG and press ENTER.
4) In the Procedure Editor window enter the command RUN VBRESET.R and
press F2.
5) The program will then prompt for table name to be reset.
6) The program will end by displaying a completion message.
7) File|Exit|No to save buffers to leave the procedure editor screen.
________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Tom Ford
Sent: Wednesday, March 28, 2007 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] VB Form Error

We are on Vantage 6.0. We are trying to add fields to the RMAHead VB
Form, but we get the following error: VBForm Detail, Record Not on
File(138). We can add fields to other VB forms, but not this one. Any
help would be greatly appreciated.

Thanks,

Tom Ford
Mid-West Spring

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended
recipient only and may contain confidential and privileged information.
No one else may read, print, store, copy, forward or act in reliance on
it or its attachments. If you are not the intended recipient, please
return this message to the sender and delete the message and any
attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.f-
<http://www.f-secure.com/> secure.com/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>