Subject:  Re: [access] Time Difference



dim intTimeIn as double

dim IntTimeOut as double

dim intTotalTime as double

dim intLunchtime as integer



intTimeIn =3D inputbox ("Enter time In")

intTimeOut =3D inputbox ("Enter Time Out")

intLunchTime =3D inputbox("Enter Lunch Hour ex: 1.0 or 1.5 or .5")



intTotalTime =3D DateDiff("n", intTimeIn, intTimeOut) - intLunchTime



Note "n" =3D Minutes

See Help Index  - " DateDiff " for more help



Derrick A. Flores

Associate Systems Engineer

6" Line Engineering

Sony Electronic Inc.

Semiconductor San Antonio

1 Sony Place M/S 730

San Antonio, Texas 78245-2100

Telephone:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx

Pager:  (xxx) xxx-xxxx

E-mail: derrick_flores@s...



>>> Pam McMillin <pmcmillin@m...> 06/11 11:18 AM >>>



I am needing the formula to calculate the difference in hrs and

minutes.  This is being used as a time clock.  Where an employee types 

in

their time they arrive, amount of time taken for lunch hr and the time 

they

leave.  e.i.  8:00 am - 6:00 pm and 1 hr for lunch.  I need to know the

number of hrs and minutes worked.







Pam McMillin

Systems Technician



Schlumberger - IPM Asset Management

500 W. Texas, Suite 500

P.O. Box 2726

Midland, TX 79702-2726

Office 915/571-4600

Cell 915/556-0749

Fax 915/571-4788

pmcmillin@m...





om

Subject:  Re: [access] Running a built in Wizard from code



You can use the following to build a report using Report Wizard

Just copy any of these syntax in the Click Event of a command button

Report Wizard: Application.Run "Wzmain80.frui_Entry", "Customers", 

acReport

Graph Report Wizard: Application.Run "Wztool80.cw_WizardEntry", "Registrati

on", acReport, 0

Pivot Table Wizard: Application.Run "Wzmain80.pvt_Entry", "Customers"





Derrick A. Flores

Associate Systems Engineer

6" Line Engineering

Sony Electronic Inc.

Semiconductor San Antonio

1 Sony Place M/S 730

San Antonio, Texas 78245-2100

Telephone:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx

Pager:  (xxx) xxx-xxxx

E-mail: derrick_flores@s...



>>> Brian Skelton <brian.skelton@b...> 06/11 8:58 AM 

>>>



I'm putting together a report writing database that wil allow users to 

create new reports based on pre-designed templates. BUT, it would be nice 

to offer the more adventurous user the ability to create reports from 

scratch using the Access report builder wizard.



So, is it possible to invoke this wizard (or any other) from code?



Many thanks



-BDS









om

Subject:  Re: [access] How robust is access?



Access can be as much robust as you want depending on your skillset.

Access can easily handle your 25k record and even your fellow employees 

all at one

depending on how you set it up.  I use access in differnt types of 

environments

(Aircraft Engine Builder, Semiconductor, Temp Service Contractors, and 

even Y2K data analysis for hospital

accross the US).  So to answer your question: Yes if your resources and 

budget are limited for SQL Server.

If not I would rather go with SQL Server and also use Access as a front 

end to the server.



Derrick A. Flores

Associate Systems Engineer

6" Line Engineering

Sony Electronic Inc.

Semiconductor San Antonio

1 Sony Place M/S 730

San Antonio, Texas 78245-2100

Telephone:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx

Pager:  (xxx) xxx-xxxx

E-mail: derrick_flores@s...



>>> "Michael B. Deck" <mdassignment@h...> 06/22 2:35 PM >>>

Hello -

  I'm building a database application in VB6.  This app will be used to

file medical reports and records so preventing against corruption is

extreamly important because of the legal implications associated with 

this

data.  The max number of records won't exceed 25,000 and there will 

only

be about a dozen clients with the app even installed and it's very

unlikely that all of those will be in use at once.  My question is, has

anyone written an app using access as a data server with this type of

record and user load.  And does anyone think SQL Server 7 would be a

better choice.







    Thanks,

    Mike



om