Search results

I don't have enough experience to say much. So, first off, THANK YOU! The type of work needed to accomplish this type of project is quite extensive. Thank you for putting in the time and the rest of the team involved!

@Joe.Richardson - Thanks for clarifying many points. The costs proposition is unique to each situation. I wish you success in your business implementation and know there are some clients that would gladly pay your per user costs for simplicity. I only know the wild west part of MS Access...

Which for the mathematically disinclined is $46.50/month/user :) The nice thing about this service is that it doesn't seem to have a lower limit. The bad thing about this service is that unless you already know how to implement a two part syncing back end (with it's own pros/cons/issues) then...

This sounds a lot like a business idea (I have lots of ideas that I'm not capable of implementing!) I thought of when I ran into the access/smb/internet issue. Someone skilled in UI/platform development could write a nice package that streamlined the CITRIX/RDP process for users like me who are...

This sounds a LOT like virtual desktops which has been an option for awhile but was cost prohibitive from a licensing/user standpoint (we looked into it for our needs and it was a non starter due to the monthly expense for even a limited number of users). Given their business model, it sounds...

Edit: It looks like @The_Doc_Man beat me to it. As he said (he's the expert by far, not me), from what I've read the technical limitations weren't establishing a fault-tolerant SMB connection but that you would die from boredom or old age trying to use it on anything approaching a production...

That's fantastic!

The basic team is this company https://www.justgetproductive.com/ I am VERY far from a programmer/OS expert, but I do read alot :) I'd be surprised (pleasantly) if it was @The_Doc_Man's #2 thought. It seems like the SMB protocol by it's very core would be hard to make robust over a network...

All this has really done is add more weight on this "this needs to be redeveloped as a database form instead of an excel file" side of the equation. The only tricky part is what I've posted before in the past. Figuring out how to manage the data on a service tech laptops with spotty internet...

I concur with @isladogs. There are a lot of moving parts to this module and I've made some tweaks myself. BUT, only when I felt I had a thorough knowledge of each routine, not only what they literally were doing with the code, but their intent also.

@The_Doc_Man - Definitely a *sigh*. So, I shouldn't malign our 3rd party IT. They didn't "screw it up". But, they did appear to make some assumptions that burned me (and me making assumptions too in the code). @Isaac - The SaveAsCopy method is interesting. I originally did SaveAs for a few...

It's definitely "B". The sad thing is that this is all a result of the one time I personally didn't setup this laptop. Our third party IT company set this up at our main office location (I work at our production shop). They managed to completely screw it up. All the user locations are...

So, i've been able to remote in, comment out my error handling and reenable alerts and... Error 400 So, in the code I posted above everything gets to the SaveAs block without a problem. The SaveAs block is initiated This triggers the BeforeSave subroutine Private Sub Workbook_BeforeSave(ByVal...

@Isaac - That was my initial thought as well after perusing some similar internet posts. But, my msgbox line I inserted has always shown the correct path. That's why I'm confused. I've definitely seen a robust desktop function that basically cycles through all four possibilities you are...

@The_Doc_Man - ErHa does get called. The error is being first generated in the UserDesktop function I posted. Oddly, though, as I mention below, the MsgBox line always resolves correctly despite the error. Thanks for the tip on the alerts! I forgot that I toggled off the alerts to bypass some...

I realize actual code would be helpful. Here is the Temp_Save macro on button click: Sub Temp_Save() 'Subroutine run on click of "Temporary Save" button On Error GoTo EH ErrName = "Temp_Save" Call Unprot Module1.BttnChk = 1 'For use verifying the save was initiated by a proper button...

Anyone run into a situation where a stable macro failed on just one laptop? Any ideas on what to look for? I've checked refererences, added debug displays. Can't seem to figure out A. What is happening. B. Why it's happening. It's related to pulling the username and saving the file...

Ok, So it's not my parameters. If I pass in the parameters and then print them, I get the right ones. For some reason my string concatenation (which worked in the code posted in #12) is not working in this function. I'm at a loss. Here is what I get printing the three parameters after they've...

So, I messed up my function code...anyone have insight on using parameters? Here's the code: #Define Shortcut Function function jmMakeShortcut { Param($LinkLoc, $LinkTarget, $LinkName) $WscriptShell = New-Object -ComObject Wscript.Shell $ShortcutFile = $LinkLoc + $LinkName + ".lnk"...

I have limited experience of course, but I've already run into flakiness with MsgBoxes when I use the verbose form of the parameter settings (such as vbOK, vbInformation) instead of enumeration. I realize that the typical delineation involves early/late binding, but my unscientific feeling is...