Search results

  1. R

    Handling null values in Expression builder

    In Expression Builder, I have the query(in the Criteria row) set to run based on values in different fields on a form. When one of the fields is empty however, the query will not return any records. How can tell Access to ignore the fields when those fields on the form are empty and only look...
  2. R

    Inactive use of Null in Search form

    Hi there, I'm trying to add a new functionality on my search form where the user can search for records that haven't been modified(based on the field DateModified) for certain amount of time. This is what I added in my search function but it's giving me "Invalid use of Null" If Not...
  3. R

    Send multiple attachments using outlook

    I would really appreciate some help here... I'm trying to use the SendEmails function below to automatically send email to users with multiple attachments. When I call the function as such, it works fine as long as I have one attachment. SendEmails(strTo, strSubject, strMessage...
  4. R

    Syntax error with DLookup

    I would appreciate any help with this Dlookup function. This part of a function that checks whether there is a duplicate in the table. A duplicate record here is a record that has the following: an already existing Card number AND (the status of the card = activated OR pending) I have the...
  5. R

    Help in VBA

    Hi there, This could be a easy one for a VBA "savvy".. I have the following piece of validation code(part of a function) that returns True/False based on whether the required data is filled: For Each ctl In Controls If IsNull(ctl) And (ctl.Tag = "*") Then ValidateRequiredFields = False...
  6. R

    Control the report window size

    Hi there, Is there a way I can control the size of the report when it opens on the screen. I want the report to pop up like a form. I tried the q_Sizer function(below) but it doesn't work on the width an height. Function q_Sizer(q_Right As Integer, q_Down As Integer, q_Width As Integer, q_Height...
  7. R

    Execute Search With The Enter Key(instead Of Mouse Click)

    I have a Search form where users can go and perform queries(single or multiple). They click the Search button to view the result. Between the eight different fields they can search on, the first field(Log no.) is the most used one. I'm trying to make it easier for them, by allowing them to...
  8. R

    Protect a hyperlink field from being edited

    I'm trying to protect a hyperlink field from being edited by certain users. The form gets the windows username, then looks up the security group of the user from a table. Based on the group, it should allow or deny the user to edit this field. Everybody should be allowed to click on the link...
Top Bottom