Search Results - VBForums

Search:

Type: Posts; User: DataMiser

Page 1 of 13 1 2 3 4

Search: Search took 0.12 seconds.

  1. Re: VB6 dont release write protection from opened file

    Have you tried using a new project where the only thing you do is open the connection, open an rs, close rs and connection to see if you experience the same problem?
    I still think your problem is...
  2. Replies
    1
    Views
    101

    Re: Sales Invoice using Bar Code in VB6

    Not 100% sure what you mean by "how to create sales invoice using Bar Code"

    Do you mean that you want to add a barcode to your invoice or do you mean that you want to scan a barcode and generate...
  3. Re: VB6 dont release write protection from opened file

    Yeah I do not see anything there that should cause the reported problem. I would suspect that the source of the issue is elsewhere in the code.

    I also agree that you should not use the As New...
  4. Replies
    1
    Views
    98

    Re: Odd ADODB.NET connection error

    Well first of all that is not ADO.Net it is ADO
    Secondly it is not telling you that there is a connection error.

    It is telling you that there is a missing parameter somewhere. It would help if...
  5. Re: Constructing features of forgotten passwords by email

    Yes you can send an email using VB6

    As for constructing features of a forgotten password I have no idea what you mean by that.

    Can VB retrieve the password and send it? Maybe, that would depend...
  6. Replies
    12
    Views
    338

    Re: [RESOLVED] JAVA is faster than VB6?

    I wonder if netbeans fully compiles the code to an exe before executing it. I know VB.Net does.

    I'm not really sure how VB4-6 handles the code running in the IDE. There is an option there for full...
  7. Replies
    12
    Views
    338

    Re: JAVA is faster than VB6?

    IIF is slow use If Then Else construct instead
  8. Replies
    18
    Views
    270

    Re: Improve VB6 Controls' Appearance?!

    I agree with the previous comment about the Windows classic look. I have been writing professional apps for many years and have saw many written by others. I like the clean basic look of the standard...
  9. Re: [VB6 error] Automation error Call was rejected by callee

    Set wb = GetObject(App.Path & "\BANG_TINH_QUY_CHUAN_2015.xls)

    It is missing the closing " at the end of the filename
  10. Replies
    13
    Views
    216

    Re: question on recordset

    If you want to return data then you should use the rs.open method
    If you want to execute an action query you should use the execute method.

    IMO Set Rs=Cn.Execute should not be used. I personally...
  11. Replies
    13
    Views
    216

    Re: question on recordset

    No!

    Once again, You do not use a recordset when you are not returning data. The is no need for a recordset, nothing to go into a recordset, no reason to use a recordset. The db engine will handle...
  12. Re: changing .setfucus from a listbox to another in a access form

    Do all of those lists have the same number of items in them? If not then you would run into problems

    Show the code you used when you got the most recent error you mention
  13. Replies
    10
    Views
    236

    Re: Compiling EXE issues

    The error indicates that there is no variable or object defined by that name in the current scope. so either you have spelled the name wrong or it is on a different form or doesn't exist.

    Show...
  14. Replies
    13
    Views
    216

    Re: question on recordset

    There you are using both the execute and the recordset.

    I was referring to cases where no records are returned. There you should use execute rather than rs.open

    Did you understand what i said...
  15. Replies
    13
    Views
    216

    Re: question on recordset

    If there are to be no records returned then you should not be using a recordset

    You should be using the execute method instead

    Also why have you used your own variables rather than the...
  16. Re: changing .setfucus from a listbox to another in a access form

    There is no need to set focus. You can simply set the listindex to any valid value

    You also did not answer the other questions such as are they are visible, is there other code that you have in...
  17. Replies
    11
    Views
    229

    Re: enum for data type conversion

    Debug.Print IsNumeric(Null)

    returns false

    same with an empty string or a string that is not numeric
  18. Re: changing .setfucus from a listbox to another in a access form

    Do you also have code that fires when the list gets focus and/or when the listindex/selecteditem changes?
    Are all of those listboxes visible?

    Why do you feel the need to jump around on them with...
  19. Replies
    11
    Views
    229

    Re: enum for data type conversion

    Ok.. that might make more sense depending on how you are trying to do it but still not much.

    IsNumeric() seems like what you need followed by the proper conversion
  20. Re: creat a number of transactions by date automatically

    If you want to be able to sort those records on the transaction field then you should reformat the date portion to use YYYYMMDD other wise there will be all mixed up as the months pass.

    For...
  21. Replies
    11
    Views
    229

    Re: enum for data type conversion

    It really makes no sense at all to do this. If you do then you will end up having to type more characters when you convert anything and you would be returning a variant instead of an actual double or...
  22. Replies
    11
    Views
    229

    Re: enum for data type conversion

    Why would you even try to do this?
    It shouldn't be done.
    Those are functions not values.
    If you really want to wrap these functions then you do so by creating a function but would be a waste of...
  23. Re: what is this run-time error ?

    It would help if you showed the code. I am assuming that you are using an RS.Update statement.
    That error is generated when one or more of the field assignments can't be made.
  24. Re: Put file .EXE online for Auto Update purpose

    Mot ISPs grant you at least a small amount of web space and there are free hosting options out there as well as paid ones that cost very little.

    Create a web site and use it.
  25. Replies
    23
    Views
    666

    Re: Run VB6 program on Win 7/8 and later

    It may help if you were to tell us what the actual error message was that you receive.
    Are you using any 3rd party controls or dlls?
  26. Re: how to set textbox date formating as dd-mm-yyyy

    You would use that format statement but use the variable that holds the date you want to use rather than Date
    Date is a function which returns the current system date.

    If your date is stored in a...
  27. Replies
    5
    Views
    204

    Re: Need Data Widgets Program for Windows 7

    I have not used those either but they are really really old. I'm not sure they were even available back when VB6 was released. As you can see by the names they included 16 bit versions which strongly...
  28. Re: syntax error in update statement run time error -2147217900 (80040e14)

    You still have the same issue I pointed out in my first reply


    harga='100000'

    the field harga is defined as being Numeric in your database. You do not use quotes when working with numeric...
  29. Re: syntax error in update statement run time error -2147217900 (80040e14)

    & "harga= '" & Text3.Text & "'," _

    harga is a numeric field. You are not supposed to use 's around the values for numeric fields so that is throwing a syntax error
  30. Replies
    4
    Views
    193

    Re: Edit, Save records ADO

    In your first part you are pulling all data from the table to add a new record. You should not be doing this. You should structure your select to where it only returns the records you need. In the...
  31. Replies
    13
    Views
    485

    Re: Display data Horizontally

    How depends on where the data is coming from and what you are using to display it. You haven't given us any info to go on so.....
  32. Re: I can't loop through the images one by one

    For v = 1 To 2 Step 5 What this does is tell the program that you want to count up from 1 to 2 and you want to do so by adding 5

    The result is that it will not loop at all. The first time it will...
  33. Re: I can't loop through the images one by one

    Well first of all keep in mind that if you have code like

    show picture1
    show picture2

    you will only see picture2 because the code loads and replaces the first picture before it can even be...
  34. Replies
    10
    Views
    312

    Re: problems in creating a *txt file

    I did not notice that either. All of the print statements use the correct iFileNo but I would image that it is jumping to the error handler as soon as he tries to open the file and never gets to any...
  35. Replies
    10
    Views
    312

    Re: problems in creating a *txt file

    Writing to the root folder of any drive is not a good idea and may be restricted. Aside from that the code should work so long as spath contains a valid path and filename combo.

    Are you getting an...
  36. Re: VB6: Database field contents not being recognized

    If rs3.Fields("itemCategory") <> "" Then

    Also note that the line above is checking for an empty string which is not the same thing as a null value.
    If the value of the field were null that line...
  37. Re: Auto Select Item in Common Dialog Control

    Not really sure what you are talking about. You need to give a better description of what you are trying to do. Is this dialog in the same program or are you trying to trigger an event in a...
  38. Re: Loop all elementi in userform and enabled to false

    Yeah, but it should only be temporary at most say while something else is busy.

    There are other ways too but looping through all controls on a form and enabling them or disabling them is a bit...
  39. Re: Loop all elementi in userform and enabled to false

    Or you could just set the form.enabled=false if you want them all to be disabled
  40. Replies
    10
    Views
    542

    Re: problem create multiple user

    Text1.Text = "CSO" + Right(Str(Val(Right(!userid, 4)) + 10001), 4)

    What in the world are you trying to do there?

    You have the value of right 4 characters which you are converting to a string...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width