Search Results - VBForums

Search:

Type: Posts; User: si_the_geek

Page 1 of 13 1 2 3 4

Search: Search took 0.67 seconds.

  1. Replies
    13
    Views
    275

    Re: need help with coding

    Welcome to VBForums :wave:

    Thread moved from the 'VB6 and Earlier' forum to the 'VB.Net' (VB2002 and later) forum
  2. Replies
    2
    Views
    176

    VS 2013 Re: communication port sÚrie

    Welcome to VBForums tintine :wave:

    This is an English speaking site, so please post only in English... you can use Google translator (like Mc_VB did for you) if it helps.
  3. Re: Register form- What to add security levels

    Thread moved from the FAQ forum, which is not the place to post your questions.
  4. Replies
    2
    Views
    123

    Re: Sql Statement

    Thread moved to the 'Database Development' forum - which is where you should always post SQL questions (while SQL can be used in VB, it is certainly not specific to VB)


    Don't just tell us "an...
  5. Replies
    3
    Views
    130

    Re: More on parameterization.

    I'm afraid I don't know, as the controls available vary by the application which hosts VBA (and it's been years since I used VBA regularly).

    I'd recommend asking in the Office Development forum.
  6. Replies
    3
    Views
    130

    Re: More on parameterization.

    Textboxes are controls that allow string input, so they always contain strings... and strings are always "of the string variety", no matter what they look like.

    If you want to stop a user from...
  7. Re: I need help with an sql statement syntax please.

    If you are using ADO it is.

    I see you are using DoCmd, which I suspect means you are using DAO. I'm afraid I haven't used DAO for many years, so I can't help with the syntax you would need... but...
  8. Re: I need help with an sql statement syntax please.

    It wouldn't be much work... you would just copy+paste a small section of code (to set up and run the command), and replace the values that you currently append to the SQL statement with placeholders,...
  9. Re: I need help with an sql statement syntax please.

    That Insert example is from the FAQ article "How can I add a record to a database?", and that is one of the methods shown that does not use parameters. Here is the version of the same thing, but...
  10. Replies
    1
    Views
    98

    Re: Simplifying a database.

    The way to have "less clicks and less screens" is to design the screens (and functions within them) appropriately, wherever possible streamlining the process for the user.


    As an example, think...
  11. Replies
    4
    Views
    318

    Re: VBA Excel - Sort, Copy and Paste.

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.
  12. Re: I need help with an sql statement syntax please.

    Parameters work the same no matter what SQL statement you are using... you replace the values in the statement with placeholders (which varies by database system, but includes ? and @ParameterName),...
  13. Re: How to Print Selected Item on Listview using ADODB Connection

    Welcome to VBForums :wave:

    Thread moved from the 'CodeBank VB6' forum (which is for you to post working code examples, not questions) to the 'VB6 and earlier' forum
  14. Replies
    5
    Views
    311

    Re: Health and fitness

    As it isn't computer related it would need to be as a sub-forum of Chit-Chat... but given that we don't get many threads about that kind of thing, it would be best to post directly in the Chit-Chat...
  15. Replies
    2
    Views
    230

    Re: Help with migrated code

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.
  16. VS 2010 Re: Which is faster that VB will read the code?

    The code runs at the same speed. Calling a function takes a tiny amount of time, so you should ignore it unless you are doing it in a loop that you call millions of times.


    There are much bigger...
  17. Replies
    3
    Views
    228

    VS 2013 Re: Excel UPDATE error

    For an update the syntax is:

    UPDATE table

    SET field1 = value1
    , field2 = value2

    WHERE conditionYou can find more information and examples via our Database Development FAQs/Tutorials (at...
  18. Thread: Array

    by si_the_geek
    Replies
    22
    Views
    662

    Re: Array

    Thread moved from the 'CodeBank VB6' forum (which is for you to post working code examples, not questions) to the 'VB6 and earlier' forum
  19. Re: Transfer data between Multiple Database and recommended database

    Apparently so, but I've cleared up the mess it made :)
  20. Re: Login system with different firms for different groups

    You will need to store somewhere (presumably in the database) which users should have which permissions.

    If you are certain that you will only ever have the two sets of permissions you could use a...
  21. Replies
    2
    Views
    171

    Re: format nember in vba for excel

    Thread moved from the 'Database Development' forum to the 'Office Development/VBA' forum
  22. Re: Firebird db, connecting to local and remote server

    Possibly, it is a bit vague... and looks like it might just be inside that application.

    That has something useful: the "TCP/IP connection strings" has the kind of thing you want, which it does...
  23. Replies
    3
    Views
    125

    Re: mysql syntax error

    You haven't got the right amount of single-quote ( ' ) characters in this section:
  24. Re: Firebird db, connecting to local and remote server

    If by "real" you mean server-based (like SQL Server etc) rather than file-based (like .mdb files etc) then yes, you don't need the path.

    In this case you did need a path when it was local, so...
  25. Re: Firebird db, connecting to local and remote server

    I've never used Firebird, but an obvious problem with your new connection string is that it no longer contains any information about where on the computer the database file is... and if you don't...
  26. Re: how to bind datagridview to database at page load time in vb6

    Thread moved from the 'VB6 and Earlier' forum to the 'VB.Net' (VB2002 and later) forum
  27. Re: Making my codwe shorter and Easier to read and Write

    In terms of the size and effort to write the code, you could create a Sub to do the work of those three lines, and pass parameters to it.

    Assuming the sub was like this:

    Sub...
  28. Replies
    4
    Views
    262

    Re: Deleting files form Listbox

    Welcome to VBForums :wave:

    Thread moved from the 'VB6 and Earlier' forum to the 'VB.Net' (VB2002 and later) forum

    (thanks for letting us know Sam :thumb: )
  29. Re: [RESOLVED] Code for program to re-structure itself?!

    Whether you like it or not, you were on a path that had no obvious good points beyond random learning... even if you had somehow got past the wide variety of very awkward things you would need to do...
  30. Replies
    9
    Views
    407

    Re: get screen resolution on windows 2000

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.
  31. Replies
    2
    Views
    255

    Re: Line breaks in a MsgBox

    Welcome to VBForums :wave:

    Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum.
  32. Thread: test

    by si_the_geek
    Replies
    2
    Views
    331

    Re: test

    Welcome to VBForums :wave:

    Your posts currently wont be visible immediately, as our security system (which helps block large amounts of spammers, and other unwanted people) has decided for some...
  33. Re: Where is the problem ??? format string

    The data type Long (also known as Long Integer) can only contain whole numbers... if you want decimal places, you will need to use another data type that allows them, such as...
  34. VS 2012 Re: VB2012 Adding record to database problem

    Welcome to VBForums :wave:

    The most likely cause of the problem is your field names. While it is possible to use spaces and other non-alphanumeric characters (such as - ) within field names, it...
  35. Replies
    2
    Views
    241

    Re: Rotate Textbox

    Thread moved from the 'CodeBank VB6' forum (which is for you to post working code examples, not questions) to the 'VB6 and earlier' forum
  36. Re: A lightweight Flexible replacement for a 2D array.

    The only changes I would make would be to change the ColumnDelimiter and RowDelimiter parameters so that they are optional (with default values of Tab and NewLine), and alter GetColumnText so that it...
  37. Re: Administrating Database with Sensitive Info

    Correct... and the bonus points to it include that you can change both apps without having to touch either of them directly, you can change the database structure without having to re-write the apps...
  38. Re: (VB 2010) Score and Object Removal

    Welcome to VBForums :wave:

    Thread moved from the 'Game Demos' forum (which is for you to post working examples, not questions) to the 'Games and Graphics' forum
  39. Replies
    8
    Views
    235

    Re: Missing .frm file

    You can start a new project, and create a new form that way with the same name (then just copy the .frm file over).

    Unfortunately the code is stored in the .frm file, so without it your options...
  40. Re: Administrating Database with Sensitive Info

    What I generally do in situations like this is create separate database users/groups (in this case one for the Winforms app, and one for the web app), and separate stored procedures to suit their...
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.