Search results

I created different Access Databases from time to time for different departments. Each database is used for different purposes, has different functionalities, different fields, and for different end user/users. Recent discussion from our company (We are small company with only me as a...

I have an Access 2007 application which has VBA code to avoid users to key in wrong data in the data entry form. After I upsized the main table to a back end SQL Server 2005, then link the main table at Access 2007 front end, the VBA code at Access 2007 didn’t work any more. All other functions...

Hi, I tried to build a reprot which change one of number fields color depend on another Category field at the report and number field itself. If there is Category A, then number field will change color at certain number range. If there is category B, then the number field will have...

Hi, I have two tables as the below: Equipment: EquipmentID (Auto Number), Equipment Name, Purchased Date. Shared : Category(primary, Secondary), StaffName, Department, Assigned Date, and EquipmentID(as foreign key) One Equipment may have couple of staffs shared with it as the below I...

Re: Avoiding access to save on close event Hi, guys, I created a VBA code to avoid wrong data saving at Form level; However, when I close database, all the data at data entry form which should not saved by VBA code still be saved. Is anyone can help for avoiding wrong data saved at...