Search results

Hi everyone, I have a form where i have a text zone and a botton. I need a vba code to use in that botton which help me to only open the file location that i have its path in the text zone. Let's say the text zone is named "txtfilepath" and the botton is named "openfilelocation". Could anyone...

i made a program by using Microsoft access,so i share my accessdatabase on onedrive, i use it on 3 laptops, i put the backend on my onedrive and frontend on the disk of all the 3 laptops, the problem is when i open the database on the 3 laptops and add some records, the onedrive make another...

Hi everyone, i made an app with M.access, so when i open a report, it doesn't fully open, i need everytime to click to open it (see the pic ) ,so is there any way to tackle that issue. I don't need to use docmd.maximaze. Thanks

Hi our great teachers, I have a form "a" where i have 10 buttons with images in them( let's say animals images) . All this images have an id from 1 to 10 in a table "x" which is related to the form "a" . In the form i have a zone text "zt" and a Ok button "btnok" , what i want is write number 3...

Hi everyone, I have a form which it related to a table, in the form, i used button to move next and last. But what i want is moving through my record with condition,all my records in the table seperated in 3 parts, first part has number 1, second part has number 2 and last part has number 3, all...

Hi everyone, if you please i wanna count how many lignes between two dates, i mean date from A to B. So i used dcount, but i didn't know what to use in the criteria. Me.textbox1=Dcount("[expr1]","table1","[criteria1]= between #"& me!textbox5 &"# and #"& me!textbox6 &"# ") Is this one correct...

Hi everyone, i have a form in my access database, i use the code maximize when i open it in my laptop where i have big screen, but when i open it in my other laptop where i have small screen, some parts of the form not shown , like out of the screen, how to deal with that please

Hi everyone, I have a table "x" where there is a colon named "path", all the lignes in that colon start by G:\&......... I have a form, in the form i have two txtbox, the first one named "P1" and the second is "P2" . When i open the form, the P1 brings the start of the colon "path" from the...

Hi everyone, I have a vba code which helps me to download pictures to my form. actually, it loads the picture's path from a folder. (see the picture). When i scan papers like invoices, they regestred in download folder in C. With my access data base, i create a folder "documents". What i need...

Hi everyone, Please i need your help, i have an app made by access 2010, when i see that most people in my region still use 2007, i decided to transforme my 2010 app to 2007. When i try to do "copy- paste" to all my tables ,queries, forms , i get nothing, please, i hope if there is any way to do...

Hi everyone, I have a problem and i need your help, imagine i have a table with a large liste of image emplacement, let's say the begining of all the records in the liste is D:\ So what i need is a vba code to update only the beginig of the emplacement, so with one click, all the emplacement in...

Hi , i hope you are all fine. I wonder if there is a way to deal with the Access Security Warning message during the opning the Access, it shows this message: Security Warning, certain content in the database has been disabled. I know how to deal with it manually, but i wich if there's a VBA way...

hi, can anyone help me with free microsoft 2007. i google it to download it but most of the sites don't give me any thing, and i wanna know if the computer could have two version in the same time (2007 and 2010)?

Hi everyone Can we get the mac address using vba access plz

Hi everyone, Pleaaaaase i need your help, i have two questions. 1) how to get my IP adress into a txtbox by Vba? 2) how to change the form i choose in the application opening by another form using vba (see screenshot)

Hi everyone, please how to resize my access application when i use it in another computer with diffirent screen resolution? Thanks Is there any VBA Code to do that??

hi, i really struggled for more than 15 days to solve a problem but i couldn't. i have a form, let's say form A and a subform B and a third subform C for the form B. C related to B and B related to A . so when i put for exemple "France" in A i put records in B like " Paris" and i put "all...