Thank you very much for reply but you misunderstood me,
I know how to add Vb forms , i already have some.
But i a not able to undetstand what i have to write in a program to
get this working.
I would like to add 3 fields in vb form
I know how to add Vb forms , i already have some.
But i a not able to undetstand what i have to write in a program to
get this working.
I would like to add 3 fields in vb form
>same then
> start counter -> initial value = 0
> but for next labordtl record if the shift,date and job number is
> the start counter is updated by 0+ start counter of last record.counter of
>
> End counter = 0 (initially)
> but for next shift for the same job number end counter = start
> previous shift.value
>
> Cycle time = 0(initially) but update each next record with the
> entered for same shift and job number.
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Practice this in your training database first but here goes.
>
> Adding VBFields in the LaborDTL records.
>
> System Management / Vantage Basic / Forms Design
> Select File Drop Down Menu then New.
> Select LaborDtl table.
>
> You get a screen to add your fields to.
> Yours are numeric so using the palette select the 3rd button
> On the top row marked "12.3" (this is for numeric fields)
> After selecting the button drag a box on the where you want the
field.
> You get a popup to where in the database the data will go.
> Numeric01, Numeric02, Numeric03, etc...
> Select Numeric01. Press OK. You now got your first field.
> Double click on the field to bring up "Fill-In Attributes.
> Control Name: (don't mess with)
> External name: (enter "X1", if for external display in crystal
> forms)
> Format: Press the set format button and have fun.
> Label: (Enter your screen label for this field.)
> Press OK.
> Repeat for your three fields.
> Your Done with adding fields and getting data in the system.
>
> For reporting you will select LaborDtl.Numeric01, ~02, ~03 for your
data.
>
> Patrick Winter
> sSc Specialty Screw Corporation
> Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal
8.5.3.975
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> sharma_nalini
> Sent: Wednesday, June 15, 2005 3:27 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: call records from MS-Access to vantage vb
form
>
> Please help,
>
> If this is not possible, Can you help me build a vb program for
labor dtl
> table.
>
> I would like to add 3 fields in vb form
>
> start counter -> initial value = 0
> but for next labordtl record if the shift,date and job number is
same then
> the start counter is updated by 0+ start counter of last record.
>
> End counter = 0 (initially)
> but for next shift for the same job number end counter = start
counter of
> previous shift.
>
> Cycle time = 0(initially) but update each next record with the
value
> entered for same shift and job number.
>
> Please ask if i am not clear.but please reply with some clue.
>
>
>
> if shift <> shift of next record then initial value = 0
again.cahnges
> --- In vantage@yahoogroups.com, "sharma_nalini" <sharma_nalini@y...>
> wrote:
> > Right now we are usng MS-Access database for our labour details,
> but
> > very soon wnat to start using vantage data collection.
> >
> > We are not ready right now to stop use of MS- Access database, so
> we
> > planned that only few of the employees like shift supervisors
will
> > enter the entries.
> >
> > We do not see all the fields in vantage wht we enter right now in
> > Access.
> >
> > Is it possible to call a particular record via vb form in the
> labour
> > details
> >
> > e.g
> > If vantage.jobnum = access.jobnum
> > and vantage.empid = access.empid.
> > then display access form with details for particular empid and job
> num.
>
>
>
>
> 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