Search:

Type: Posts; User: jdelano

Page 1 of 5 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    9
    Views
    1,047

    Re: React Native Login connect with sql server ?

    Maybe posting your question in a React forum will be more helpful to you, https://www.reddit.com/r/reactjs/ or perhaps https://dev.to/t/react
  2. Re: Why does INameSpaceTree fatale crashing when it's asagined to usercontrol?

    Have you looked at fafalone's thread: https://www.vbforums.com/showthread.php?798633-VB6-Vista-Host-Windows-Explorer-on-your-form-navigation-tree-and-or-folder maybe something there will help.
  3. Replies
    10
    Views
    802

    VS 2013 Re: Set Cursor Position in VB 2013

    To me, moving the mouse pointer is a band-aid for a symptom instead of curing the illness relieving the symptom.
  4. Re: DataGridView doest not show the data

    I just meant to switch the fromdate and todate vars in the query, you'll still need to format the query properly for MySQL
  5. Re: DataGridView doest not show the data

    I think you need to have the Where clause
    Where dated >= fromdate and dated <= todate
  6. Replies
    10
    Views
    802

    VS 2013 Re: Set Cursor Position in VB 2013

    That is a strange behavior, have you tried adding some logging to a text file to see why it is doing this? The mouse position shouldn't prevent a combobox from being displayed or filled. Can you post...
  7. Re: [RESOLVED] Determine which computer is running Excel file

    There you go :D
  8. Re: Determine which computer is running Excel file

    You could use the Environ function to look at the computer name https://vbaf1.com/variables/environment/


    If Environ("COMPUTERNAME") = "[your desktop computers name]" then
    ...
  9. VS 2022 Re: [RESOLVED] 2nd form not showing on desktop

    Excellent news, glad you were able to get it sorted out.
  10. VS 2022 Re: 2nd form not showing on desktop

    I'd do as jmcilhinney suggested and add some logging code, write to a text file where you attempt to display form2 and in the form2 load event.

    Are you using all the "normal" controls on this...
  11. VS 2022 Re: 2nd form not showing on desktop

    Which .net version is this using? I'm guessing maybe 4.8 given you state it has been "working fine for a long time".
    When you say it is installed on the PC, do you have an install script or are you...
  12. Re: DataReport + Vb6 + Multiple Pages + foot report print

    It has been a while since I used Data Report, so I went and created one. As you have seen it is VERY limited in its flexibility. To my eye, what you want to do is not feasible using Data Report. You...
  13. Re: ASP Classic xlsx file connect and retrieve columns

    Excellent news. Glad you were able to get it sorted out.
  14. Re: ASP Classic xlsx file connect and retrieve columns

    Your strDirInfoX query is a MySQL query, in particular using INFORMATION_SCHEMA.COLUMNS so the Jet OLEDB engine doesn't recognize that.

    I don't have a VBScript page to test with but try this:

    ...
  15. VS 2022 Re: Writing UserDetails to a file and recalling them

    One good resource is the Microsoft documentation...
  16. Replies
    18
    Views
    768

    Re: Copy/Paste with blank cells inbetween

    You could use a for loop, it would look something like:




    Dim fromRow as Integer
    Dim toRow as Integer

    Dim fromWS as Worksheet
    Dim toWS as Worksheet
  17. Re: combobox with FindStringExact issue. Requesting assistance to find substring

    You can just assign the combobox's SelectedValue the country code. Like:




    Public countries As New List(Of Object)

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles...
  18. Replies
    7
    Views
    654

    VS 2019 Re: Drag/Drop Outlook message to form

    Here is the VS2019 project if interested https://1drv.ms/u/s!AkG6_LvJpkR7j6hnHAxOEXmLLwsshA?e=fxXieL
  19. Replies
    7
    Views
    654

    VS 2019 Re: Drag/Drop Outlook message to form

    Here is the VB.NET version:




    Imports System.Runtime.InteropServices
    Imports Outlook = Microsoft.Office.Interop.Outlook
    Imports System.Windows
    Imports System.IO
  20. Replies
    7
    Views
    654

    VS 2019 Re: Drag/Drop Outlook message to form

    I played around with the Winform (they're using .Net Framework 4.5) project from the GitHub link. It didn't have the OleDataReader that the WPF project did, so I moved that over. In this code it...
  21. Replies
    7
    Views
    654

    VS 2019 Re: Drag/Drop Outlook message to form

    I don't believe this can be handled natively. You have to build in the feature of accepting an OLE object, instead of the few simple items it can handle. This GitHub repository has some info on doing...
  22. Re: How can I control a Excel file opened from VB6?

    One option could be to write the last modified date of the files on the temp folder to an array when the app opens and then on app close, compare that to the files in the temp folder. If any have...
  23. Replies
    3
    Views
    448

    Re: VB6 freezes when I insert a OLE Object

    Oh, nice find. Glad you've got it sorted and thanks for updating this thread with that info!
  24. Replies
    19
    Views
    893

    Re: capitals letters only and..

    Ah, yes. You both are quite right. Nice catches.
  25. Replies
    19
    Views
    893

    Re: capitals letters only and..

    You could do something like




    Private Sub Text1_KeyPress(KeyAscii As Integer)

    'if not lower case characters, upper case characters, a period or a space then exit
    If Not (KeyAscii...
  26. Replies
    4
    Views
    379

    Re: construct BMP from hexadecimal data

    Do you know the format of the file, in that which section is the image and which can be discarded in the string?
  27. Replies
    13
    Views
    749

    Re: How can I buffer parameterized inserts?

    Ah, yeah. In memory datatable is a way better approach.
  28. Replies
    13
    Views
    749

    Re: How can I buffer parameterized inserts?

    I see, I wonder if you are hitting a hardware throttle writing locally. Are you keeping the records in memory first, then writing them to the local DB or are you just attempting to write them...
  29. Replies
    13
    Views
    749

    Re: How can I buffer parameterized inserts?

    Yeah, I was thinking the local db is the queue'd data and then it goes to a SQL Server on the network. I am assuming facts not in evidence.
  30. Replies
    3
    Views
    448

    Re: VB6 freezes when I insert a OLE Object

    Which OS and Office version are you using?
  31. Replies
    13
    Views
    749

    Re: How can I buffer parameterized inserts?

    Okay, maybe something in this SO post will help get you over the hump https://stackoverflow.com/questions/2177880/using-a-database-table-as-a-queue it looks to be doing close to the same thing.
  32. Replies
    13
    Views
    749

    Re: How can I buffer parameterized inserts?

    More code is needed, this code is just showing that you're connecting to a local database and running some command which isn't defined here (a global or form level object?)
  33. Replies
    36
    Views
    1,540

    Re: conflicting issue

    Here is an example of filling a combo box on form load:



    Private Sub Form_Load()
    Dim strCon As String
    Dim cn As ADODB.Connection
    Set cn = New ADODB.Connection

    strCon =...
  34. Replies
    21
    Views
    1,127

    Re: Calculate in two tables

    Basically, you have to move the join between tbl2 and tbl3 into their own select statement and then join that to tbl1

    Again, I just have this is MS Access to build the query. Modify it as you need...
  35. Thread: TwinBasic

    by jdelano
    Replies
    1,808
    Views
    867,782

    Re: TwinBasic

    I have an Access 2000 database that I opened in twinBASIC and ran a query using this code:



    Private Sub Command1_Click()
    Dim cn As New ADODB.Connection
    Dim strCon As...
  36. Replies
    21
    Views
    1,127

    Re: Calculate in two tables

    So, should the T_Id in Tbl2 for the 40 actually be 2, given the T_ID in tbl3 is 2?
  37. Replies
    21
    Views
    1,127

    Re: Calculate in two tables

    You're selecting everything from tbl3, how does the data get into that table? Please show your code that calculates / fills the tables with their values.
  38. Replies
    15
    Views
    916

    Re: path name issue

    What OS?

    In XP I have no problems with this code


    Private Sub Command1_Click()
    Dim fs As FileSystemObject
    Dim fl As TextStream
    Dim fileContents As String
  39. Replies
    21
    Views
    1,127

    Re: Calculate in two tables

    I just put the data in an access database, queried it, looped the results and wrote to the grid directly as the remaining is calculated during the loop. I hope that makes sense.



    Dim...
  40. Replies
    21
    Views
    1,127

    Re: Calculate in two tables

    Oh okay. Let me modify it
Results 1 to 40 of 178
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width