User Profile
Collapse
-
As the first step, I would discuss this with my CIO who knows your business in and out and can cut all the sweet talk. -
Sometimes when things run to weird - beyond common sense, as you have experienced - the editor has done something behind the scene.
What cures it, is to remove the stubborn code lines and rewrite them not using copy-paste.Leave a comment:
-
-
Again: the code above will copy any file extension. Why don't you try?Leave a comment:
-
-
If you can accept to compress the file before copying, you can use one of my functions right away:- zip
- cab
- tar
https://github.com/GustavBrock/VBA.Compress
Or you can modify the code stub that controls the versioning to fit your need:
Code:ZipFile = FileSystemObject.BuildPath(ZipPath, ZipName) If FileSystemObject.FileExists(ZipFile) Then If OverWrite = True Then
Leave a comment:
-
-
You haven't revealed strSQL. Your final expression, if #2025-03-08#, is correct and will insert that date, but variable Expiry must be declared as String....Leave a comment:
-
"Upgrading" to Windows 10 isn't an upgrade as Windows 11 has been out for years.
So, download the Windows 11 ISO file and use Rufus to create a USB stick to boot from.
If the machine lacks the W11 requirements, do mark in Rufus to ignore these.Leave a comment:
-
This works for me:
Code:Private Sub ImmportFiles_Click() Dim InputDir As String Dim ImportFile As String Dim InputMsg As String Dim Name As String InputMsg = _ "Type the pathname of the folder that contains " & _ "the files you want to import." InputDir = InputBox(InputMsg, "Import
Leave a comment:
-
Probably something like this:
Code:strSearchString = "456" Dim HyperLink As String HyperLink = "http://viewitd.com/UnitTrace/ListUnitTrace.asp?&ListProduct=0&ListProductVar1=0 &ListProductVar2=0&ListProductVar3=0&DespatchNo=&TraceabilityNo=" & strSearchString & "&StartDateTime=&EndDateTime=&TitleStrin g=+++strSearchString&sProduct="
Leave a comment:
-
If "the text replaces the great majority of the background image" there isn't much you can do.
That should be obvious.
Use a red (slightly slanted) "stamp" at the top of the page above the printing area. That have worked for centuries.Leave a comment:
-
> it seems like I need to learn many different languages such as SQL Server, C++, C#, html, and maybe also master .net framework.
That is correct. Go with Visual Studio and C# and be prepared for a learning curve.Leave a comment:
-
Like this - as there might be more than one dash:
Code:string currentSong = "Spotify - SONGNAME"; string songTitle = currentSong.Split(" - ", 2)[1]; Console.WriteLine(songTitle);
Leave a comment:
-
-
cactusdata replied to Printing to a ticket thermal printer from ancient VB6.0 - apparently loses bytesin Visual BasicIt could be Unicode that messes up the "k". Try:
Code:Printer.Print = Chr$(29) & StrConv("k", vbFromUnicode) & Chr$(72) & Chr$(12) ' or: Printer.Print = Chr$(29) & ChrB(107) & Chr$(72) & Chr$(12)
Leave a comment:
-
Use Substring or other method to split your string into its single values:
30, 32, 36, 31, etc.
Now, convert each of these, here '36' to return '6':
Code:Char(Convert(int,Convert(binary(1), '0x' + '36', 1)))
Leave a comment:
-
The source: https://learn.microsoft.com/en-us/do...OP-MVP-5002361
Previously Microsoft Academy. That's where I started with C#. At zero cost.Leave a comment:
-
You will need a unique Id for each record. Then:
Code:Select IndividualId, Value From YourTable Where Id In (Select Top 7 T.Id From YourTable As T Where T.IndividualId = YourTable.IndividualId Order by T.Value Desc, T.Id)
Leave a comment:
No activity results to display
Show More
Leave a comment: