Search:
Type: Posts; User: jdelano
Search:
Search took 0.11 seconds.
-
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
-
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.
-
To me, moving the mouse pointer is a band-aid for a symptom instead of curing the illness relieving the symptom.
-
I just meant to switch the fromdate and todate vars in the query, you'll still need to format the query properly for MySQL
-
I think you need to have the Where clause
Where dated >= fromdate and dated <= todate
-
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...
-
-
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
...
-
Excellent news, glad you were able to get it sorted out.
-
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...
-
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...
-
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...
-
Excellent news. Glad you were able to get it sorted out.
-
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:
...
-
One good resource is the Microsoft documentation...
-
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
-
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...
-
Here is the VS2019 project if interested https://1drv.ms/u/s!AkG6_LvJpkR7j6hnHAxOEXmLLwsshA?e=fxXieL
-
Here is the VB.NET version:
Imports System.Runtime.InteropServices
Imports Outlook = Microsoft.Office.Interop.Outlook
Imports System.Windows
Imports System.IO
-
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...
-
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...
-
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...
-
Oh, nice find. Glad you've got it sorted and thanks for updating this thread with that info!
-
Ah, yes. You both are quite right. Nice catches.
-
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...
-
Do you know the format of the file, in that which section is the image and which can be discarded in the string?
-
Ah, yeah. In memory datatable is a way better approach.
-
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...
-
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.
-
Which OS and Office version are you using?
-
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.
-
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?)
-
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 =...
-
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...
-
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...
-
So, should the T_Id in Tbl2 for the 40 actually be 2, given the T_ID in tbl3 is 2?
-
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.
-
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
-
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...
-
Oh okay. Let me modify it
|
Click Here to Expand Forum to Full Width
|