Recent content by alvingenius

  1. alvingenius

    Solved cascading context menu in form

    that's exactly what i was looking for thanks @MajP
  2. alvingenius

    Solved cascading context menu in form

    Sorry for the delay, I had a situation that prevented me to open the forum since I post it So, like I said I've seen a couple of posts regarding shortcut menus, ur mentioned link is one of them ! and it didn't help me since it's going with the 3 tables levels! the same as my example of cascade...
  3. alvingenius

    Solved cascading context menu in form

    Thanks @isladogs for your reply i've already done it with cascading combos, but I wanted to make it as context menu
  4. alvingenius

    Solved cascading context menu in form

    Hello I have seen a couple of posts on this forum about shortcut menus and context menus and I wanna make it deeper I have a form with 3 cascading combo boxes, getting data from 3 tables, with a one to many relationships between them so, I wanna just create a button when I click it opens a...
  5. alvingenius

    Issue doing update queries over local network

    By random i mean sometimes it work from the first time and sometimes its not from the same users pc so its nothing related to access version or user rights, ( while the access version are identical and user rights are good ) when i tried it on server it self that have the BE, to just test the...
  6. alvingenius

    Issue doing update queries over local network

    Hello I think I did !!, I said I can't replicate the issue, because it's the only location that can execute 3 update queries the code is so simple, it runs update query so, nothing in the code regarding setwarnings I said the queries execute normally with warnings !, if I execute the queries...
  7. alvingenius

    Issue doing update queries over local network

    it's the only button that has 3 update queries, so I can't replicate it if I disabled set warnings it will execute! and regarding the "wait for" code, it's for waiting for * seconds after executing every query, I thought it may fix the issue again, I think it's because of the network ...
  8. alvingenius

    Issue doing update queries over local network

    Thanks, @CJ_London for your reply the code of the button is simple, here's the code in the button and I've done decompile/recompile, and compact repair. I believe the issue is executing these 3 update queries through the network !!, maybe it got interrupted !
  9. alvingenius

    Issue doing update queries over local network

    Hello We have a db splitted into FE/BE, and the backend is in a server machine and regarding the front end... First, it was In Server too and users have a shortcut from it on local machines and everything was good except a button that execute 3 update queries, and I've put a msgbox that appears...
  10. alvingenius

    Solved Setting a Recordset to a query Criteria expression issue

    I was just reading about it in the Microsoft community DAO operates at the database level, not at the Access application level. It doesn't "know" about Access forms and combo boxes. So, it doesn't understand "Forms!Form1!txtDate" until we define it and @arnelgp code working great and I just...
  11. alvingenius

    Solved Setting a Recordset to a query Criteria expression issue

    Hello I'm trying to build a module with a recordset to a query and it working as screenshot but if i tried to but a criteria into the query, for example getting the date from the form1 and opened the form and entered a date for example 16/01/2022, then should only get 1 value in...
  12. alvingenius

    Building a complex cascading tables in access

    I'm so sorry for that @plog First i've asked of the part the holds me, and when you asked for a full explanation I provided it So, i'm trying to figure it out till now, and did many trial and errors to get it and i think i need to build a table for every convention that holds articles...
  13. alvingenius

    Building a complex cascading tables in access

    I'll explain the whole idea We are an organization the issues a Conventions, a convention is an agreement with our organization and every country that approves it we have about 20 conventions every convention have a unique number and name of the convention eg: "convention1: for Occupational...
  14. alvingenius

    Building a complex cascading tables in access

    Thanks @strive4peace I've watched the video, it's talking about relations, not hierarchical tables and it have good ideas but is not related to what i'm asking after seeming In the screenshot, you have only 1 table named: QUESTIONS, that have only a couple preset questions, and it's not...
  15. alvingenius

    Building a complex cascading tables in access

    Hello I have this idea about a new project we are doing at my work I'll try to describe it and I hope you get the idea So at first lets say we have a main table called : Topics Topics table have about 20 records and i've another table that have a one to many relation with it called ...
Top Bottom