--------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00006 Date: 04/18/97 From: BUCKY CARR Time: 10:03am \/To: STEVEN LAGER (Read 6 times) Subj: VB internet newsgroups? SL> comp.lang.basic.visual SL> comp.lang.basic.visual.3rdparty SL> comp.lang.basic.visual.announce SL> comp.lang.basic.visual.misc (*) SL> microsoft.public.vb.controls (*) SL> feeding my source code habit . nice little, legal addiction we all have, eh? SL> Other than that I've SL> gotten more from this echo than all the messages in the above SL> newsgroups; especially with people like yourself - Eileen - Gary (and SL> others) who contribute and help on a regular basis. Well thank you very much and that info is very interesting. I'll reconsider connecting there. Always glad to help if I can and nothing I've been writing do I consider too private to post here, especially. --- PPoint 2.00 * Origin: Vanishing Point 7198460140 Trinidad CO (1:15/7.1) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00007 Date: 04/18/97 From: RONALD BOWSER Time: 05:15pm \/To: JOHN FELTHAM (Read 6 times) Subj: VB Listserv YES :) you can go to http://peach.ease.lsoft.com and check the for other interest also. C++ Qbasic ect. Send mail to LISTSERV@PEACH.EASE.LSOFT.COM in the text body write SUBSCRIBE VISBAS-BEGINNERS or I think SUBSCRIBE VISBAS for the more advanced programmers. You can check the WEB site :) Hope this helps you and G'day to you also. 8-) <<***** On 04-17-97, JOHN FELTHAM wrote to ALL: *****>> JF>G'day All, JF> JF>Is there such a thing as a VB Liserv anywhere? JF> JF>If so what is the procedure for joining please? And the address. JF> JF>ooroo JF> JF>--- GoldED 2.42.G0614+ JF> * Origin: Coral Sea BBS K12Net Townsville North Queensland Oz. JF>(3:640/706) JF> -=*%*=-rbowser@nameless.com-=*%*=- -!- VbReader V1.4 Del *.* Best compression all around --- GEcho 1.11+ * Origin: (1:343/70) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00008 Date: 04/18/97 From: EILEEN LOUISE Time: 08:07am \/To: LAWRENCE KELLIE (Read 6 times) Subj: Database question Hi Lawrence, ->> I have an Access database. This is the construction of it: you will forgive me in advance if this doesn't work. i don't have access 2/VB3 and the syntax i'm offerring may not be quite correct -- and i can't test it. sorry ... but it should only require some minor changes. ->> Table1 ->> Table2 ->> Table1/Table2 have a one to many relationship, respectively. okay. to create a query to return the records you are interested in, try SELECT Table1.*, Table2.* FROM Table1 LEFT JOIN Table2 ON Table1.Table1ID = Table2.Table1ID (all one line of course) All fields from both tables will show up in this query. the left join is the one to many relationship you described, i think the rest is obvious. using VB3 and a data control, you have two choices on executing the binding. you can define the query in access and access it directly in your code (data1.recordset=query1). or you can codify the querydef. the former is certainly easier, however the latter has the advantage of keeping the code where you can see it without having to open the table to read the query, and allowing for parameterized queries. ->> I have a 2 Data controls. One to each table. Data2.Visible = ->> False. ->> Finally, I have 7 Text boxes, numbered Text1-Text7 with DataField ->> assignment for each assigned to the above list of fields, ->> respectively. as you have already found, this is very sloggy. ->> I would like all the text boxes to MoveNext together, giving the ->> impression that the two tables (or even two databases) are one. I by defining a SQL query, you are in effect making the two tables one. if you define the query in access, all you have to do is bind data1.database to your database, bind data1.recordset to your query1, set data1 as the text1(x).datasource bind the appropriate fields to your text boxes.datafields simple, huh? it gets more complicated with parameterized queries or queries defined on the fly. do you need to see that code? --- Flying Pond Software * Origin: Television is furniture. (1:326/431) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00009 Date: 04/15/97 From: MICHAEL JUNG Time: 01:46am \/To: ALLE (Read 6 times) Subj: Printing Hello! I have a problem printing filled circles. My cirlcle on the screen is filled with black color. All i've got on the Paper are empty circles. How can i rint a filled circle? Bye, Michael --- CrossPoint v3.11 R * Origin: Bestell mo dei Eis! (2:245/6666.39) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00010 Date: 04/16/97 From: GABRIEL GOLDMAN Time: 10:45pm \/To: JOHN TUBBS (Read 6 times) Subj: Apppath Hi John: I hope it's not to late (hey, I'm really far from there :*) ) JT> I've never encountered this problem before. In the path box in the JT> data control propteries box is there a way to enter the apppath so JT> it will default to whatever directory the user chooses at JT> installation time? Nope, not in the properties box. BUT you have a simple solution. After finishing the design stage, blank the path property and set the enabled propert of the data control to FALSE. In the load event of the form containing the data control, put the following lines: MyDataControl.DatabaseName = App.Path + "\database.dbf" MyDataControl.Enabled = True Is this what you're looking for?? Bye. Gaby.// --- RM 1.31 2261 A Canadian is an unarmed American with health insurance. --- * Origin: New Age BBS, +54-1-796-3900, 24 hs, Florida, Bs.As., Argentina (4:901/124) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00011 Date: 04/19/97 From: RICK PEDLEY Time: 02:46pm \/To: PHILLIP NORMAND (Read 6 times) Subj: let's forget the PAST! -=> Quoting Phillip Normand to Eileen Louise <=- PN> Once let just put the past behind! Shall We? Exactly. And the fastest way to achieve that is to say no more about it. BTW, don't you have access to netmail? I sent you something the other day. To summarize, it says what you just said. Nothing will be gained by anyone, or by the echo itself, if it continues. Has anyone heard from Randy Birch, the moderator, recently? I can't recall the last time I saw him post here. --- Blue Wave/DOS v2.20 * Origin: ...the vented spleen - kingston on (613) 544-9332 (1:249/139) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00012 Date: 04/19/97 From: LAWRENCE KELLIE Time: 06:25am \/To: JIM FARLEY (Read 6 times) Subj: Database question > Here is a suggestion Lawrence: Try ditching the second data control > and set the RecordSource property of the first data control to the > following SQL statement: > SELECT *.Table1, *.Table2 From Table1, Table2 WHERE Table1.Table1ID = > Table2.Table1ID Thanks for the suggestion. It gives me another avenue to work on. One point, when I set up the query, I found that the *.Table1 and *.Table2 had to be Table1.* and Table2.*, respectively. Lawrence ... I'm sorry, but my brain has developed a few bad sectors. --- FMail 1.0g * Origin: Cala Creek Resort (in seclusion) (1:343/70.164) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00013 Date: 04/19/97 From: LAWRENCE KELLIE Time: 06:32am \/To: ALL (Read 6 times) Subj: My First I have never really considered myself a programmer as I have pretty high expectations in that definition. However, that may be changing. I obtained my first "for real" programming assignment--and I even thought up the possibility of the solution and how to approach it. Consequently, I am quite excited. I need, however, the utility to access the user's login name (Novel 4.x), after he/she logs in. I see two differrent approach possibilities. Each user in our firm has a directory based on the login name on the network that is accessable to everyone and one that is private. Accessing the name through the pathway (i.e., g:\general\) would be fairly simple with the Right$ command to strip out the unwanted stuff. However, I noticed the other day, that an environment variable is set when a user logs on. It is USR=. I have searched through many of the VB3 Pro. helps/sources, but I am unable to determine how to access an environment variable value. Suggestions? Lawrence ... You disagree? May I plea guilty by reason of sanity? --- FMail 1.0g * Origin: Cala Creek Resort (in seclusion) (1:343/70.164) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00014 Date: 04/19/97 From: STEVEN LAGER Time: 12:11pm \/To: BUCKY CARR (Read 6 times) Subj: Just to butt in for a sec Hello Bucky! Thursday April 17 1997 15:00, Bucky Carr wrote to Eileen Louise: EL>> you are putting a lot of overhead on your form with all of these EL>> individual text boxes (and i assume labels as well). use control EL>> arrays. BC> There is that phrase again. My project's forms have tons of textboxes BC> for data entry, too. Guess I need to look up control arrays, eh? Just to throw in my two cents about control arrays Bucky, I wouldn't know what to do without them....... the project I am working on is heavy on TabStrips - Labels (display cumulative entries) and using control arrays have made the work much quicker and better. I have only just really begun to understand the concepts of control arrays and how they work and while a 'newbie' in this area of VB I wouldn't want to be without them. Steven Lager Sysop - The THIRD WAVE ... An elephant: A mouse built to government specifications. -L.Long --- GoldED/W32 3.00.Alpha5 UNREG * Origin: The THIRD WAVE --==[ Shotgun FDN H.Q. ]==-- (1:253/234) --------------- FIDO MESSAGE AREA==> TOPIC: 178 VISUAL BASIC Ref: E4Q00015 Date: 04/19/97 From: STEVEN LAGER Time: 12:17pm \/To: GARY SONNENBERG (Read 6 times) Subj: VB internet newsgroups? Hello Gary! Friday April 18 1997 23:54, Gary Sonnenberg wrote to Steven Lager: GS> Aw shucks, I'm blushin'. Thanks for the compliment. (Uh, that was me, GS> right?) without a doubt and you deserve it. Steven Lager Sysop - The THIRD WAVE ... When the ship lifts, all bills are paid. No regrets. - L.Long --- GoldED/W32 3.00.Alpha5 UNREG * Origin: The THIRD WAVE --==[ Shotgun FDN H.Q. ]==-- (1:253/234)