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...

Ok figured it out thanks... Now to work out the expressions :)

hi, Awesome.....where do you do that? :D Sorry I'm still a bit new to access. Im using Access 2013 by the way.

Thank you! They never specified the"Next line" part in the other post! I have added it to second criteria and it works...! Thanks!

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...

Thank you...that seems to have worked!

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...

hehe, no was not confusing so much as knowing where to start! I dont like being spoon fed, and like to be able to figure stuff out...you showed me the way and I learnt a new trick! What you posted didn't make a lot of sense at start, until I broke it down...as I have very limited coding...

Whew...took me a while to get that right, and had to modify code somewhat, but I understood you were getting at! My thanks sir! Its now doing what I was looking for, and you have shown me a whole other world of options for designing queries! I a code newebie when it comes to writing from...

Ok, When I said Home form, I mean its the equivalent of the switchboard function in access 2007..like landing page when access database opens, it only has buttons it. I have read about this Dcount before when researching this problem....im not sure where to try implement this? On the button...

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