Reminds me of years back when a system I worked on saved dates as a 2 digit
hex number to save hard drive space. What a treat that was to work with.
Patrick Winter
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Friday, June 04, 2004 4:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Table fields
The VBForm fields are limited to the number that Vantage has setup to allow.
These can not be added to unless Epicor adds them.
This however is a neat idea of using combination binary patterns of all the
checkboxes on a form. The problem comes to the users that would have to use
it. It's hard enough getting them to enter data correctly, I don't see how
they could manage trying to enter a binary sequence. However, it could be
possible to have a .w program with all the 13 check boxes you need on it.
The program itself would be launched from the VBForm and pull the status of
the 5 form check boxes, convert the binary value to a decimal value and
assign the current status of the 13 check boxes on the .w window based upon
the binary pattern of the vbform checkboxes. Then upon closing of the .w
window, read the 13 check boxes, convert it to binary format and assign the
values back on the VBForm. The problem I could see, would be the checkboxes
on the VBForm are not locked/hidden, meaning that a user could check/uncheck
them at will and throw off the actual check list pattern. I'm not sure if
it is possible, but if you could assign these values from the .w application
without actually having the fields available on the form, then this idea
would work great. But I think when Vantage updates, it may clear these
values since they are not available on the form. You would have to test
this.
I think a better solution might be to just add a table to your database to
contain your 13 check off list fields/values, have a button on the VBForm to
open the .w application so the user can set the values, then in reports,
just link to this table (in Report builder or Crystal) to pull the values.
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, June 04, 2004 3:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Table fields
Can you elaborate on this more? How would you set this up and how would you
pull each field on to a report?
Thanks,
Jasper
-----Original Message-----
From: HPN Charles Paluska [mailto:cpaluska@...]
Sent: Friday, June 04, 2004 1:22 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Table fields
Howdy,
You might be able to use all 5 fields to form a binary number - this will
get you 32 possibilities
f1 f2 f3 f4 f5
0 0 0 0 0 check list item 1
0 0 0 0 1 check list item 2
0 0 0 1 0 check list item 3
0 0 0 1 1
...
1 1 1 1 1 check list item 32
Just a thought ....
Charles
hex number to save hard drive space. What a treat that was to work with.
Patrick Winter
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Friday, June 04, 2004 4:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Table fields
The VBForm fields are limited to the number that Vantage has setup to allow.
These can not be added to unless Epicor adds them.
This however is a neat idea of using combination binary patterns of all the
checkboxes on a form. The problem comes to the users that would have to use
it. It's hard enough getting them to enter data correctly, I don't see how
they could manage trying to enter a binary sequence. However, it could be
possible to have a .w program with all the 13 check boxes you need on it.
The program itself would be launched from the VBForm and pull the status of
the 5 form check boxes, convert the binary value to a decimal value and
assign the current status of the 13 check boxes on the .w window based upon
the binary pattern of the vbform checkboxes. Then upon closing of the .w
window, read the 13 check boxes, convert it to binary format and assign the
values back on the VBForm. The problem I could see, would be the checkboxes
on the VBForm are not locked/hidden, meaning that a user could check/uncheck
them at will and throw off the actual check list pattern. I'm not sure if
it is possible, but if you could assign these values from the .w application
without actually having the fields available on the form, then this idea
would work great. But I think when Vantage updates, it may clear these
values since they are not available on the form. You would have to test
this.
I think a better solution might be to just add a table to your database to
contain your 13 check off list fields/values, have a button on the VBForm to
open the .w application so the user can set the values, then in reports,
just link to this table (in Report builder or Crystal) to pull the values.
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, June 04, 2004 3:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Table fields
Can you elaborate on this more? How would you set this up and how would you
pull each field on to a report?
Thanks,
Jasper
-----Original Message-----
From: HPN Charles Paluska [mailto:cpaluska@...]
Sent: Friday, June 04, 2004 1:22 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Table fields
Howdy,
You might be able to use all 5 fields to form a binary number - this will
get you 32 possibilities
f1 f2 f3 f4 f5
0 0 0 0 0 check list item 1
0 0 0 0 1 check list item 2
0 0 0 1 0 check list item 3
0 0 0 1 1
...
1 1 1 1 1 check list item 32
Just a thought ....
Charles
----- Original Message -----
From: Jasper Recto
To: Vantage Groups (E-mail)
Sent: Friday, June 04, 2004 1:06 PM
Subject: [Vantage] Table fields
I am making a VB form that contains a checklist that a user must go thru.
I'm using the QuoteHed table and using the Checkbox fields. Is there a way
to add more checkbox fields to the table? The quotehead table only has 5
usable fields and I need at least 13.
Thanks,
Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.453.2300
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
[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 Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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
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
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