Search results

Thanks for reply.. can you elaborate please

Hi, I have a code to extract the files in attachments and save them in another location. This code loop to all files attached in one record and sometimes it takes time. once the code get started. It takes long time to be conpleted and this prevents the users from working on that form until the...

This post is really helpful. It’s comprehensive in one of the item yo said NEVER put the file in share folder and let users use it from there. may I know why? And is it possible that more than one user can use it at the same time. as I mentioned the only challenge I faced is that I can’t run...

Is there any code to hide the top menu Such as “create” “external data” If there is a code that hide them and unhide them. It will be good

This is helpful .. many thanks

It is only linked with access

if I do this ... they still can change the code and view it ... also ... can I make a default form to open automatically once I open the file?

the lock is not working ... I was able to change the code

Hi, I completed an app in access and I wonder how can I have the file in other PCs. the database is centralized in sharepoint where 5 users have access to it. I don't have authority to make it executable as EXE file. so I want to know if there is anyway to have it as a access file only...

Good Day, I need your help in the following I want to build SQL string that adds on only if the text is not empty.. Dim Variable1,Variable2, Variable3 as string Variable2=me.TXT2 Variable2=me.TXT3 Dim COND as string If Len( txt1.value &"" )=0 then Variable1= me.TXT1 COND=COND+ "FName='" &...

It worked Many thanks to all of you i knew this would save time! I changed the filter to requery thanks Pat

Thanks ... I tried that link before.. it didn’t work for me. How to add the filter? Is ig considered a control or what.. Do you have a code example file ?

Good Day, I have an issue in referencing a filter for a nested sub form. It is taking me longer than it should.. I am sure I can find the answer quickly here. 1- I have a subform named “ChildTest” in the main form name “FrmMain” 2- that subform is linked to another form named “FrmReqMain” 3- in...

thanks all for your reply what do you recommend to have good looking graphs in VBA ? can I integrate access and excel? extract the result in excel graphs via VBA ? any suggestions

Thanks a lot for your reply. As you just said BI is for analytics while building the data structure is through Access I want to utilize the good analytical structure and the good looking dashboards from power BI an my access application. I don’t like the charts in access

Good Day, I am starting new project where I want to link my power BI view with my access forms? I don't know if this is doable if yes, would you share tutorial