Search results

Hello guys, Have a good day sir/mom. i would insert image in database table to report. i already create table to store file location from image, how to insert the image to access report? i have try to insert with this way but didn't work. table name: Test field1: pic field2: path location...

Dear All, Good day, I want to open folder link from table database, but that link wouldn't open the folder. first, i store the folder link in FileLocation Fields and i set datatype as Hyperlink. Please see the picture below. actualy file location will store attachment data/file but i...

Dear All, heloo, how to open external database? i was created button (Input DB) in my access application to open file Kategori.mdb but it's not works. here i capture picture, please see the picture below: From this: to this: so, when i click input DB it will open kateogri.mdb here i...

Hello Guys, Good day, i have some trouble in my access table. my query: Shift: IIF([aoRemarks1]="NON SHIFT","NON SHIFT",[Xshift]), as you can see in the table result below in Shift column not showing the right result. what's wrong with my querry? and i have some problem with same...

Dear All, hello i need some advice to fix my trouble. i have a table, there is CuciMesinStart, CuciMesinEnd and Column A as a Calculated result from CuciMesinEnd - CuciMesinStart. with condition Shift 3, it's mean start from 11:00 PM until 07:00 AM. so my question how to get a result from...

Hello guys, I have query design based on table. like as my post thread tittle , i want to counting number of week in one month. with criteria like Jan ,1 2021 until jan,10 2021 as week 1 and jan, 11 2021 until jan, 20 2021 as week 2 . also i want separated week of the month to be 3...

Hello, let me intro my self. i'am Alvein from indonesia, and i'am a new in access. so i hope i can learn from this forum and i can share knowledge to you all. thank you for intro