Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. H

    Combobox how to reset if without required value

    Hello, I have a issue with a combobox in my BD, Ill explain below (and I hope to explain it well): - I have a form "frmproducts" from "tblproducts" - fields ProductID, ProductName, Store. - field Store is a combobox that shows the contents of tblStore (it shows StoreName but links with StoreID)...
  6. H

    Hi :)

    Hello, I just registered on this forum and I just wanted to say HI to all of you. I'm Hugo Silva and I'm from Portugal. In the last times I've been making some access DBs and maybe we'll "chat" sometimes here. I'm not a programmer but I don't feel 100% new to M.Access, because I've been...
Top Bottom