Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 0.44 seconds; generated 8 minute(s) ago.

  1. VS 2022 Re: Programmatic Form: Pause Application Until Closed

    Possibly useful links:

    https://www.homeandlearn.co.uk/NET/nets13p4.html

    https://learn.microsoft.com/en-us/dotnet/api/system.windows.forms.form.modal?view=windowsdesktop-8.0
  2. Re: Adding a Hyperlink In Wix Version 4

    Possibly useful link:

    https://support.wix.com/en/article/wix-editor-adding-a-link-to-text
  3. Re: Hacking - Article Well Worth Reading

    Actually, with open-source software, you have lots of potential eyes looking at the code. That is how issues like this are found. With closed source, you have to hope the company that is trying to...
  4. Re: nHelp excel.saveas to older version

    Possibly useful links:

    https://www.mrexcel.com/board/threads/vba-to-file-save-as-in-the-format-of-xls.1001666/

    https://learn.microsoft.com/en-us/office/vba/api/excel.workbook.saveas
    ...
  5. MsOf365 Re: [Word] Access custom document properties in the parent from an inserted document

    After you insert the document, does the macro code also get inserted?

    There is a way to update the macro code of a document, but this is often blocked, as it can be used by hackers for unwanted...
  6. Re: Export time value from Datagridview to Excel

    For Excel, you will need to format the cell(s) as Text first, if you want "00700" and "00879" to look like that in Excel.
  7. Replies
    2
    Views
    2,809

    Re: PuTTY line drawing

    Possibly useful links, in case you have not already seen them:

    https://documentation.help/PuTTY/config-linedraw.html
    ...
  8. Replies
    12
    Views
    653

    Re: Error to do with Connectivity

    The fix was to give the server, and in the case or Quickbooks, the clients also, static IP addresses.
  9. Replies
    12
    Views
    653

    Re: Error to do with Connectivity

    I encountered a similar error situation once with a Quickbooks shared database. It was caused by the server's IP address lease being renewed. There was a brief disconnect, but Quickbooks did not...
  10. Replies
    10
    Views
    699

    Re: BeforeColEdit Problem

    Possibly useful link:

    https://www.tek-tips.com/viewthread.cfm?qid=1672036
  11. Replies
    10
    Views
    2,591

    Re: Excel VBA Clipboard error

    Update:

    I have added some code to my macros that verifies that the data that was supposed to be copied from the source sheet to the destination sheet using the Clipboard was actually copied. I...
  12. Re: yrs old compiled exe runs on my win 11 laptop, new compile errors only on laptop

    OK, I did not see your Post #2 while I was posting.

    That information is useful, and it looks like it has information that might be helpful to correct the issue.

    Can you post the SQL queries...
  13. Re: yrs old compiled exe runs on my win 11 laptop, new compile errors only on laptop

    Did you transfer all required files to both computers?

    Are all dependencies present and registered on both computers?

    Without seeing any code, it would be nearly impossible to determine which...
  14. Re: Remove special characters from all file names within a folder

    Try this:



    Option Explicit

    Dim sNewFile, objFso

    Set objFso = CreateObject("Scripting.FileSystemObject")
    Browsefolder objFso.GetFolder("C:\Users\user\Desktop\test")
  15. Replies
    10
    Views
    2,591

    Re: Excel VBA Clipboard error

    OK, I was able to activate the Clipboard History, however, I still got the same error at about the same point during the process.

    Note that the computer where the macros process works OK has the...
  16. Replies
    10
    Views
    2,591

    Re: Excel VBA Clipboard error

    Win+v shows "Can't show Clipboard History", so it is definitely off. I will try enabling it and, if successful, run a test to see what happens.
  17. Replies
    10
    Views
    2,591

    Re: Excel VBA Clipboard error

    Thanks, Zvoni.

    Clipboard History is normally Off for security reasons. I will attempt to turn it on and run a test to see what happens, but that may not be a setting that I can change. I will...
  18. Thread: RFID reader

    by jdc2000
    Replies
    8
    Views
    973

    Re: RFID reader

    Also, depending on the RFID reader, you may be able to add prefix or suffix characters to the data that the readers are sending that would allow you to distinguish between the 2 readers.
  19. Replies
    10
    Views
    2,591

    Re: Excel VBA Clipboard error

    Sorry, typo, 32 bit.

    Clipboard History is Off.
  20. Replies
    10
    Views
    2,591

    Excel VBA Clipboard error

    I have an Excel workbook with macros that copy data from various sheets to cells on a main sheet. These macros have worked flawlessly for years, however, today I find that I am getting the following...
  21. Re: Remove special characters from all file names within a folder

    To eliminate the error, try this:



    Option Explicit

    Dim sNewFile

    Set objFso = CreateObject("Scripting.FileSystemObject")
    Browsefolder objFso.GetFolder("C:\Users\user\Desktop\test")
  22. Re: Remove special characters from all file names within a folder

    Possibly useful link:

    https://superuser.com/questions/1224047/vbs-replace-characters-from-filenames-of-all-files-in-folder-and-subfolders

    The script could easily be modified to remove any...
  23. Replies
    6
    Views
    4,220

    Re: RDLC granularity

    Possibly useful links:

    https://github.com/microsoft/AL/issues/6896

    https://www.sqlservercentral.com/articles/using-an-rdl-file-locally-in-net-to-print-reports
    ...
  24. Replies
    6
    Views
    4,220

    Re: RDLC granularity

    I mentioned drivers since you were having trouble with margins. If you do not have the driver or printer hardware margins set up correctly, you will not be able to get your software to print as...
  25. Replies
    5
    Views
    1,295

    Re: Troubleshoot Device Driver

    What model of HP scanner is it? That might be some useful information.
  26. Replies
    6
    Views
    4,220

    Re: RDLC granularity

    What make and model of label printer are you using? Zebra, or something else?

    You may be able to scale the label size using the printer driver. Note that you should print some test labels to...
  27. Re: [RESOLVED] Ecxcel vexing autofilter problem

    Note the "Filter on Color" in Excel is actually broken. It will not always show ALL of the cells with a certain color when you filter on a color. Sometimes, it will not even show the color you want...
  28. Re: Error on reporting a thread - And Other Site Issues

    Steve,

    That may be the case, however, the general rule is that the only time you ever need to restore from a backup is when you don't have one.

    The database I work on has been the same, except...
  29. Re: Error on reporting a thread - And Other Site Issues

    As long as the do not just have ONE backup which is overwritten each night, but instead keep a week's or a month's worth of backups, that would be OK. If there is just one backup, the chances that...
  30. Re: Resizeable VBA UserForms (and Unicode Form Captions)

    ALL .zip files on the forum are currently corrupted, unfortunately. This may be fixed at some point.
    ...
  31. Replies
    2
    Views
    372

    Re: I have no tools here in the forum

    https://www.vbforums.com/showthread.php?902721-Error-on-reporting-a-thread-And-Other-Site-Issues&p=5633060#post5633060
  32. Thread: Post Race!

    by jdc2000
    Replies
    68,958
    Views
    18,615,870

    Re: Post Race!

    https://en.wikipedia.org/wiki/Riverworld
  33. Replies
    7
    Views
    1,107

    Re: Rename sheets in Excel using UDF

    Possibly useful links:

    https://stackoverflow.com/questions/409434/automatically-execute-an-excel-macro-on-a-cell-change
    ...
  34. Replies
    7
    Views
    1,107

    Re: Rename sheets in Excel using UDF

    Possibly useful link:

    https://www.edureka.co/community/212921/using-a-udf-in-excel-to-update-the-worksheet

    It looks like VBA may what you will need to rename a sheet.
  35. Re: Clear contents in column range based on criteria

    Option Explicit


    Sub ClearComments()

    Dim lngRow1 As Long
    Dim intCommentsColumn As Integer
    Dim intTemp1 As Integer, intTemp2 As Integer
    Dim lngTemp1 As Long
    Dim strTemp1...
  36. Re: Clear contents in column range based on criteria

    It looks like your header is on Row 5. Is there any reason for this, rather than having it on Row 1? Will the header row vary, or will it always be on Row 5?
  37. Replies
    3
    Views
    513

    Re: Immediate Window Warning VS2019

    Possibly useful links:

    https://www.sqlservercentral.com/forums/topic/issue-displaying-external-image
    ...
  38. Replies
    6
    Views
    534

    Re: Resize form when printing

    It looks like you are creating a bitmap image and then printing that. You did not mention what printer or what printer driver you are using. There may be a setting similar to "Fit Image to Page"...
  39. VS 2019 Re: VB.NET Application Process Name in Task Manager

    Possibly useful links:

    https://stackoverflow.com/questions/1055987/how-to-set-a-projects-executable-processname

    https://superuser.com/questions/1231640/how-to-search-a-process-by-name
    ...
  40. Replies
    22
    Views
    1,759

    Re: Python discussion

    Elroy,

    I have looked at creating forms for Python and have not found anything that I thought even comes close to an easy-to-use method, so I will be following this thread to see how your progress...
Results 1 to 40 of 499
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width