Search results

Hi I have a form that a user fill out to populate fields in my database...how can I make it so that user MUST fill in certain fields before they are allowed to save data? I need to stop users from taking shortcuts when entering data, and skipping a lot of fields. So i would like to be able to...

Hi All, I have a query running on my database built within a form that has 2 drop down boxes to stipulate search criteria, ie: Status and Make. The query works perfectly fine, as long as both fields are filled in. What i would like is if one of the fields is left blank, the query should return...

Hi All, I have reports, that are based around dates. Is it possible to make a report highlight different report outputs according to age? In other words, if an entry is older than say 15 days, highlight it in blue, if its older than 30 days highlight in orange etc etc I need to find a way for...

Hi All, Im busy working on a database, that has a field called Comments, where users can input data about communications with clients. The limit is 255 characters, is there any way I can increase this, or offer users a way to input more data? Im relatively new to access, so use small words...

Hey all, I recently got roped into designing a database for my company, after some long hours work have first working copy up and running. Now I need to tweak it to lock down errors etc. So with that in mind.... I have a query running on the main table, that uses criteria field to bring up...

Hey all, Just to say hello..been referencing this forums for a while while teaching myself Access, now working in Access a lot more so decided to register to ask my own questions. o/ Banelight