Search Results - VBForums

Search:

Type: Posts; User: dee-u

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds.

  1. Replies
    14
    Views
    210

    Re: Count and Sum using SQL (MS Access and ADO)

    COUNT and SUM normally returns just one value/record, perhaps you can clarify where you want to use distinct?
  2. Replies
    16
    Views
    269

    Re: Warm welcome to my recruit

    Too late! :D



    Indeed you are, you can always go back to this thread for you to remember that you are special to me. :thumb:
  3. Replies
    16
    Views
    269

    Re: Warm welcome to my recruit

    :cry: My heart melts, you also used our picture as your avatar? I am elated! :)
  4. Replies
    16
    Views
    269

    Re: Warm welcome to my recruit

    Actually, I am that nice looking girl, and blue bubble is that guy! :D
  5. Replies
    14
    Views
    210

    Re: Count and Sum using SQL (MS Access and ADO)

    You can return a recordset with the Execute command and read its field. This is hand coded so it may have some errors:

    dim adoR as ADODB.Recordset
    cSQL = "SELECT COUNT(cField) AS nVariable FROM...
  6. Replies
    16
    Views
    269

    Re: Warm welcome to my recruit

    If given the chance I would have taught my classes with C# but then our Dean prefers VB.Net for whatever reason. We use PHP in web development. I've asked her to join us here so the experts here...
  7. Replies
    16
    Views
    269

    Warm welcome to my recruit

    I've always advertised our site to my classes specially those who really wanted to learn and this time, with great pleasure, I am welcoming this lad who topped their batch! It is blue_bubble, please...
  8. Replies
    33
    Views
    420

    Poll: Re: Decisions: To EAT THE PEEL or NOT?

    When I was young the adults said not to peel, until they offered me a coconut.
  9. Thread: IE no more?

    by dee-u
    Replies
    25
    Views
    410

    Re: IE no more?

    Is the Aptana Studio a freeware? Looks cool based on your description.
  10. Thread: IE no more?

    by dee-u
    Replies
    25
    Views
    410

    IE no more?

    What can we use to download other browsers then?
  11. Replies
    5
    Views
    137

    Re: [RESOLVED] Generate Data via ADO

    Without the Generate Script of Management Studio I would still be using that linked SP, glad it also works for you. :-)
  12. Replies
    5
    Views
    137

    Re: Generate Data via ADO

    If you want to use an SP you may want to have a look at this one: http://vyaskn.tripod.com/code/generate_inserts_2005.txt

    I've tried it before and it worked but that is, I used it in old...
  13. Re: DeskView Monitor [Updated: March 17th, 2015]

    Okay, that did it, thanks! I wanted to make something like this one, I'm glad you saved me some effort. :-)
  14. Re: DeskView Monitor [Updated: March 17th, 2015]

    Upon clicking the settings there is nothing selected in the Network Interface and even when I selected the Wireless Connection there is nothing displayed in the form. See attached screenshot:124809
  15. Re: DeskView Monitor [Updated: March 17th, 2015]

    Is there any specific configuration I should set to be able to use it on same computer? I was able to run the client fine but I am having problems with the Server, see error below. I am using a...
  16. Re: DeskView Monitor

    Where can we find xtracontrols? I would assume that the client will be displayed in the SystemTray, right? As an Administrator I would prefer that the client should not be able to close the app so I...
  17. Re: Site loading/refreshing very slow in Chrome

    No problem here as well although a few days ago I seem to have a problem with Chrome, typing on it was very slow, it was somewhat lagging and couldn't load FB well, I have updated it since and all is...
  18. Thread: Select Query

    by dee-u
    Replies
    8
    Views
    228

    Re: Select Query

    This returns the date yesterday

    SELECT getdate()-1
  19. Replies
    7
    Views
    434

    Re: DAO To Open Access MDB

    That is classic ADO, not ADO.Net.
  20. Replies
    14
    Views
    582

    Re: Question on why to use VB over others

    One benefit of prefering C# over VB is that when you decide on learning Java and PHP the syntax will be very familiar.
  21. Replies
    2
    Views
    171

    VS 2010 Re: MDIChild Maximized bug?

    No, it is 0,0. From the looks of it it appears the child form should be maximized already as its title bar already merges with the menustrip as can be seen in the image but form size is not. If I...
  22. Replies
    2
    Views
    171

    VS 2010 MDIChild Maximized bug?

    Its been a while since I last use an MDI Form and when I tried it I happen to be experiencing what is shown in the screenshot. It will appear that the Child form is maximized, or not? I've only used...
  23. Replies
    6
    Views
    234

    VS 2010 Re: OOP Programme example & question

    Make private anything that you don't want to be seen outside of its class.
  24. Replies
    14
    Views
    305

    Re: Ridiculously tired right now

    124393
  25. Replies
    14
    Views
    305

    Re: Ridiculously tired right now

    Perhaps you need a wife if you don't already have one.
  26. Replies
    3
    Views
    138

    Re: MySQL Server and Wampserver side by side?

    I made a workaround, peeked into the mysql database of the MySQL Server and found out that it has a root username but with a password (which I don't know, I did not set one when I installed it and I...
  27. Replies
    3
    Views
    138

    Re: MySQL Server and Wampserver side by side?

    Yes, it does have its .ini file and the odd thing is it contains only the following:

    It sure should try connecting to the wampserver instance in that setting but even if the wampserver is off the...
  28. Replies
    3
    Views
    138

    MySQL Server and Wampserver side by side?

    I've already got Wampserver and I can access it find. Now I need to review a certain in-house program which uses MySQL Server, problem is I don't know how to connect and view the details of the...
  29. Replies
    14
    Views
    473

    Re: Maintaining commit-ment?

    You need chunking
    http://www.vbforums.com/showthread.php?766209-Programming-Keeping-the-fire&p=4702043&viewfull=1#post4702043
  30. Replies
    1
    Views
    253

    VB.Net to C# (Pauser of jm)

    I am trying to convert the following code of jmcilhinney:

    http://www.vbforums.com/showthread.php?717921-Adding-a-Pause-to-Your-Code&highlight=pause

    I'm stucked on the line

    ...
  31. Replies
    13
    Views
    317

    Preventing Carpal Tunnel Syndrome

    Just saw my former computer instructor and she has CTS now, I'm just wondering guys if you are concerned about it and what prevention are you doing?
  32. Replies
    25
    Views
    600

    Re: We Got Windows 8.1

    I can't remember where I've read it but one feedback on Windows 7 and below was that we had to click Start to Shutdown, perhaps Microsoft did hear that comment? I don't like Windows 8 specially if it...
  33. Replies
    17
    Views
    491

    Re: trying to get rid of in a query

    Can you try NOT IN and see if it it will speed it up?

    select *
    FROM VTEXTERNAL.dbo.MOVIE M
    RIGHT JOIN (SELECT Film_strCode,MAX(Person_strCode) as Person_strCode FROM VISTAHO.dbo.tblFilmPerson...
  34. Replies
    17
    Views
    833

    Re: What is your favorite program?

    For programming utility:

    Management Studio - SQL Server
    SQLYog - MySQL
    Wampserver - PHP/MySQL
    Notepad++ - HTML/PHP
    Filezilla - for uploading website contents
    Photoshop - for graphic designs...
  35. Re: Temporarily store form data (retrieve after restart)

    Nice one, this worked but will test it further. Are there any conditions where it will not work? We are using Wampserver for this and it will be on the local network.
  36. Thread: Inheritd Types

    by dee-u
    Replies
    9
    Views
    400

    Re: Inheritd Types

    If I may have a say on this I think your current implementation has its drawbacks. The problem with your GetData is it can only select from a specific table using a primary key (how about a composite...
  37. Temporarily store form data (retrieve after restart)

    Our form has lots of fields and we would like to be able to temporarily save it before submitting so even if there was a sudden power interruption the user could still restore it. Is cookie the way...
  38. Replies
    3
    Views
    270

    Re: What's with this new ad/popup??

    It is appearing more frequently to me these days, starting last week.
  39. Replies
    56
    Views
    1,148

    Re: Help JR Lose Weight For The Wedding!

    Why lose weight now if you are just going to gain it again in a while?
  40. Thread: Dead of Alive?

    by dee-u
    Replies
    22
    Views
    514

    Re: Dead of Alive?

    That monk is dead OF alive.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.