Subject:  Re: [access] Creating self executing Access Databases



You would need to use the MS Office 2000 Developer Edition.  Once you 

install the software you would need to find a folder call "Runtime" that 

is probably located on the 2nd CD.  You need to copy this folder to 

...\Program Files\Microsoft Office\ODETools\V9\Runtime.  This folder 

(Runtime) will not be installed to your computer as part of the MS Office 

2000 Developer Setup program.  When you're about to package a database, 

open the database, go to the VBA Projects Code module (ctrl + F11), Go to 

the Add-ins menu, Add-in Manager, from there you will see a list of 

Add-ins.  Select the "Package and Deployment Wizard" and click OK.  The 

Package and Deployment Wizard will launch.  The reason that you have to 

copy the "Runtime" folder to your local drive is that when you get ready 

to package a database you have the option to include an Access 2000 

Runtime for those computers that do not have Access 2000 loaded on their 

machines. After you finished you packaging and ready to install the 

software onto a computer, the software will check to see if there is an 

Access 2000 Runtime software already loaded on the machine.  If not, is 

will load it onto the computer and will restart the computer before 

loading the Access database.  Once the software is finished loading and 

restarting the machine, it will then load your database.  When you install 

another database (even with runtime on it) it will by-pass the Runtime 

installation and just load your database program.

*** WARNING : ONCE YOU INSTALL THE RUNTIME SOFTWARE ON THE MACHINE ALL 

ACCESS 97 DATABASE ICON WILL CHANGE TO ACCESS 2000 ICON AND WHEN YOU OPEN 

THE DATABASE FROM ACCESS 97, IT WILL GIVE THE OPTION TO CONVERT IT OR JUST 

OPEN IT USING RUNTIME.  THIS WILL BE FOR ALL DATABASES ('97 & 2000).  TO 

OVERCOME THIS YOU HAVE TO UNINSTALL THE MS RUNTIME SOFTWARE FROM THE 

ADD-REMOVE SOFTWARE IN YOUR CONTROL PANEL.



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...



>>> "Mark Collins" <mark.g.collins@s...> 04/18 12:38 PM >>>

All,



Does anyone know how to create self-installing Access programs.  I am

currently working on a database which would look a lot more professional=20



if I could install it via an installation program.  I know it can be 

done

as my predecessor had distributed databases in this manner, which

obviously makes the whole operation less painful.



Thanks in advance for any advice,

Mark.

Subject:  Re: [access] Displaying option group values in reports



What you can do is add Unbound text boxes on your report one for each 

option if you have more than one.

For each Unbound text box you will write in an IIf Function in place of 

the row source.  The IIF Function will look at the associated option

and depending on the option value you will assign the Unbound text box the 

value that you want.

Example



Option Box =3D myOption

Unbound Text Box =3D txtMyOption



Type in code into txtMyOption RowSource

IIF([myOption] =3D -1, "Yes", IIF([myOption] =3D 0, "No", "Maybe"))

this means: If myOption value is -1 then txtMyOption value is Yes if not, 

if myOption value is 0 then txtMyOption value is No if not, txtmyOption 

value is Maybe.



ex.

myOption =3D -1

txtMyOption =3D Yes

or

myOption =3D 0

txtMyOption =3D No



Once this IIF Statement works to your satisfaction, hide the option values 

and place the Unbound Text boxes in the desire place.



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...



>>> "Michelle Madden" <michellem@a...> 04/24 9:19 PM >>>

Can anyone help?



I am writing a report and I need to display a value as something 

different

to the actual value.



It=C6s a value from an option group.  On the form the options are Yes, 

No,

Consider and Don=C6t Know.  These are represented on the table by =FB1, 0, 

1

and 2.  The report is displaying the table values.



How do I convert the table values to display Yes, No etc.



Thanks



Michelle





om

Subject:  Re: [access] how to create a text file in VBA code



Elmer here is a sample on creating a text file and writing to it



Open "c:\My Documents\MyFile.txt" For Output As #1   ' Open file if it do 

not exist create file

    Print #1, "Enter the first line here"                                ' 

Writing to the fle

    Print #1, "Enter the second line here"

Close #1                                                                   

       ' Closing the file





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...



>>> "Elmer  Espinosa" <elmerespinosa@y...> 04/30 4:59 PM >>>

Greetings!



Need your help.  how to create a text file in VBA code.

ex. Field Name





Request#     =3D 1234

Work Numbers =3D 0020

Client       =3D Strong Corp.





All I need the ex above should appear in text file







Appreciate your help.



Thanks



Elmer









om