Recent content by Ronaldo9

As you said, it's a bit of work, but it works great!! Many Thanks!!

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...

OK so now I check whether DateModified is null or not then I calculate the value of LValue using: LValue = DateDiff("d", Me.DateModified, Date) That got rid off the "Invalid use of Null", but now each time I run the search, it's prompting me to enter a value for LValue..

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...

Of course !!!.. I forgot about nz... Thank you very much and God Bless!!

Thank you guys for the replies. They were all helpful. Ari you made my day.. I used your solution and it works great.:) Just one more simple question for you. if I call the the function with 3 atatchments as such: SendEmails(strTo, strSubject, strMessage...

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...

:o Can't believe I missed that.. Many Thanks

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...

Yes.. I was just re-stating my issue.. I incorporated the enabled property in my condition and it works just fine now.. Since all my required fields are texboxes or combo boxes ,I did the following: If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then If IsNull(ctl) And...

This is exactly what I did here. I added a "*" in the tag property of all required fields. My validation function loops thru the controls, if the field has a "*" in the tag property and is Null, the function returns false, otherwise returns true. My issue here is: I can't incorporate this...

The required fields are all either text box or combo box I tried: Dim ctl as Textbox but that didn't work either. Thanks for the boolean tip.. Elias

fields are enabled depending on who's logged in for example if HR user is logged in, the HRReviewdate is enabled, if they're finance, the FINReviewDate is enabled etc... These review dates are mandatory but only one at a time...

I was trying to combine all the criteria in one line.. Since the new five fields are only enabled for the corresponding user, I tried: If IsNull(ctl) And (ctl.Tag = "*") And (ctl.Enabled = True) Then but it seems the enabled property is not supported for control object. and that didn't work...

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...