Search:

Type: Posts; User: SamOscarBrown

Page 1 of 13 1 2 3 4

Search: Search took 0.49 seconds.

  1. Re: [RESOLVED] ListView sorting the date issue

    AND, if you checked Lapot's posts, you would see he hasn't been posting for almost 10 years as well...might not even be alive! (Hope so, though)
  2. Replies
    10
    Views
    504

    Re: BeforeColEdit Problem

    from where is this Sub call? What parameters are passed to it, and how?
  3. Replies
    10
    Views
    504

    Re: BeforeColEdit Problem

    You can look up locking columns in a datagrid...that might help
  4. Replies
    10
    Views
    504

    Re: BeforeColEdit Problem

    Also confused (a bit).

    Other than your KeyAscii not being vbKeyDelete, what is to prevent a user from clicking on the cell and using the BackSpace key?
  5. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Ah...you're right...there were a lot of words in this Thread...I get tired trying to read every one! ~smile~
  6. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    Thx shaggy....appreciate the support.

    For OP...and, BTW, I redid the save/print function...no errors now. So, basically "I" have a pretty decent (no, not perfect...but PRETTY SURE free of bugs...
  7. Re: years ago I wrote a mysql app that runs on win 10, but found it breaks badly on

    Only an IDEA....because I really don't know what the problem is with your program...code? MySQL? 32 vs 64?

    And that idea is simply this. Create brand new program and try to connect to a brand new...
  8. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    2 short lines of code...that's it...it FIXED IT!. BUT, seeing as how you haven't written one single line of code for YOUR project (My Code, you said), doubt you'll figure it out.
  9. Replies
    3
    Views
    281

    Re: Date Add

    loop it
  10. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    THEN FIX IT!

    Remember...I'm done.
  11. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    I'm sorry...wrong button: click on the CHange Name Only button
  12. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    Click on the NEW ENTRY Button!!!!

    It will prompt you for a new name.
  13. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    LAST TIME....if you still need help, upload the zip file so others can help you.

    I changed it so you can rename a Product. (On the EDIT Form -- available on the MAIN FORM's Menubar.)
    I also add...
  14. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    No...sorry....WAY too complicated the way you have it....I created a VERY GOOD program for you. I didn't get to the PRINTING of the front and back of the Packages (although I did create a NEW FORM...
  15. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    More tomorrow...review and let me know what else.
  16. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    Here 'tis
  17. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    I have completed most of everything in your project for you. Let me know when you want me to upload it. Also, haven't seen you on that chat app.

    Sam
  18. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    Same thing....not sure what that is...maybe mods can check!!!!!
  19. Replies
    32
    Views
    3,340

    Re: Delete duplicate in access table

    Yes, mi culpa.

    Didn't check.
  20. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    He says no Exe in the file...besides, already deleted it.
  21. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    It was just a warning to others....not appreciative of receiving viruses. Again, not sure where it came from (other than I know it is in your zip file you had in post 7). NO, I don't think it was...
  22. Replies
    32
    Views
    3,340

    Re: Delete duplicate in access table

    Try This:


    Private Sub RemoveDupes()
    Set cnn = New ADODB.Connection
    With cnn
    .Provider = "Microsoft.ACE.OLEDB.12.0"
    .ConnectionString = "User ID=Admin;password=;" & "...
  23. Replies
    32
    Views
    3,340

    Re: Delete duplicate in access table

    Well, first, don't name a field 'relative'---it is a reserved word. use something like 'relation'.

    Second, why do you want a second table...why not just delete all duplicates in the 'Customers'...
  24. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    I downloaded a file the OP uploaded. I did a Microsoft Defender scan of it and it came up with a Trojan:Win32/Kuping.

    Probably not safe to download any from OP.

    Sorry el...not sure if YOU are...
  25. Replies
    32
    Views
    3,340

    Re: Delete duplicate in access table

    So, you want a COPY of "Customers", but you don't want some particular field in the new Table, correct? Or do you want all fields to be copied, but one of them deleted of any data?
  26. Replies
    44
    Views
    1,878

    Re: set form to vbmodal is not working

    got it
    will look at it later
  27. Replies
    5
    Views
    325

    Re: Save all record listview to ADO DB

    And don't forget the #'s for dates.

    without checking real close...something like this:


    str = "Insert Into Table3 (Code, Title, Name, Street, Price, Total, Date) Values ('" &...
  28. Re: [RESOLVED] Darn old null dates in MS Access via VB6

    @vb6f...yes., that would be one way. But I checked what I was putting in, not what was there. Actually, in my query to populate flexgrid, I had already checked the DB field, and if it was Null, put...
  29. Re: [RESOLVED] Darn old null dates in MS Access via VB6

    Soooo....for ME, this is RESOLVED....I changed all text 'dates' in the DB back to Dates.

    I changed the date variables from String (originally had Dates) to Variant.

    In an if-statement I simply...
  30. Re: [vb6] Obtain the value of MyVar, from the string "MyVar"

    The original post was completely edited. Of course if he calls it a string, it’ll be a string. But the OP said he wanted to know what TyPE of variable was being passed (the original variable, I...
  31. Re: [vb6] Obtain the value of MyVar, from the string "MyVar"

    See this at MSDN
  32. Re: [vb6] Obtain the value of MyVar, from the string "MyVar"

    Use VarType
  33. Re: How to get the current ROW in datagrid in vb6

    Not holding ME back...was just trying to answer x's question...I don't use DataGrids at all. :-)
  34. Re: Darn old null dates in MS Access via VB6

    The solution (for me) is from Zvoni....Declaring the variable as Variant instead of Date.

    Used this code to test....with myDate set to Null, inserts NULL in a DATE field in Access. When set to a...
  35. Re: How to get the current ROW in datagrid in vb6

    Yes, but that is by code, I’d assume. When an item is selected that one has to scroll to (beyond visible rows), the .row property returns the number of the row that is now visible. So, let’s say...
  36. Re: Darn old null dates in MS Access via VB6

    Have not. Will.
  37. Re: Darn old null dates in MS Access via VB6

    @Z....I can set a Date-Field to NULL...easy.

    But, what I can't seem to do is, using a VARIABLE, which I wanted to be NULL...I can't make a date variable equal NULL. (see post 1)
  38. Re: How to get the current ROW in datagrid in vb6

    @ It does.

    But no option for 'selectedCell', there is a .Text, but its flaky (IMO).
  39. Replies
    34
    Views
    1,180

    Re: rs.Edit (help)

    Ok. Just make sure you send some ghost explanations of what you want it to do.
  40. Re: HAve to run Executable as Elevated, otherwise....

    @couts...yup. Could.
    @VanG...Know absolutely nothing about Manifests (I know, I know, been around all these years and never used them???--sorry).
    @Elroy...yes. Best solution for me.

    Thx to all...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width