Search results

  1. M

    IIF statement on a criteria

    Hi, I have a query with multiple fields, Three of those fields are named "FirstName","Condition" and "Status". The condition field can be one the following, either "Working","Under Maintenance" or "Damage" and for the status, it's either "Availbale, Unavailable or Assigned". If the condition...
  2. M

    Filtering Query Reposrt using form and multiple combo box

    Hi experts, I have a trouble filtering my query and report using combo boxes, I also use a wildcard on the criteria field to do the filtering. These are the following table that I made for this specific practice. 1. Employee -ID -FirstName -LastName -Occupation 2...
  3. M

    Run-Time Error '438': Object Doesn't support this property or method

    Hi, Run-Time Error '438': Object Doesn't support this property or method. I'm creating a button to upload a picture file but I'm getting the above error code. Private Sub CmdAddPhoto_Click() Dim f As Object Dim strfile As String Dim strfolder As String Dim VarItem As Variant Set f =...
  4. M

    How can I keep my the text and combo boxes blank every time I open my form

    Hi, I noticed in MS ACCESS that, if you associate any bound or unbound text boxes fields and combo boxes fields to your table then those fields will automatically show up the record from the table from which those fields are associated with. Now, what if I want to keep those field blank...
  5. M

    Allowing combo box to accept blank entries

    Hi, I have a form with many combo boxes, and the problem is, if I leave one of any of those combo boxes as blank then I get an error message says. You cannot add or change a record because a related record is required in the table 'Table Name'. Is there any solution to save an entry even if I...
  6. M

    Query is not displaying records after adding multiple tables.

    Hi good people, I'm having an issue in generating Query from a multiple table source. I have a table called "DeviceLists" and within that table, I have two fields named DeviceType and EmpID which are connected to my DeviceType and my Employee Details table. Now the problem is, every time I make...
  7. M

    Opening report based on the selection from combobox

    Hi, I'm new to MS access, and I would like to do an experiment on how I can filter a report based on the selection from my combo box. I've watched so many tutorials but it seems like I'm having a hard time to follow it. I did even follow one tutorial from youtube and did exactly what the video...
  8. M

    Hello I'm a new member.

    Hello good people, I'm just new here, and I just also started learning MS ACCESS and I hope you guys can support me toward my journey in MS ACCESS WORLD. Thank you, :):):)
Top Bottom