Search results

  1. H

    Solved Change between custom shortcut menu and default with vba

    Hi, finally got some time to come here and feedback: I chose to follow HiTechCoach suggestion, as dynamic shortcut menus were easier for me to apply on my database, CurrentDb.Properties is yet a bit outside my knowlegde and couldnt implement that way even after some (huge) search. So yeah, I...
  2. H

    Solved Change between custom shortcut menu and default with vba

    HiTechCoach, If I understood right, in that aproach each form would have its own shortcut menu (or the same menu replicated on all forms), I was looking for a more general setting that would apply to all forms thats why I were trying through current database settings (and would still be a good...
  3. H

    Solved Change between custom shortcut menu and default with vba

    theDBguy, I dont know which options from Application.SetOptions I should use, but I tried the following (still unsure if this is the right option): CurrentDb.Properties("StartupShortcutMenuBar") = "ShortcutMenu" but it returns runtime error 3270 property not found, so I'm still looking to...
  4. H

    Solved Change between custom shortcut menu and default with vba

    Hello, I have a database and made a custom shortcut menu bar (right click menu), which is enabled for all database by setting it up in file > options > current database> ribbon and toolbar options > shortcut menu bar: "ShortcutMenu" (instead of default). So, I would like to change between...
  5. H

    Dmax error 2465 cannot locate field

    As an amateur databaser, I should follow that technique more than I actually do LOL Anyway, good advice, The_Doc_Man. thank you :)
  6. H

    Dmax error 2465 cannot locate field

    So yeah, I changed my formula and it worked as it was supposed. thank you theDBguy ...it was all because of the missing S!! (*awkward moment*) :o But I am awkwardly happy :) Thank you both for your time.
  7. H

    Dmax error 2465 cannot locate field

    Thanks for the reply theDBguy :) Yes its a TempVar! Well this is awkward because I created a button with MsgBox "LocationID: " & [TempVars]![Location] and yes, it returned value (=2) as its suposed to.. I cant believe it was all because of a missing S!! Will correct formula and will...
  8. H

    Dmax error 2465 cannot locate field

    Thanks for the reply isladogs :) Changed to Reference, problem is still there. VarTemp works in other forms, that might be because TempVar in my language is read VarTemp Workplace is a combobox with query source where Column 0 = Workplace (text in table) Column 1 = WorkplaceID (number in...
  9. H

    Dmax error 2465 cannot locate field

    Update: problem seems to be with [LocationID] = " & [VarTemp]![Location] because I used formula without it and added number to field when button press. But I need to use that part of the formula... and I cant find why it doesnt work. Also gave me another error - 3075 syntax error (missing...
  10. H

    Dmax error 2465 cannot locate field

    Hello, I have a form (frmClients) on which i'm trying to update a field using a button on click event, with the vba code: Me.[Number] = Nz(DMax("[Number]", "QryClientsExt", "[LocationID] = " & [VarTemp]![Location] & " And [WorkplaceID] = " & Forms("frmClients").Workplace.Column(1)), 0) + 1...
  11. H

    Cascading combobox with tempvar check

    After some attempts with Gasman and JHB ideas, I could not make it work (that might be my fault and not the ideas LOL) I was still convinced that it was something wrong with tempvar so I changed the code to make a different check (on cbB) since they were related: If [cbA].Value <>...
  12. H

    Cascading combobox with tempvar check

    isladogs: Combos are based on tables! on both first column is a name, second column is ID. cbA (the fruit one) is independant, still displays values based on table. cbB (the pear one) is not independant, displays values from table. cbA is independant but required to filter cbB. Should not...
  13. H

    Cascading combobox with tempvar check

    Thank you for your time Uncle Gizmo and isladogs. I thought I didnt explained myself right in the first post, but I realized just now why does it not make sense to you: Yes, comboboxes only select values on the defined rowsources, but the message-box its suposed to warn when a change is made...
  14. H

    Cascading combobox with tempvar check

    Uncle Gizmo, thanks for the post edit, looks better that way. As requested, here is a (hopefully better ?) explanation of what I'm trying to do: What I have: - I have a form with 2 comboboxes - cbA and cbB - Selecting a cbA record filters options available on cbB (example cbA choose fruit...
  15. H

    Cascading combobox with tempvar check

    Hello, I have a form with two cascading comboboxes - cbA e cbB, where cbB is filtered with cbA choice (all works well here). BUT the problem is because I'm trying to make a messagebox to warn when cbA is changed, so I used cbA before update event to make a tempvar about old record in cbA, then...
  16. H

    Combobox get value and filter another combobox

    arnelgp, attached file is exactly what I wanted! I copied to my DB and everything works as expected, but I made just a small change for new records because by default it would show the first Region in cbRegion and I prefer field empty (used "Me.cbRegion = Null"). Thanks! have a nice day :)
  17. H

    Combobox get value and filter another combobox

    here it is: tblStores: StoreID StoreName PlaceID (association with tblPlaces) tblRegions: RegionID RegionName tblPlaces: PlaceID PlaceName RegionID (association with tblRegions) frmStores (from tblStores), comboboxes: cbRegions (unbounded, doesnt store value...
  18. H

    Combobox get value and filter another combobox

    Hello, in my database I have a form (frmStores) with 2 combobox: cbRegion - Lists RegionName and RegionID from tblRegions - This combobox is unbound cbPlace - Lists PlaceName, PlaceID and RegionID from tblPlaces In database, tblRegion is related with tblPlaces because tblPlaces has field...
  19. H

    Combobox how to reset if without required value

    moke123 Yup you got it right, that was what I wanted. moke123 Nice, this attached database helped me understand what I was missing, because in that example DB the combobox that opens a new form to add a record was what I wanted. Problem is solved now!!! Insane_ai, moke123 thanks for your...
  20. H

    Combobox how to reset if without required value

    moke123 that could help too, but I have problem solved another way. What I'm looking now is some code to reset combobox - because I entered some letters to find Store then I delete them when no record found but combobox is different than it was untouched (when new Store added with other form, I...
Top Bottom