Search results

Hello I know it sounds weird, but I'm trying to build a form to act as Messagebox; with it, it gives an excellent look instead of the standard message box window I've tried the formatted messagebox in AttentionSeek db of @isladogs, and it's not giving a look that a specific form gives! here's...

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

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

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

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

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

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

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

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 !

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

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

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

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

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

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

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

Thanks for your reply, Who said anything about me using subforms on unbound forms ? i have to use subforms in bound forms since the subform act as a junction table and i've already edited the main thread with the solution post.

I'm gonna tell you my other try to make it work without OpenArgs and failed on it, and I don't know why it failed, and I hope you telling me So, I've thought of using TempVars and filtering the subform using it so on the button i've put this : Private Sub btnEdit_Click() Dim TmpYear As...

oooh, my mistake, i though openArgs is same like filter parameter, after searching online now, I found it passes values between forms and that's exactly what I was searching for so I have put code to get the value of the field "FollowupYear" as in this code DoCmd.OpenForm...

@The_Doc_Man thanks for your reply when you telling use the filter on the on load event, it will work if the filter is based on a string I will put Me.subformcontrol.Form.Filter = "... some filter string..." I don't have the filter value, the value of the filter is on the continuous form! so...