Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 1.04 seconds.

  1. Replies
    12
    Views
    452

    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.
  2. Replies
    12
    Views
    452

    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...
  3. Replies
    10
    Views
    485

    Re: BeforeColEdit Problem

    Possibly useful link:

    https://www.tek-tips.com/viewthread.cfm?qid=1672036
  4. Replies
    10
    Views
    1,343

    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...
  5. 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...
  6. 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...
  7. 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")
  8. Replies
    10
    Views
    1,343

    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...
  9. Replies
    10
    Views
    1,343

    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.
  10. Replies
    10
    Views
    1,343

    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...
  11. Thread: RFID reader

    by jdc2000
    Replies
    8
    Views
    703

    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.
  12. Replies
    10
    Views
    1,343

    Re: Excel VBA Clipboard error

    Sorry, typo, 32 bit.

    Clipboard History is Off.
  13. Replies
    10
    Views
    1,343

    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...
  14. 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")
  15. 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...
  16. Replies
    6
    Views
    1,913

    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
    ...
  17. Replies
    6
    Views
    1,913

    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...
  18. Replies
    5
    Views
    962

    Re: Troubleshoot Device Driver

    What model of HP scanner is it? That might be some useful information.
  19. Replies
    6
    Views
    1,913

    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...
  20. 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...
  21. 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...
  22. 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...
  23. 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.
    ...
  24. Replies
    2
    Views
    334

    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
  25. Thread: Post Race!

    by jdc2000
    Replies
    68,852
    Views
    17,964,262

    Re: Post Race!

    https://en.wikipedia.org/wiki/Riverworld
  26. Re: Rename sheets in Excel using UDF

    Possibly useful links:

    https://stackoverflow.com/questions/409434/automatically-execute-an-excel-macro-on-a-cell-change
    ...
  27. 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.
  28. 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...
  29. 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?
  30. Replies
    3
    Views
    459

    Re: Immediate Window Warning VS2019

    Possibly useful links:

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

    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"...
  32. 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
    ...
  33. Replies
    22
    Views
    1,625

    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...
  34. Replies
    9
    Views
    2,937

    Re: Get pixel color by coordinates (PNG)

    Note that Microsoft is planning to deprecate VBScript at some point:

    https://www.vbforums.com/showthread.php?901284-VBScript-being-deprecated&highlight=vbscript+deprecated
    ...
  35. Re: Why do I get a type mismatch error?

    It could still be the same issue though. Did you try it to see if it made a difference?
  36. Re: Why do I get a type mismatch error?

    Try adding the specific worksheet reference.

    https://www.mrexcel.com/board/threads/run-time-error-13-type-mismatch-when-hiding-rows-via-vba.1233212/
  37. Replies
    9
    Views
    673

    Re: Remote Drive Activate

    The drives in question are likely going into power save mode and powering down. Getting your program to detect this and power them up might be challenging.

    One other option would be to disable...
  38. Re: VBA code for printing double sided in Excel

    Duplex printing is printer-dependent. Some printers do not even have that capability, and those that do generally have their own manufacturer-dependent or model-dependent settings. Printer settings...
  39. Replies
    5
    Views
    535

    Re: Log executions times ?

    One simple way is to just add some code to your application that creates a log file (text file) and then at the start and end of each section that you want to time, write the system date and time to...
  40. Re: Second day of Christmas : What did you do to celebrate?

    Shaggy,

    The UP 4014 will be in Nampa in 2024. Check the link below from time to time to find out when.

    https://www.up.com/heritage/steam/schedule/index.htm
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width