Recent content by vanzie

  1. V

    Need help with VBA to check for required fields

    I'll find a way around but thank you for your input. Much appreciated.
  2. V

    Need help with VBA to check for required fields

    The tag of the fields I want to trigger is set to "Required". Some of the fields are mixed between text and date fields. I've used your suggested code and the result still produced the last message box of the code instead of telling me the required fields are left empty.
  3. V

    Solved Unbound form required using VBA

    Just saw this thread and have the same concept with my registration form. I used the following code that will give you a pop up of unfilled fields and added code to check for a duplicate value if you have something like I do that includes an employee code: Dim db As DAO.Database Dim rs...
  4. V

    Need help with VBA to check for required fields

    Hi everyone Just need some help quickly with the following code: Private Sub btnSubmit_Click() Dim ctrl As Control Dim missingFields As String Dim isValid As Boolean ' Initialize variables missingFields = "" isValid = True ' Loop through all the controls...
  5. V

    Solved Security Risk Microsoft has blocked.....

    The local path seems to work on my PC. The reason why I don't want to distribute the FE locally is because they always tend to forget or they intend to mess things up and on a daily basis help to recover their files. But if it has to be done, it has to be done. So far had no problems using one...
  6. V

    Solved Security Risk Microsoft has blocked.....

    There is no such option. I've just set up the share drive on another employee's PC and started the database. It gave me the same error but showed me the message bar to Enable Content and added to file as Trusted. No problem whatsoever. I've relinked all tables to the back end file and removed...
  7. 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...
  8. V

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

    My thoughts exactly
  9. V

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

    That works perfectly. Thank you
  10. V

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

    When it shows me the error and I click debug, it highlights this part: ctrl = StrConv(ctrl, vbUpperCase) same with @arnelgp code: ctrl = StrConv(ctrl & "", vbUpperCase)
  11. V

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

    But now I don't understand is that I've gone through another database I designed and the exact method I used there, is used in this one. Same age display textbox with the expression and it saves perfectly without error.
  12. V

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

    There is one control yes that has the expression to display the age from the DOB value but the age value does not save to the table
  13. V

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

    Still gives me the same error
  14. 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...
  15. V

    Solved Access Application Not Responding

    I've disabled the wifi on the laptop and behold...the f..ng thing did not freeze. What I don't get is that it's just the normal documents folder that you will get on any standard PC or laptop, and that folder was not shared on One Drive at all. But I did take note...The laptop has been spoofed...
See more
Back
Top Bottom