dcsimg

Search:

Type: Posts; User: Phill.W

Page 1 of 13 1 2 3 4

Search: Search took 0.54 seconds.

  1. Replies
    7
    Views
    251

    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...
  2. 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...
  3. 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...
  4. Thread: Search History

    by Phill.W
    Replies
    17
    Views
    663

    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, ...
  5. Thread: Search History

    by Phill.W
    Replies
    17
    Views
    663

    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...
  6. 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.
  7. Replies
    4
    Views
    380

    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...
  8. Replies
    16
    Views
    827

    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( _
  9. Replies
    16
    Views
    827

    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...
  10. Replies
    16
    Views
    827

    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...
  11. Replies
    16
    Views
    827

    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...
  12. Replies
    16
    Views
    827

    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...
  13. Replies
    3
    Views
    373

    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...
  14. Replies
    13
    Views
    1,195

    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.
  15. Replies
    4
    Views
    615

    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...
  16. Replies
    31
    Views
    1,858

    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)...
  17. 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...
  18. Re: Change Date format in windows xp to 10

    > "how to use "format" properties to display as "dd-mm-yy" when the user start typing. ??"

    Again, you don't.

    The User should enter a date (or, rather, the Character Representation of a Date...
  19. Re: Change Date format in windows xp to 10

    > "I need to set my date format to dd-mm-yy"

    No, you don't.

    You need to learn how to work with Dates, including

    How to parse Date values from the String values that Users can enter...
  20. Replies
    8
    Views
    652

    Re: Opening many recordsets

    Make the RecordSet variable, RS, local to the Sub.
    That way, it doesn't matter how many events you trigger, how many times you call this code, you cannot get one invocation nullifying the [shared]...
  21. Re: trying to check between hours nothing works why?

    So you need to find any Customer with a free period that completely contains the appointment they you've just cancelled?

    Something like this?



    cancelledStart = "10:15"
    cancelledEnd =...
  22. Replies
    2
    Views
    326

    Re: Problem with FileCopy

    > "could be another bot posting ..."

    Surely not.
    No self-respecting Bot would ever write such appallingly bad code. :bigyello:

    Regards, Phill W.
  23. Replies
    3
    Views
    305

    Re: Adodc Recordsource (HELP)

    > "So i made a program that creates a table using a name from textbox ..."

    Bad Idea.

    Database != WorkBook.
    Table != Spreadsheet.


    If the user enters a name that isn't a valid table name...
  24. Replies
    14
    Views
    950

    Re: Access Denied

    Agreed; a Timer on its own will not cause this problem.

    What are Timers often used for? Giving visual feedback about a process.

    What does visual feedback involve? Using properties /...
  25. Replies
    14
    Views
    950

    Re: Access Denied

    > "I always Set the form (full form name) to equal Nothing after carrying out the Unload statement (using Me. I wonder of I should use the full name there too?). "

    The Form's "name" is a...
  26. Replies
    10
    Views
    789

    Re: Follow-up on Binary Compatibility

    > "I was hoping the compiler ... would not only flag it, but not create a new binary and hence a new Class ID."

    That is how it behaves.

    See this posting for a sample of the warning dialog that...
  27. Replies
    10
    Views
    789

    Re: Follow-up on Binary Compatibility

    If a build is going to break Binary compatibility, VB will tell you so before it does so.

    If I recall correctly, it offers you the change to break compatibility, or "downgrade" it to "Project"...
  28. Replies
    10
    Views
    681

    Re: Iterate dir and txt

    The easiest way is to use the Dir$() function but there's a huge "Gotcha" with it - while you are looping through one directory using Dir$(), you cannot then loop through another directory - Dir$()...
  29. Replies
    7
    Views
    593

    Re: Add ( WHERE + word ) at query

    Remember: SQL is just a String that happens to contain something that your Database can understand.

    Start by creating the SQL that you need in whatever utility program your database uses. Then...
  30. Replies
    28
    Views
    1,701

    Re: SQL Query in order except first record

    > "I think they can intuit a user interface, almost instantly. If they can't ... it is a bad design."

    Absolutely agree.

    I despair of many of the "modern" Microsoft offerings, plastered with...
  31. Replies
    28
    Views
    1,701

    Re: SQL Query in order except first record

    Windows used to have a consistent, [mostly] intuitive User Interface paradigm whereby if you could use one application, you could pretty much use any application. Life was Good. You didn't have to...
  32. Re: Giving the user the ability to abort a long running process

    > "will the Click method of the Abort button "cmdAbortProcess_Click" fire without a DoEvents"

    No. Without DoEvents, the click will be queued until the heavy process has finished.

    The call to...
  33. Replies
    6
    Views
    430

    Re: search a TABLE in MS ACCESS

    > "Every patient has its own table for their own records"

    Terrible idea, even in Access.

    How do you intended to search across patients?
    You could write a loop to search ea Patient table in...
  34. Replies
    12
    Views
    2,316

    Re: Date Format VB6

    > "No need to bother with SQL-Syntax-Differences between different Database-Systems"

    Really?

    From the original post:



    rs1.Open "SELECT * FROM tbl_hourlysalesdetails WHERE Date='" &...
  35. Replies
    12
    Views
    2,316

    Re: Date Format VB6

    Zvoni,

    Sorry, but I have to disagree with this advice.

    Whilst, admittedly, date values in VB can be used in this form, you should not make the assumption that your DBMS(s) will do the same. ...
  36. Replies
    12
    Views
    2,316

    Re: Date Format VB6

    > "The value of my dates in my database is ="MMDDYYYY""

    I think you mean the format of your dates.

    Here's a very important truth about Dates in Databases:


    Dates have no format.
    ...
  37. Re: My VB6 written app always freezes on my windows 8.1 pro

    VB applications won't "redraw" themselves while they're busy doing stuff.

    Add calls to the Refresh method on the Controls (TextBoxes, etc.) that you've updated.



    With Text1
    ' Append...
  38. Replies
    24
    Views
    2,498

    Re: ListView not responding to code

    OK, let's get the really daft stuff out of the way ...


    Have you got more than one ListView?
    You haven't somehow created a ListView2 (or a ListView1(1)) that sits "over the top" of ListView1?...
  39. Replies
    24
    Views
    2,498

    Re: ListView not responding to code

    What if you try adding "dummy" items into the listview at the same time?



    If strValue2 <> "" Then
    Set lstItem = Me.ListView1.ListItems.Add() ' Add items and subitems to list control.
    ...
  40. Replies
    24
    Views
    2,498

    Re: ListView not responding to code

    Let's see some more of the "data loading" code - like the loop construct that's driving it.

    When you debug the code, does it pass through Me.ListView1.ListItems.Add() more than once?

    Regards,...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width