dcsimg

Search:

Type: Posts; User: Phill.W

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    348

    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...
  2. Thread: xls to csv

    by Phill.W
    Replies
    4
    Views
    240

    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...
  3. 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...
  4. Thread: Overflow Error

    by Phill.W
    Replies
    4
    Views
    282

    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...
  5. 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...
  6. Replies
    7
    Views
    329

    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...
  7. 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...
  8. 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...
  9. Thread: Search History

    by Phill.W
    Replies
    17
    Views
    861

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

    by Phill.W
    Replies
    17
    Views
    861

    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...
  11. 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.
  12. Replies
    4
    Views
    417

    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...
  13. Replies
    16
    Views
    1,003

    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( _
  14. Replies
    16
    Views
    1,003

    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...
  15. Replies
    16
    Views
    1,003

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

    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...
  17. Replies
    16
    Views
    1,003

    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...
  18. Replies
    3
    Views
    400

    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...
  19. Replies
    13
    Views
    1,477

    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.
  20. Replies
    4
    Views
    644

    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...
  21. Replies
    31
    Views
    1,935

    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)...
  22. 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...
  23. 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...
  24. 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...
  25. Replies
    8
    Views
    755

    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]...
  26. 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 =...
  27. Replies
    2
    Views
    351

    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.
  28. Replies
    3
    Views
    332

    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...
  29. Replies
    14
    Views
    1,041

    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 /...
  30. Replies
    14
    Views
    1,041

    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...
  31. Replies
    10
    Views
    891

    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...
  32. Replies
    10
    Views
    891

    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"...
  33. Replies
    10
    Views
    724

    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$()...
  34. Replies
    7
    Views
    647

    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...
  35. Replies
    28
    Views
    1,817

    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...
  36. Replies
    28
    Views
    1,817

    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...
  37. 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...
  38. Replies
    6
    Views
    467

    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...
  39. Replies
    12
    Views
    3,528

    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='" &...
  40. Replies
    12
    Views
    3,528

    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. ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width