Recent content by TajikBoy

That's cool, If you don't mind, I will work on the format, add in the revenue sheet and related and flip it over to you? Your next coffee(s) on me :)

Thanks CheekyBuddha - This is also very nice, if I can add an extra question to your formula, if I want to change the "x" to numbers and add up in the same fashion so to speak? Possible?

So simple yet elegant solution....... Many thanks arnelgp, much appreciated :)

Good morning all, Need some assistance for the attached file.... I need to count the "X"s in Villa Occupancy sheet based on villa number and date ranges, for example, for January 1 to 31, villas 101 to 122, total of "X"s.... Both criteria sets are in the Summary sheet for linking. Been trying...

Hi ArnelGP, Unfortunately I can't (file too complex with links etc to tone it down to few sheets) but I resolved with ranking the data in the source, and did a xlookup for country names, it seems to work, for now..... Thanks and have a great day !

Good Morning Guys, Bit stuck with a small dilemma and hope one of you guys can help me..... Trying to list some countries based on the data in column O, when the data is not same works god, but when I have same, it only picks up the first entry from the list Basically I have an index/match...

Thanks Pat, I'll have a look, I dont use Navigation option in Access, I implemented ribbons, I'll see if I can adopt your solution.....

if I put allowedits false without the user access level checking, form is not editable, so line works, not sure why the if block screws up things....

strClasss is an unbound text field on frmStatus form....

Hi ArnelGP, frmStatus is my login form, which I hide after login and refer to the fields on it when/if needed, pretty sure there are other better ways but I prefer this way, got used to it more likely..... Tried addition of your &"" and placed the code onCurrent, and form is still editable......

Form' editability depends on the users access level, hence the if statement to check

OnOPen and onCurrent, both also not resulting properly, Code I am using is below, placed to msgboxes to see , firts one confirms its "Read' and second one also confirms form edit is False, still editable though Private Sub Form_Open(Cancel As Integer) Dim Class As String Class =...

Hi Guys, I'm trying to use 'me.allowedits = false' statement in one of my forms but it doesn't make diddly doo difference, I put it in the load section of the form, is there a magic trick to make it work? Or, is there any other easy way to make the form read only, there are plenty of...

HI Pat, Yes I do, that was a feeble attempt to resolve an issue caused by something else, which I have fixed now, also the bad name issue, form was copied over from a different project and modified, hence the 981...... All good now and value your advice..... Thanks,

OK..... Problem solved for erratic working..... Apart from the expression error as mentioned by you guys, I found out that my data entry guy took a short cut and instead of linking the ID fields, he has just typed the vendor names, now he is correcting, after he will dig his own grave - is...