db-noob's latest activity

  • D
    db-noob replied to the thread Error 3315.
    The error hasn't popped up in the last few days. Not to say that it's fixed or anything. Just not sure whether to leave this open or not.
  • D
    db-noob replied to the thread Error 3315.
    Ah gotcha.
  • D
    db-noob replied to the thread Error 3315.
    Yes, the tables are stored on a password protected BE stored on a shared server. A max of 4 users (including myself) downloads a fresh...
  • D
    db-noob replied to the thread Error 3315.
    No GUsername problems so far. Ooh. I've seen that option during the File > Save As bit. Does an .accde stop users from...
  • D
    db-noob replied to the thread Error 3315.
    Okay. Went back to all of my forms to include Option Compare Database and Option Explicit. Ran the Compile and nothing came up, which is...
  • D
    db-noob replied to the thread Error 3315.
    Oh darn. I went back to my login form code and changed it to: strSQL = "SELECT UserName, Password FROM tbl_login WHERE UserName =...
    • Screenshot 2021-01-15 162946.jpg
    • Screenshot 2021-01-15 163429.jpg
  • D
    db-noob replied to the thread Error 3315.
    I'm confused. I thought GUserName = rst.Fields("UserName").Value did the job. If it's not, how do I change it (or add) so it does?
  • D
    db-noob replied to the thread Error 3315.
    With my luck, it's probably a mix of all 3.
  • D
    db-noob replied to the thread Error 3315.
    So in my database, I have 4 forms that have a Editor and Edit Date fields: Work Order, Purchase Order, Customer, and Inventory. They all...
  • D
    db-noob replied to the thread Error 3315.
    So yesterday the error popped up for one of my users and highlighted the line Me.EditedBy.Value = GUserName like in post #1. I hovered...
  • D
    db-noob replied to the thread Error 3315.
    @CJ_London Thank you for explaining and with an example. It's easier to learn with examples/visuals. I'll go ahead and implement those...
  • D
    db-noob reacted to gemma-the-husky's post in the thread Error 3315 with Like Like.
    As a general catch, there is an important function you can use to cast any "blank" object into a value of your choosing. Technically a...
  • D
    db-noob replied to the thread Error 3315.
    Hmm. I'm not sure I understand. *sigh* Perhaps that's something I can try if this problem persists, but I've been playing with my test...
  • D
    db-noob replied to the thread Error 3315.
    @CJ_London This login sub is code I found online. I'm not sure where to have it exit. Come to think of it, I don't have any error...
  • D
    db-noob replied to the thread Error 3315.
    Yes, I do have a user table with username and password. Could you explain that bit about login initials? I checked my user table and...
Top Bottom