Search results

  1. V

    Solved Security Risk Microsoft has blocked.....

    Hi everyone. To avoid duplicate thread, please direct similar solved post. I am running Windows 11 on a administered network. The front end and back end file is on th same share drive but back end is password protected and since many users are utilizing the FE, the BE is linked through network...
  2. V

    Solved Error 2448 Can't assign a value to this object

    Hi everyone My code: Dim ctrl As Control For Each ctrl In Detail.Controls If (TypeOf ctrl Is TextBox Or TypeOf ctrl Is ComboBox) Then ctrl = StrConv(ctrl, vbUpperCase) End If Next This code is fired upon clicking the Save button in my form and is the first code in the line. All...
  3. V

    Solved Access Application Not Responding

    Hi everyone Need some help on a frustrating matter. I've started a new database file and whenever I start working on a form or open the VBA window, the application freezes and becomes non-responsive for up to 5 minutes. This can be anything from opening a form in design view or renaming a...
  4. V

    Update one database from another

    Hi everyone If this is a repost, please redirect me to the relevant one. I have 2 databases that are on different network share drives. With the one database, we use every day, I want the details of the person (first name, last name, date of birth, etc.) I save to get carried over to the other...
  5. V

    Solved Concatenating

    Good day everyone In my table, there are 3 columns I want to concatenate in a Query. These columns are named LEO1, LEO2, and LEO3 which are the Initial and Surname of a person. In the query I create a new column LEO with the following string: LEO: IIf(IsNull([LEO1]),"",[LEO1] & ", ") &...
  6. V

    Database Maintenance and Kick Users

    Does anyone have a sample database where the admin can kick current users out while doing maintenance? or to notify the users that database maintenance is scheduled and have them locked out from using the database
  7. V

    Reserved Error

    Hi everyone In my database when I want to view a report, I go to the search form where I can input the date criteria. When I choose to view the last 30 days of the records, I get the following error: Reserved error (I); there is no message for this error Any idea what it might be and a way to...
  8. V

    Solved Open record after save click

    Hi everyone Need help with something... I have an unbound form that saves records. What I want to know is if it's possible to be able to directly view the record in a report once I've clicked save? The reason for this is because I do daily reports and my database helps keep records should my...
Top Bottom