Search:

Type: Posts; User: Phill.W

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    9
    Views
    282

    Re: vb6: package and deployment wizard

    I absolutely agree with this.

    In over two decades of using VB "Proper", Option Explicit and Start With Full Compile have caught so many potential bugs for me that I wish there was a way of...
  2. Replies
    11
    Views
    449

    Re: Database beginner. I need help.

    OK, so you know nothing about Databases but think it would be a Good Idea to learn something about them.

    Personally, I think that's a great idea, but then I am a Database Administrator.

    There...
  3. Replies
    11
    Views
    449

    Re: Database beginner. I need help.

    Let's start from the very beginning.

    Why do you think you need a Database?

    Have you started to think about some particular Problem that you want to solve and have started thinking about the...
  4. Re: Gosh dang i cant find an answer anywhere?! hElp!!

    You have very little control over where the User chooses to put your program when they download it. It's their computer, after all.

    But, that said, the User should not be downloading your program...
  5. Replies
    5
    Views
    426

    Re: How can vb6 controls align as .Net?

    Call me old-fashioned, but I still write code in Resize events to take care of this so that I know exactly what's going where.

    Even in Visual Fred code!
    Yes, I've tried .Net's Aligning and...
  6. Replies
    15
    Views
    656

    Re: expiry date code

    Your constructed SQL is incorrect.


    Debug.Print SQL
    select id_name, from tbl_info where id_expire < '21/04/2020'"




    Did you open the connection before trying to use it to open a...
  7. Replies
    15
    Views
    656

    Re: expiry date code

    So you want records "where" the value of "id_expire" is "less than" the current time?



    SQL = "select field1, field2, field3 from tbl_info where id_expire < '" & txtTime.Text & "'"


    Some...
  8. Replies
    15
    Views
    656

    Re: expiry date code

    Not sure why you need a Timer to set your expiry dates but I won't worry about that now.

    When used with an iterable collection, like the ListItems property on the ListView control, the...
  9. Replies
    15
    Views
    656

    Re: expiry date code

    Well done!
    You've made the realisation that Users cannot enter Dates, but only a Character Representation of them.
    The same is true for numbers.
    It's a hugely important distinction that, sadly,...
  10. Replies
    15
    Views
    656

    Re: expiry date code

    I'm assuming that you're storing the "Item Detail"s in a [database] table, which now includes a column that holds the "Expiry Date".

    If that's the case, then you need to write a program that...
  11. Replies
    12
    Views
    597

    Re: VB6 crashes at start

    Under User Account Control, being an Administrator and running a Process as Administrator are not the same thing.

    You must go through the U.A.C. challenge to get into an "elevated" security...
  12. Replies
    7
    Views
    408

    Re: Cannot do a basic while loop

    1. Is this form set as the "StartUp Form" in the Project Properties?

    When you start a VB application, it will either
    load and display the Form that you specify or run a Sub of your choosing.
    ...
  13. Re: error 339, FM20.dll or its dependencies in Windows 10

    It should not have done so.
    You probably "got away with it" because the Users of the Application just happened to have a [paid-for] copy of Microsoft Office on their machine, of which fm20.dll is...
  14. Re: How to test for return string from GetPrivateProfileString

    GetPrivateProfileString does not return a string.

    Two of the arguments that you pass to the function are

    a buffer into which it can write the returned string, and
    the maximum length of...
  15. Replies
    10
    Views
    351

    Re: Error when start creation of .exe

    Errors on perfectly valid lines of code when making the Executable are often caused by broken or missing References.

    Check the Components and referenced Libraries used by the Project. I'd expect...
  16. Re: The parent class directly calls the methods of the child class (VB6)

    > "... properties and methods of child objects are obtained automatically ..."

    And this is exactly what the "Object-Based" VB6 does not do that the (proper, fully-fledged, "grown-up" Developer's)...
  17. Re: The parent class directly calls the methods of the child class (VB6)

    I would suggest that you've got it the wrong way around.

    VB6's partial implementation of Inheritance is to encapsulate an instance of the parent class in each child class and call the parent...
  18. Re: VB6 Error :Object variable or with block variable not set

    > "Private m_Session As ASPTypeLibrary.Session"

    The default value for a reference variable is Nothing. You have to instantiate the object before you can use it.

    I suspect you've either...
  19. Replies
    7
    Views
    568

    Re: Centering text in a MsgBox

    Question: I want to do something non-standard with MsgBox.

    Stock Answer: Write your own dialog that does what you want.

    Whilst you could spend [lots of] time making the standard dialog do...
  20. Thread: xls to csv

    by Phill.W
    Replies
    4
    Views
    361

    Re: xls to csv

    [From a very brief look], this is taking data from an Excel workbook and loading it into an Access database.

    It does not appear to have anything to do with CSV [files].

    The easiest way to...
  21. Re: ADO Querying a table based on a field without a key

    Others have found the root cause of your problem.

    Let me just add that this query will get progressively slower as your table increases in size.



    You should still be able to put an index...
  22. Thread: Overflow Error

    by Phill.W
    Replies
    4
    Views
    421

    Re: Overflow Error

    The Data Type of the variable into which you're going to store the result of this algebraic expression plays no part in the evaluation of the expression.

    VB can "get away with" Integer Data Types...
  23. Re: Record is inserting at improper place in .mdb database with vb6.0

    Rule #1 of Relational Databases (and, in this respect, even MS Access counts)


    Rows in Relational Tables have no intrinsic order.

    The database will store rows in any way that it finds...
  24. Replies
    7
    Views
    372

    Re: Function vs Macro

    > "What is the difference between a Function and a Macro?"

    First important distinction: VB doesn't have macros. :-)

    In C++, macros are a sort of "inline functions" that are injected by the...
  25. Re: Transferring data from textbox to textbox in sequence Vb6

    > "Whatever result I get from the numbers from above must be put in order ..."

    Now that sounds more like a Sorting problem.

    I would suggest that the only sane code for this involves Control...
  26. Re: Transferring data from textbox to textbox in sequence Vb6

    Sorry, but that sounds like Homework to me.

    What have you tried so far?

    Personally, I'd create a set (array) of values to choose from, then loop through the target TextBoxes (read up on...
  27. Thread: Search History

    by Phill.W
    Replies
    17
    Views
    982

    Re: Search History

    I suspect Zvoni means "DropDown", not "Textbox-Mode".



    Combo1.Style = vbDropDown


    With this set, you can pick from the items in the list or enter a completely new value.

    Regards, ...
  28. Thread: Search History

    by Phill.W
    Replies
    17
    Views
    982

    Re: Search History

    A simple solution would be to place a ComboBox behind the TextBox so that the dropdown arrow bit "sticks out" at the end of the TextBox.

    When the button is clicked, add the current TextBox value...
  29. Re: simple application to calculate grade of class students with output of five subje

    We don't provide answers for homework assignments. (That's your job).

    Ask us specific questions and we'll try to offer specific help.

    What have you tried so far?

    Regards, Phill W.
  30. Replies
    4
    Views
    445

    Re: form2 opens when the computer is start

    > "I want the form2 opens when the computer is start and run timer1 without open form1"

    If you want the program to start when the user logs in, why not just add a shortcut to it into the Windows...
  31. Replies
    16
    Views
    1,972

    Re: Convert string to date format

    Your safest option is the DateSerial() function.



    Dim sStartDate as String
    Dim dtStart as Date

    sStartDate = "121018"

    dtStart = DateSerial( _
  32. Replies
    16
    Views
    1,972

    Re: Convert string to date format

    The easiest way to convert things to a Date is the CDate() function but if your "input" data looks like "ddmmyy" (as suggested by your schema.ini file) then that won't work - that's effectively only...
  33. Replies
    16
    Views
    1,972

    Re: Convert string to date format

    > "How silly is it for programs to be cobbling together text and sending it to the DBMS to parse, construct a query plan, and then execute that?"

    But there's a whole industry built on trying to...
  34. Replies
    16
    Views
    1,972

    Re: Convert string to date format

    > "I am beginner in VB6 ..."

    Nice to know that people are still learning VB "Proper", even if it is sixteen years since its creators declared it Dead and Buried.

    > "... the conversation that i...
  35. Replies
    16
    Views
    1,972

    Re: Convert string to date format

    > "it's the first time that I convert a string to date."

    But your code is not converting anything into anything.
    There aren't actually any Dates in any of your code.

    Users cannot enter...
  36. Replies
    3
    Views
    422

    Re: Capture all change in form

    If you just want to "notice" when a change is made to a field on the Form, use the *Changed events on the various Controls.

    If you want a complete record of who changed what and when, then you...
  37. Replies
    13
    Views
    1,961

    Re: vb6 garbage collector

    There is no Garbage Collector in VB 6. That's a .Net thing.

    In VB, you have to "clean up" after yourself.

    If you create it, destroy it.
    If you open it, close it.

    Regards, Phill W.
  38. Replies
    4
    Views
    680

    Re: can anybody help in vb coding rk

    Excel's Macro Recorder is your Friend.

    Start the recorder, do the job manually, then stop the recorder and look at the code that it's written for you. You will need to modify this code, but it's...
  39. Replies
    31
    Views
    2,016

    Re: Declaring Variables

    Not a solution, but something to help highlight the problem:


    Option Explicit
    DefObj A-Z


    This tells VB to implicitly declare any variable starting with the letters A..Z (i.e .all of them)...
  40. Re: VB6: Chatbot transfer name from text to list

    I would not use a ListBox for this.
    OK, 32K entries sounds like a lot for an application like this, but it slows down considerably long before it gets to that limit.
    Also, it doesn't easily...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width