Search results

Hi, can you show me some example ragarding to the database relationship design ?

Hi All, I want to design a database to track the component First, the OEM data will be import into tbl_Part, this contain component Original serial number(Example : 40000001). After 3 years, if I want to rebuild this part, I will given a new serial number for it(from 40000001 changed to...

Hi All, Im developing a Meeting Room Booking System using Access Database , My question is , how can I create a TimeSlot form with Monday-Friday & All meeting room ? Please refer to attached picture for example. Let say If I want to book ACE room @ 8.00AM , So I will click on first box...

Hi all , Im seeking for a solution to prompt all user with windows alert for Notification Case 1: One staff applied leave and clicked "Submit" , after clicked I want the system will prompt his/her Supervisor for his/her leave approval or like a notification that the Supervisor need to go...

Hi all , Everytime i want to make some changes to my "Testing" Database , always got somebody using it / opening it... So ~ I am trying to create a button , the function of the button is close "Testing" access database who using it or opening it , Example : 5 users included me in a company ...

Hi all , Im doing an attendance in Access database , i have a Staff table and AttendanceMain table for keep all the staff attendance ... I also created a query to append the data into AttendanceMain table ... the problem is , I always reuse the staff name , so i created a Staff form , but...

sorry add-on , there is 2 table one is accountant and works accountant_name (accountant table) is already linked to accountant_name in (works table)

Hi guys , I attach the database file , please download it and take a look... the query is "question 5" i want to query out those people which their salary is more than the average of those people who just work in "Changi Anron"

Hi all , I facing a query expression problem , 2 table = accountant & works table, accountant -accountant_name table, works -branch_name -annual_pay from this 2 tables , I want to query out those people's annual_pay is more then the average of the total of all accountant's pay what...

you may need to create a query to filter out the staff logged in , then retrive the username from your query .

That mean you want retrive the foreign key of the logged in staff when your staff key in sale ?

Hi all , I want to load and show an image in a form , i know this only will work when i select the image file path using vba application.filedialog ... but i don't know how to write this code , anyone can help me write this code please ? Example : I have form1 and report 1 ... inside the...

I will try with this solution first :)

Hi all , i want to know how to display picture in object frame in a form ? i would like to select the data from a table ... please give me a simple solution to work it out. ..

hi all , im looking a solution that can track who logged into my access database ... i have an ideal about this but don't know which way to do it .... how to set user's status to "Active" when he logged in through Login page ? when he close the access database ... i want the user's status set...

Thanks Paul ! Ur "hide" means minimize window ?

Hi All , I have a Login form , i set a query retrieve information from Login form's Text3 (username) after that , if the user Successfully logged in then the Login form will close . i set the query because i need to retrieve what is His/Her Department . But , after i closed the Login Form ...

Hi All , I would like to develop an Access Database for my office ... I'm using MS Access 2010 . Work Flow : First , I will key in all the details into a form ... after i filled up all the textbox , i will click SUBMIT ... the submit button will help me save record into table and generate a...

which login system you want ? i can help you create 1 ... please state the function you need ... something like Login ... Sign up ... Forgot password ...

Hi All , I going to develop an access database for my company . i will implement Attendance Marking Sheet into access database , My attendance have 3 people's signature , 2 supervisor and 1 manager , what I want is , when the first supervisor click "Approve" , then the supervisor's...