Search results

  1. T

    Counif(s) Help.....

    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 :)
  2. T

    Counif(s) Help.....

    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?
  3. T

    Counif(s) Help.....

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

    Counif(s) Help.....

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

    Solved Index & Match for 2nd,3rd etc

    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 !
  6. T

    Solved Index & Match for 2nd,3rd etc

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

    me.allowedits

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

    me.allowedits

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

    me.allowedits

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

    me.allowedits

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

    me.allowedits

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

    me.allowedits

    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 =...
  13. T

    me.allowedits

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

    Solved DLookup

    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,
  15. T

    Solved DLookup

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

    Solved DLookup

    Yes, it opens up from a list a view contract form sort of and yes, same Dlookup is in there too, as I need it to update if I change the vendor on the form
  17. T

    Solved DLookup

    It is unbound..... It works on some vendors...... which is the puzzling bit
  18. T

    Solved DLookup

  19. T

    Solved DLookup

    Hi, Text981 - correct, me.vendorName correct Code in Form Load.... If I change the vendorname combobox to a different vendor it works ?
  20. T

    Solved DLookup

    Good afternoon guys/gals, I'm trying to assign a value to a text box on form load with below code but Access tells me I can't.... As usual, what am I doing wrong? Also tried .value, same error..... Me.Text981 = DLookup("[CompanyName]", "tblVendors", "[ID]=" & Me.VendorName)
Back
Top Bottom