--------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E1X00002Date: 01/27/97 From: CHRISTOPHER GREAVES Time: 08:16am \/To: THOM KIRBY (Read 2 times) Subj: Linking Excel To Access TK> Where I work I've written a somewhat complex database in Access. his TK>database was to replace what the people were doing in Excel. I'm sure I'm TK>going to have a hard time getting everyone where I work to switch to my I don't have a solution for the implementation problem you raised, but I may have a solution for the motivational deal. What prompted you to switch to Access? Whatever it was, it ought to have been a good reason, one that is beneficial to your users. How quickly can you bring your users to the point where they can REAP the benefits of that unique feature of Access? I'm in the situation of switching client from WordPerfect5.1 to Word6.0. Demonstrating automatic-numbering of paragraphs after introduction of fresh text did the trick! No matter that the feauture was probably available within WP51 - they weren't aware of it until I showed it to them in Word6. I suspect that if you can find a real benefit in Access and get your people to it, your problem will soon be solved. Of course, if you can't find a real benefit in Access, that prompts the question "Why Switch?" From christopher.greaves@ablelink.org christopher.greaves@pro-mail.com * 1st 2.00b #6263 * People and Computers --- QScan/PCB v1.19b / 01-0150 * Origin: Pro-Mail Communications - Toronto Canada (1:250/1004) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E1Y00000Date: 01/26/97 From: NICHOLAS JAMES PITT Time: 03:00pm \/To: ANJE GROOTEN (Read 2 times) Subj: Re: Datasheet and form view Hi there Anje. AG> Did you use it also on the /on focus/ event of the form layout...??? Thinking about it, I may not have. AG> Also you could try to avoid the change of view... by restricting to AG> form view only... The person I put the database together for likes to go into datasheet view at time so this wasn't possible. I did have that idea though. I have now found a solution to the problem though. Instead of basing the form on the tables themselves, I have now based it on a query and everything is working as I want. In the past I decided to always base forms on queries and yet I didn't do it this time. Silly me. All the best. Nick. ... A smile gives more light than electricity. --- FMail/386 1.0g * Origin: The Nightmare BBS (2:2501/204.10) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E1Y00001Date: 01/28/97 From: MATTHEW JOHNSON Time: 04:35pm \/To: JOEL LAMBERT (Read 2 times) Subj: ACCESS 2 QUESTION It came to pass on 01/23/97 that JOEL LAMBERT wrote concerning access 2 question... JL> is anyone using the developers kit and will the developers kit allow JL> one to produce a run time version of an application in the same way JL> visual basic does??? The developers kit contains a runtime version of MS-Access; MSRUN200.EXE which you are given a licence to distribute. It does not produce an application in it's own rigth, you distribute your .MDB file(s) and the runtime engine. It takes about 4 floppies do do this, even for a small program, so that may be a concern for some people. Users would need full access to modify the 'program'. Theoretically, you should be able to prevent users form modifying your application by setting up the security properly. Unfortunatly there is a hole in access security, which means that you cannot stop people form gaining access to any code you have behind a form. You can protect code in a module, however, but this is a pain for development. Access 7 fixes this problem, aparently, but I have little interest in Win95. You can also get a program that will obfuscate your code. This is not as effective as it is with a language such as C, but it is better that nothing. The program will go through all your code, remove all comments, replace all variable names with short names that don't make much sense (like n1, b4) and also remove any formatting. It just makes it harder for people to understand what your code is doing. I hope this helps. Cya Matt __ _ ____ ____ ---+=| =\|=| ==| ===) =========| ===' =============+--- matthewj@gil.com.au |_|\__|ew |_|\_\esolution |____,ommunications * RM 1.31 3332 * Call me if you need my phone number! --- * Origin: Past the Black Stump BBS 07-54-656667 Laidley.. Q'land. (3:640/404) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E1Y00002Date: 01/28/97 From: MATTHEW JOHNSON Time: 04:35pm \/To: GREG HICKS (Read 2 times) Subj: FIDO ECHOS VIA INTERNET It came to pass on 01/20/97 that GREG HICKS wrote concerning Fido Echos via Internet... GH> Help. My local source for the Fido Echo areas is about to drop GH> their Fido Echos. I need to find another source for all the Fido GH> Echos as I really rely on them for various uses. I have Internet GH> access and would You could try: bbs.ftbbs.com bbs.delta.com bbs.pcboard.com as a start. * RM 1.31 3332 * A lie is terminological inexactitude." Churchill --- * Origin: Past the Black Stump BBS 07-54-656667 Laidley.. Q'land. (3:640/404) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E1Y00003Date: 01/25/97 From: PFAFF ANDRAS Time: 09:16pm \/To: ALL (Read 2 times) Subj: Access-> EXE Hi! Can I maybe translate my Access database to .EXE ?? (Maybe using VisualBasic ??) Would you answer to 2:371/20.123 Pleeze! NOT TO 2:371/20, !!!!!! TO 2:371/20.123 !!!!!!!!!! Pa /\$ -MaL FidoetMaL[Pfaff]2:371/20.123 V[:+36(1)33-55-994 ***PGP 1024b/308EEFA1 - 6E FC 5D C6 3D 99 87 C2 34 3A 8F 57 18 21 BB 03 ... Rekordnak szmt a tavalyi 25 fogolyszks. Radsul idn szkv lesz --- OS/2 Warp * Origin: The FlintStones' Cave in BedRock (2:371/20) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E1Y00004Date: 01/28/97 From: JOEL LAMBERT Time: 08:26am \/To: JIM CHEVRAUX (Read 2 times) Subj: ACCESS 2 QUESTION Jim Chevraux wrote in a message to Joel Lambert: -=> Quoting Joel Lambert to Anyone <=- JL> suggestions on what can be done to eliminate the menu choices ie like JL> design for reports or forms! JC> You can create custom menus, which will leave the JC> users with only those options you put in. Greetings Jim, tks for the reply... one additional question... If I were to set up custom menus, would not the end user be able to add the origional menu bar back to the application? or will the dev kit prevent this... or am I doing something wrong I only say this because I'v cunstructed custom menus, taken the databases 2 files and copied them onto another machine running another copy of Access 2. and was able to edit the design of the form... this was of course without the dev kit. don't own that as of yet but have just ordered it this AM tks in advance JL> is anyone using the developers kit and will the developers kit allow JL> one to produce a run time version of an application in the same way JL> visual basic does??? JC> Yes, and it'd virtually be required to distribute JC> your application. Without the run-time version of Access JC> (which is freely distributable if you buy the dev. kit), no JC> one would be able to run it unless they had Access. TTYL regards Joel --- timEd-B11 - Practice safe government, use kingdoms! * Origin: There's a sucker born every minute. (1:141/455) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E2100000Date: 01/29/97 From: NICHOLAS JAMES PITT Time: 07:00pm \/To: TONY TOEWS (Read 3 times) Subj: Re: Datasheet and form view Hi Tony. TT> Disable the datasheet view by going into the form properties. That's TT> what I do *ALL* the time. My users have never seen the datasheet view. That would be Ok if it wasn't for the fact that the person I did the database for likes to use the datasheet view from time to time. I have since sorted out the problem by basing the form on a query rather than the tables. Thanks for the reply. All the best. Nick. ... A smile gives more light than electricity. --- FMail/386 1.0g * Origin: The Nightmare BBS (2:2501/204.10) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E2100001Date: 01/30/97 From: JIM CHEVRAUX Time: 11:37am \/To: JOEL LAMBERT (Read 3 times) Subj: ACCESS 2 QUESTION -=> Quoting Joel Lambert to Jim Chevraux <=- JL> Greetings Jim, tks for the reply... one additional question... If I JL> were to set up custom menus, would not the end user be able to add the JL> origional menu bar back to the application? or will the dev kit prevent JL> this... or am I doing something wrong You're doing something wrong. I've got an application that I wrote for another company that has the menus locked down nice and tight. There's only one menu option and it's got two options under it ... print and quit. -) However, I've got to warn you that there's a hole in Access 2's security that'll allow people to get into the code. I don't know what all your aims are here, but I figured I'd better mention it. JL> I only say this because I'v cunstructed custom menus, taken the JL> databases 2 files and copied them onto another machine running another You loading the custom menus on startup of the database (AUTOEXEC macro)? By the time a user can start using menus, they shouldn't have anything but your custom menu up there. jc ... Who is General Failure and why is he reading my disk? --- FLAME v1.1 * Origin: CanCom TBBS - Canton, OH (1:157/629) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E2100002Date: 01/31/97 From: NIKOLAY VYGLAZOV Time: 10:07pm \/To: ALL (Read 3 times) Subj: .OCX module Hello All! Sorry. I'm not very good speak english. Where i can find information about OLE objects inserting in forms (ACCESS 2) ? I want create 'list box' including 'dirrectory list', but i don't know how. And othe question. Can I write on russian in this echos? шиб... Nikolay --- GoldED/386 2.51.A0901+ * Origin: Soft Magic (2:5030/168.20) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E2200000Date: 02/01/97 From: THOM KIRBY Time: 02:31pm \/To: CHRISTOPHER GREAVES (Read 3 times) Subj: Linking Excel To Access *** Quoting Christopher Greaves to Thom Kirby dated 01-27-97 *** > What prompted you to switch to Access? Whatever it was, it ought > to have been a good reason, one that is beneficial to your users. Everyone was using Excel to input data like in a Database. The main thing I can find beneficial is it makes inputting data easier, and is less likely to screw up other records. I sent out a memo to all the people who would be making the decision to switch over to my DB. I was out sick Friday, but I'm sure I'll hear something Monday. Thanks for responding! Thom ...Yep! you bet... What was that you said? --- TAG, You're It! * Origin: The Blackboard - Pomona, NY - Since 1983 (1:2625/143)