Search results

  1. E

    Run your own LLM locally, like ChatGPT or Claude

    What are the specs of the VPS? Have you tried the Colab notebook? The one I posted is uncensored and really quick.
  2. E

    AI Options

    None is objectively better, but Claude tends to be relatively better at code in most languages, and it has come up with more elegant solutions for me in VBA and other languages too. You need to familiarize with context size, which is the amount of things it can remember. It comes to a point...
  3. E

    Run your own LLM locally, like ChatGPT or Claude

    Yeah, RAM alone isn't enough. I tried this on older computers and they struggled. The CPU matters a lot if you are not using a compatible GPU. If everything runs on the CPU, it can max out and freeze apparently. 8GB of RAM will not be enough with these models. For smoother local use, you really...
  4. E

    Run your own LLM locally, like ChatGPT or Claude

    I could upgrade to 32GB, and I probably will at some point. What I have now is enough for most tasks. A few days ago I was testing some WAN2.2 video generation models, and I realized my machine simply could not handle the load very well. That led me to try quantized models, and they have been...
  5. E

    Run your own LLM locally, like ChatGPT or Claude

    I don't know, but I doubt it's because of the available size on your c drive, how much RAM and VRAM do you have? If it's struggling with a 15gb model, try to download a quantized model instead, a Q4 would be smaller and still produce nice results. RAM is the biggest candidate for that message...
  6. E

    Run your own LLM locally, like ChatGPT or Claude

    I recommend Forgotten Safeword, it's very expressive compared to the others I tested. The size is around 15gb. If you find smaller models, they may not be as expressive and creative, but they also generate good responses
  7. E

    Run your own LLM locally, like ChatGPT or Claude

    Here's something you can play with, it's a Google Colab notebook that you can just run and it will output a chat UI that lets you talk about anything. Instructions: Go to Google Colab and sign in with a Google account Extract the attached file, it's the notebook Go to File > Upload notebook Go...
  8. E

    Run your own LLM locally, like ChatGPT or Claude

    It can get very creative, I made it roleplay that it was an aroused piece of VBA code and started telling me "I can be your interpreted s*ut, daddy". It was quite the experience.
  9. E

    Run your own LLM locally, like ChatGPT or Claude

    It's a gaming laptop I bought 2 years ago, it came with Windows 11. It's a TUF DASH F15, it has an i7 12th gen processor, nvidia Geforce RTX 3070 card with 8GB VRAM, 16GB RAM. I don't play games, sadly, but I do test AI tools all the time. I can generate video, images, and recently, I've been...
  10. E

    The Win11 disaster explained

    I use this tool to fix a lot of the issues with Win11. GitHub - ChrisTitusTech/winutil: Chris Titus Tech's Windows Utility - Install Programs, Tweaks, Fixes, and Updates It needs to be run after every update, Win11 is BS and resets things with the updates. I'm now trying some Kali and it's...
  11. E

    Run your own LLM locally, like ChatGPT or Claude

    Running it locally gives me multiple advantages. The main advantages: 1. No terms of service 2. No conditions 3. No feature removals 4. No paywall 5. No ads 6. Usage on demand 7. No limitations in the type of questions 8. No limits other than your own machine 9. No ad profiling 10. No spying...
  12. E

    VBAStack - Read the callstack in VBA6 and 7

    I had to modify the initial Option Explicit On to just Option Explicit and changed the whole CopyMemory API definition for this to work. I had the immediate window line appear in the result too but I did not use it at all. If anything, it was just visible.
  13. E

    Overview of subsequently added object properties that are only accessible via the "Properties" collection.

    To view a list of the properties of something, just add the expression to the watch window: It could be traversed using a loop, but it's handy to just open it from the watch window because you get to see how it is initialized, type, value, etc. To know which ones are not accessible using dot...
  14. E

    Run your own LLM locally, like ChatGPT or Claude

    Yeah I heard they're moving their data centers to water abundant places too. Mitigate that by a nano-fraction if you run the thing locally. Sadly, I know most people would simply prefer the convenience of just using it online without giving it any thought.
  15. E

    Run your own LLM locally, like ChatGPT or Claude

    When you're chatting with a model running locally, if you're on a moderately decent but humble computer like I am, you'll notice that the answers take like 2 seconds to start and they take a while to complete, depending on their length. It's nothing like the speed you're used to from Claude or...
  16. E

    Run your own LLM locally, like ChatGPT or Claude

    By the way, you don't have to pay for any of this. About models: Depending on the models you choose, their capabilities. There are plenty of models for different purposes. For example, I installed an unrestricted model that can talk about anything, and it can also write code. Expect sporadic...
  17. E

    Run your own LLM locally, like ChatGPT or Claude

    In case any of you needs to run a Large Language Model (LLM) locally, there are a few ways to do this, I will post what I found to be the simplest way. 1. Download and install LM Studio, I use Developer mode, you can choose another option. 2. Download a model, more on this below. 3. Do this...
  18. E

    Sub vs Function - who win?

    hey, sub is shorter than function :eek: i win
  19. E

    Sub vs Function - who win?

    For a MS Access developer who just wants to get things done: Use sub for routines that don't need to return a value Use functions for things that need to return a value and things that will be used from MS Access' GUI expression fields and queries. So, that's my POV, OP. I don't see any...
  20. E

    Last time form design has changed.

    You can try using this from a watch CurrentProject.AllForms("name_of_your_form").DateModified or From the immediate window ?CurrentProject.AllForms("name_of_your_form").DateModified or In a line of code Debug.Print CurrentProject.AllForms("name_of_your_form").DateModified or Right click from...
Back
Top Bottom