Search results

Hi everyone, I hope you can help. This is driving me crazy. I have a query that was previously working literally just a while ago and suddenly I am getting "Invalid Use of Null" I cannot see the cause of this problem. What could be causing thissss? The query, I checked all fields while on debug...

Hello, thanks for the suggestion, I will try this on another time as I have already built mine like the example CJ_London has provided. I was laughing at the Me.Dirty=True though... :D:D:D

Thank you very much for this, I really appreciate it, It did not flicker on my end, thanks for feeding the hungry... hehehehe :):):)

I see, thank you very much your example helped a lot, I apologize for asking too much as I admit I am unable to write codes by myself. I think Sir Arnel's code is for subforms though, not the continuous form like yours that I already built.

Yes I did, however I am unable to find from your example form the option where I can select all instead of selecting one by one, may I know where I could find it? I apologize

Can I have a link of the example and will those apply to your example form?

Another question, how do I select all without clicking them all one at a time? like a select all command?

Great! this code worked I thank you so much! :):):) I do have the altback control, it is just a box or rectangle is what it is called right? I don't know how to apply the conditional formatting though....

This is how it looks like on my end... yes I have enabled the code... for the update, it says I have Syntax error in Update statement: CurrentDb.Execute "Update tbl_LFMngment SET tbl_LFMngment.[Due Date Extended]= " & Format(Me.DueDateExtended, conJetDate) & "...

How do I change the color of the entry when the record is selected? Also the altbackground does not change color when I select, only the "select" word changes...

This is close to what I have in mind... one more thing though... say I want to update the country field for all entries I selected, how would I do that? I'm sorry I'm struggling thinking about how to build the code for it or is an update query not sure?

Hello, actually not sure how to go about it, is it possible on a split form or datasheet form to display the records?

Hello everyone, Good day! Reaching out again for help... Is it possible to create a form where it displays a certain set of records then I can select some and batch update them? Something that looks like this image attached.... :):):)

Thanks I will try those out as soon as I get back on this project that needs it, for now I am working on a different one.... thanks a lot!

I apologize for the late reply, so I have seen the problem, I was trying to save it to my desktop, and the user folder in my pc does not match the environ username that is why it does not come up with the correct path... the user folder has one letter in upper case and the other does not. So I...

Thanks it would have been any of the conditions if the first condition is not true... ;)

Thank you this worked. Thank you for helping a beginner :):):)

Thank you very much for helping out a beginner... thank you!

Hello, it is just the amount of days that it is already past, it is calculated based on a date, if it is -2 then it is 2 days past due. :)

Hello everyone, good day! I hope you're all doing fine. So I have this formula because of your help guys and I need to add another condition that will ignore these conditions if the condition is met. This one determines the priority based on Age, however I need to have it ignore this based on...