Hi guys i ve a pic box with listview and lbl cntrls (display dates). I am looking for a way to print the listiview control along with the lbl ctrls. The lview...
Hi Geoff 'This one is correct Private Sub Form_Load() datMain.RecordSource = _ "SELECT * FROM PhoneBook_T" & _ "ORDER BY Contact" datMain.Refresh End Sub % is...
Good Morning Geoff, ... Ooooops, I goofed, and I apologize. I forgot to mention that my forked tongue was firmly embedded in my cheek. I think Dot Net will be...
Hi Michelle, ... Been There, got the Tee Shirt, and The Tuxedo. Look at the attached text file. There are many comments that should explain everything fairly...
... Good point, well said Andrew. While everyone, the employees, and the owners of the company, would love to have shiny new equipment and software, sometimes...
Good Morning sa, You must want to print images of screen captures because we can easily print all of the data, including the 'hidden' data, to a text file. If...
This is a question I guess on etiquette. Lately, I use mostly VBA in different applications. I have found (sort of by laziness) that Excel does not care if I...
Wow... nice work, Steve. ________________________________ From: helpwithvb@yahoogroups.com [mailto:helpwithvb@yahoogroups.com] On Behalf Of Steve Manser Sent:...
Hi Geoff, ... That's my mistake. When I said "%" is the wildcard, I meant with regard to "LIKE". "*" is still the correct wildcard in the SELECT clause. You...
Hi Tim, ... You can make VBA require variable declaration the same way as VB - by placing "Option Explicit" at the top of each module. And in either case, it ...
Tim: Can you say "can of worms"? I knew that you could. Let's think about this Dim thing for a moment. What happens when you Dim... what happens when you...
Thank you, Bruce. Excellent tutorial and advice. I was actually surprised that VB allowed it, because C pitches a royal fit over these things. I will stick...
Hello all, I have written a program that searches a recordset for a particular job number. The statement is below: rstJobCommPayment.Find "JobNo = " &...
Debbie Schmidt
debbies@...
Nov 2, 2006 3:14 am
18791
Hi Bruce, ... My 2 cents: Implicit type conversion is confusing if you also use method overloading (even worse if you also use operator overloading). Since VB6...
Hi, ... How did you test for EOF? VB/VBA has a global function by the same name for testing whether the end of a previously opened text file has been reached. ...
Hi Steve, Thanks for the help. When I try this File_Path = Path & strArray(lstFiles.ListIndex) imgShow.Picture = LoadPicture(File_Path) I get object not found....
Adelle, Yes, to cover my bases, It did a test for .EOF and .BOF, however that didn't work the way I thought it would. I didn't know if that was the only...
Debbie Schmidt
debbies@...
Nov 2, 2006 3:19 pm
18796
I believe that would work -- certainly it does if you use ADO. however, if using DAO, I usually use the recordset object's NoMatch() method. After any Find...
Hello Chris, Thank you for this info. Do you know who the author is, and if the book is available in electronic format? Thanks. Geoff ... From: Bharati K To:...
Hi Bruce, ... My 2 cents: (Worth more than that, Adelle:) Implicit type conversion is confusing if you also use method overloading (even worse if you also use...
Bruce, Thanks, I am using ADO and I'm afraid to mix in DAO also, though in this case, I would prefer it. It seems ADO does not have a NoMatch equivalent, ...
Debbie Schmidt
debbies@...
Nov 2, 2006 3:43 pm
18800
Hello Steve, Appologies not needed, Grinning! I probably misunderstood the spirit in which your remarks were intended. Therefore, I'm as much to blame for any...
Hello Adelle, Chuckling! Thanks. I hadn't noticed the missing space and I take on board what both you and Mike say. Much appreciated. Geoff ... From: Adelle...
Hello Mike, Thank you for taking the time out to clarify my error. I don't have time right now, to test it, but I shall do very soon. Thanks again, Geoff ... ...
... Good Morning Debbie, VB-6 and ADO An ADO Recordset has two Pseudo Files: BOF and EOF Normally the cursor will point to a single record within the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
