Search:
Type: Posts; User: jdc2000
Search:
Search took 0.59 seconds; generated 59 minute(s) ago.
-
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.
-
Possibly useful links, in case you have not already seen them:
https://documentation.help/PuTTY/config-linedraw.html
...
-
The fix was to give the server, and in the case or Quickbooks, the clients also, static IP addresses.
-
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...
-
Possibly useful link:
https://www.tek-tips.com/viewthread.cfm?qid=1672036
-
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...
-
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...
-
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...
-
Try this:
Option Explicit
Dim sNewFile, objFso
Set objFso = CreateObject("Scripting.FileSystemObject")
Browsefolder objFso.GetFolder("C:\Users\user\Desktop\test")
-
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...
-
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.
-
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...
-
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.
-
Sorry, typo, 32 bit.
Clipboard History is Off.
-
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...
-
To eliminate the error, try this:
Option Explicit
Dim sNewFile
Set objFso = CreateObject("Scripting.FileSystemObject")
Browsefolder objFso.GetFolder("C:\Users\user\Desktop\test")
-
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...
-
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
...
-
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...
-
What model of HP scanner is it? That might be some useful information.
-
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...
-
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...
-
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...
-
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...
-
ALL .zip files on the forum are currently corrupted, unfortunately. This may be fixed at some point.
...
-
https://www.vbforums.com/showthread.php?902721-Error-on-reporting-a-thread-And-Other-Site-Issues&p=5633060#post5633060
-
https://en.wikipedia.org/wiki/Riverworld
-
Possibly useful links:
https://stackoverflow.com/questions/409434/automatically-execute-an-excel-macro-on-a-cell-change
...
-
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.
-
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...
-
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?
-
Possibly useful links:
https://www.sqlservercentral.com/forums/topic/issue-displaying-external-image
...
-
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"...
-
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
...
-
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...
-
Note that Microsoft is planning to deprecate VBScript at some point:
https://www.vbforums.com/showthread.php?901284-VBScript-being-deprecated&highlight=vbscript+deprecated
...
-
It could still be the same issue though. Did you try it to see if it made a difference?
-
Try adding the specific worksheet reference.
https://www.mrexcel.com/board/threads/run-time-error-13-type-mismatch-when-hiding-rows-via-vba.1233212/
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|